Tag: Database

Follow a SQL query through the router, across four Postgres shards, and back.

Sharded Postgres by PlanetScale. Scale real Postgres to hundreds of millions of QPS and petabytes of data with zero-downtime resharding.

implements both distributed firewall rules and gateway firewall rules for each DSM database deployed via VCF Automation

This is probably the question I get asked most about Spacetime. It’s a simple enough question, and it certainly seems like it should have a simple answer. Scaling is a complex topic, and the devil is…

a new version 9.1.1 of VMware Data Services Manager, a release that is chock-full of new features and enhancements

Tailscale and SQLite developers traced maddening corruption incidents to find the WAL-Reset data race, then uncovered a second stale expression index bug.

Lessons learned from scaling Postgres-backed durable queues for users running tens of billions of workflows per month.

Portabase is the open-source, self-hosted tool to back up, centralize, and restore your databases, led by a non-profit organization.

We built a social network on SQLite, put it behind a Node API, and hit it until something broke. One file, one process, 315 million requests a day on the heaviest endpoint. Here are the numbers, the config, and the honest limits.

How to make 768 distinct Postgres servers look like 1 to your applications.

Check out https://planetscale.com for more Postgres and MySQL content.

Explaining the concept of a Postgres-backed durable execution system like DBOS and comparing it to external workflow orchestration systems like Temporal.

In Data Services Manager version 9.1, MySQL databases can now leverage the the new snapshot capability in vSAN ESA.

a very powerful solution for customers who wish to offer data services to their users, all the while maintaining multi-tenancy controls through VCF Automation

how to provision SQL Server Instances and automatically integrate with Active Directory and DNS for a seamless deployment experience

How the maintainer of the popular For You feed serves it from their living room!

Healthchecks.io ping endpoints accept HTTP HEAD, GET, and POST request methods. When using HTTP POST, clients can include an arbitrary payload in the request body. Healthchecks.io stores the first 100kB of the request body. If the request body is tiny, Healthchecks.io stores it in the PostgreSQL database. Otherwise, it stores it in S3-compatible object storage. [...]

A real-world production migration from DigitalOcean to Hetzner dedicated, handling 248 GB of MySQL data across 30 databases, 34 Nginx sites, GitLab EE, Neo4j, and live mobile app traffic — with zero downtime.

We built the same HTTP server in Go, Bun, and Rust using two storage strategies: read the file on every request, or load everything into memory. Then we ran real benchmarks. The results are more interesting than you'd expect.

SQLite has evolved far beyond a simple embedded database. Explore modern features like JSON, FTS5, window functions, strict tables, and more.

The world tried to kill Andy off but he had to stay alive to to talk about what happened with databases in 2025.

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more. - Maxteabag/sqlit

We made the switch from AWS-hosted MongoDB Atlas to a self-hosted solution on Hetzner, resulting in a 90% reduction in costs while maintaining performance and reliability.

Learn how to use UUIDv7 today with stable releases of Python 3.14, Django 5.2 and PostgreSQL 18. A step by step guide showing how to generate UUIDv7 in Python, store them in Django models, use PostgreSQL native functions and build time ordered primary keys without writing SQL.

Data API Framework for AI Agents and Data Apps

How to access to a DSM provisioned Postgres database using User or Client Certificates

Whilst Microsoft SQL Server is still in technical preview in Data Services Manager 9.0.1, our team continues to release significant enhancements for our customers as we gravitate towards full support.

With the release of VMware Cloud Foundation 9.0, VMware is ushering in a new era of private cloud management, where data services become an integral part of the automated platform. A key element of this transformation is VMware Data Services Manager (DSM) 9.0, an advanced Database-as-a-Service (DBaaS) tool that is now fully integrated with VCF...

The horizontal scaling layer for PostgreSQL, deployed as a simple proxy.Load balance queries and shard databases, without application changes.

Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.

A self-hosted bookmarking service that is designed to be minimal, fast and easy to set up.

Secure access / PAM for your internal SSH, HTTPS, MySQL, Postgres and Kubernetes servers with SSO and RBAC.

DSM is providing is the DBaaS solution for VCF. In this post, I will attempt to highlight the overall benefits of DSM. I will do this for three different personas; the VI Admin, the DBA and the end-user/developer.

Dumping a SQLite database to a text file can make it much smaller, which means you can download it faster.

SDDC Manager oprations may not be allowed due to System Lock held by Password Manager operation in progress. A password rotation task may have failed on individual components for various reasons. S…

We're Rivet, a new open-source, self-hostable serverless platform. We've been in the weeds with SQLite-on-the-server recently and – boy – do we have a lot of thoughts to share. Give us a star on GitHub, we'll be sharing a lot more about SQLite soon!

Let’s Encrypt protects a vast portion of the Web by providing TLS certificates to over 550 million websites—a figure that has grown by 42% in the last year alone. We currently issue over 340,000 certificates per hour. To manage this immense traffic and maintain responsiveness under high demand, our infrastructure relies on rate limiting. In 2015, we introduced our first rate limiting system, built on MariaDB. It evolved alongside our rapidly growing service but eventually revealed its limits: straining database servers, forcing long reset times on subscribers, and slowing down every request.

the latest version of Data Services Manger (DSM) is now available. Version 2.2 has a wealth of new features

Some of the interesting and insane facts I learned about SQLite

The VCSA vPostgres service fails starting. In this post I describe how I was able to revive my Postgres instance with the help of the Postgres Write-Ahead log (WAL). The Postgres Write-Ahead Log contains enough data for Postgres to restore its state to the last committed transaction. Nevertheless, this action should be done with care.

How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.