271
Building a Database in the 2020s (2022)
Building a database in the 2020s
New
The latest blog posts to take off on Hacker News. 371 posts.
272
273
How does database sharding work?
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools.
274
275
Mapping hospital accessibility with OpenStreetMap
Using OpenStreetMap data to craft a self-hosted interactive map of hospital accessibility in Virginia.
276
Near-lossless image formats using ultra-fast LZ codecs
I think simple ultra-high speed lossy (or near-lossless) image codecs, built from the new generation of fast LZ codecs, are going to become ...
277
Parquet: An efficient, binary file format for table data
Quicker, but also more convenient
278
15k inserts/s with Rust and SQLite (2021)
There is this growing sentiment in tech that stacking more and more layers of complexity to reach the sacrosanct "infinite scalability" is not the way forward. First, because it rarely materializes: you need a lot of other things than fancy tech to reach millions of people. Second, because the tradeoffs
279
BigQuery prices increasing by more than 100% for many users
New BigQuery pricing editions and autoscaling let you choose the right price-performance for your workloads, and pay for only what you use.
280
Postgres as a graph database
You don't need Neo4j for graph data. Walking through nodes, edges, and recursive traversals in plain Postgres, with working SQL.
281
How to Read MySQL EXPLAINs
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.
282
Retool Database
Get a free Postgres DB with the speed + convenience of a spreadsheet. No setup required. Get started today.
283
284
AlloyDB Omni – run AlloyDB anywhere
Today, we’re excited to announce the technology preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run on premises, at the edge, across clouds, or even on developer laptops.
285
286
New health insurance “transparency data” looks suspiciously wrong
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
287
Quicker serverless Postgres connections
Neon’s serverless driver redirects the PostgreSQL TCP wire protocol over WebSockets. This makes ordinary, fully-functional PostgreSQL connections accessible from new environments — including serverless platforms like Cloudflare Workers and Vercel Edge Functions. A key feature of these environments is that state is not…
288
289
Ban 1+N in Django
I always thought of 1+N as a thing that you just keep in your head, catch on code reviews or via performance regressions. This worked well for a long …
290
Retrieval in LangChain
Build better AI apps with flexible retrieval methods in LangChain. Use any retriever—from semantic to hybrid—to create personalized ChatGPT for your data.
291
Yandex open-sources its exabyte-scale big data platform
Hello, my name is Maxim Babenko, I’m the head of the distributed computing technologies department at Yandex. Today we’re pleased to…
292
Pg_jsonschema – JSON Schema Support for Postgres
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
293
Strong Consistency with Raft and SQLite
In the recent past, a typical client/server environment consisted of multiple clients connected to a central database server. A central database architecture is a system where all data is stored in a single centralized location. When client A from Si...
294
Bank failures come in waves
Interactive post about the frequency of bank failures over time
295
Building ClickHouse Cloud from scratch in a year
Have you ever wondered what it takes to build a serverless software as a service (SaaS) offering in under a year? In this blog post, we will describe how we built ClickHouse Cloud from the ground up
296
PostgreSQL Logical Replication Explained
Vigneshwaran C explained the internals of PostgreSQL Logical Replication during PGConf India - if you were not able to attend, you can read all here.
297
Pyroscope and Grafana Phlare join together
We’re happy to announce that Pyroscope, the company behind the open source continuous profiling project of the same name, is now part of Grafana Labs.
298
PostgreSQL 14 Internals
I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova. The final part of the book considers each of the index types in great detail. It explains and demonstrates how access methods, operator classes, and data types work…
299
What is Temperature in NLP?
Temperature is a parameter used in natural language processing models to increase or decrease the “confidence” a model has in its most likely response.
300
There have been 562 bank failures since 2000
One way to measure the magnitude of a bank's failure is by the amount of assets the bank held. At the time it failed, SVB's collapse was the second largest American bank failure of all time, and the largest since 2008.