511
Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal)
Discover how Expensify achieved remarkable scaling: 4M QPS on one server! Dive into optimizing SQLite for impressive performance gains.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
512
513
514
515
Rerun 0.9 – a framework for visualizing streams of multimodal data
We're releasing Rerun 0.9.0 with a completely revamped API that gives more control over the underlying data model, a hierarchical and time aware Entity Component System (ECS).
516
Database Performance at Scale – A free book
Discover new ways to optimize database performance and avoid common mistakes that impact latency and throughput.
517
518
Pgroll: zero-downtime, reversible schema migrations for Postgres
We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL
519
Goodbye integers, hello UUIDv7
The journey Buildkite took from sequential integer primary keys, through randomly generated UUIDs, to adopting time-ordered UUIDv7 — and the database index tradeoffs along the way.
520
Azure dropping database support for MariaDB. Users advised to migrate to MySQL
Subscribe to Microsoft Azure today for service updates, all in one place. Check out the new Cloud Platform roadmap to see our latest product plans.
521
ClickHouse Keeper: A ZooKeeper alternative written in C++
Read about why we built a resource-efficient alternative for Zookeeper from scratch in C++, what our next big step with it is, and how you can join the Keeper community.
522
DuckDB 0.9
The DuckDB team is happy to announce the latest DuckDB release (0.9.0). This release is named Undulata after the Yellow-billed duck native to Africa. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many changes to discuss them each in…
523
Ways to capture changes in Postgres
Discover all the options for change data capture (CDC) in Postgres––and which is best for your use case.
524
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...
525
Apache Pinot 1.0
Introducing Apache Pinot 1.0 Release
526
64-bit bank balances ‘ought to be enough for anybody’?
“640K ought to be enough for anybody.” - Supposedly Bill Gates, circa 1981.
527
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:
528
529
My favourite API is a zipfile on the European Central Bank's website
Simple data pipeline powertools: sqlite, pandas, gnuplot and friends
530
PostgreSQL 16
September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of …
531
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.
532
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.
533
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.
534
535
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.
536
537
Fine-tuning GPT-3.5-turbo for natural language to SQL
Tutorial and comparison with RAG methods
538
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?
539
540
SQLite 3.43
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .