New
The latest blog posts to take off on Hacker News. 4,224 posts.
PostgreSQL 15
**October 13, 2022** - The PostgreSQL Global Development Group today announced the release of [PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest version of …
New ScyllaDB Go Driver: Faster Than GoCQL and Its Rust Counterpart
How we built a new Go ScyllaDB driver that’s almost 4x faster than its GoCQL predecessor and 2X faster than its Rust counterpart.
Modeling Starlink Capacity
Prior attempts to calculate Starlink’s potential for service have been theoretical. We simulate based on the actual constellation.
Gcloud storage: Faster data transfers for Cloud Storage
gcloud CLI enables super-fast data transfers into Cloud Storage and delivers a consistent CLI experience across all Google Cloud services.
Vectors are over, hashes are the future
Get an introduction into the thinking behind the rise of neural hashing technology — and learn why this may end up being an enormous shift in AI advancement.
SAT score distributions in Michigan
The state of Michigan required all public HS seniors to take the SAT last year (~91k out of ~107k total seniors in the state). This generate...
Partitioning in Postgres, 2022 Edition
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
ClickHouse Cloud is now in Public Beta
ClickHouse Cloud has entered public beta. Get your free trial now!
The next generation of Materialize
Today, we’re excited to announce a product that we feel is transformational: a persistent, scalable, cloud-native Materialize.
Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.
Why we moved from AWS RDS to Postgres in Kubernetes
Every new Nhost project now gets a dedicated PostgreSQL instance on Kubernetes with root access, custom extensions, and direct connections.
Analysis of Apple Watch running data
Analysis of Apple running measurements and statistics
TimescaleDB 2.7 vs. PostgreSQL 14
TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical.
LiteFS
We are building a distributed file system for your SQLite databases. Kinda weird, huh?
Postgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
TinyBase v2.0: reactive data store for local-first apps
This is a reverse chronological list of the major TinyBase releases, with highlighted features.
Cloud Spanner now with a free trial
Create a 90-day Spanner free trial instance with 10GB storage at no cost. Try Spanner free.
TIL–Python has a built-in persistent key-value store (2018)
Simplex Sigillum Veri
Dabbling with Dagster vs. Airflow
Dissecting the Octopus
Algolia Acquires Search.io
Acquisition creates world’s first and only hybrid search engine combining Keyword and Vector Search in a single API.
Let’s make WordPress officially support SQLite
WordPress can be (and is) used for any kind of site, regardless of size or complexity. Some common use-cases include: Single-page landing sitesSimple company sites with just a few pages. These site…
How the SQLite virtual machine works
Let's look at how SQLite parses, optimizes, and compiles every query that it receives.
IKEA’s knowledge graph and why it has three layers
At IKEA we are building a knowledge graph to improve the overall experience of our customers in the physical and digital space. I like to…
A sequel to SQL? An intro to Malloy
Homepage of Carlin Eng
Health insurers just published close to a trillion hospital prices
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
Extending SQLite with Rust
SQLite has a powerful extension mechanism: loadable extensions. Being an in-process database, SQLite has other extensions mechanisms like application-defined functions (UDF for short). But UDFs have …