Hacker News with Generative AI: SQL

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 13 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 20 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 20 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 22 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 30 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 33 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 37 days ago | 0 comments
Show HN: SQL Premier League – Learn SQL with Sports Data (sqlpremierleague.com)
SQL, Education, Sports, Data
10 points by ayushpawar 38 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 48 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 51 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 52 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 63 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 67 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 72 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 84 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 90 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 90 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 93 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 97 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 102 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 105 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 105 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 107 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 118 days ago | 66 comments
DSQL Vignette: Reads and Compute (brooker.co.za)
In today’s post, I’m going to look at half of what’s under the covers of Aurora DSQL, our new scalable, active-active, SQL database.
Databases, Software, SQL
34 points by louis-paul 119 days ago | 5 comments
Show HN: SQL Simulator – Create Subsetted Databases in Docker or K8s (tribalknowledge.tech)
In laymen's terms SQL Simulator uses SQL scripts to generate subsetted databases within a secure Sandbox environment.
SQL, Docker, Kubernetes, Databases, Sandbox
36 points by westonOG 122 days ago | 3 comments
Writing Composable SQL Using Knex and Pipelines (lackofimagination.org)
SQL is great! It can handle complex queries involving multiple tables, aggregations, subqueries, and joins. It can perform CRUD (Create, Read, Update, Delete) operations. It enforces data integrity through constraints like primary and foreign keys. It supports transactions, allowing multiple operations to be executed as a single unit, which can be rolled back if one of the operations fails.
SQL, Databases, Programming, Tools
58 points by tie-in 125 days ago | 46 comments
Show HN: Build you own SQL query planner/optimizer guide (github.com/tuannh982)
Software, Databases, SQL, Programming, Open Source
5 points by tuannh982 126 days ago | 0 comments
Towards Optimizing SQL Generation via LLM Routing (arxiv.org)
Text-to-SQL enables users to interact with databases through natural language, simplifying access to structured data.
Artificial Intelligence, Databases, SQL
11 points by PaulHoule 126 days ago | 1 comments
Show HN: Trilogy – A Reusable, Composable SQL Experiment (trilogydata.dev)
This demo uses the popular TPD-DS dataset for transactional database benchmarking. You can read more about Trilogy and this benchmark tool here.
SQL, Databases, Open Source, Benchmarking, Tools
78 points by efromvt 129 days ago | 40 comments