2311
New
The latest blog posts to take off on Hacker News. 4,224 posts.
2312
2313
2314
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.
2315
How to Make Maps Using Leaflet.js, PostGIS and Chicago Open Data
How to get started with mapping GIS data
2316
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…
2317
EDB Postgres AI
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
2318
PostgreSQL Features to Try
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
2319
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).
2320
Open-sourcing F14 for memory-efficient hash tables
Hash tables provide a fast way to maintain a set of keys or map keys to values, even if the keys are objects, like strings. They are such a ubiquitous tool in computer science that even incremental…
2321
Technical Challenges Developing a Distributed SQL Database
Here is an outline of some of architectural issues addressed as we build YugabyteDB, our high-performance distributed SQL database.
2322
Visualization techniques for different data sets
Visualizations are awesome.
2323
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.
2324
2325
Pyodide: Bringing the scientific Python stack to the browser
Pyodide is an experimental project from Mozilla to create a full Python data science stack that runs entirely in the browser. We think it’s worthwhile to work on moving the ...
2326
2327
The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
A question that is frequently occurring among my SQL training’s participants is: What’s the difference between putting a predicate in the JOIN .. ON clause and the WHERE clause? I can d…
2328
2329
CVE-2019-9193: Not a Security Vulnerability
There is widespread mention in the media of a security vulnerability in PostgreSQL, registered as [CVE-2019-9193](https://nvd.nist.gov/vuln/detail/CVE-2019-9193). The PostgreSQL Security Team …
2330
Azure Cosmos DB: Microsoft's Cloud-Born Globally Distributed Database
It has been almost 9 months since I started my sabbatical work with the Microsoft Azure Cosmos DB team. I knew what I signed up for then...
2331
Migrating 23TB from S3 to B2 in 7 hours
Nodecraft moved 23TB of customer backup files from AWS S3 to Backblaze B2 in just 7 hours, and saved big on egrees fees with Cloudflare's Bandwidth Alliance.
2332
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 .
2333
Ice cold archive storage
Get the latest cloud storage news here from Google Cloud, with a new archive storage class and Persistent Disk updates.
2334
PostgreSQL Count(*) Performance Improvements
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
2335
Sorting in Japanese – An Unsolved Problem (2011)
Sorting Japanese is not only difficult—it’s an unsolved problem. This seems hard to believe if you are not familiar with the complexities of processing Japanese digitally. But what is trivially easy in English is impossible in Japanese, even with the amount of computer power we have available today.
2336
Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.
This is pretty important change, as it has the chance to cause performance issues in some cases.
2337
Let’s Build a Simple Database (2017)
Writing a sqlite clone from scratch in C
2338
PostgreSQL Performance on Raspberry Pi
Have you ever wondered how well PostgreSQL performs on a Raspberry Pi 3B ? Oh. You haven't? Oh well, I asked myself that question and put it to the test. This post covers how I used pgbench to answer this question and the results of what I found.
2339
Unreasonable Effectiveness of SQL
Read Couchbase engineering tutorials, product news, and customer stories on AI agents, Capella, vector search, mobile sync, and real-time analytics.
2340
Amundsen – Lyft’s data discovery and metadata engine
In order to increase productivity of data scientists and research scientists at Lyft, we developed a data discovery application built on…