Latest AI and tech news
This week we worked on Matplotlib and data visualization, using real UK milk and cream trade data from Comtrade, covering January to May…...
A few years ago, solid SQL, Python, and the ability to build reliable ETL pipelines made you valuable. Today tools like GitHub Copilot…...
OpenSearch has come a long way since Amazon Web Services first announced the project back in January 2021, in response to Elastic’s decision to move Elasticsearch and its accompanying visualization tool, Kibana, away from Apache 2.0 and onto a combin...
Week 8 at DataraFlow: grouping data, plotting it, and asking SQL the same questions twice....
A cybersecurity graduate heading into GRC learns GROUP BY the hard way....
The modern data platform is no longer just about storing information and running SQL queries....
Enterprise storage infrastructure rarely receives attention until something goes wrong. Yet behind business applications, databases, analytics platforms, and digital services are complex systems responsible for storing, protecting, and making data av...
An advanced Senior and Staff Engineer system design interview covering Kubernetes HPA, PostgreSQL connection pools, queueing theory…...
An advanced Senior and Staff Backend Engineer interview walkthrough covering double-entry accounting, PostgreSQL transactions, idempotency…...
pg_cron, pgAgent, and shell scripts all break on AWS Aurora, Azure MI, or server restart. Jinba runs scheduled PostgreSQL queries that persist and produce a full audit trail.
The Spring Release of Couchbase Capella™ DBaaS coincides with National Cloud Database Day (June 1st) – perfect timing because Capella reimagines the modern database as a fast, flexible, and affordable cloud database platform. In…
IDEMIA Secure Transactions (IST) has achieved the first EMVCo certification for a payment card platform that incorporates post-quantum cryptography (PQC) and crypto-agility services. This platform allows for future-proofing against quantum threats wh...
Mem0 made four decisions for you. Here is how to own every one of them with one SQL table, one Python class, and an update policy you can…...
A LlamaIndex vector store is where your index keeps node embeddings, usually alongside the text chunks and metadata, so queries can find similar content. The default store lives in memory, so a restart or redeploy wipes the index and sends you back t...
Large database tables can contain millions of records, but we don’t always need to retrieve every row to inspect data, test queries, or…...
A few months ago, our RAG (Retrieval-Augmented Generation) setup did what most first versions do: the Streamlit app called OpenAI directly, pulled chunks from MongoDB, and stitched an answer together. It worked. It also had three problems nobody want...
For the longest time, I skipped window functions in every SQL course I took. They showed up in the last chapter, looked intimidating, and…...
Some database bugs are surprisingly difficult to spot because every transaction can look correct on its own....
What happens when two MongoDB clusters sync in both directions, and how do you stop changes from looping endlessly?...
If you are a data scientist, data analyst, or anyone who works with big data, you have likely used SQLite, or even use it daily....
P99 CONF is a virtual conference on high-performance, low-latency applications. Its 2026 event ran October 21–22. Here, we cover five of its 60-plus sessions. The recordings are available on demand at p99conf.io after registration....
Language models are good at writing and reasoning, but they only know what they saw in training. That knowledge has a cutoff date, so anything that happened afterward is invisible to them. They also can’t look inside your database, read your codebase...
A practical guide to data pipeline architectures: the layers every pipeline has, the common patterns and when to use each, a decision table, and a reference design for SaaS and database data....
Earlier this year, we introduced PSMDB Sandbox, a lightweight web UI that sits on top of our Terraform and Ansible automation for MongoDB. Since then, the project has changed a lot. It has a new name and repository, and it supports many more Percona ...
Connect Hex to your LiteLLM Postgres data.Set budgets and routing in LiteLLM....
Introduction
Run Group-Bys Faster
Run Warehouse SQL Directly
Encrypt Sensitive Columns
Other Additions in 2.1
Final Thoughts...
If you have ever written a SQL query and wondered whether a condition belongs in WHERE or HAVING, you're not alone....
A while back, I wrote What the Heck is GizmoSQL?, about Philip Moore's project that took DuckDB, an in-process library, and turned it into a proper server with concurrent sessions, authentication, TLS, and an Arrow Flight SQL endpoint. It solved a re...
We introduced caching to make applications faster. But every time we add another copy of our data, we also introduce another version of…...
The best accounting software for bank reconciliation depends on where your matching has to happen. If your bank transactions arrive through a few bank feeds into one set of books, the built-in reconciliation in QuickBooks Online, Xero, NetSuite or Sa...
How to find the query that ran at 3 a.m. after the fact. It uses nothing but what SQL Server 2025 keeps on its own. I planted a culprit, gave it eight disguises and buried it in four hundred innocent lookups. Then I tracked it down with Query Store. ...
The post Why your schema shouldn’t mirror your database (and what to do instead) appeared first on SQLServerCentral....