61
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 304 posts.
62
One Billion Drive Hours and Counting: Q1 2016 Hard Drive Stats
61,590 hard drives were used in our data center during Q1, 2016. We take a deep dive into the usage to see what we can learn about their performance.
63
Announcing R Tools for Visual Studio
Access to this page requires authorization. You can try signing in or changing directories .
64
65
66
67
68
Amazon RDS now supports PostgreSQL 9.6.1
[Amazon RDS for PostgreSQL](https://aws.amazon.com/rds/postgresql/) now supports the next major release of the PostgreSQL open source database, version 9.6.1. New features …
69
Andl, a relational language that is not SQL, is coming to Postgres
Postgres is “the world’s most advanced open source database”. It is a highly capable database server, and is ordinarily accessed using SQL queries. Postgres is also highly customisable, with the ability to add new functions, new data types and even new languages. There are currently several language implementations…
70
Log Structured Merge Trees
A detailed look at the interesting LSM file organisation seen in BigTable, Cassandra and most recently MongoDB.
71
Torus: A distributed storage system by CoreOS
No single cloud fits all. Explore how we build a more flexible future with hybrid cloud.
72
Backblaze hard drive reliability stats for Q3 2016
We take a look at the hard drive performance of over 65,000 hard drives ranging from 2TB to 8TB drives. Find out the best performers.
73
Postgresql 9.6: Support parallel aggregation
Parallel workers can now partially aggregate the data and pass the transition values back to the leader, which can combine the partial results to produce the final answer.
74
What SMART Stats Tell Us About Hard Drives
Have you ever wondered what your hard drive SMART errors actually mean? Find out what we look at to determine if a drive is about to fail.
75
76
77
78
79
CouchDB 2.0
The Apache CouchDB development community is proud to announce the immediate availability of version 2.0. See also the official Apache Press Release. CouchDB 2.0 is 99% API compatible with the 1.x s…
80
Parsing 10TB of Metadata, 26M Domain Names and 1.4M SSL Certs for $10 on AWS
Last May I was working on hobby project similar to this: https://github.com/zakjan/cert-chain-resolver/. As I found the cert-chain-resolver project a couple of days later I did nothing with the results, but I got some…
81
Introduction to PostgreSQL physical storage
I initially wrote this post for myself, I wanted to understand enough about the underlying physical storage to be able to grasp other concepts which can affect your database. This post is probably more aimed to people with similar interests, I will try to keep it accurate but the aim is to make it simpler to…
82
Apache Spark Scale: A 60 TB+ production use case
Visit the post for more.
83
The impact of Prince’s death on Wikipedia
“Prince is synonymous with indulging in yourself shamelessly and with passion. His music and his cultural impact mean more than words can offer.” “He taught me that being black wa…
84
Spark as a Compiler: Joining a Billion Rows per Second on a Laptop
Discover how Apache Spark can join a billion rows per second on a laptop, showcasing its powerful data processing capabilities.
85
SQL Server on Linux public preview
This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing Today, we are excited to announce the public preview of the next release of SQL Server on Linux and Windows, which brings the power of SQL Server to both Windows – and for the first time ever – Linux.
86
87
Designing a SaaS Database for Scale with Postgres
Exploration of different architectures for designing a SaaS database that scales for multi-tenant data models, including one database per tenant, one schema per tenant, and having all tenants share the same tables. The right choice for you depends on whether you’re optimizing for scale or isolation.
88
89
A Tour of Python’s Data Visualization Landscape, Including Ggplot and Altair
Why Even Try, Man? I recently came upon Brian Granger and Jake VanderPlas’s Altair, a promising young visualization library. Altair seems well-suited to addressing Python’s ggplot …
90
Practical advice for analysis of large, complex data sets
By PATRICK RILEY For a number of years, I led the data science team for Google Search logs. We were often asked to make sense of confusin...