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"
BEAVER: Enterprise benchmark for LLM Text-to-SQL from private data warehouses
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…
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 …
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…
Rewald
Portable real-time SQL database. One binary, SQL over a WebSocket, predicated subscriptions evaluated server-side. - Akira-AA83/rewald…
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 20000: case_not_found — What It Means and How to Fix It PostgreSQL error...…
Oracle ORA-00215 Error: Causes and Solutions Complete Guide
ORA-00215: Must Be at Least One Control File — Causes, Fixes & Prevention ORA-00215 is...…
HammerDB TPC-C Analysis on TidesDB v9.3.3/TideSQL v4.5.4 and InnoDB in MariaDB v11.8.6
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...…
PostgreSQL CLI Setup
How I Built a 7-Layer NL2SQL Guardrail Stack for a Fortune 500 Enterprise
Liquid syntax error: Unknown tag 'endraw'…
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...…
SQL-like Queries in FSRS Plugin for Obsidian
SQL-like Queries in FSRS Plugin for Obsidian Spaced repetition in Obsidian usually works...…
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...…
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,...…
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...…
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...…
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...…
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드
08003 connection does not exist 는? PostgreSQL 에러 코드 08003은 클라이언트가 이미 존재하지 않는 데이터베이스 연결을 통해...…
Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드
ORA-00057 maximum number of temporary table locks exceeded 는? ORA-00057 에러는 Oracle...…
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...…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning ...…
Build an AI Data Analyst That Needs No SQL
The Problem: Your Team Has Questions, Your Data Has Answers, and SQL Sits in Between In...…
SQLite is all you need for durable workflows
Part 08: Designing Tables, Data Types and Constraints
Part of the "SQL: Zero to Ninja" series, for junior web devs who want SQL to finally click. Up to...…
Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026
Recent licensing and distribution changes (MinIO archived, Bitnami catalog reduced, Crunchy Data redistribution limits) reshape what "open source" means for Kubernetes Postgres ope…
Practical Docker 29.5.2 setup for a Java 25 / Spring Boot 4.0.6 / PostgreSQL backend project using a vide-coding approach
SQL Learning Material
One Practical SQL Trigger Example You Can Actually Use
One UPDATE statement. One trigger. One automatic audit record — no extra code required. Triggers are...…
Why MySQL performance sucks!
Debo Data Studio – Visual ETL that compiles pipelines to a single SQL query
Contribute to Debo-et/Debo_data_studio development by creating an account on GitHub.…
MongoDB `$facet` Explained: One Query, Multiple Results
Sometimes one MongoDB aggregation needs to return more than one result. For example, from the same...…
How to set up PostgreSQL permissions for AI coding tools (Cursor, Claude, Copilot)
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin...…
Key Joins (SQL Proposal)
Show HN: Claude Code AskUserQuestion which works for subagents/teams/workflows
A-Z Database Glossary
A comprehensive reference of database terms from A to Z written for beginners and anyone learning how...…
PostgreSQL 02000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 02000: No Data PostgreSQL SQLSTATE 02000 ("no data") occurs when a query...…
Oracle ORA-00036 Error: Causes and Solutions Complete Guide
ORA-00036: Maximum Number of Recursive SQL Levels Exceeded ORA-00036 occurs when Oracle's...…
RSQL – High-Performance, Open Source PostgreSQL Client (Tauri v2, React, Rust)
A Tauri application for efficient and secure database management. - rust-dd/rsql…
SQLite Does Not Accept Agentic Code
SQLite gained an AGENTS.md file five days ago - but it's not intended for their own development, it's presumably aimed at people who are pointing agents at the SQLite codebase. ……
HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal - HeidiSQL/HeidiSQL…
SQL Injection Protection in Flask: A Practical Guide. Part 5 of e2ee chat series
The Problem Most developers think their database is safe. It's not. SQL injection attacks...…