181
Introduction to vector similarity search (2022)
Learn what vector search is and the metrics pertinent to decide the distance (or similarity) between objects.
New
The latest blog posts to take off on Hacker News. 371 posts.
182
Git and Jupyter Notebooks Guide
We show you best practices, workflows, and tools to solve all Jupyter Notebooks <--> Git challenges.
183
PlanetScale Scaler Pro
See how Scaler Pro combines the best of our current plans for companies of all sizes while enabling you to grow with the best database for serverless.
184
Demystifying Text Data with the Unstructured Python Library
In the world of data, textual data stands out as being particularly complex. It doesn’t fall into neat rows and columns like numerical data does. As a side project, I’m in the process of developing my own personal AI assistant. The objective is to use the data within my notes and documents to answer my questions. The…
185
LiteFS Cloud: Distributed SQLite with Managed Backups
Documentation and guides from the team at Fly.io.
186
Our Journey with Apache Arrow (Part 2): Adaptive Schemas and Sorting
In the previous article, we discussed our use of Apache Arrow within the context of the OpenTelemetry project. We investigated various techniques to maximize the efficiency of Apache Arrow, aiming to find the optimal balance between data compression ratio and queryability. The compression results speak for themselves…
187
SQLite-based databases on the Postgres protocol? Yes we can
libSQL “server mode” (sqld) enables access to SQLite-based databases using Postgres and HTTP network protocols.
188
Things that surprised me while running SQLite in production
I've been using SQLite in several production projects for six months, and I've encountered some surprising aspects.
189
Joins 13 Ways
Relational (inner) joins are really common in the world of databases, and one weird thing about them is that it seems like everyone has a different idea of what they are. In this post I’ve aggregated a bunch of different definitions, ways of thinking about them, and ways of implementing them that will hopefully be…
190
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩
191
Case study: Algorithmic trading with Go
In this case study, we are excited to share an insider's perspective and look under the hood of how a Massive.com customer built an automated retail trading bot that is capable of monitoring the entire stock market in real-time.
192
193
Using command line to process CSV files (2022)
Process CSV files from the command line with awk, sort, and grep: pull out fields, order rows, and filter data without a spreadsheet or a script.
194
What are embeddings?
A deep-dive into machine learning embeddings.
195
Around the World with SQLite3 and Rsync
Run sqlite3 dbs in multiple regions with rsync
196
Unexpected downsides of UUID keys in PostgreSQL
Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.
197
[109] Data Falsificada (Part 1): “Clusterfake”
This is the introduction to a four-part series of posts detailing evidence of fraud in four academic papers co-authored by Harvard Business School Professor Francesca Gino. In 2021, we and a team o…
198
Representing Enums in PostgreSQL
Recently, we had a discussion about whether we should use native enums in PostgreSQL, or rely on regular string columns with CHECK constraints. In the end, we decided that we wanted to go with the latter.
199
I don't need your query language
Seriously, I don't. I'd prefer SQL.
200
Getting 10TB of GitHub logs and extracting details of all users and repositories
Trickest workflow parses 15TB of GitHub Archive logs and extracts public details for every user and repository back to 2015.
201
202
The PostgreSQL documentation and the limitations of community
In my opinion, the PostgreSQL documentation is simultaneously excellent and fairly poor, and both its excellence and its shortcomings are di...
203
Why PostgreSQL High Availability Matters and How to Achieve It
Achieving PostgreSQL high availability is vital for application uptime. Explore popular HA deployment options to make an informed choice that fits your needs.
204
205
206
Track HN: Survival Rate of Show HN Stories
Spoiler alert: many of the good projects didn’t survive
207
Text Editor Data Structures
Text editors can be an interesting challenge to program. The types of problems that text editors need to solve can range from trivial to mind-bogglingly difficult. Recently, I have been on something of a spiritual journey to rework some internal data structures in an editor I have been building, specifically the most…
208
Merklizing the key/value store for fun and profit
Joel Gustafson
209
Daft: A High-Performance Distributed Dataframe Library for Multimodal Data
Discover how Daft accelerates multimodal data processing with a high-performance distributed dataframe engine built for modern AI and analytics tasks.
210
Why SQLite is so great for the edge
Everyone already knows that SQLite is great. This article makes the praise much more specific though — it explains why we, the developers of libSQL, think that SQLite is a great choice for bringing your data to the edge.