721
Backblaze's Hard Drive Stats for Q2 2017
In this update, we’ll review the Q2 2017 and lifetime hard drive failure rates for all our current drive models including enterprise and consumers drives.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
722
Introduction to R Programming
This is a detailed step-by-step introduction to R programming. Starting with the two major reasons to learn R for Data Science, it will guide you through the installation process, and prepare you for the basics of R: arithmetics, variables assignment, data types, functions, and documentations.
723
Backblaze drive stats for Q2 2026
Explore Q2 2026 failure rates across 354,415 Backblaze drives, plus standout models and emerging CMR, SMR, and HAMR storage technologies.
724
Azure Data Studio: An Open-Source GUI Editor for Postgres
When you are working with a database, or any other kind of software, your experience is enhanced or hindered by the tools you use to interact with it. PostgreSQL has a command line tool, psql, and it’s pretty powerful, but some people much prefer a graphical editor.
725
726
727
PlanetScale for Postgres is now GA
PlanetScale for Postgres is now generally available.
728
729
Wolfram Alpha Personal Analytics for Facebook
Wolfram|Alpha analyzes your Facebook data for free. Compute statistics: posting activity, most liked post, words most used, friends' geography, age and genders... more than a dozen reports.
730
The Truth About Linear Regression (2015)
This is basically a compilation of the lecture notes I wrote when teaching 36-401, Modern Regression, in fall 2015 . I offer it here on the chance that it might be of interest to those learning, or teaching, linear regression. There's no shortage of resources on that, but I have tried to present the subject as though…
731
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.
732
Was MongoDB Ever the Right Choice?
I was reading a post recently about Red Hat removing MongoDB support from Satellite (and yes, some folks say it is because of the license changes). It made me think how often over the last few years I’ve seen post after angry post about how terrible MongoDB is and how no one should ever use. However, […]
733
Building a scalable time-series database on PostgreSQL
We just announced the release of TimescaleDB, a new open-source time-series database optimized for fast ingest and complex queries, now available on GitHub.
734
735
736
Understanding the BM25 full text search algorithm
BM25 is a widely used algorithm for full text search. I wanted to understand how it works, so here is my attempt at understanding by re-explaining.
737
Storing UTC is not a silver bullet
Note: this is a pretty long post. If you’re not interested in the details, the conclusion at the bottom is intended to be read in a standalone fashion. There’s also a related blog post …
738
Oracle vs. PostgreSQL – A Comment
I know, this list is not for this, but I just couldn't resist. Please forgive me.
739
Pushing ChatGPT's Structured Data Support to Its Limits
“Function calling” with ChatGPT is ChatGPT’s best feature since ChatGPT.
740
Postgres Indexes for Newbies
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
741
Why Julia
it's faster than other scripting languages, allowing you to have the rapid development of Python/MATLAB/R while producing code that is as fast as C/Fortran
742
78% of Reddit Threads with 1,000+ Comments Mention Nazis
Let me start this post by noting that I will not attempt to test Godwin’s Law , which states that:
743
Python overtakes JavaScript as most questioned language on StackOverflow
Discover some of the most common software bugs that businesses are struggling with and unlock effective strategies to overcome them.
744
Three bugs in the Go MySQL driver
Check out what we learned from shipping our busiest Go service in production—we found 3 bugs in the Go MySQL driver.
745
Clang-11.0.0 Miscompiled SQLite
It appears that the clang-11.0.0 compiler mis-compiles sqlite3.c version 3.32.1. I have checked in a change to SQLite that appears to work around the problem. But there might be other bugs. Therefore, use clang-11.0.0 with caution and test your applications carefully!
746
TimescaleDB vs. Amazon Timestream
Our TimescaleDB vs Amazon Timestream results surprised us, but after intensive testing, we found Timestream slow, expensive, and missing key capabilities.
747
Python Data Visualization 2018: Why So Many Libraries?
Anaconda Scale Customer Event Join us live October 15th Save Your Seat Anaconda Blog
748
Following a Select Statement Through Postgres Internals (2014)
This is the third of a series of four posts based on a presentation I did at the Barcelona Ruby Conference called “20,000 Leagues Under ActiveRecord.” (posts: one two four and video ).
749
Investigating Linux phantom disk reads
An investigation of weird hardware utilization highlighting some interesting Linux kernel behaviors.
750
PostGIS at 20, the Beginning
Twenty years ago today, the first email on the postgis users mailing list (at that time hosted on yahoogroups.com) was sent, announcing the first numbered release of PostGIS. The early history of PostGIS was tightly bound to a consulting company I had started a few years prior, Refractions Research. My first contracts…