31
The satellite imagery industry still has no idea what customers want
The satellite imagery industry still has no idea what customers actually want
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 300 posts.
32
How we upgraded our 4TB Postgres database
Last fall, we migrated our 4TB Postgres database from version 9.6 to version 13 with minimal downtime. Here is how we did it (gotchas included).
33
I almost failed to search a 37 GB text file in under 1 millisecond
... in which we check if your password has been compromised in many inconvenient ways, in a tale of destruction, obsession, and self-discovery.
34
Excel is pretty dang cool
It's like discovering a treasure chest under my kitchen sink
35
You might not need a CRDT
Cloud infrastructure for teams that develop, train, and serve AI applications at scale.
36
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
37
Friendlier SQL with DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
38
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
39
40
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.
41
Turning SQLite into a Distributed Database
mvSQLite is the open-source , SQLite-compatible distributed database. We decoupled SQLite's storage layer onto FoundationDB to offer massive yet "bottomless" scalability, point-in-time reads, and the strictest level of consistency.
42
How PostgreSQL stores rows
poking inside postgres pages
43
Postgres Full Text Search vs. the Rest
Comparing one of the most popular Postgres features against alternatives
44
45
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
46
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
47
Architecture Notes: Datasette
Simon is the creator of Datasette and co-creator of Django web framework. Formerly he was a JSK journalism fellow at Stanford, and prior to that an Engineering Director at Eventbrite.
48
Scaling our spreadsheet engine from thousands to billions of cells
Causal has joined Lucanet to deliver Extended Planning and Analysis (xP&A) as part of the Lucanet CFO Solution Platform. Make smarter planning decisions with unified real-time insights across financial and operational planning.
49
Tips for a Healthier Postgres Database
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
50
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.
51
Analysis of Apple Watch running data
Analysis of Apple running measurements and statistics
52
Postgres full-text search: A search engine in a database (2021)
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.
53
Postgres Auditing in 150 lines of SQL
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
54
TIL–Python has a built-in persistent key-value store (2018)
Simplex Sigillum Veri
55
Static B-Trees: A data structure for faster binary search
This section is a follow-up to the previous one , where we optimized binary search by the means of removing branching and improving the memory layout. Here, we will also be searching in sorted arrays, but this time we are not limited to fetching and comparing only one element at a time.
56
Postgres Indexes for Newbies
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
57
Pretty maps in Python
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
58
How Postgres chooses which index to use for a query
How the Postgres planner breaks down a query into scans and how this impacts indexing choices
59
SQLite or PostgreSQL? It's Complicated
Learn how to benchmark SQLite and PostgreSQL databases.
60
Moving Away from UUIDs (2018)
If you need an unguessable random string (for a session cookie or access token, for example), it can be tempting to reach for a random UUID, which looks like this: 88cf3e49-e28e-4c0e-b95f-6a68a785a…