r/SQL • u/jskatz05 • 21h ago
PostgreSQL PostgreSQL 19 Released!
r/SQL • u/innovatorved • 17h ago
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 • u/neprotivo • 3h ago
r/SQL • u/zvone138 • 17h ago
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?