Hacker News with Generative AI: Databases

Observability 2.0 and the Database for It (greptime.com)
Observability 2.0 is a concept introduced by Charity Majors of Honeycomb, though she later expressed reservations about labeling it as such(follow-up).
Observability, Databases, Software, Cloud Computing
122 points by todsacerdoti 1 day ago | 51 comments
What every developer needs to know about in-process databases (graphgeeks.org)
SQLite, the mother of all in-process (aka embedded, embeddable, or serverless) DBMSs, has been wildly popular for over two decades.
Databases, Software Development, SQLite
10 points by semihs 1 day ago | 1 comments
PgDog is a transaction pooler logical replication manager can shard PostgreSQL (github.com/pgdogdev)
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL.
Databases, PostgreSQL, Open Source, Software, Transaction Pooling
24 points by Bender 2 days ago | 0 comments
A Principled Approach to Querying Data – A Type-Safe Search DSL (claudiu-ivan.com)
The rise of local-first web applications demands a rethinking of traditional client-server architectures.
Data, Databases, Programming, Web Development, Software Architecture
90 points by kioku 2 days ago | 17 comments
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
Show HN: Moose – OSS framework to build analytical back ends with ClickHouse (fiveonefour.com)
Moose lets you develop analytical backends in pure TypeScript or Python code like this:
Open Source, Analytics, TypeScript, Python, Databases
76 points by okane 3 days ago | 15 comments
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy (github.com/litestar-org)
A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy, offering:
Python, Databases, SQLAlchemy, Libraries, Open Source
36 points by Kumzy 3 days ago | 12 comments
ClickHouse gets lazier and faster: Introducing lazy materialization (clickhouse.com)
Imagine if you could skip packing your bags for a trip because you find out at the airport you’re not going. That’s what ClickHouse is doing with data now.
Data Storage, Databases, Performance, ClickHouse
363 points by tbragin 4 days ago | 121 comments
Ask HN: Has anyone used Riak? Thoughts? (ycombinator.com)
I’ve just stumbled upon RIAK. It seems like a very cool technology. Almost like an alternative to kubernetes. Has anyone used it in production? Why isn’t it more well known? It seems like an awesome solution.
Databases, Distributed Systems, Cloud Computing, Open Source
10 points by ag_rin 4 days ago | 14 comments
Lessons learned operating petabyte-scale ClickHouse clusters: Part II (tinybird.co)
This is the second part of the series. Here's more of what I've learned from operating petabyte-scale ClickHouse clusters for the last 5+ years.
ClickHouse, Databases, Big Data, Software Engineering
58 points by javisantana 5 days ago | 2 comments
Decomposing Transactional Systems (transactional.blog)
Software, Databases, Distributed Systems
131 points by pongogogo 6 days ago | 8 comments
(All) Databases Are Just Files. Postgres Too (tselai.com)
Dear reader: If you’re feeling an urge to comment solely based on the title, just be warned that too many have done so already.
Databases, Postgres, Data Storage
6 points by mooreds 6 days ago | 0 comments
Arch Linux to Switch from Redis to Valkey (archlinux.org)
Valkey, a high-performance key/value datastore, will be replacing redis in the [extra] repository.
Linux, Operating Systems, Databases, Key-Value Stores
7 points by namanyayg 6 days ago | 0 comments
Libro: a command-line tool to track your books (github.com/mkaz)
📚 Libro: A simple command-line tool to track your reading history, with your data stored locally in a SQLite database.
Books, Software, Databases
113 points by marcuskaz 7 days ago | 38 comments
Memory Size Matters to PostgreSQL (pgdba.org)
Nowadays it’s not uncommon to deal with machines with hundreds of GB of RAM.
Databases, PostgreSQL, Performance
60 points by PaulHoule 8 days ago | 11 comments
Just Throw It into Postgres (simonsafar.com)
When you think of databases... it probably looks like a neatly organized schema of multiple tables, having unique ids connecting them, neatly listing names, addresses and other well-defined entities. It's either something corporate, or... maybe a PHP webapp? A forum?
Databases, Data Modeling, Programming
7 points by todsacerdoti 9 days ago | 0 comments
SQLite transactions and virtual tables (misfra.me)
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables.
Databases, Go Programming, Virtual Tables, SQLite
103 points by preetamjinka 9 days ago | 9 comments
Valkey to Replace Redis in the Arch Linux [extra] Repository (archlinux.org)
Valkey, a high-performance key/value datastore, will be replacing redis in the [extra] repository.
Linux, Databases, Open Source
15 points by andrewSC 9 days ago | 4 comments
Heroku migrated PostgreSQL databases to Amazon Aurora (amazon.com)
In this post, we discuss how Heroku migrated their multi-tenant PostgreSQL database fleet from self-managed PostgreSQL on Amazon Elastic Compute Cloud (Amazon EC2) to Amazon Aurora PostgreSQL-Compatible Edition.
Cloud Computing, Databases, PostgreSQL, Amazon Aurora, Heroku
6 points by mariuz 9 days ago | 0 comments
Manga Guide To Databases (2004) [pdf] (oberstar.eu.org)
Manga, Databases, Programming, Books
72 points by mastermedo 9 days ago | 6 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
All Databases Are Just Files (tselai.com)
SQLite and DuckDB have earned their popularity in the data world, and for good reason. I’m a big fan of both. Their appeal is simple: they’re just files. You can see, copy, and move them around like any other file.
Databases, Software, Data, Files, SQLite, DuckDB
6 points by azhenley 9 days ago | 0 comments
European Union Vulnerability Database (EUVD) (europa.eu)
Security, Databases, Government, European Union
222 points by stefankuehnel 10 days ago | 23 comments
Hacking the Postgres wire protocol (pgdog.dev)
PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code.
Security, Databases, PostgreSQL, Networking
229 points by levkk 11 days ago | 50 comments
SQLite File Format Viewer (pages.dev)
SQLite, Databases, Tools
273 points by ilumanty 12 days ago | 41 comments
A hackable AI assistant using a single SQLite table and a handful of cron jobs (geoffreylitt.com)
There’s a lot of hype these days around patterns for building with AI. Agents, memory, RAG, assistants—so many buzzwords! But the reality is, you don’t need fancy techniques or libraries to build useful personal tools with LLMs.
Artificial Intelligence, AI Assistants, Programming, Databases, Open Source
800 points by stevekrouse 12 days ago | 174 comments
Query Engines: Push vs. Pull (2021) (justinjaffray.com)
People talk a lot about “pull” vs. “push” based query engines, and it’s pretty obvious what that means colloquially, but some of the details can be a bit hard to figure out.
Query Engines, Databases, Software Engineering
101 points by tanelpoder 12 days ago | 9 comments
Postpass – a public OSM PostGIS instance (openstreetmap.org)
OpenStreetMap, Databases
8 points by altilunium 13 days ago | 0 comments
Show HN: HelixDB – Native graph and vector types for RAG and retrieval (github.com/HelixDB)
HelixDB is a powerful, graph-vector database built in Rust for millisecond query latency and ease of use.
Databases, Graph Databases, Rust, RAG, Retrieval
25 points by GeorgeCurtis 14 days ago | 6 comments
Show HN: Pg_CRDT – CRDTs in Postgres Using Automerge (github.com/supabase)
pg_crdt is an experimental extension adding support for conflict-free replicated data types (CRDTs) in Postgres.
Databases, Open Source, Software, CRDTs
11 points by kiwicopple 15 days ago | 4 comments