Latest Tech News

Stay updated with the latest in technology, AI, cybersecurity, and more

Filtered by: database Clear Filter

A recap on May/June stability at Neon

Details of incidents and what we did to prevent more in the future Starting in May, we had a series of feature launches with agentic AI partners that gained far more momentum than we predicted. In two short timespans, the rate of new database creation increased more than 5x, and the rate of branch creation increased more than 50x. While we were humbled by the uptick, the significant burst in operational load caused a lot of strain in the Neon platform, manifesting as more incidents over the cou

A Recap on May/June Stability at Neon

Details of incidents and what we did to prevent more in the future Starting in May, we had a series of feature launches with agentic AI partners that gained far more momentum than we predicted. In two short timespans, the rate of new database creation increased more than 5x, and the rate of branch creation increased more than 50x. While we were humbled by the uptick, the significant burst in operational load caused a lot of strain in the Neon platform, manifesting as more incidents over the cou

Pgactive: Postgres active-active replication extension

Active-active Replication Extension for PostgreSQL (pgactive) pgactive is a PostgreSQL replication extension for creating an active-active database. Overview Database replication is a method that copies changes between databases instances, and is a key component for use cases like high availability, reducing latency between an application and its source data, moving data between systems such as production and test, infrastructure migration, and others. Relational databases such as PostgreSQL

AWS open-sourced Postgres active-active replication extension

Active-active Replication Extension for PostgreSQL (pgactive) pgactive is a PostgreSQL replication extension for creating an active-active database. Overview Database replication is a method that copies changes between databases instances, and is a key component for use cases like high availability, reducing latency between an application and its source data, moving data between systems such as production and test, infrastructure migration, and others. Relational databases such as PostgreSQL

Postgres LISTEN/NOTIFY does not scale

At Recall.ai, we run an unusual workload. We record millions of hours of meetings every month. Each of these meetings generates a large amount of data we need to reliably capture and analyze. Some of that data is video, some of it is audio and some of it is structured data – transcription, events and metadata. The structured data gets written to our Postgres database by tens of thousands of simultaneous writers. Each of these writers is a “meeting bot”, which joins a video call and captures the

Analyzing database trends through 1.8M Hacker News headlines

How the analysis was done I used camelAI with a ClickHouse database of every HN story to do all analysis. You can use it for free with no login here to explore the data interactively yourself. 18 years • 1.8 million headlines • 13 database engines Hacker News is a real-time barometer of developer excitement. I mined every story title from February 2007 to June 2025 and asked three questions: How has headline volume for each database changed over time? Which engines are accelerating the fast

Analyzing Database Trends Through 1.8M Hacker News Headlines

How the analysis was done I used camelAI with a ClickHouse database of every HN story to do all analysis. You can use it for free with no login here to explore the data interactively yourself. 18 years • 1.8 million headlines • 13 database engines Hacker News is a real-time barometer of developer excitement. I mined every story title from February 2007 to June 2025 and asked three questions: How has headline volume for each database changed over time? Which engines are accelerating the fast

Supabase MCP leaks your entire SQL Database, a lethal trifecta attack

Supabase MCP can leak your entire SQL database (via) Here's yet another example of a lethal trifecta attack, where an LLM system combines access to private data, exposure to potentially malicious instructions and a mechanism to communicate data back out to an attacker. In this case, General Analysis identify all three components in a single MCP - the Supabase MCP. They imagine a scenario where a developer asks Cursor, running the Supabase MCP, to "use cursor’s agent to list the latest support

Speeding up PostgreSQL dump/restore snapshots

The last few pgstream releases have focused on optimizing snapshot performance, specifically for PostgreSQL targets. In this blog post, we’ll walk through the key improvements we made, share the lessons we learnt, and explain how they led to significant performance gains. But first, some context! What is pgstream? pgstream is an open source CDC(Change Data Capture) tool and library that offers Postgres replication support with DDL changes. Some of its key features include: Replication of DDL

Benchmarking Postgres

Want to learn more about unlimited IOPS w/ Metal, Vitess, horizontal sharding, or Enterprise options? Benchmarking Postgres By Benjamin Dicken | July 1, 2025 Today we launched PlanetScale for Postgres. For the past several months, we've been laser focused on building the best Postgres experience on the planet, performance included. To ensure we met our high standard for database performance, we needed a way to measure and compare other options with a standardized, repeatable, and fair method

Pbf2sqlite: Reading OpenStreetMap into a SQLite Database

pbf2sqlite A simple command line tool for reading OpenStreetMap .osm.pbf files into a SQLite database. Usage: pbf2sqlite DATABASE [OPTION ...] Options: read FILE Reads .osm or .osm.pbf FILE into the database rtree Add R*Tree indexes addr Add address tables graph Add graph table The command pbf2sqlite test.db read country.osm.pbf reads the OSM PBF file country.osm.pbf and creates in the database test.db the tables. OSM data can be obtained from a provider such as Geofabrik.

Topics: add database file osm pbf

ZeQLplus: Terminal SQLite Database Browser

ZeQL+ : Terminal SQLite Database Browser Features Open any SQLite database file Very fast Runs in a Terminal / CMD window Tiny executable with no dependencies List all tables in the database to browse Paginated view of table rows Run custom SQL queries and view the results Cross platform: macOS, Linux, Windows Open source Install Pre-built binaries for macOS, Linux, Windows 10+ are available as zip files in the releases page. Just extract and run directly with no need to install. Ho

I Dropped the Production Database on a Friday Night

How I Dropped the Production Database on a Friday Night The case for moving fast and breaking things (before your competitors kill you) The worst 7PM in my software engineering career Picture this: It's a Friday evening in Paris, and I'm wrapping up what should have been a routine week at Joe AI, the real-estate startup where we were building an AI agent that automated communications for property developers across France. I had just finished what I thought was a clean migration: moving our en

Show HN: Workout.cool – Open-source fitness coaching platform

Workout.cool Modern fitness coaching platform with comprehensive exercise database Table of Contents Contributors About A comprehensive fitness coaching platform that allows create workout plans for you, track progress, and access a vast exercise database with detailed instructions and video demonstrations. 🎯 Project Origin & Motivation This project was born from a personal mission to revive and improve upon a previous fitness platform. As the primary contributor to the original workout.lo

Workout.cool – Open-source fitness coaching platform

Workout.cool Modern fitness coaching platform with comprehensive exercise database Table of Contents Contributors About A comprehensive fitness coaching platform that allows create workout plans for you, track progress, and access a vast exercise database with detailed instructions and video demonstrations. 🎯 Project Origin & Motivation This project was born from a personal mission to revive and improve upon a previous fitness platform. As the primary contributor to the original workout.lo