1531
A Python-first data lakehouse
Prototype in Marimo, deploy in Bauplan. Learn how to build production-grade pipelines from notebooks with a Python-native stack. No handoffs, no rewrites.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,338 posts.
1532
In the land of LLMs, can we do better mock data generation?
"Lorem ipsum is latin, slightly jumbled, the remnants of a passage from Cicero's _de Finibus_ 1.10.32, which begins 'Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit...' [There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is…
1533
1534
Managed Redis on Google Cloud Platform
Google Cloud provides managed database services for your favorite open source data stores as well as Google proprietary technologies. Today we’re announcing updates to both.
1535
Where machine learning meets rule-based systems
Summary: This post addresses some high-level questions like: Longer term, how much of the verification of Intelligent Autonomous Systems can be done with just Machine Learning (ML)? Should most req…
1536
1537
PostgreSQL Count(*) Performance Improvements
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
1538
1539
How to become a data scientist
This is Part One in a three-part series examining how to become a data scientist. Supported by extensive research and expert opinions, it aims to provide a comprehensive guide to anyone looking to move into this field, irrespective of background and experience. The topic of Part One is: "What is Data Science?".
1540
OrioleDB beta7: Benchmarks
OrioleDB is a storage extension for PostgreSQL which uses PostgreSQL's pluggable storage system. Designed as a drop-in replacement for PostgreSQL's existing Heap storage, OrioleDB aims to overcome scalability bottlenecks and fully utilize modern hardware capabilities. By integrating seamlessly with PostgreSQL, it…
1541
The Use of assert() in SQLite
The assert(X) macro is part of standard C , in the <assert.h> header file. SQLite adds three other assert()-like macros named NEVER(X), ALWAYS(X), and testcase(X).
1542
Improving compression at scale with Zstandard
Two years ago, Facebook open-sourced Zstandard v1.0, a landmark data compression solution that offers best-in-kind performance. Since then, we’ve released a variety of enhancements and advanc…
1543
1544
Introducing FreeNAS Corral
In the TrueNAS blog, discover the latest in scalable data storage solutions. Stay updated on the latest innovations in TrueNAS technology.
1545
Avoiding “OR” for Better Query Performance
OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.
1546
1547
The way CTRL-C in Postgres CLI cancels queries is incredibly hack-y
There are a few different reasons to hit the brakes on a Postgres query. Maybe it’s taking too long to finish. Maybe you realised you forgot to create an index that will make it orders of magnitude quicker. Maybe there’s some reason the results are no longer needed. Or maybe you, or your LLM buddy, […]
1548
1549
1550
Plotnine: Grammar of Graphics for Python (2019)
Blog article by Jeroen Janssens. Jul 7, 2024. 93 min read. Hey there, you’re reading an updated version of a post I published way back in 2019. Because of the 2024 Plotnine contest and the recent release of Polars 1.0, I decided to freshen things up. Changes include: Upgrade to Plotnine version 0.13.6 (from…
1551
1552
BM25 in PostgreSQL
VectorChord-BM25 enhances PostgreSQL search with BM25 ranking, 3x faster than ElasticSearch. Supports BERT, Tocken, and Unicode tokenizers
1553
Multiranges in Postgres
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
1554
1555
1556
1557
PostgreSQL 10.2 Released
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.2, 9.6.7, …
1558
The World’s Largest Street-Level Imagery Dataset for Teaching Machines to See
Mapillary Vistas, the world’s largest and most diverse publicly available, pixel-accurately and instance-specifically annotated street-level imagery dataset, will empower autonomous mobility and transport at the global scale.
1559
1560