871
The drive stats of Backblaze storage pods
Dive into Backblaze's analysis of storage server performance, exploring Drive Stats, Storage Pods, and insights on drive failure rates since 2009.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
872
Neki – Sharded Postgres
Neki, sharded Postgres by PlanetScale, is now available in platform preview.
873
Will Amazon S3 Vectors kill vector databases or save them?
AWS S3 Vectors aims for 90% cost savings for vector storage. But will it kill vectordbs like Milvus? A deep dive into costs, limits, and the future of tiered storage.
874
Amazon Location Service
Update June 1, 2021 – Amazon Location Service is now generally available and includes routing and raster (satellite) maps. You can easily and securely add maps, geocoding, routing, tracking, and geofencing to your applications. Read more about the new features in our new blog post here or try it now in the console. We…
875
Open-Source Loan-Level Analysis of Fannie and Freddie
[M]ortgages were acknowledged to be the most mathematically complex securities in the marketplace. The complexity arose entirely out of the option the homeowner has to prepay his loan; it was poetic …
876
Log-log plot of new vs. total Covid-19 cases by country
Visualizing the exponential growth of COVID-19 across the world.
877
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.
878
PlanetScale – Database for Developers
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
879
PSA: SQLite WAL checksums fail silently and may lose data
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
880
Removing newlines in FASTA file increases ZSTD compression ratio by 10x
First released with Zstandard 1.3.2 in 2017, the --long range match finder increases the compressor’s search window to at least 128MiB, improving deduplication inside large files. This optional feature had substantial performance overheads at launch, but various optimisations have since brought its performance within…
881
Announcing R Tools for Visual Studio
Access to this page requires authorization. You can try signing in or changing directories .
882
Building a Simple Search Engine That Works
You don't need Elasticsearch for most projects. I built a simple search engine from scratch that tokenizes everything, stores it in your existing database, and scores results by relevance. Dead simple to understand and maintain.
883
884
Comprehensive Tutorial on Time Series Modelling and Forecasting
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for Auto-Regressive and MA stands for Moving Average
885
Hedge funds use satellite images to beat Wall Street
Berkeley Haas research finds there may be a dark side to the rise of “alternative data” in capital markets While Assoc. Prof. Panos Patatoukas was discussing Walmart in his Financial Information Analysis course last year, a student brought up the story of how company founder Sam Walton used to count cars in store…
886
Excel now supports multiple values in a single cell
Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with...
887
ClickHouse Cloud is now in Public Beta
ClickHouse Cloud has entered public beta. Get your free trial now!
888
SQL:2023 is finished: Here is what's new
SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Central Secretariat, and it’s now up to the ISO gods when it will be published. Based on past experience, it could be between a few weeks and a few months.
889
AWS Elasticsearch: a fundamentally-flawed offering
I'm currently working on a logging project that was initially implemented using AWS Elasticsearch. Having worked with large-scale mainline Elasticsearch clusters for several years, I'm absolutely stunned at how poor Amazon's implementation is and I can't fathom why they're unable to fix or at least improve it. I…
890
2022 Cloud Report
The 2022 Cloud Report is the only cloud performance report to compare AWS, Azure, and GCP on benchmarks that reflect critical applications and workloads.
891
Cloud SQL for PostgreSQL now generally available
Among open-source relational databases, PostgreSQL is one of the most popular—and the most sought-after by Google Cloud Platform (GCP) users. Today, we’re thrilled to announce that PostgreSQL is now generally available and fully supported for all customers on our Cloud SQL fully-managed database service.
892
893
KSQL: Open Source Streaming SQL for Apache Kafka
Introducing KSQL, a streaming SQL engine for Apache Kafka. KSQL provides a simple and completely interactive SQL interface for processing data in Kafka.
894
An overview of distributed Postgres architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
895
896
PostgreSQL’s New LATERAL Join Type
This post walks through a conversion funnel analysis that wouldn’t be possible in PostgreSQL 9.2
897
898
Deep Inside: A Study of 10,000 Pornstars and Their Careers
An analysis and infographic of 10,000 porn stars and adult films, revealing what the average adult performer looks like and does on film.
899
Open, rigorous and reproducible research: A practitioner’s handbook (2021)
Even though many scientists are expected to abide by the principles of open, rigorous and reproducible research, few scientists actually receive formal training in this. Indeed, there is no collection written by working scientists for working scientists about the principles of transparent, rigorous and reproducible…
900