121
Versioning data in Postgres? Testing a Git like approach
KQBD Vip - trực tiếp kết quả bóng đá hôm nay cập nhật trực tuyến theo Nano giây, kết quả đêm qua & rạng sáng nay từ 2.000+ giải đấu toàn thế giới.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 212 posts.
122
123
AcousticBrainz: Making a hard decision to end the project (2022)
We created AcousticBrainz 7 years ago and started to collect data with the goal of using that data down the road once we had collected enough. We finally got around to doing this recenty, and realised that the data simply isn’t of high enough quality to be useful for much at all.
124
Git and Jupyter Notebooks Guide
We show you best practices, workflows, and tools to solve all Jupyter Notebooks <--> Git challenges.
125
Teach your LLM to answer with facts, not fiction
Learn how to train LLM for accurate answers with VectorSQL which allows you to execute finely-grained vector searches to target and retrieve the required information
126
Nile: Serverless Postgres for modern SaaS
I am thrilled to announce Nile, a serverless Postgres database designed for modern SaaS applications.
127
The Inner Workings of Distributed Databases
Comparison of replication options of time-series databases.
128
129
DuckDB 0.9
The DuckDB team is happy to announce the latest DuckDB release (0.9.0). This release is named Undulata after the Yellow-billed duck native to Africa. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many changes to discuss them each in…
130
SQLite 3.43
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
131
PostgreSQL 14 Internals
I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova. The final part of the book considers each of the index types in great detail. It explains and demonstrates how access methods, operator classes, and data types work…
132
Rules of schema growth (2017)
The free database designed for immutable values and a time-aware information model.
133
134
How to Read MySQL EXPLAINs
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
135
136
SQLite Begin Concurrent
Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.
137
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
We talk about querying system wide I/O statistics in Postgres, show several use cases for pg_stat_io, and talk about the future of I/O observability in Postgres.
138
Building a Streaming Platform in Go for Postgres
At PeerDB, our mission is to create a Postgres-first data-movement platform that makes it fast and simple to stream data from Postgres to Data Warehouses…
139
140
The Dutch benefits scandal: a cautionary tale for algorithmic enforcement
On January 15, the Dutch government was forced to resign amidst a scandal around its child-care benefits scheme. Systems that were meant to detect misuse of the benefits scheme, mistakenly labelled over 20,000 parents as fraudsters. More crucially, a disproportionate amount of those labelled as fraudsters had an…
141
Quicker serverless Postgres connections
Neon’s serverless driver redirects the PostgreSQL TCP wire protocol over WebSockets. This makes ordinary, fully-functional PostgreSQL connections accessible from new environments — including serverless platforms like Cloudflare Workers and Vercel Edge Functions. A key feature of these environments is that state is not…
142
S3 Express Is All You Need
The future of modern data infrastructure is object storage.
143
144
145
146
Citus 12: Schema-based sharding for PostgreSQL
Release blog post for the 12.0 release of the Citus extension to Postgres. Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications (and microservices) as well improvements in the Citus support for the Postgres 15 MERGE feature.
147
Transaction Isolation in Postgres
Ever dealt with glitches in a SaaS platform where your actions don't seem to sync up? That's often a transaction isolation issue in databases. Lets talk about transaction isolation and how they work in Postgres, so you can write reliable and performant code with minimal headache.
148
Uses and abuses of cloud data warehouses
Data Warehouses are great for many things but often misused for operational workloads.
149
ChatGPT plugins now support Postgres and Supabase
Supabase recently contributed to the OpenAI Retrieval Plugin repo with a Postgres and a Supabase implementation to help developers build ChatGPT plugins using pgvector.
150
PostgreSQL 16 Beta 1
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 16 is now [available for download](https://www.postgresql.org/download/). This …