Hacker News with Generative AI: Databases

When parameterization fails: SQL injection in Nim using parameterized queries (nns.ee)
I discovered a potential SQL injection vulnerability in Nim's standard library module db_postgres.
Security, Databases, Programming Languages, SQL Injection
13 points by xx_ns 9 hours ago | 3 comments
Show HN: SQLite? Postgres? Use both with omni_SQLite (omnigres.org)
omni_sqlite is an extension that adds the capability to use SQLite databases as a first-class data type within Postgres. It uses expandable datum technique to ensure no additional serialization overhead for data in-flight.
Databases, PostgreSQL, SQLite, Software, Extensions
11 points by michelpp 2 days ago | 0 comments
Stop syncing everything (sqlsync.dev)
Partial replication sounds easy—just sync the data your app needs, right? But choosing an approach is tricky: logical replication precisely tracks every change, complicating strong consistency, while physical replication avoids that complexity but requires syncing every change, even discarded ones. What if your app could combine the simplicity of physical replication with the efficiency of logical replication? That’s the key idea behind Graft, the open-source transactional storage engine I’m launching today.
Databases, Open Source, Software, Data Replication
612 points by neilk 2 days ago | 113 comments
Turso SQLite Offline Sync Public Beta (turso.tech)
We're excited to announce that Turso Offline Sync is now available in public beta!
Software, Databases, Offline Data, Mobile Development
220 points by charlieirish 2 days ago | 66 comments
Dragonfly: Modern Replacement for Redis and Memcached (github.com/dragonflydb)
Dragonfly is an in-memory data store built for modern application workloads.
Databases, Software, In-Memory Computing
15 points by klaussilveira 2 days ago | 2 comments
Show HN: I built an open-source NotebookLM alternative using Morphik (github.com/morphik-org)
Morphik is an open-source database designed for AI applications that simplifies working with unstructured data. It provides advanced RAG (Retrieval Augmented Generation) capabilities with multi-modal support, knowledge graphs, and intuitive APIs.
Open Source, AI, Databases
22 points by ArnavAgrawal03 3 days ago | 3 comments
Ask HN: Code should be stored in a database. Who has tried this? (ycombinator.com)
To me it seems obvious that code should be stored in a database rather than a hierarchical, text-based format.
Software Development, Databases, Programming, Data Management
22 points by vaughan 4 days ago | 46 comments
Show HN: Cloud-Ready Postgres MCP Server (github.com/stuzero)
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.
Cloud Computing, Databases, AI, PostgreSQL
164 points by spennant 4 days ago | 79 comments
Memelang: A hybrid graph-relational query language (memelang.net)
Memelang is a hybrid graph-relational query language that encodes complex relationships in a compact syntax.
Query Languages, Databases, Programming Languages
4 points by holtwork 4 days ago | 0 comments
Postgres Language Server: Initial Release (github.com/supabase-community)
Postgres, Language Servers, Open Source, Databases
354 points by steinroe 5 days ago | 52 comments
Postgres Extension Tutorial (github.com/IshaanAdarsh)
Welcome to the Postgres Extension Tutorial. This comprehensive tutorial is designed to provide a step-by-step guide to PostgreSQL extension development.
Databases, Tutorials, PostgreSQL
24 points by giulianopz 6 days ago | 0 comments
Show HN: Searchable encryption, SQL proxy for Postgres (cipherstash.com)
Following fast on the heels of last week’s Protect.js announcement, we’re excited to introduce version 2 of CipherStash Proxy, our no-code data-protection solution for PostgreSQL.
Security, Databases, Open Source, PostgreSQL
10 points by dandraper 6 days ago | 0 comments
PostgreSQL Lands Initial Support for IO_uring: "Can Be Considerably Faster" (phoronix.com)
As a very exciting improvement for the open-source PostgreSQL database server, it has merged initial support for making use of IO_uring on Linux servers for asynchronous I/O and can provide for some nice performance improvements.
PostgreSQL, Databases, Performance, Linux, Asynchronous I/O
11 points by pella 7 days ago | 0 comments
New open-source benchmark for real-time analytics applications (github.com/timescale)
Open Source, Databases, Real-Time Analytics, Benchmarking
16 points by thenoahhein 7 days ago | 4 comments
Faster interpreters in Go: Catching up with C++ (planetscale.com)
The SQL evaluation engine that ships with Vitess, the open-source database that powers PlanetScale, was originally implemented as an AST evaluator that used to operate directly on the SQL AST generated by our parser. Over this past year, we've gradually replaced it with a Virtual Machine which, despite being written natively in Go, performs similarly to the original C++ evaluation code in MySQL.
Performance Optimization, Databases, Programming Languages, Open Source
16 points by krvajal 7 days ago | 0 comments
Reducing Cloud Spend: Migrating Logs from CloudWatch to Iceberg with Postgres (crunchydata.com)
As a database service provider, we store a number of logs internally to audit and oversee what is happening within our systems.
Cloud Computing, Cost Optimization, Data Storage, Databases, Logging
11 points by rubiquity 7 days ago | 0 comments
Sharding Pgvector (pgdog.dev)
If you find yourself working with embeddings, you’ve shopped around for a vector database. pgvector is a great option if you’re using Postgres already. Once you reach a certain scale (about a million arrays), building indices starts taking a long time. Some workarounds, like parallel workers, help, but you still need to fit the whole graph in memory.
Databases, PostgreSQL, Embeddings, Vector Databases
86 points by levkk 7 days ago | 10 comments
DuckDB: Development Roadmap (duckdb.org)
The DuckDB project is governed by the non-profit DuckDB Foundation.
Databases, Open Source, Development Roadmap
30 points by tosh 8 days ago | 4 comments
It's Time to Stop Building KV Databases (buttondown.com)
I'm so sick of Key-Value. The most unopinionated, uninspired data model that is a pain to use for anything.
Databases, Data Models
65 points by foldU 9 days ago | 62 comments
Why PostgreSQL needs a better API for alternative table engines? (orioledb.com)
For a long time now, PostgreSQL has had an extensible Index Access Method API (called AM), which has stood the test of time and enabled numerous robust extensions to provide their own index types. For example: rum, pgvector, bloom, zombodb and others. PostgreSQL 12 introduced the Table AM API, promising equivalent flexibility for table access methods.
Databases, PostgreSQL, API, Performance, Extensions
15 points by atombender 9 days ago | 3 comments
Open-source Rust database tops JSONBench using DataFusion (greptime.com)
GreptimeDB Takes on the Billion-JSON-Document Challenge - Outperforms ClickHouse, VictoriaLogs, and Competitors
Databases, Rust, Benchmarks, Open Source
13 points by killme2008 10 days ago | 5 comments
Let's Build a Simple Database (cstack.github.io)
I’m building a clone of sqlite from scratch in C in order to understand, and I’m going to document my process as I go.
Programming, Databases, C, Software Development, Open Source
6 points by ibobev 12 days ago | 0 comments
MySQL transactions per second vs. fsyncs per second (2020) (sirupsen.com)
How many transactions (‘writes’) per second is MySQL capable of?
MySQL, Databases, Performance, Benchmarks
121 points by jcartw 12 days ago | 52 comments
TidesDB: A fast key/value store for modern hardware (tidesdb.com)
TidesDB is an embeddable persistant key-value storage engine.
Databases, Key-Value Stores, Software, Hardware
14 points by alexpadula 13 days ago | 3 comments
Show HN: Minimalytics – a standalone minimal analytics app built on SQLite (github.com/nafey)
Minimalytics is a standalone minimalist analytics tool built on SQLite.
Software, Analytics, Databases, Open Source
74 points by nafey 13 days ago | 12 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 13 days ago | 8 comments
One Billion Row Challenge in Racket (defn.io)
I decided to have some fun tonight and work on a Racket solution to the One Billion Row Challenge.
Programming, Racket, Performance Optimization, Databases
15 points by todsacerdoti 14 days ago | 0 comments
Fauna Service Winding Down (fauna.com)
The Fauna service will be ending on May 30, 2025. For more information, read the announcement and the FAQ.
Cloud Computing, Service Endings, Databases
131 points by jaredwiener 14 days ago | 95 comments
CockroachDB has changed their license, again (github.com/cockroachdb)
Open Source, Databases, Licenses
27 points by tison 15 days ago | 5 comments
The real failure rate of EBS (planetscale.com)
PlanetScale has deployed millions of Amazon Elastic Block Store (EBS) volumes across the world. We create and destroy tens of thousands of them every day as we stand up databases for customers, take backups, and test our systems end-to-end. Through this experience, we have an unique viewpoint into the failure rate and mechanisms of EBS, and have spent a lot of time working on how to mitigate them.
Cloud Computing, Databases, Reliability, Data Storage
113 points by QuinnyPig 15 days ago | 30 comments