511
Google to Acquire Looker
Google to acquire Looker, a unified platform for business intelligence, data applications, and embedded analytics.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
512
Rearchitecting: Redis to SQLite
Learn how we approached migrating our Wafris v1 client based on Redis to a new faster, easier to use SQLite architecture.
513
Marketers are addicted to bad data
Modern marketing is all about data and however hard you might try, you can't spend any time around marketers online without being subjected to endless
514
River: A fast, robust job queue for Go and Postgres
Introducing River, a Postgres-based job queue designed for resilience and correctness through strong transactional guarantees.
515
516
Building durable workflows on Postgres
Explaining the concept of a Postgres-backed durable execution system like DBOS and comparing it to external workflow orchestration systems like Temporal.
517
Debugging PostgreSQL performance the hard way
Adventures in getting to know our database
518
Dolt is Git for data
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
519
Running Awk in parallel to process 256M records
TL;DR Awk crunches massive data; a High Performance Computing (HPC) script calls hundreds of Awk concurrently. Fast and scalable in-memory solution on a fat machine.
520
521
When buying the dip doesn’t work: An analysis of the dot-com crash
When a sale isn’t quite what it seems to be
522
523
Doing a database join with CSV files
How to combine data spread over two CSV files, like separate tables in a normalized relational database.
524
Common DB schema change mistakes in Postgres
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
525
Create Statistics in PostgreSQL 10
Postgres stores a lot of statistics about your data in order to effectively retrieve results when you query your database. Here we deep dive into some of the statistics PostgreSQL stores and how you can leverage a new feature in Postgres 10 to improve performance when different columns are related.
526
527
528
Hard Drive Stats for 2019
In 2019 we monitored the performance of 122,507 hard drives. In this article we look at the failure rates by make and model.
529
In Search of a Faster SQLite
Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.
530
531
Why you should probably be using SQLite
Where you store your application data has enormous impacts on your entire application. There are implications on the entire stack based on what you decide to...
532
The Future of Notebooks: Lessons from JupyterCon
At JupyterCon, I learned three things: reactive notebooks are the future, Jupyter is the new Bash, and data science is a gateway drug.
533
Database Performance at Scale – A free book
Discover new ways to optimize database performance and avoid common mistakes that impact latency and throughput.
534
535
Redis is fast – I'll cache in Postgres
There are books & many articles online, like this one arguing for using Postgres for everything. I thought I’d take a look at one use case - using Postgres instead of Redis for caching. I work with APIs quite a bit, so I’d build a super simple HTTP server that responds with data from that cache. I’d start from Redis…
536
Learning from 20 years of personal analytics
Utilizing data analysis capabilities in Wolfram|Alpha Pro, Stephen Wolfram looks at his quantified self based on his large collection of lifelogging data.
537
B-Trees and Database Indexes
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
538
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.
539
Making Postgres slower
As an respectable unemployed person must do, I tried to make Postgres as slow as possible
540
Visualizing Ext4
What does ext4 look like?