451
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,223 posts.
452
Postgres Just Cracked the Top Fastest Databases for Analytics
Databricks offers a unified platform for data, analytics and AI. Build better AI with a data-centric approach. Simplify ETL, data warehousing, governance and AI on the Data + AI Platform.
453
Instant SQL for results as you type in DuckDB UI
Type, see, tweak, repeat! Instant SQL is now in Preview in MotherDuck and the DuckDB Local UI. Bend reality with SQL superpowers to get real-time query results as you type. | Reading time: 8 min read
454
Bullshit graph database performance benchmarks
Hey HackerNews, let me just drop my mixtape, checkout my soundcloud and “Death Row” is the label that pays me. How is the Graph Database category supposed to grow when vendors keep spou…
455
PostgreSQL Features to Try
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
456
Avoid UUID Version 4 Primary Keys in Postgres
Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩
457
Postmortem of database outage of January 31
Postmortem on the database outage of January 31 2017 with the lessons we learned.
458
459
460
461
Litestream VFS
Query your SQLite database any time, anywhere
462
Things we learned running Postgres 13
Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.
463
Excel is pretty dang cool
It's like discovering a treasure chest under my kitchen sink
464
The database I wish I had
I watched the talk " Platform as a Reflection of Values: Joyent, Node.js and beyond " by Bryan Cantrill, and I think he was able to put into words something I already felt for some time: if there’s no piece of software out there that reflects your values, it’s time for you to build that softwarefootnote:talk-time[ At…
465
An unexpected find that freed 20GB of unused index space in PostgreSQL
How to free space without dropping indexes or deleting data
466
467
Effectively Using Matplotlib
Matplotlib is a valuable but misunderstood foundation of the python data science stack.
468
469
How Postgres Makes Transactions Atomic
A dive into the mechanics that allow Postgres to provide strong atomic guarantees despite the chaotic entropy of production.
470
Limbo: A complete rewrite of SQLite in Rust
we forked SQLite with the libSQL project. What would it be like if we just rewrote it?
471
Postgres LISTEN/NOTIFY actually scales
How we optimized Postgres LISTEN/NOTIFY-backed data streams to 60K writes per second on a single Postgres server, with millisecond-scale latency.
472
How to Corrupt a SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully…
473
474
You might not need a CRDT
Cloud infrastructure for teams that develop, train, and serve AI applications at scale.
475
Graph-Powered Machine Learning at Google
Posted by Sujith Ravi, Staff Research Scientist, Google ResearchRecently, there have been significant advances in Machine Learning that enable comp...
476
477
SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale
Learn why SQLite-on-the-server fits hyper-scale systems when each tenant gets an isolated database with local reads, durable storage, and simple…
478
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
479
Publishing with Apache Kafka at The New York Times
This post covers how Apache Kafka and its Streams API are used for storing and processing all the articles ever published by The New York Times
480
Algorithmic Trading: A Practitioner’s Guide
I really enjoyed reading Algorithmic Trading: A Practitioner’s Guide by Jeffrey M. Bacidore. Before starting, I imagined it would cover various strategies for trading in the markets, along th…