271
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
272
Find anything fast with Google's vector search technology
Recently, Google Cloud partner Groovenauts, Inc. published a live demo of MatchIt Fast . As the demo shows, you can find images and text similar to a selected sample from a collection of millions in a matter of milliseconds:
273
274
Friendlier SQL with DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
275
ClickHouse gets lazier and faster: Introducing lazy materialization
ClickHouse learned to procrastinate strategically. Discover how lazy materialization skips unnecessary column reads to accelerate queries.
276
Postgres.new: In-browser Postgres with an AI interface
Introducing postgres.new, the in-browser Postgres sandbox with AI assistance.
277
Databases in 2022: A Year in Review
Andy Pavlo - Carnegie Mellon University,
278
An Unlikely Database Migration
From JSON Files to etcd: A Tailscale Database Migration Story
279
Jepsen: MySQL 8.0.34
MySQL needs little introduction. Over the last 28 years it has become one of the most widely deployed SQL databases. MySQL is primarily used for online transaction processing (OLTP) workloads, but is also deployed as a part of OLAP and queuing systems.
280
Databases and why their complexity is now unnecessary
This post is not going to be about what’s wrong with individual databases. There are so many databases and so many individual API issues, operational problems, and arbitrary limitations that it wou…
281
What happens when US economic data becomes unreliable
Sound economic planning and policymaking requires trustworthy data. Private data can serve as a complement but not fully replace official U.S. statistics.
282
Jepsen: ParticleDB 1.1.4
Modern applications often spread state across a variety of systems: databases, caches, queues, data warehouses, search indices, and so on. Coordinating these systems is challenging: caches are often stale, the analytics platform might lag days behind the primary database, the search index might lose data, and…
283
284
Introduction to Datalog
A rule-based data query language that thinks differently
285
Pokémon GO: The Data Behind America’s Latest Obsession
Similarweb's blog is a go-to resource for digital professionals and marketing experts offering a wide range of business tips, industry insights, trends and more.
286
Apache Arrow 1.0
The Apache Arrow team is pleased to announce the 1.0.0 release. This covers over 3 months of development work and includes 810 resolved issues from 100 distinct contributors. See the Install Page to learn how to get the libraries for your platform. Despite a "1.0.0" version, this is the 18th major release of Apache…
287
PostgreSQL 11 Partitioning Improvements
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.
288
Google to Acquire Looker
Google to acquire Looker, a unified platform for business intelligence, data applications, and embedded analytics.
289
Rearchitecting: Redis to SQLite
Learn how we approached migrating our Wafris v1 client based on Redis to a new faster, easier to use SQLite architecture.
290
291
Building durable workflows on Postgres
Explaining the concept of a Postgres-backed durable execution system like DBOS and comparing it to external workflow orchestration systems like Temporal.
292
Debugging PostgreSQL performance the hard way
Adventures in getting to know our database
293
Dolt is Git for data
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
294
295
Common DB schema change mistakes in Postgres
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
296
Create Statistics in PostgreSQL 10
Postgres stores a lot of statistics about your data in order to effectively retrieve results when you query your database. Here we deep dive into some of the statistics PostgreSQL stores and how you can leverage a new feature in Postgres 10 to improve performance when different columns are related.
297
Hard Drive Stats for 2019
In 2019 we monitored the performance of 122,507 hard drives. In this article we look at the failure rates by make and model.
298
299
Why you should probably be using SQLite
Where you store your application data has enormous impacts on your entire application. There are implications on the entire stack based on what you decide to...
300
Database Performance at Scale – A free book
Discover new ways to optimize database performance and avoid common mistakes that impact latency and throughput.