3451
PostgreSQL DBaaS vendor comparison and calculator
This is a comparison of PostgreSQL DBaaS providers with an interactive calculator.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3452
Starting data analysis with R: Things I wish I'd been told
R is a very powerful open source environment for data analysis, statistics and graphing, with thousands of packages available. After my previous blog post about likert-scales and metadata in R , a few of my colleagues mentioned that they were learning R through a Coursera course on data analysis . I have been working…
3453
We built a persistent agent memory layer on Elasticsearch with 0.89 recall
Persistent agent memory on Elasticsearch: three-index architecture, hybrid retrieval, supersession and DLS isolation. R@10 0.89, zero cross-tenant leaks.
3454
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
3455
3456
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
3457
ChaosDB Explained: Azure's Cosmos DB Vulnerability Walkthrough
This is the full story of the Azure ChaosDB Vulnerability that was discovered and disclosed by the Wiz Research Team, where we were able to gain complete unrestricted access to the databases of several thousand Microsoft Azure customers.
3458
3459
3460
Sparrow, a modern C++ implementation of the Apache Arrow columnar format
A Modern C++ Implementation of the Apache Arrow Columnar Format
3461
LLM Classification Is Feature Engineering
LLMs make good classifiers but even better features
3462
databow: a Rust CLI to query any database with an ADBC driver
One command-line tool to query them all, built with Rust and ADBC
3463
Recommending items to more than a billion people
Visit the post for more.
3464
The mean means nothing: data visualization to debug a latency problem
I was recently trying to validate some performance improvements related to lld at $DAYJOB and it was a little frustrating to see the improvements in our benchmarks but not in the live-production dashboards.
3465
3466
Postgres text search: balancing query time and relevancy
How do you balance query time and relevance with Postgres text search? Stephen Gutekanst, an engineer working on Sourcegraph's API docs feature, shares tips for stirring code analysis with search indexing.
3467
Querying the GitHub archive with the ClickHouse playground
Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
3468
Datasette Facets: Faceted Browse and a JSON API for any CSV File or SQLite DB
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
3469
3470
A Comparison of Distributed Machine Learning Platforms
This paper surveys the design approaches used in distributed machine learning (ML) platforms and proposes future research directions. This ...
3471
3472
Distributed consensus revised
Distributed consensus revised Howard, PhD thesis Welcome back to a new term of The Morning Paper! To kick things off, I’m going to start by taking a look at Dr Howard’s PhD thesis, ‘Distributed con…
3473
Why query planning for streaming systems is hard
Many groups are working on running sql queries in incremental/streaming systems . Query planning in this context is not a well understood problem. This post is a quick pointer towards the many open problems. It's not intended to be complete or authoritative, because I haven't engaged with the problem much beyond…
3474
Hi My Name is John…and I am addicted to analytics
…and I am addicted to analytics. It all started when I was a wee lad. I quite enjoyed playing Tecmo NBA Basketball, among other games. One day, while…
3475
The Impact of Index Investing: A Follow-Up
The prior piece received a much stronger reaction than I expected. The topic is complicated, with ideas that are difficult to adequately convey in words, so I’m going to use this piece as a follow-up. I’m going to look at the specific example of the Tech Bubble, which is a clear case in which the broad adoption of a…
3476
ZFS: Use mirror vdevs, not RAIDZ
Continuing this week’s “making an article so I don’t have to keep typing it” ZFS series… here’s why you should stop using RAIDZ, and start using mirror vdevs instead.
3477
Modern Transactional Stack
Transactional databases have long been the most critical component of application design. Why? Because a steadfast database is generally the ultimate enforcement point for correctness in a messy, distributed world. Without them we’d overpay and undercharge. We’d lose riders trying to get home from the airport, and…
3478
Gravwell Community Edition: A Splunk Alternative Built with Go
Initial Gravwell testers did a lot of home monitoring with the software and wanted to get licenses for their friends and colleagues but Gravwell was built for larger enterprises and our pricing model isn't set up for home use. All of that changes with the Community Edition...
3479
3480
MySQL 5.7: over 1M queries/sec on a single machine
Last week, during Tomas ' keynote at MySQL Percona Live Conference in London we announced as one of "previews" of the following MySQL 5.7 release(s) -- an over 1,000,000 Query/sec result obtained with InnoDB Memcached plugin on a Read-Only workload. This article here is just to confirm the announced results without…