181
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 272 posts.
182
The Empty Promise of Data Moats
Data has long been lauded as a competitive moat for companies, and that narrative’s been further hyped with the recent wave of AI startups. Network effects have been similarly promoted as a defensible force in building software businesses. So of course, we constantly hear about the combination of the two: “data…
183
Wikipedia pageviews this year for each line of ‘We Didn't Start the Fire’
The modern relevancy of every line of 'We Didn't Start the Fire'
184
185
CockroachDB 19.2
CockroachDB 19.2 improves latency, reliability, and usability. We’re bringing the speed of distributed transactions closer to the theoretical minimum.
186
Data Science Interview Study Guide
We help you acquire the perfect domain for your site. Affordable payment options. Quick and responsive customer support available.
187
188
Useful Postgres Extension: Pg_stat_statements
Inspired by a talk in the PostgreSQL devroom at FOSDEM, a post on the usefulness of the pg_stat_statements extension to Postgres and why every Postgres developer should have it in their toolbox. With sections on getting started, and how to extract insights with pg_stat_statements.
189
Ice cold archive storage
Get the latest cloud storage news here from Google Cloud, with a new archive storage class and Persistent Disk updates.
190
PostgreSQL Count(*) Performance Improvements
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
191
The Use of assert() in SQLite
The assert(X) macro is part of standard C , in the <assert.h> header file. SQLite adds three other assert()-like macros named NEVER(X), ALWAYS(X), and testcase(X).
192
Avoiding “OR” for Better Query Performance
OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.
193
Notes on the Amazon Aurora Paper
This is my notes on the paper: Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases.
194
Postgres tips for the average and power user
A collection of power user tips for those working with Postgres
195
Amazon Launches Managed Cassandra Service
Managing databases at scale is never easy. One of the options to store, retrieve, and manage large amounts of structured data, including key-value and tabular formats, is Apache Cassandra. With Cassandra, you can use the expressive Cassandra Query Language (CQL) to build applications quickly. However, managing large…
196
Linux Fsync Issue for Buffered IO and Its Preliminary Fix for PostgreSQL
With the latest upgrades to PostgreSQL the fsync failure had been fixed. Avinash Vallarapu takes a look at why this issue might cause problems.
197
Random Forest vs. Neural Network
Choosing between Random Forest and Neural Network depends on the data type. Random Forest suits tabular data, while Neural Network excels with images, audio, and text data.
198
199
How Bad Is Your Colormap? (2014)
What this function does is to give you a lumninance-correct grayscale version of any matplotlib colormap. I've found this useful for quickly checking how my plots might appear if printed in black and white, but I think it's probably even more useful for stoking the flame of the internet's general rant against jet .
200
What’s Wrong with Bayes
My problem is not just with the methods—although I do have problems with the method—but also with the ideology.
201
Attunity Data Leak: Vendor for half the Fortune 100 exposed terabyte of backups
Backups ensure data continuity, but they're also a surface of risk. See how Fortune 100 vendor Attunity exposed nearly a terabyte of internal backups.
202
203
Data-as-a-Service: Running DaaS Companies
A complete guide to building and running a Data-as-a-Service (DaaS) company. Learn DaaS economics, market dynamics, data acquisition models, transformation, delivery, and how to achieve market dominance.
204
Apache Arrow Flight: A Framework for Fast Data Transport
This post introduces Arrow Flight, a framework for building high performance data services. We have been building Flight over the last 18 months and are looking for developers and users to get involved.
205
Introduction to LSM Trees: May the Logs Be with You
LSM Trees overview This post is a part of a newsletter that I run: “Scamming The Coding Interview“, which is geared towards helping people ACE their coding interviews. We send a coding qu…
206
207
Oklahoma Department of Securities Leaked Millions of Files
A storage server configured for public access exposed millions of files belonging to the Oklahoma Securities Commission.
208
Designing far memory data structures: think outside the box
Designing far memory data structures: think outside the box Aguilera et al., HotOS’19 Last time out we looked at some of the trade-offs between RInKs and LInKs, and the advantages of local in…
209
Backblaze Hard Drive Stats Q1 2019
This review looks at the Q1 2019 and lifetime hard drive failure rates of the 104,325 data drive models currently in operation in our data centers.
210
FastMRI initiative releases neuroimaging data set
As part of the fastMRI research project to use AI to speed up MRI scans, NYU Langone Health is making a new dataset of de-identified brain MRIs available to researchers and Facebook AI is sharing additional tools and resources.