sql

52 stories and discussions about sql, aggregated from every source we track.

1.

Paste SQL, parse it locally, and catch Postgres migration lock and rewrite risks before deploy.

116 points•vira28•about 2 months ago•40 comments•
2.

Give your agent the internet hypercube. Run programs over billions of documents, for fun and profit.

60 points•Xyra•2 months ago•26 comments•
4.

In March 2026, a financial services company discovered that their customer-facing AI agent had been...

27 points•james_anderson_h•about 2 months ago•21 comments
6.

Write SQL. Keep TypeScript. Skip the query-builder translation layer. - Clickin/SQLBraid

8 points•Clickin•2 months ago•3 comments•
7.

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

8 points•fractalbeauty•3 months ago•1 comment
8.

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

6 points•theanonymousone•2 months ago•0 comments•
9.

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...

5 points•noncrab•over 3 years ago•1 comment
10.

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…

5 points•calvin•about 9 years ago•0 comments
11.

A free embed that turns the SQL in your blog posts into real Postgres queries readers can edit and run without leaving the page.

4 points•mikenikles•about 2 months ago•0 comments•
12.

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…

4 points•abdullahk0634•2 months ago•0 comments•
13.

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

4 points•davidborras•2 months ago•0 comments•
15.

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.

4 points•nalentados•almost 9 years ago•0 comments
16.

OpenStreetMap data extracted into thematic layers and converted to cloud-native file formats that are easy to use with software from DuckDB to QGIS.

3 points•raybb•about 2 months ago•0 comments•
17.

Free, simple, and intuitive online database diagram editor and SQL generator. - drawdb-io/drawdb

3 points•redbell•about 2 months ago•0 comments•
18.
3 points•durner•2 months ago•0 comments•
19.
2 points•Vaslo•about 2 months ago•3 comments•
20.
2 points•Alephinitesimal•about 2 months ago•0 comments•
21.

US public data at the edge: offline NHTSA vPIC VIN decoder, verified against NHTSA's own SQL - AIKitLLC/nhtsa-edge-api

2 points•tuannx•about 2 months ago•0 comments•
22.

DuckDB is a SQL OLAP database management system. Simple, feature-rich, fast & open source.

2 points•nvmdbljstm•about 2 months ago•1 comment•
23.

Maximizing perf on AI-SQL queries with the KV-optimal left-deep join

2 points•charles_irl•about 2 months ago•0 comments•
24.
2 points•ibobev•about 2 months ago•1 comment•
25.
2 points•kciter•about 2 months ago•0 comments•
26.
2 points•Vaslo•about 2 months ago•1 comment•
27.

DuckDB extension: typed Jev answers as real SQL types - colliber/duckdb-jev

2 points•jmrothweiler•2 months ago•0 comments•
28.

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...

2 points•eatonphil•7 months ago•0 comments
29.

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…

2 points•raymii•about 6 years ago•0 comments
30.

<p>Inspired by HugSQL written in Clojure.</p>

2 points•pims•over 7 years ago•0 comments
31.
1 points•shscs911•about 2 months ago•0 comments•
32.
1 points•vinhnx•about 2 months ago•0 comments•
33.
1 points•kerng•about 2 months ago•0 comments•
34.
1 points•swingbit•about 2 months ago•0 comments•
35.
1 points•birdculture•about 2 months ago•0 comments•
36.

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.

1 points•fabioselau•about 2 months ago•0 comments•
37.

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…

1 points•teeskay•about 2 months ago•0 comments•
38.
1 points•fanf2•about 2 months ago•0 comments•
39.

Interactive SQL query visualizer and analytical database client - Hemlig371/queryast-lens

1 points•Hemlig371•about 2 months ago•0 comments•
40.

Drop in structured memory for agent harnesses. Contribute to tjbroodryk/ingot development by creating an account on GitHub.

1 points•tjbroodryk•about 2 months ago•1 comment•
41.

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…

1 points•teeskay•about 2 months ago•0 comments•
42.

dbt-style reproducible data builds with DuckDB and Make - ltrgoddard/duckdb.mk

1 points•ltrg•about 2 months ago•0 comments•
43.

Learn how PostgreSQL timestamp and timestamptz compare with SQL Server datetime2 and datetimeoffset, including precision, offsets, and storage.

1 points•ibobev•about 2 months ago•0 comments•
44.

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.

1 points•matt_d•about 2 months ago•0 comments•
45.
1 points•carli2•about 2 months ago•0 comments•
46.

Browse, filter, and edit your Firebase Data Connect (PostgreSQL) tables at the speed of thought — no page reloads, no friction.

1 points•moshercode•about 2 months ago•0 comments•
47.

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.

1 points•thunderbong•2 months ago•0 comments•
48.

A durable SQL database shared by every session in a project environment

1 points•iacguy•2 months ago•0 comments•
49.

Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!

1 points•gregsadetsky•2 months ago•0 comments•
50.

The SQL parser powering pgdog.dev. Contribute to pgdogdev/pg_raw_parse development by creating an account on GitHub.

1 points•levkk•2 months ago•0 comments•
51.
1 points•yahikoyama•2 months ago•0 comments•
52.

"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

0 points•Kyle Orland•about 2 months ago•0 comments

Related topics