3331
Making Faster B-Trees with Go Generics
Go generics are a new way to improve performance in golang. Let’s see what effect generics had on Google’s B-tree implementation.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3332
Dicom File Format Basics
Explore the fundamentals of the DICOM file format! This quick introduction covers the basics of DICOM's structure, its essential uses, and tips for easily navigating its complex and abstract components.
3333
SQL + M4 = Composable SQL
I often work with clients who have large “data lakes” or big star schema style enterprise databases with fact and dimension tables as far as the eye can see. Invariably said clients end up with a substantial SQL codebase composed of hundreds of independent queries with lots of overlap between them. I want to be able…
3334
Timescale Announces New Database Cloud
Timescale Cloud provides a balance between a familiar developer platform and a flexible database for modern applications while retaining the ease.
3335
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
3336
Let’s Talk OpenZFS Snapshots
Optimize OpenZFS snapshots. Learn which data benefits from snapshots, how long to keep them, and how to avoid performance bottlenecks.
3337
3338
Loading NumPy arrays from disk: mmap() vs. Zarr/HDF5
Learn how to load larger-than-memory NumPy arrays from disk using either mmap() (using numpy.memmap), or the very similar Zarr and HDF5 file formats.
3339
One Million Database Connections
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.
3340
3341
Architecture of Nautilus, the new Dropbox search engine
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
3342
3343
SQLAlchemy and You
The Django ORM feels so much easier than SQLAlchemy? Maybe this article can change your perception.
3344
The Ethereum-blockchain size will not exceed 1TB anytime soon
Once a month users post a chart on `r/ethereum` predicting the blockchain size of Ethereum will soon exceed 1 TB. I want to clean up with some stories around the Ethereum-blockchain size in this article and try to explain why this chart is technically correct, but not the full picture...
3345
3346
3347
Daft: A High-Performance Distributed Dataframe Library for Multimodal Data
Discover how Daft accelerates multimodal data processing with a high-performance distributed dataframe engine built for modern AI and analytics tasks.
3348
RStudio Is Becoming Posit
We are very excited to announce that RStudio has a new name, Posit.
3349
3350
CockroachDB's Consistency Model
CockroachDB's consistency model fits somewhere between serializability and linerarizability. We're proposing a new marketing phrase for CRDB's guarantees: no stale reads.
3351
SQLite Release 3.40.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
3352
Cloud Platform at Google I/O – new Big Data, Mobile and Monitoring products
Cost per task: Using cheap classifiers to route across Gemini models and thinking levels
3353
3354
3355
3356
3357
PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 released
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, …
3358
Postgres vs. Pinecone
We respond to Pinecone's recent blog post comparing Postgres and Pinecone. We show that Postgres can outperform Pinecone in the same benchmarks Pinecone covered in their article.
3359
Diffing Coronaviruses
Comparing the genome sequences of the Wuhan coronavirus and a bat coronavirus using `diff` and NCBI BLAST reveals an 89% similarity.
3360
Make Patterns Pop Out of Heatmaps with Seriation (2018)
One of the easiest ways to start visualizing data is to turn a table into a heatmap: every cell gets a colour, the higher the number the brighter the colour. Unfortunately, this is often a fairly unrewarding exercise, yielding graphics that look like plaid or tartan fabric. Part of the problem is that the rows and…