» Tag
sql
29 postsAI Agents Write PostgreSQL Like Python
Exploring how AI agents write SQL in a Pythonic style and the resulting challenges.
Sqlsure: Deterministic Checks for AI-Generated SQL
Sqlsure quickly and reliably checks SQL queries generated by AI. It provides an effective solution to prevent errors.
Indexing the Data Lake for Online Point Queries
Spotify and others leverage RAP to optimize point queries in data lakes.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comSynnoDB: Accelerating SQL with Custom Engines for DuckDB
SynnoDB accelerates SQL queries for DuckDB using custom C++ engines.
SQL Injection in AI-Generated Code: Why Cursor Keeps Writing It
AI editors use string interpolation for SQL, leading to vulnerabilities. Use parameterized queries to fix this.
We Built a Local SQL Engine for DynamoDB
DynoTable's local SQL engine enhances DynamoDB with essential SQL functionalities.
The Startup's Postgres Survival Guide: Tips for Engineers
A guide compiling experiences with Postgres. Tips and best practices for developers.
Commit Chronicles: Unveiling Your Story Through SQL
Commit Chronicles reveals the story behind a GitHub repo's commit history. An essential tool for developers.
PostgreSQL Batch UPSERT with CTE: From 90 Seconds to 5
An email sync process with audit history was rewritten from separate queries into a single PostgreSQL CTE, cutting 100k-row processing time from 90 seconds to 5.
Sqlfmt: A gofmt-style Formatter for SQL
Sqlfmt is a tool that formats SQL queries in a gofmt style, inspired by PostgreSQL books.