pgGraph is a PostgreSQL extension for running graph search, traversal, shortest path, and relationship queries directly against ordinary PostgreSQL tables. Your tables stay the source of truth.

In 2021, after catching the tech bug as a kid and earning a degree in communications, Ada got into tech writing by editing crypto guides. Ada's expertise now spans Windows, Android (especially Samsung ...

Event sourcing is a design pattern for persisting the state of an object by storing the sequence of events that have occurred on the object. Event sourcing fits the functional paradigm as the state is ...

About one year ago we announced the private preview of SQL Server 2025 at Microsoft Ignite 2024. Today, I am excited to announce our product has gone to GA! I know you will want to try it immediately ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

After six months at his internship, polytechnic graduate Alden Chia, 20, earned $6,000. But of this income, he spent close to $4,500 getting certified in cyber security. Coming home from his ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

When you’re trying to understand customer retention, calculating churn is one of the most crucial metrics. But what happens when you need to look back in time to see how well your business was doing ...

Pattern matching for switch enables a switch expression or statement to be tested against a number of patterns, each with a specific action, so that complex data-oriented queries can be expressed ...

For regular readers of this blog, you may recall a blog post by Carlos Figueira on working with SQL server time values. In it, Carlos used the Mid, Find, Substitute, and other functions to parse an ...