991
Outperforming larger language models with less training data and smaller models
Posted by Cheng-Yu Hsieh, Student Researcher, and Chen-Yu Lee, Research Scientist, Cloud AI Team Large language models (LLMs) have enabled a new da...
New
The latest blog posts to take off on Hacker News. 4,224 posts.
992
993
MongoDB’s new query engine
SBE Article logo Discussion on HackerNews and Lobsters. MongoDB has recently released a new query engine coming in version 7.0. I was one of the people work...
994
Grouping digits in SQL
PostgreSQL 16 was released last week. This is the story of a feature.
995
Apache Pinot 1.0
Introducing Apache Pinot 1.0 Release
996
64-bit bank balances ‘ought to be enough for anybody’?
“640K ought to be enough for anybody.” - Supposedly Bill Gates, circa 1981.
997
What if OpenDocument used SQLite? (2014)
Suppose the OpenDocument file format, and specifically the "ODP" OpenDocument Presentation format, were built around SQLite. Benefits would include:
998
How FoundationDB works and why it works (2021)
FoundationDB is a very impressive database. Its paper won the best industry paper award in SIGMOD’21. In this post, I will explain, in detail, how FDB works and discuss a few very interesting design choices they made. It’s a dense paper packed with neat ideas. Many details (sometimes even proof of correctness) are not…
999
1000
My favourite API is a zipfile on the European Central Bank's website
Simple data pipeline powertools: sqlite, pandas, gnuplot and friends
1001
Optimizing LLMs from a Dataset Perspective
Practical guide to improving LLM finetuning with better instruction datasets, covering data curation, prompt-output pairs, synthetic data, and experiment ideas.
1002
PostgreSQL 16
September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of …
1003
How to build a IP geolocation database from scratch?
Download a free IPv4 and IPv6 geolocation database (CSV, CC BY-SA 4.0), or the commercial one with full coverage in CSV and MMDB, updated at least twice a week.
1004
Skip the API, ship your database
The best code is the code unwritten. Avoid building a complex API layer by sharing your database between services.
1005
You Don't Need UUID
I've experienced first-hand how using UUID hurts the usability of computer systems, and I want you to understand why you certainly don't need it.
1006
A LLM+OLAP Solution
The exploration of a LLM+OLAP solution is a bumpy journey, but phew, it now works well for the Tencent case, and they're writing down every lesson learned to share with you.
1007
PgBouncer is useful, important, and fraught with peril
Updated 2024-09-17 to reflect updated PgBouncer support for protocol-level prepared statements 🐘 To start, I want to say that I’m appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and I’m thankful for the incredible amount of work and…
1008
1009
Deno KV Is in Open Beta
Deno KV, the easiest way to add a strongly consistent database to your app, is now in open beta.
1010
ZFS for Dummies
As mentioned on previous posts, I have spent the past few weeks dealing with a ZFS crash on my FreeNAS install. Because of that, not only was I forced to learn how to troubleshoot ZFS, but I also had to learn how to setup new volumes and come up with new backup strategies (between a few other things).
1011
Cola: A text CRDT for real-time collaborative editing
A deep dive into the theoretical framework and the technical implementation of a text CRDT.
1012
1013
Explaining the Postgres iceberg
Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
1014
1015
Fine-tuning GPT-3.5-turbo for natural language to SQL
Tutorial and comparison with RAG methods
1016
When should you use the IN instead of the OR operator in Postgres?
Query performance often varies depending on how you write queries. For PostgreSQL, what provides better performance? The IN or OR operator?
1017
1018
How to get transactions between almost any data stores
How to get ACID transactions between almost any data stores, with the Epoxy protocol.
1019
ChatLZMA – text generation from data compression
I came across a random tweet, found a Wikipedia page and bumped into some smart people and long story short, apparently compression is equivalent to general intelligence.
1020
Pgvector 0.5.0 Feature Highlights and how tos
An overview of new features in pgvector 0.5.0, including HNSW, parallel index builds, and more!