Build a local graph of database schema objects, SQL artifacts, and relationships so agents can search, validate, analyze, and reason about database changes without storing business row data by default ...
Data isn't just oil anymore; it’s the oxygen your enterprise breathes. In 2026, the volume of data flowing through the average mid-to-large enterprise isn't just massive—it’s complex, messy, and ...
Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...
Microsoft has announced a distributed PostgreSQL database service designed to rival other hyperscaler systems and third-party RDBMSes such as CockroachDB and YugabyteDB. Claiming 100 percent ...
Read also introduction article on my blog for more context. Pongo treats PostgreSQL as a Document Database benefiting from JSONB support. Unlike the plain text storage of the traditional JSON type, ...
After announcing support for Cosmos DB inside the Microsoft Fabric data platform at Build 2025, Microsoft recently opened a public preview of the new service. This release gives Cosmos DB a new role ...
PostgreSQL treats JSON as a first-class citizen—and when you need to flatten key-value pairs from a JSON column, jsonb_each_text() is your go-to function. What does jsonb_each_text() do? It expands a ...
In this guide, we’ll explain how to set up a private LoRaWAN network using the Raspberry Pi CM4-based RAKwireless’ WisGate Connect gateway and Docker or Portainer to install NodeRED, InfluxDB, Grafana ...
Esri have added a nice example here of how a GeoJSON layer can be created using GeoJSON from a URL. This is great and very useful, however, it won't scale very well. The reason is because all of the ...