61
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 175 posts.
62
IKEA’s knowledge graph and why it has three layers
At IKEA we are building a knowledge graph to improve the overall experience of our customers in the physical and digital space. I like to…
63
How PlanetScale Boost serves SQL queries faster
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
64
Why we moved from AWS RDS to Postgres in Kubernetes
Every new Nhost project now gets a dedicated PostgreSQL instance on Kubernetes with root access, custom extensions, and direct connections.
65
Shopify's Data Science and Engineering Foundations (2020)
Shopify’s Data team uses these foundational approaches to data warehousing and analysis empowering us to deliver the best results for our ecosystem.
66
How discord stores billions of messages (2017)
We decided early on to store all chat history forever so users can come back at any time and have their data available. This is a lot of data: how do we do it?
67
Wikimedia Enterprise announces Google and Internet Archive as first customers
Wikimedia Enterprise announced its first customers: multinational technology company Google and nonprofit digital library Internet Archive. Wikimedia Enterprise was recently launched by the Wikimedia Foundation as an opt-in product.
68
Supabase Vault
Today we're announcing Vault, a Postgres extension for managing secrets and encryption inside your database.
69
Implementing "seen by" functionality with Postgres
Different approaches for tracking visitor counts with PostgreSQL.
70
Historical weather data API for machine learning, free for non-commercial
Get weather data for the past days, weeks or months
71
Jepsen: Redpanda 21.10.1
Redpanda is a Kafka -compatible distributed streaming system based around append-only logs. Compared to Kafka, Redpanda aims to offer users lower latencies and reduced operational complexity. It uses the Raft consensus algorithm internally, rather than depending on a separate installation of Zookeeper . Redpanda…
72
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
73
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
74
SQLite Release 3.39.0
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 .
75
76
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
77
78
Google Analytics 4
Universal Analytics is sunsetting next year. Prepare now by moving over to the next generation Analytics solution, Google Analytics 4.
79
New ScyllaDB Go Driver: Faster Than GoCQL and Its Rust Counterpart
How we built a new Go ScyllaDB driver that’s almost 4x faster than its GoCQL predecessor and 2X faster than its Rust counterpart.
80
Backblaze Drive Stats for Q1 2022
Backblaze wants to be as transparent as possible with our customers about our business. Here’s what you need to know about our drives in Q1 2022.
81
PostgreSQL views and materialized views and how they influenced TimescaleDB
Continuous aggregates are one of Timescale's most popular features, but you can’t fully understand them without some context on Postgres views and materialized.
82
Postgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
83
84
85
86
Analyzing Indie Hacker Products with Verified Revenue
Indie Hackers is a wonderful community for founders, a vast ocean of shared knowledge and a place to showcase your product journey. A lot of people are sharing their products there along with the revenue, often verified by Stripe. We analyzed the available data to check how much revenue are those products making and…
87
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
88
Vectors are over, hashes are the future
Get an introduction into the thinking behind the rise of neural hashing technology — and learn why this may end up being an enormous shift in AI advancement.
89
90
The evolution of the data engineer role
The Evolution of The Data Engineer: A Look at The Past, Present & Future