Hacker News with Generative AI: SQL

Instant SQL for results as you type in DuckDB UI (motherduck.com)
Today, we’re releasing Instant SQL, a new way to write SQL that updates your result set as you type to expedite query building and debugging – all with zero-latency, no run button required. Instant SQL is now available in Preview in MotherDuck and the DuckDB Local UI.
SQL, Databases, Tools, Software, User Interface
368 points by ryguyrg 2 days ago | 118 comments
Sqlc: Generate type-safe code from SQL (github.com/sqlc-dev)
sqlc generates type-safe code from SQL.
SQL, Type Safety, Code Generation, Programming Languages, Databases
5 points by todsacerdoti 9 days ago | 0 comments
Show HN: Time Travel with Your SQL (ycombinator.com)
Hi, my name is Anguel and I am one of the developers of WhoDB (https://github.com/clidey/whodb)
Databases, SQL, Time Travel
44 points by modelorona 15 days ago | 18 comments
OLAP Hierarchical Aggregation with DuckDB SQL Recursive Common Table Expressions (medium.com)
Aggregation for dimensional hierarchies doesn’t require costly Business Intelligence (BI) tools. You can use recursive SQL techniques to express your hierarchical data in relational form, allowing for easy and fast aggregation along multiple levels and dimensions.
SQL, Databases, Data Analysis, Data Warehousing, Recursive SQL
7 points by tanelpoder 16 days ago | 1 comments
Database Protocols Are Underwhelming (byroot.github.io)
If you’ve been in this trade for a while, you have probably seen dozens of debates on the merits and problems of SQL as a relational database query language.
Databases, SQL, Programming, Technology
114 points by PaulHoule 21 days ago | 29 comments
Query GPT: Transform Natural Language into SQL (query-gpt.com)
SQL, Databases, Tools
17 points by pekingzcc 21 days ago | 11 comments
Show HN: GizmoSQL – Run DuckDB as a Server with Arrow Flight SQL (github.com/gizmodata)
This is the GizmoSQL public repo - used to provide info and artifact downloads for GizmoSQL - an Apache Arrow Flight SQL server implementation using DuckDB or SQLite as a backend database.
Databases, Software, Open Source, SQL
17 points by philbe77 37 days ago | 8 comments
SQL queries don't start with SELECT (2019) (jvns.ca)
Okay, obviously many SQL queries do start with SELECT (and actually this post is only about SELECT queries, not INSERTs or anything).
SQL, Databases, Programming
34 points by Tomte 43 days ago | 12 comments
SQLBolt – Learn SQL (sqlbolt.com)
Welcome to SQLBolt, a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser.
SQL, Programming, Education, Web Development
3 points by Tomte 43 days ago | 0 comments
Show HN: An open source SOTA SQL Agent in 1k lines of code (textql.com)
Open Source, SQL, Databases, AI
10 points by spencerhubert 46 days ago | 3 comments
Debunking the Myth of Join Ordering: Toward Robust SQL Analytics (arxiv.org)
Join order optimization is critical in achieving good query performance. Despite decades of research and practice, modern query optimizers could still generate inferior join plans that are orders of magnitude slower than optimal.
Database Optimization, SQL, Performance Optimization
8 points by ksec 54 days ago | 0 comments
Ask HN: A question about mentoring a junior developer (ycombinator.com)
So this is the scenario: I develop a SQL object which is being used by an application developer in an app I haven't seen before. The developer is a junior and it's clear that they have a poor understanding of the use cases they're dealing with, and likely haven't adequately tested their changes. This developer isn't on my team and isn't someone I'm directly responsible for mentoring.
Software Development, Mentoring, Junior Developers, SQL
36 points by Desafinado 56 days ago | 40 comments
Some useful SQL(ite) tips I've learned (jvt.me)
I've recently spent some time working towards presenting some of the findings from dependency-management-data at work, which has required writing some fun queries, and then using Google Sheets to better visualise that data.
SQL, Databases, Data Visualization, Programming
13 points by thunderbong 60 days ago | 0 comments
Show HN: SQL Premier League – Learn SQL with Sports Data (sqlpremierleague.com)
SQL, Education, Sports, Data
10 points by ayushpawar 62 days ago | 1 comments
Show HN: SQL Noir – Learn SQL by solving crimes (sqlnoir.com)
Learning, SQL, Programming, Games, Creative Projects
463 points by chrisBHappy 71 days ago | 85 comments
How about trailing commas in SQL? (eisentraut.org)
Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.
SQL, Programming, Databases
227 points by ingve 74 days ago | 268 comments
SQL pipe syntax available in public preview in BigQuery (cloud.google.com)
Pipe query syntax is an extension to GoogleSQL that supports a linear query structure designed to make your queries easier to read, write, and maintain. You can use pipe syntax anywhere you write GoogleSQL.
SQL, BigQuery, Cloud Computing, Programming Languages, Database
247 points by marcyb5st 75 days ago | 113 comments
SQL or Death? Seminar Series – Spring 2025 (cs.cmu.edu)
Suppose somebody has been rubbing gasoline on their body since the 1970s. Would you marry that person even if they smelled terrible? But suppose this person starts showering every day so they smell a little better. They also famously get along with nearly everyone on the planet and makes a lot of money. What about marrying this person now? This is the question that we face today in the world of databases. SQL is 50 years old.
Databases, SQL, Programming, Technology
46 points by matt_d 86 days ago | 44 comments
Composable SQL (borretti.me)
SQL could be improved somewhat by introducing composable query fragments with statically-typed interfaces. I begin by explaining two areas (testing and reusing business logic) where SQL does very poorly. Then I explain my solution, and how it addresses the problems.
SQL, Programming, Database, Testing, Business Logic
271 points by earnestinger 90 days ago | 143 comments
You probably don't need query builders (mattrighetti.com)
In a previous [0] post I’ve discussed why I ditched sea-query and why sql is almost always the best way to not re-learn something new from the beginning that will inevitably end up slowing you down or simply not working at all in the long run.
SQL, Databases, Programming, Software Development
151 points by mattrighetti 95 days ago | 152 comments
SQL nulls are weird (jirevwe.github.io)
Yes, you read that right. SQL does treat all NULL values differently. I learnt this a while back while working on Convoy and again on LiteQueue: a Golang a queueing library.
SQL, Programming, Databases, GoLang
214 points by subomi 107 days ago | 280 comments
TiDB – cloud-native, distributed SQL database written in Go (github.com/pingcap)
TiDB (/’taɪdiːbi:/, "Ti" stands for Titanium) is an open-source, cloud-native, distributed SQL database designed for high availability, horizontal and vertical scalability, strong consistency, and high performance.
Databases, Open Source, Go, Cloud Computing, SQL
72 points by philonoist 113 days ago | 65 comments
Advent of Code 2024 in pure SQL (blogspot.com)
On a whim I decided to do this years advent of code in pure SQL. That was an interesting experience that I can recommend to everybody because it forces you to think differently about the problems. And I can report that it was possible to solve every problem in pure SQL.
Programming, SQL
484 points by greghn 114 days ago | 107 comments
Show HN: Execute SQL against Bluesky firehose (github.com/turbolytics)
SQLFlow enables SQL-based stream-processing, powered by DuckDB. SQLFlow embeds duckdb, supporting kafka stream processing logic using pure sql.
SQL, Data Streams, Databases, Open Source, Social Media
100 points by dm03514 116 days ago | 4 comments
SQL query optimization: a comprehensive developer's guide (aiven.io)
An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.
SQL, Databases, Optimization, Performance, Development
11 points by reqo 121 days ago | 1 comments
Reads Causing Writes in Postgres (jesipow.com)
It is good practice to regularly inspect the statements running in the hot path of your Postgres instance. One way to do this is to examine the pg_stat_statements view, which shows various statistics about the SQL statements executed by the Postgres server.
Database, Postgres, Performance Optimization, Monitoring, SQL
224 points by thunderbong 125 days ago | 28 comments
SQLCipher – SQLite library that adds 256 bit AES encryption of database files (github.com/sqlcipher)
SQL, Security, Databases, Encryption
15 points by gjvc 128 days ago | 0 comments
Leadership Power Tools: SQL and Statistics (blwt.io)
A common pattern I’ve seen over the years have been folks in engineering leadership positions that are not super comfortable with extracting and interpreting data from stores, be it databases, CSV files in an object store, or even just a spreadsheet.
Leadership, Data Analysis, SQL, Statistics
51 points by PaulHoule 129 days ago | 19 comments
Use Cases for ChDB, a Powerful In-Memory OLAP SQL Engine (runportcullis.co)
Clickhouse is quickly becoming a crowd favorite real-time data warehouse platform for organizations looking to take advantage of blazing fast query speeds in OLAP scenarios that power mission-critical applications and embedded analytics.
Databases, Data Warehousing, Real-time Data, OLAP, SQL
9 points by auxten 130 days ago | 2 comments
Litdb – type safe SQL for JavaScript/TS (litdb.dev)
litdb contains LINQ-like type-safe SQL builders for TypeScript/JavaScript for writing type-safe expressive SQL that's parameterized & portable across SQLite, MySQL & PostgreSQL
TypeScript, JavaScript, Databases, SQL
112 points by crummy 141 days ago | 66 comments