Tablesample Picks Rows(boringsql.com)
3 points by surprisetalk | 0 comments
A technical blog post explaining how PostgreSQL's TABLESAMPLE SYSTEM and BERNOULLI methods select rows by hashing physical addresses, and the resulting sampling biases.
#sql on Hacker News
47 stories tagged sql, newest first.
DuckDB 2.0.0 LTS “Cinnamon Teal”(duckdb.org)
439 points by nnx | 62 comments
DuckDB blog post announcing the 2.0.0 LTS "Cinnamon Teal" release, covering the Quack server protocol, async I/O, VARIANT type, agent mode, new PEG parser and migration notes.
How Postgres DELETE can actually scale(dbos.dev)
22 points by KraftyOne | 6 comments
A DBOS blog post by Peter Kraft and Qian Li explaining how to make large-scale DELETE operations in Postgres perform and scale well.
SQLAlchemy 2.1.0 Released(sqlalchemy.org)
18 points by kbumsik | 3 comments
Blog post on the SQLAlchemy website announcing the release of SQLAlchemy 2.1.0, the Python SQL toolkit and ORM.
Why DuckDB 2.0 is faster(motherduck.com)
192 points by tosh | 60 comments
MotherDuck blog post by Mehdi Ouazza testing DuckDB 2.0 alpha features like async I/O over S3 and recursive CTEs, explaining why the new version is faster.
The Query Transformation Pipeline(readyset.io)
14 points by gvsg-rs | 0 comments
Readyset blog post explaining how its query transformation pipeline rewrites SQL queries internally.
DOOM, simulated and rendered inside the Firebird SQL database using WASM(github.com)
6 points by mariuz | 1 comments
GitHub repository for a project that simulates and renders DOOM inside the Firebird SQL database, running in the browser via Firebird compiled to WebAssembly.
We ported the original Doom to SQL(cedardb.com)
293 points by Vaslo | 45 comments
CedarDB blog post describing a port of the original 1993 Doom game logic and renderer to SQL, running inside the database with Python only handling timing and display.
Show HN: Graphene – Data analysis toolkit for your coding agent(github.com)
22 points by kcmarr | 7 comments
GitHub repository for Graphene, an open source toolkit giving coding agents a semantic layer and MDX-style dashboards for data analysis.
I could've accessed 17T Microsoft records(blog.faav.net)
287 points by luispa | 120 comments
A security researcher's blog post describing a Microsoft internal analytics service flaw where unchecked token signatures allowed admin access to query 17.3 trillion records.
Footguns with Postgres “at time zone 'UTC'”(bookofrevenue.com)
154 points by birdculture | 92 comments
Blog post explaining pitfalls of Postgres's AT TIME ZONE 'UTC' operator and why it may need to be applied twice.
Is your Postgres migration safe or not safe?(safenotsafe.dev)
117 points by vira28 | 40 comments
A browser-based tool that parses PostgreSQL migration SQL with libpg_query WASM and flags operations that may be unsafe, such as locking schema changes.
Postgres SELECT DISTINCT Does Not Scale(dbos.dev)
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.
A Preview of DuckDB v2.0(duckdb.org)
684 points by ibotty | 120 comments
DuckDB blog post previewing v2.0 features including server mode, triggers, VARIANT type, async I/O, a new SQL parser and storage format.
Free SQL→ER diagram tool, runs in the browser, nothing uploaded(sqltoerdiagram.com)
334 points by robhati | 65 comments
A free in-browser tool that parses SQL CREATE TABLE statements and renders an entity-relationship diagram, with PNG/SVG export and no data uploaded.
ggsql: A Grammar of Graphics for SQL(opensource.posit.co)
438 points by thomasp85 | 81 comments
Posit Open Source blog post announcing the alpha release of ggsql, a grammar-of-graphics visualization language built on SQL.
Unconventional PostgreSQL Optimizations(hakibenita.com)
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
Show HN: Use Claude Code to Query 600 GB Indexes over Hacker News, ArXiv, etc.(exopriors.com)
357 points by Xyra | 123 comments
Landing page for Exopriors Scry, a tool giving Claude arbitrary SQL and vector-algebra search over indexes of arXiv, Hacker News, LessWrong and other sources.
Supabase MCP can leak your entire SQL database(generalanalysis.com)
798 points by rexpository | 433 comments
A General Analysis blog post describing how Supabase's MCP server can be exploited via prompt injection to leak an entire private SQL database.
Getting AI to write good SQL(cloud.google.com)
459 points by richards | 311 comments
Google Cloud blog post explaining techniques Google uses to improve Gemini's generation of SQL from natural language (text-to-SQL).
DuckDB is probably the most important geospatial software of the last decade(dbreunig.com)
444 points by dbreunig | 139 comments
Blog post by Drew Breunig arguing that DuckDB's spatial extension has made geospatial data accessible to far more people than specialized GIS tools.
Instant SQL for results as you type in DuckDB UI(motherduck.com)
355 points by ryguyrg | 117 comments
MotherDuck blog post announcing Instant SQL, a feature in the DuckDB UI that previews ad-hoc query results as you type.
Postgres Language Server: Initial Release(github.com)
317 points by steinroe | 50 comments
GitHub repository for the Supabase community's Postgres Language Server, an MIT-licensed LSP implementation for PostgreSQL and SQL tooling.
The DuckDB Local UI(duckdb.org)
868 points by xnx | 181 comments
DuckDB blog post announcing a local web-based UI for DuckDB, built with MotherDuck and shipped as part of the ui extension.
I Went to SQL Injection Court(sockpuppet.org)
1162 points by mrkurt | 416 comments
Blog post by Thomas Ptacek about testifying in an Illinois court case over whether public bodies can withhold database schemas from FOIA requests, and pending legislation.
Show HN: SQL Noir – Learn SQL by solving crimes(sqlnoir.com)
380 points by chrisBHappy | 78 comments
SQL Noir is an open-source interactive detective game where players solve crime mysteries by writing real SQL queries.
Advent of Code 2024 in pure SQL(databasearchitects.blogspot.com)
461 points by greghn | 103 comments
Blog post describing solving every Advent of Code 2024 puzzle in pure SQL, with a full recursive-query solution for one day shown as an example.
SQLiteStudio: Create, edit, browse SQLite databases(sqlitestudio.pl)
540 points by thunderbong | 104 comments
Homepage of SQLiteStudio, a free desktop application for creating, editing, and browsing SQLite databases, announcing the 3.4.6 hotfix release.
What I wish someone told me about Postgres(challahscript.com)
389 points by todsacerdoti | 161 comments
A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.
Sq.io: jq for databases and more(sq.io)
535 points by stavepan | 110 comments
Homepage of sq, a command-line tool for querying and wrangling data from databases and files with jq-like syntax.
PostgreSQL 17(postgresql.org)
493 points by jkatz05 | 102 comments
Official PostgreSQL news announcement of the PostgreSQL 17 release on September 26, 2024.
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)(sqlitebrowser.org)
323 points by punnerud | 54 comments
Homepage of DB Browser for SQLite, an open source visual tool for creating, searching, and editing SQLite database files on Windows, macOS, and Linux.
DuckDB Doesn't Need Data to Be a Database(nikolasgoebel.com)
353 points by tosh | 115 comments
A blog post by Nikolas Göbel discussing how DuckDB can act as a database without storing data itself, querying external data sources directly.
Show HN: We open sourced our entire text-to-SQL product(github.com)
437 points by aazo11 | 140 comments
GitHub repository for Dataherald, an open-sourced natural-language-to-SQL engine using LLM agents, with admin console, enterprise backend, and Slackbot services.
GPT in 500 Lines of SQL(explainextended.com)
1038 points by thunderbong | 70 comments
Blog post from Explain Extended implementing a GPT-style large language model inference in about 500 lines of SQL, as a New Year's post.
SQL for data scientists in 100 queries(gvwilson.github.io)
694 points by Anon84 | 130 comments
Greg Wilson's "SQL for the Weary" lesson notes with working examples for instructors teaching SQL to data scientists in about 100 queries.
Show HN: Natural-SQL-7B, a strong text-to-SQL model(github.com)
324 points by thecalebf | 157 comments
GitHub repository for Natural-SQL, a series of text-to-SQL language models including Natural-SQL-7B, with notebooks and prompt files.
Vanna.ai: Chat with your SQL database(github.com)
507 points by ignoramous | 215 comments
GitHub repository for Vanna, an MIT-licensed tool for chatting with SQL databases using LLM-based text-to-SQL generation with retrieval-augmented generation.
PostgreSQL 16(postgresql.org)
440 points by pella | 47 comments
Official PostgreSQL news announcement of the PostgreSQL 16 release on September 14, 2023.
Postgres Language Server(github.com)
899 points by kiwicopple | 112 comments
GitHub repository for Supabase's Postgres Language Server, an LSP implementation that uses the real Postgres parser via libpg_query for IDE features.
PRQL: Pipelined Relational Query Language(github.com)
469 points by animal_spirits | 188 comments
GitHub repository for PRQL, a pipelined relational query language that compiles to SQL as a simpler, more composable alternative.
Is ORM still an anti-pattern?(github.com)
337 points by AnhTho_FR | 611 comments
A GitHub wiki page from the Lago project arguing that ORMs are criticized for the wrong reasons and examining whether ORM is still an anti-pattern.
Open source hospital price database(dolthub.com)
457 points by alecst | 221 comments
DoltHub repository page for the transparency-in-pricing database, a 62.9 GB open dataset of US hospital prices with a SQL query view of the rate table.
Ways to shoot yourself in the foot with Postgres(philbooth.me)
635 points by philbo | 218 comments
Blog post by Phil Booth describing nine PostgreSQL gotchas, mostly scalability-related, that can cause production problems as databases grow.
Show HN: I made a SQL game to help people learn / challenge their skills(lost-at-sql.therobinlord.com)
498 points by robinLord | 98 comments
Lost at SQL is a browser-based nautical-themed game for learning SQL through a story mode and SQL challenges.
Evidence.dev – Business Intelligence as Code(evidence.dev)
342 points by hughess | 88 comments
Landing page for Evidence, an open-source business intelligence tool for building data products and reports with SQL and markdown.
Postgres as a graph database(dylanpaulus.com)
557 points by elorant | 127 comments
Blog post by Dylan Paulus explaining how to model and query graph data structures in PostgreSQL instead of using a dedicated graph database.