151
Indexing iCloud Photos with AI Using LLaVA and Pgvector
A straightforward idea, gluing stuff together until it works, but it’s a glimpse of what’s possible with help of local AIs in near future
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 350 posts.
152
Loro's rich text CRDT
This article presents the rich text CRDT algorithm implemented in Loro, complying with Peritext's criteria for seamless rich text collaboration. Furthermore, it can be built on top of any List CRDT algorithms and turn them into rich text CRDTs.
153
The new PostgreSQL 17 make dist
When the PostgreSQL project makes a release, the primary artifact of that is the publication of a source code tarball. That represents the output of all the work that went into the creation of the PostgreSQL software up to the point of the release. The source tarball is then used downstream by packagers to make binary…
154
Optimizing Large-Scale OpenStreetMap Data with SQLite
The personal website of JT Archie. Includes a blog, work ethic, and projects they have worked on.
155
Optimizing Postgres table layout for maximum efficiency
Introduction When modeling a Postgres database, you probably don’t give much thought to the order of columns in your tables. After all, it seems like the kind of thing that wouldn’t affect storage or performance. But what if I told you that simply reordering your columns could reduce the size of your tables and…
156
Improvements to data analysis in ChatGPT
Improvements to data analysis in ChatGPT Interact with tables and charts and add files directly from Google Drive and Microsoft OneDrive.
157
DuckDB 1.1.0 Released
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.1.0, codenamed “Eatoni”.
158
159
160
What Is a Knowledge Graph?
What is a knowledge graph? Learn about nodes, relationships, organizing principles, and ontologies, which comprise a knowledge graph.
161
Redict 7.3.0, a copyleft fork of Redis, is now available
The Redict community is pleased to announce the release of Redict 7.3.0, the first stable version of our copyleft fork of Redis® OSS 7.2.4.1 You can download the release on Codeberg, or download one of our official container images from registry.redict.io. We have written comprehensive documentation detailing our…
162
Amazon S3 now supports the ability to append data to an object
Discover more about what's new at AWS with Amazon S3 Express One Zone now supports the ability to append data to an object
163
Do you need Redis? PostgreSQL does queuing, locking, and pub/sub (2021)
It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.
164
A bird's eye view of Polars
Read how Polars executes your query from planning, optimizing to execution.
165
Building rqlite 9.0: Cutting disk usage by half
rqlite is a lightweight, open-source, distributed relational database written in Go. It is built on the Raft consensus protocol and uses SQLite as its storage engine. Development of 9.0 has begun and aims to reduce disk usage by approximately 50%. This goal will be achieved through a high-level design overhaul…
166
167
You can't just assume UTF-8
How to infer character encodings with statistics
168
LlamaCloud and LlamaParse
LlamaIndex introduces LlamaParse and LlamaParse for production-grade RAG. Unlock complex PDF data to improve LLM response quality. Discover how today.
169
RavenDB 6.0.2 (A Jepsen Report)
RavenDB is a distributed document database which repeatedly advertises its support for ACID transactions. 1 It’s intended for OLTP workloads, and offers a variety of ETL paths for exporting data to other systems. Its transactional API revolves around a session handle, which “represents a single business transaction on…
170
Preview of Explore Logs, a new way to browse your logs without writing LogQL
Learn all about Explore Logs, a new way to browse your logs in Grafana 11 and Loki 3.0 without writing LogQL.
171
What I talk about when I talk about query optimizer (part 1): IR design
Achieving Data Freedom Through Open Source and Rust
172
Phrase matching in Marginalia Search
Marginalia Search now properly supports phrase matching. This not only permits a more robust implementation of quoted search queries, but also helps promote results where the search terms occur in the document exactly in the same order as they do in the query. This is a write-up about implementing this change. This is…
173
Difference between running Postgres for yourself and for others
At Ubicloud, our managed cloud service enables us to run PostgreSQL for others. We open sourced our implementation, so we thought this was a good opportunity to talk about its features. This blog post summarizes features commonly available in a managed service. It also describes interesting differences between running…
174
DuckDB 1.0.0
The DuckDB team is very happy to announce that today we’re releasing DuckDB version 1.0.0, codename “Snow Duck” (anas nivis).
175
pg_duckdb: Splicing Duck and Elephant DNA
Introducing the DuckDB + Postgres Extension: You can have your analytics and transact them too with pg_duckdb by DuckDB Labs, MotherDuck, Hydra, Neon and Microsoft. | Reading time: 8 min read
176
Running Durable Workflows in Postgres Using DBOS
Technical deep dive into the new DBOS integration for Supabase
177
The notifier pattern for applications that use Postgres
Maximizing Postgres connection economy by using a single connection per program to receive and distribute all listen/notify notifications.
178
Data will not tell you what to do
How disappointing it is to learn that the best ideas rarely come from data after 15 years of working in the field.
179
Using PostgreSQL for military geoanalytics tasks
My name is Taras Kloba, Chief Partner Architect at Microsoft. This blog captures my journey through data engineering, certifications, and technology insights.
180
Python datetime pitfalls, and what libraries are (not) doing about it
It’s no secret that the Python datetime library has its quirks. Not only are there probably more than you think; third-party libraries don’t address most of them! I created a new library to explore what a better datetime library could look like.