The latest blog posts to take off on Hacker News. 4,224 posts.
Inspired by Felix Geisendorfer blog post I implemented a database FSM (Finite-State Machine) with Postgresql. I brought some improvements to Felix’s implementation but before reading the following I recommend you to read carefully the original post.
In July 2020, I stumbled into a fundamental limitation in the general-purpose database design for transaction processing.
Author: Alexey Makhotkin squadette@gmail.com. Introduction In this database design tutorial (~9000 words) I’m going to show how to design the database tables for a real-world project of substantial complexity. We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is…
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…
We respond to Pinecone's recent blog post comparing Postgres and Pinecone. We show that Postgres can outperform Pinecone in the same benchmarks Pinecone covered in their article.
How Notion build and grew our data lake to keep up with rapid growth
Let's look at the numbers behind Xata's free tier. How much does a database cost us and why are we offering them for free.
Binance Scales its Log Service to 100PB and Saves Millions with Quickwit
I've been playing around with SQLite the last couple of days. I thought I knew a little about SQLite, but I didn't, and am getting my remedial education through an accelerated gauntlet. Some of what …
A deep dive on Microsoft's GraphRAG paper found questionable metrics with vaguely defined lift, so I analyzed knowledge graphs in RAG overall using Neo4j vs FAISS
Inaugural blog post about the development of turbopuffer, a search engine that uses object storage and SSD caching for cost-effective, low latency search. This post describes into the motivation behind its creation, its unique architecture, and how it significantly reduces costs for large-scale vector searches…
DuckDB extensions can now be published as DuckDB Community Extensions. The repository makes it easier for users to install extensions using the INSTALL extension_name FROM community syntax. Extension developers avoid the burdens of compilation and distribution.
How do you find near-duplicates in a massive collection of documents? An exploration of the Jaccard similarity metric, and the MinHash hashing trick used to efficiently approximate it at web scale.
The personal website of JT Archie. Includes a blog, work ethic, and projects they have worked on.
GraphRAG, a graph-based approach to retrieval-augmented generation (RAG) that significantly improves question-answering over private or previously unseen datasets, is now available on GitHub. Learn more:
Finetunes of Mistral, Llama3 and Solar LLMs are more accurate for my test data than OpenAI’s models.
Embeddings encourage engineers to go full YOLO because it’s actually rewarding to do so!
I summarise the kinds of evaluations that are needed for a structured data generation task.
Explore DuckDB Wasm for fast, in-browser analytical SQL. Learn how to instantiate the JS API, query Parquet files, and export data to CSV with zero latency. | Reading time: 8 min read
This post is meant to guide you through some of the lessons I’ve learned while working with multi-terabyte datasets. The lessons shared are focused on what someone may face as the size of the…
This article provides a short introduction to the pipeline used to create the data to train large language models (LLMs) such as LLaMA using Common Crawl (CC).
We like the moon The moon is very useful, everyone Everybody like the moon Because it light up the sky at night and it lovely and it makes the tides go and we like it But not as much as cheese We really like cheese
A high-performance and high-level purely functional data-parallel array programming language that can execute on the GPU and CPU.
Need to schedule tasks in PostgreSQL? Compare pg_cron for simple in-database scheduling with pg_timetable for complex workflows and multi-cluster orchestration.
NumPy 2.0.0 is the first major release since 2006. It is the result of 11 months of development since the last feature release and is the work of 212 contributors spread over 1078 pull requests. It contains a large number of exciting new features as well as changes to both the Python and C APIs.
Optimize your Django SQLite configuration for production.
