sql
52 stories and discussions about sql, aggregated from every source we track.
Paste SQL, parse it locally, and catch Postgres migration lock and rewrite risks before deploy.
Give your agent the internet hypercube. Run programs over billions of documents, for fun and profit.
In March 2026, a financial services company discovered that their customer-facing AI agent had been...
Write SQL. Keep TypeScript. Skip the query-builder translation layer. - Clickin/SQLBraid
The SQL optimizer is an important module in relational database systems. Its purpose is to optimize SQL statements to improve query efficiency. To help beginners understand the basic principles of the
Classify text in SQL with prompt_jev(), powered by TypeSafe's Jev. 100,000 rows labeled in 40 seconds for $0.50 at frontier-LLM accuracy. Live on paid plans. | Reading time: 5 min read
I'm going to a small academic workshop on design next week. This got me thinking of the various meanings of "design", which got me thinking about the various...
The SQL language has one great advantage over procedural, object oriented, and “ordinary” functional programming languages. The fact that it is truly declarative (i.e. a 4GL / fourth ge…
A free embed that turns the SQL in your blog posts into real Postgres queries readers can edit and run without leaving the page.
LibreDB Studio is an open-source, self-hosted, browser-based SQL editor. It runs as a single server, either via npx, Docker, or a native package, and is reached through the browser rather than installed as a desktop…
Eleven Supabase/Postgres production failure modes, found by one SQL file you paste into the SQL Editor. No install, no credentials shared. - Concepto505/supabase-audit
A testing release of CrateDB 2.3 has just been published, and it's been enhanced with user password authentication, many SQL improvements, new doc and more.
OpenStreetMap data extracted into thematic layers and converted to cloud-native file formats that are easy to use with software from DuckDB to QGIS.
Free, simple, and intuitive online database diagram editor and SQL generator. - drawdb-io/drawdb
US public data at the edge: offline NHTSA vPIC VIN decoder, verified against NHTSA's own SQL - AIKitLLC/nhtsa-edge-api
DuckDB is a SQL OLAP database management system. Simple, feature-rich, fast & open source.
Maximizing perf on AI-SQL queries with the KV-optimal left-deep join
DuckDB extension: typed Jev answers as real SQL types - colliber/duckdb-jev
We talk here sometimes about how to test SQL dialects with tools like TLP and PQS. One really nice property of those tools is that they let you treat the...
After 6 months of messing around with gnuCOBOL, I am finally to the point of trying to implement Embedded SQL. What is Embedded SQL? In all of the programming I’ve done / seen, SQL is accesse…
<p>Inspired by HugSQL written in Clojure.</p>
Rowbird runs your SQL queries on a schedule and delivers the results to email, Slack, Telegram, Discord, webhooks and S3, as a table or as CSV, Excel and PDF. Open source, one binary, no telemetry.
OmniSelect FileSQL turns CSV, Excel, JSON, Parquet, SQLite, SPSS and many more file types into SQL tables inside your browser. Ask a question in plain English and get the SQL, or write your own; join, filter and…
Interactive SQL query visualizer and analytical database client - Hemlig371/queryast-lens
Drop in structured memory for agent harnesses. Contribute to tjbroodryk/ingot development by creating an account on GitHub.
OmniSelect FileSQL turns CSV, Excel, JSON, Parquet, SQLite, SPSS and many more file types into SQL tables inside your browser. Ask a question in plain English and get the SQL, or write your own; join, filter and…
dbt-style reproducible data builds with DuckDB and Make - ltrgoddard/duckdb.mk
Learn how PostgreSQL timestamp and timestamptz compare with SQL Server datetime2 and datetimeoffset, including precision, offsets, and storage.
Quail jointly plans AI-SQL queries and model inference. Across 29 QUAIL-B queries, it is 1.84x faster on average than well-tuned vLLM baselines.
Browse, filter, and edit your Firebase Data Connect (PostgreSQL) tables at the speed of thought — no page reloads, no friction.
A space strategy game played entirely inside PostgreSQL. Buy ships with INSERT, steer them in SQL, and write PL/pgSQL scripts that fly your fleet. Free, in the browser or psql.
A durable SQL database shared by every session in a project environment
Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
The SQL parser powering pgdog.dev. Contribute to pgdogdev/pg_raw_parse development by creating an account on GitHub.
"Rendering Doom in a database is obviously a bad idea," Lukas Vogel writes in a lengthy blog post explaining how exactly he managed to render Doom using an SQL database. OK, that's not entirely accurate. The SQLDoom project uses a small Python client to handle input and output, drive the game's timing, and display each frame to the screen. Behind that, a series of CedarDB tables tracks the game geometry and state, while about 1,300 lines of SQL queries spread across 89 common table expressions implement the game logic and generate 35 bitmap framebuffers per second. In this, SQLDoom is a major improvement over Vogel's previous DoomQL project , which last year set out to build "a multiplayer Doom-like shooter entirely in SQL." Unfortunately, that effort ended up with raycasting-based, grayscale ASCII graphics that were more akin to the simplistic 90-degree-angled maps of Wolfenstein 3D . The newer SQLDoom, on the other hand, generates full-color 640x480 frames that look like they could have come from the original Doom executable. Read full article Comments