60 stories tagged with #sql, in publish-time order across the WeSearch catalog. Tag pages update as new stories ingest.
⌘ RSS feed for this tag → or search "Sql"
Show HN: Kedge – Full-stack cloud with forkable VM snapshots and global SQLite
PostgreSQL's MVCC is bad. So is everyone else's
The critics are right: PostgreSQL's MVCC bloats tables and amplifies writes. Oracle, InnoDB, SQL Server, MongoDB, LSM stores, and etcd answer the same four design questions differe…
Cesium DevCon 2026 talks are up, including a keynote from SQLite's creator
Watch the recordings from the 2025 Cesium Developer Conference, featuring technically oriented, community-driven sessions curated across six tracks, keynotes, panels, and a pre-con…
Choose DuckDB rather than SQLite
Same $16.49/month server, same Traceway binary, two embedded databases. DuckDB writes 4x to 15x faster than SQLite, serves dashboards at 100x the row count, and stores a billion me…
After rewriting SQLite in Rust, Turso turns its sights on Postgres
Cloud database upstart wants one virtual machine core to power multiple SQL frontends…
SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers
Transitioning SQLite from a local development tool to a production-grade database requires a deep understanding of its internal mechanics. This article explores how to tune WAL mod…
AI-Powered Retrieval in PostgreSQL with Azure HorizonDB
Developers need flexible, efficient item searches by description. Using a Wikipedia movie dataset, I started with full-text search, then created embeddings...…
Show HN: DynoTable – The DynamoDB GUI with real SQL and your AI agent
A fast, local-first DynamoDB GUI. Real SQL with JOINs, GROUP BY and aggregates, PartiQL, and an AI agent on your own Bedrock keys. Free plan, no time limit.…
SQLite WAL Mode Can Lock Short-Lived Readers
Comments…
PGSimCity - How PostgreSQL Works
An explorable 3D city that shows how PostgreSQL actually works — backends, shared buffers, WAL, checkpoints, autovacuum and replication, all running live in your browser.…
stinkpot: sqlite-backed shell history
Comments…
SHRIDHAR KHANAL: The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database
Giving an external team access to your PostgreSQL database is one of those decisions that deserves a little thought. The easiest option is to hand over a superuser account, but it’…
Ahsan Hadi: Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
In my previous blog on the pgEdge Vectorizer and RAG Server , I showed how to build a semantic search pipeline using dense vector embeddings. The RAG Server already did hybrid sear…
stinkpot: sqlite-backed shell history
16 comments…
stinkpot: sqlite-backed shell history
16 comments…
stinkpot: sqlite-backed shell history
16 comments…
Show HN: DeepSQL – A self-hostable AI DBA agent for Postgres and MySQL
Hi HN - I'm Venkat, founder of Stayflexi (YC), CMU CS grad and Ex-Oracle Query Engine team (patents in core databases) DeepSQL started as an internal tool to stop our own databases…
AI agents write PostgreSQL like Python
Field notes from a production review of an AI-written PostgreSQL backend: exception blocks as control flow, casts that turn bad requests into 500s, races on state-advancing updates…
Rethinking Databases for Humans and AI Agents
Databases Were Built for Engines. It’s Time to Build Them for Humans.…
June 2026 newsletter
The June edition of my sponsors-only monthly newsletter is out. If you are a sponsor (or if you start a sponsorship now) you can access it here . This month: Claude Fable 5, GPT-5.…
noslow — open-source middleware that detects slow SQL queries and gives you the fix
BEAVER: Enterprise benchmark for LLM Text-to-SQL from private data warehouses
Optimistic concurrency is the whole design: event sourcing on Aurora DSQL
How an incident-command record built on Amazon Aurora DSQL stays consistent under cross-region contention, and why the property that lets the database survive a region loss is the …
Surviving the region you run in: failover on Aurora DSQL, and what the demo proves
How Quorum's failover layer works on Amazon Aurora DSQL multi-region clusters, an honest account of what the chaos demo simulates and what it does not, and where the survival story…
datasette-agent-edit 0.1a0
Release: datasette-agent-edit 0.1a0 I'm planning several plugins for Datasette Agent which can make edits to existing pieces of text - things like collaborative Markdown editing, u…
Running Python code in a sandbox with MicroPython and WASM
I've been experimenting with different approaches to running code in a sandbox for several years now, but my latest attempt feels like it might finally have all of the characterist…
Microsoft allows BYOL for Amazon RDS. Repeat, Microsoft allows BYOL for Amazon RDS
SQL Server licenses can now be consumed in the rival cloud's DBaaS…
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters
Opening a new database connection for every query is one of the most expensive things your backend...…
# Modernizing the Pitch: Building an Automated SQL Data Quality and Transformation Pipeline for Multi-Club Scouting Platforms
In global football administration, data is the ultimate competitive edge. Multi-club organizations...…
Handling Graphs with SQL/PGQ in PostgreSQL
Writing a Custom SQL Database Engine in C++17: Implementing MVCC, WAL, and a Bitmask DP Join Optimizer with Zero External Dependencies
Native Go file sql
Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"
A deep dive into one of the most clever tricks in database engineering - explained so simply, your...…
Implementing Soft Deletes in SQLAlchemy: Keeping Audit Trails Without Orphaning Foreign Keys in Multi-Tenant Systems
Design a polymorphic soft-delete pattern using SQLAlchemy's declarative mixins that preserves referential integrity across tenant boundaries, enables point-in-time recovery, and pr…
Oracle ORA-00215 Error: Causes and Solutions Complete Guide
ORA-00215: Must Be at Least One Control File — Causes, Fixes & Prevention ORA-00215 is...…
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 20000: case_not_found — What It Means and How to Fix It PostgreSQL error...…
Rewald
Portable real-time SQL database. One binary, SQL over a WebSocket, predicated subscriptions evaluated server-side. - Akira-AA83/rewald…
HammerDB TPC-C Analysis on TidesDB v9.3.3/TideSQL v4.5.4 and InnoDB in MariaDB v11.8.6
PostgreSQL CLI Setup
Getting Started with Vector Databases Using Amazon Aurora PostgreSQL + pgvector
Hello! I'm Satoshi Kaneyasu, DevOps engineer at Serverworks. In this article, I'll introduce the...…
How I Built a 7-Layer NL2SQL Guardrail Stack for a Fortune 500 Enterprise
Liquid syntax error: Unknown tag 'endraw'…
SQL-like Queries in FSRS Plugin for Obsidian
SQL-like Queries in FSRS Plugin for Obsidian Spaced repetition in Obsidian usually works...…
Great Stack to Doesn't Work Bonus: SQL vs NoSQL: Which One in 2026?
The honest decision framework, not another flame war. The SQL vs NoSQL debate has been running...…
AstralDB (my custom RDBMS) beat both DuckDB and SQLite on a 10M row bulk load and sliding window aggregate by orders of magnitude
Installing PostgreSQL on Arch Linux | Practical Setup Guide
Installing postgres on windows/mac is pretty simple, you just follow the steps on the installation...…
Show HN: MigraDiff v1.3.0 – PostgreSQL schema diff with AI migration explanation
Install pip install --upgrade migradiff What's New AI-Powered Migration Explanation (--explain) MigraDiff can now explain any migration in plain English — what each change does, w…
PostgreSQL tool that you wish ware not deprecated
Oracle Fusion Report Scheduling with Skip Conditions
In Oracle Fusion Applications, report scheduling plays a crucial role in automating business...…
From ASP.NET + MSSQL to PHP + MySQL: Migrating a Names Site Without Mangling the Accents
My baby-name site started life on ASP.NET with a MSSQL backend. It worked. The reason I rewrote the...…
YouTube Backend: How Database & Data Management Actually Work
If you've ever wondered what happens the moment you hit "upload" on a YouTube video, you're asking...…
Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js
If you've spent most of your career building beautiful UIs, managing state, and wrestling with CSS,...…
UUID v4 vs UUID v7 — Lequel choisir pour PostgreSQL en 2026 ?
Si vous utilisez PostgreSQL, vous avez probablement déjà dû choisir entre une clé primaire BIGSERIAL...…
Great Stack to Doesn't Work Bonus: 10 PostgreSQL Features You Didn't Know Existed
Between episodes, here's something lighter. Still useful. Still PostgreSQL. You've used...…
Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드
ORA-00057 maximum number of temporary table locks exceeded 는? ORA-00057 에러는 Oracle...…
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드
08003 connection does not exist 는? PostgreSQL 에러 코드 08003은 클라이언트가 이미 존재하지 않는 데이터베이스 연결을 통해...…
Building a Production-Grade Customer Inquiry Auto-Responder with SQLite Logging
The Journey I set out to build an efficient automation backend utility designed to...…
MP3 - SQLi, XSS, and CSRF WriteUp
Introduction For Machine Problem 3, our group — Aki, Lark, and Carl — was tasked with...…
SQL Pattern Series #1: The Presence Pattern
Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of...…
SQL for Developers: The Practical Guide (2026)
SQL for Developers: The Practical Guide (2026) You don't need to be a DBA to write good...…
3 Files Every AI-Assisted Project Needs Before You Write a Line of Code
Most developers think of project setup as: install dependencies, configure TypeScript, set up...…