331
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
New
The latest blog posts to take off on Hacker News. 350 posts.
332
Let's talk about joins
An review of horizontal and vertical joins with examples from education research.
333
334
Type information for faster Python C extensions
Update: The paper version of this post is accepted at PLDI SOAP 2024. Take a look at the preprint (PDF).
335
SQLite: Wal2 Mode
"Wal2" mode is very similar to "wal" mode. To change a database to wal2 mode, use the command:
336
Postgres Incremental Backup
We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.
337
A Technical Dive into PostgreSQL's replication mechanisms
Guide to PostgreSQL Replication and CDC - Navigate the complexities of logical replication in PostgreSQL.
338
Databases and why their complexity is now unnecessary
This post is not going to be about what’s wrong with individual databases. There are so many databases and so many individual API issues, operational problems, and arbitrary limitations that it wou…
339
Trade-offs between Different CRDTs
🔰If CRDTs are new to you, here are some introductory links. - An interactive intro to CRDTs - An introduction to state-based CRDTs - CRDTs for non-academics - CRDT: The Hard Parts - Readings in CRDTs - crdt.tech What are the trade-offs between different kinds of CRDTs (Conflict-free Replicated
340
An overview of distributed Postgres architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
341
Visualizing Ext4
What does ext4 look like?
342
Databases in 2023: A Year in Review
Andy recounts the rise of vector databases to SQL:2023 to MariaDB troubles and the FAA outage in 2023.
343
The drive stats of Backblaze storage pods
Dive into Backblaze's analysis of storage server performance, exploring Drive Stats, Storage Pods, and insights on drive failure rates since 2009.
344
The One Billion Row Challenge
Update Jan 4: Wow, this thing really took off! 1BRC is discussed at a couple of places on the internet, including Hacker News, lobste.rs, and Reddit. For folks to show-case non-Java solutions, there …
345
Sieve is simpler than LRU
SIEVE is Simpler than LRU: an Efficient Turn-Key Eviction Algorithm for Web Caches
346
Thoughts on PostgreSQL in 2024
A look ahead at some ongoing projects in PostgreSQL in 2024 and beyond
347
90x Faster Than Pgvector – Lantern's HNSW Index Creation Time
Index creation time is a critical database metric. Learn more about how Lantern enables 90x faster index creation times than pgvector, and how Lantern compares to Pinecone.
348
Self-hosting a high-availability Postgres cluster on Kubernetes
Ryan Schachte — infrastructure, networking, and distributed systems
349
A Canadian payroll dependency chart
Unfortunately, like most aspects of the tax system, this steadily increases in complexity, and this year with the Canada Pension Plan including not just "base" premiums and "additional" premiums but also "second additional premiums", I needed to rewrite my spreadsheet from scratch; and also very unfortunately, the…
350
Displaying Content as a Graph
Most web content is displayed as a strict hierarchy, tree-based or otherwise. What if it wasn't?An exploration into the advantages of graph-based content design, the numerous pitfalls, and a few case studies along the way.