Foreign keys are a concept embedded in almost every relational database. If you are normalizing your database, you will expect to use foreign keys throughout. And they seem simple. But simplicity often belies the subtle differences that can trip you up when switching between database systems. One si...

“Database branching is the best quality-of-life improvement to my tech stack that I can think of in recent years. Second to maybe only Copilot” Miguel Hernandez, Backend Tech Lead at Neo.Tax Neo.Tax specializes in automating the calculation of tax credits for startups, enterprises, and mid-market co...

A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: The following aggregate function computes the number of rows per group which satifsy the FILTER clause: This is useful for pivot style queries, where multiple aggregate values are co...

The new major version of GoReleaser is here!

Firefox 130 will introduce an experimental new capability to automatically generate alt-text for images using a fully private on-device AI model. The feature will be available as part of Firefox’s built-in PDF editor, and our end goal is to make it available in general browsing for users with screen...

Explore the final series on real-time maps creation using JavaScript Google Maps API and geolocation tracking.

Explore the final series on real-time maps creation using JavaScript Google Maps API and geolocation tracking.

As a fully-remote company with 47 misfits spread across ten countries, our offsites are a vital part of our culture. They’re a great way to get to…

Examples of apps and businesses that are being transformed by cognitive services, and some future use cases as well

Examples of apps and businesses that are being transformed by cognitive services, and some future use cases as well

The Last 100+ Days The NVD posted the notice below on its webpage in mid-February. Since then, nearly 13,000 CVEs have not been enriched with CWE, CVSS, and CPE data.  The vulnerability management community was told that it would be addressed at Vulncon this year. At the conference, we were told the...

Learn to construct a dashboard showing GitHub commits in real time. We utilize JavaScript, C3.js, and PubNub for this project.

Learn to construct a dashboard showing GitHub commits in real time. We utilize JavaScript, C3.js, and PubNub for this project.

Here are some ways to find the specs for your system via the Linux terminal.High LevelCheck out all the high-level stuff at once.sudo apt install neofetchAnd then run neofetch and get something like this:❯ neofetch ///////////// jaketrent@pop-os ///////////////////// ---------------- ///////*767////...

If you, like me, release your projects to the Snap Store using GoReleaser, you might need to eventually update the secret.

We love Postgres, and for us, being able to use Postgres database branches that can be integrated with our CI/CD pipeline is a killer feature. The ability to spawn databases that can scale down to zero is also incredibly helpful. This model fits well with our one database per customer architecture. ...

Database branching makes it easy to create database copies for your non-prod environments, but some companies face the obstacle of how to anonymize PII to ensure privacy. This can be solved with Neosync, an open-source tool that allows developers to anonymize data across branches. Try it with Neon. ...

Here's how to define a type for a declared function.Declare a functionIt's straightforward to type a function signature -- that is, its parameters and return value. For example, string in, number out:function parseItBoom(input: string): number { return parseInt(input, 10); }Define a function typeBut...

We're often asked what Red can be used for, or what apps have been written in Red. Red can be used to write almost anything, but the sparse ecosystem and some missing pieces limit certain use cases. It's used a lot for in-house data processing, custom DSLs, simple GUI apps, and more. We also used it...

Don't dismiss the statistically probable

From 2011-2012, the FTC investigated the possibility of pursuing antitrust action against Google. The FTC decided to close the investigation and not much was publicly known about what happened until Politico released 312 pages of internal FTC memos that from the investigation a decade later. As some...

I needed a bit of a break from “real work” recently, so I started a new programming project that was low-stakes and purely recreational. On April 21st, I set out to see how much of a Unix-like operating system for x86_64 targets that I could put together in about a month. The result is Bunnix. Not i...

I needed a bit of a break from “real work” recently, so I started a new programming project that was low-stakes and purely recreational. On April 21st, I set out to see how much of a Unix-like operating system for x86_64 targets that I could put together in about a month. The result is Bunnix. Not i...