91
Eventual Consistency isn’t for Streaming
Understand why eventual consistency isn't suitable for streaming systems & the systematic errors it can cause with Materialize's insights.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 153 posts.
92
Why CockroachDB and PostgreSQL Are Compatible
CockroachDB is PostgreSQL compatible in order to be accessible to an ecosystem of drivers, existing code, and developer knowledge.
93
Effectively Using Materialized Views in Ruby on Rails
We look at how to utilize both, views and materialized views, within Ruby on Rails with a real-world sized dataset of hockey teams and their top scorers.
94
Applying Textbook Data Structures for Real Life Wins
How we leveraged a textbook data structure in our core platform and achieved a 15x speed up for a key data processing step.
95
ListenBrainz moves to TimescaleDB
The ListenBrainz team has been working hard on moving our primary listen store from InfluxDB to TimescaleDB , and today at UTC 16:00 we’re going to make the switch.
96
How we built scalable spatial indexing in CockroachDB
Support for spatial data and geospatial indexing is one of the most requested features in the history of CockroachDB.
97
TaBERT: A new model for understanding queries over tabular data
TaBERT is the first model that has been pretrained to learn representations for both natural language sentences and tabular data.
98
Amazon RDS on Graviton2 Processors
I recently wrote a post to announce the availability of M6g, R6g and C6g families of instances on Amazon Elastic Compute Cloud (Amazon EC2). These instances offer better cost-performance ratio than their x86 counterparts. They are based on AWS-designed AWS Graviton2 processors, utilizing 64-bit Arm Neoverse N1 cores…
99
Classifying 200k articles in 7 hours using NLP
Sculpt AI was built by a team of machine learning experts and SALT.agency and is a code-free AI platform. Keep reading to learn more about the benefits of this.
100
Lessons from Bug Hunters Who've Found 400 Bugs in Popular DBMSs
TiDB is the distributed SQL database built for AI agents. Vectors, transactions, and analytics in one engine with ACID guarantees and elastic scale.
101
Apache Druid vs. Time-Series Databases
Although Druid draws ideas from a number of TSDB concepts, it is designed for a wider range of analytic use cases than those for which a TSDB is usually employed.
102
103
104
You probably don't need PostGIS
PostGIS is a fantastic, battle-tested suite of GIS extensions for Postgres. It handles most aspects of it, and is widely used, for example in OpenStreetMap’s Mapnik. But for your project, it’s most likely overkill. In a Q and A fashion, let’s discuss reasons for (not) using it.
105
Markov Chain Monte Carlo (MCMC) Sampling, Part 1: The Basics (2019)
In this first post of Tweag’s four-part series on Markov chain Monte Carlo sampling algorithms, you will learn about why and when to use them and the theoretical underpinnings of this powerful class of sampling methods. We discuss the famous Metropolis-Hastings algorithm and give an intuition on the choice of its free…
106
Foreign data wrappers: PostgreSQL's secret weapon?
EnterpriseDB (“EDB”), the leader in accelerating Postgres® in the enterprise, today announced its acquisition of Splitgraph, an early-stage disruptor that provides a Postgres compatible serverless SQL API for building data driven applications from hundreds of datasources. This move is seen as a meaningful step in…
107
Serving Dynamic Vector Tiles from PostGIS
Guide to building up a tile server and map client from scratch with PostGIS and PostgreSQL.
108
Improving Postgres Connection Scalability: Snapshots
Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.
109
110
Bay Area Regional GTFS Feed: 31 transit agency feeds together in one API
Last year, Interline began a "startup in residence" at the Metropolitan Transportation Commission. Now we're pleased to publicly release our first creation: the San Francisco Bay Area's Regional GTFS Feed.
111
Flyte: A Cloud Native Machine Learning and Data Processing Platform
Today Lyft is excited to announce the open sourcing of Flyte, a structured programming and distributed processing platform for highly…
112
Using Neural Networks to Find Answers in Tables
Posted by Thomas Müller, Software Engineer, Google Research Much of the world’s information is stored in the form of tables, which can be found o...
113
Cash Is King: Flows, Balances, and Buffer Days
See how our clients and partners—from small business owners to workforce training leaders—work with JPMorganChase to drive meaningful impact and economic growth where they live and work.
114
Pg_stat_monitor – better insights into query performance in PostgreSQL
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.
115
Scaling SQLite to 4M QPS on a Single Server (EC2 vs. Bare Metal)
Discover how Expensify achieved remarkable scaling: 4M QPS on one server! Dive into optimizing SQLite for impressive performance gains.
116
Making Netflix's Data Infrastructure Cost-Effective
By Torio Risianto, Bhargavi Reddy, Tanvi Sahni, Andrew Park
117
118
Airflow 2.0
We're proud to announce that Apache Airflow 2.0.0 has been released.
119
120