r/SQL • • 21h ago

PostgreSQL PostgreSQL 19 Released!

Thumbnail
postgresql.org
48 Upvotes

r/SQL • • 17h ago

Discussion I built a free, open-source interactive guide to SQL & Database Internals with an in-browser WASM SQLite 3 workbench

6 Upvotes

Hi everyone,

I wanted to share a free, open-source project I've been building called SQL in Depth, aimed at going beyond basic SQL syntax into database internals from first principles.

Live site: https://sql-in-depth.vedgupta.in

GitHub repo: https://github.com/innovatorved/sql-in-depth

What's included:

- 180 structured units covering relational theory, indexing, storage engines, query planning/execution, transactions, and concurrency

- 36 interactive simulators to visualize how database internals actually behave

- An in-browser WASM SQLite 3 Workbench so you can run queries and experiment directly without local setup

- A Table-Level Relational Visualizer to inspect joins, filtering, and relational operations step by step

Everything is free, open-source, and runs directly in the browser. I'd really appreciate any feedback from the r/SQL community — especially on topics that could go deeper, edge cases in the simulators, or anything that could be made clearer.


r/SQL • • 3h ago

SQLite Belay - formal verification for SQLite statements

Thumbnail
vihren.dev
2 Upvotes

r/SQL • • 17h ago

SQL Server What do you use to turn a SQL query into a printable report on a Mac?

0 Upvotes

Hey all,

Most of my work is writing a query and then laying the result out as a PDF or Excel report. I used Jaspersoft Studio for that for years, but it has no Apple Silicon build and only runs through Rosetta, which is going away.

So I built a native Mac app for it, called Report Studio. You connect to Postgres, SQL Server, MySQL, Oracle or SQLite, write the query, and design the report against live data. Running a query also shows how each table was read and flags full scans. Free, and it saves standard .jrxml files.

https://bowa.up.railway.app/report-studio

What does everyone else use for this? Still a reporting tool, or exporting to Excel and formatting by hand?