241
New
The latest blog posts to take off on Hacker News. 265 posts.
242
PostgreSQL 10.2 Released
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.2, 9.6.7, …
243
Pivot – Rows to Columns
Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).
244
Backblaze Hard Drive Stats for 2017
Since 2013, Backblaze has been showcasing daily statistics from our hard drives. Find out how our drives have been doing throughout 2017 with this blog post.
245
Do or undo – there is no VACUUM
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVC...
246
247
Postgres indexes under the hood
Many software engineers use database indexes every day, but few of us really understand how they work. In this post I’ll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for…
248
249
250
Timescale raises $16M from Benchmark, NEA, Two Sigma Ventures
Humanity is now living with machines and swimming in machine data. Timescale just raised $16M to help developers, businesses, and society make sense of it all.
251
252
Experiences with running PostgreSQL on Kubernetes
An interview covering our experience running PostgreSQL on on-premises Kubernetes: challenges, open source and commercial tools, and alternatives for stateful apps.
253
A summary of what quantitative trading firms do
This summary is an attempt to shed some light on modern quantitative trading since there is limited information available for people who are not already in the industry. Hopefully this is useful for students and candidates coming from outside the industry who are looking to understand what it’s like working for a…
254
PostgreSQL 10: Partitions of partitions
PostgreSQL version 10 brings a much anticipated feature: (Native) Table Partitioning .
255
256
Stream and Go: News feeds for 300M users, built on RocksDB and Raft
Discover the tech stack used by Stream. Explore 42 tools across 5 categories.
257
258
Datomic Cloud
Announcing Datomic Cloud: a fully AWS-integrated database, up and running from the Marketplace in minutes, delivering the complete Datomic information model.
259
260
Pick strong consistency whenever possible
Do you like complex application logic? We don’t either. One of the things we’ve learned here at Google is that application code is simpler and development schedules are shorter when developers can rely on underlying data stores to handle complex transaction processing and keeping data ordered. To quote the original…
261
Full-Text Search in Django with PostgreSQL
Article based on my talk about Full-text search in Django with PostgreSQL.
262
The State of Vacuum in Postgres
In a recent blog post , I talked about why every system that implements MVCC needs some scheme for removing old row versions, and how VACUUM...
263
264
Docker for data scientists: Introduction and use cases
Data scientists looking to learn Docker can get a brief intro and a look at how to improve your workflow
265
SQL Keys in Depth
The internet is full of dogmatic commandments for choosing and using keys in relational databases. At times it verges on a holy war: should you use natural or artificial keys? Auto-incrementing integers, UUIDs?