331
A friendly guide to colours in data visualisation
A collection of tools that help you deal with color gradients & color palettes, to design better data visualizations.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
332
Labor market impacts of AI: A new measure and early evidence
We introduce "observed exposure," combining LLM capability with real Claude usage data, and share early evidence on employment effects.
333
SQLite Release 3.25.0 adds support for window functions
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 .
334
SQLite Release 3.37.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 .
335
Strict Tables – Column type constraints in SQLite - Draft
SQLite strives to be flexible regarding the datatype of the content that it stores. For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to insert the string '123' results in an integer 123 being inserted. But if the…
336
pg_timeseries: Open-source time-series extension for PostgreSQL
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
337
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
338
Vertically Scaling PostgreSQL
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.
339
Globally Distributed Postgres
Documentation and guides from the team at Fly.io.
340
Ten years of ClickHouse in open source
ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.
341
Uncloaking a Slumlord Conspiracy with Social Network Analysis
An economic justice organization uses InFlow SNA software to reveal a slumlord conspiracy
342
Migrating Uber's ledger data from DynamoDB to LedgerStore
This week, we'll dive into how we migrated Uber’s business-critical ledger data to LedgerStore. We'll detail how we moved more than a trillion entries (making up a few petabytes of data) transparently and without causing disruption, and we'll discuss what we learned during the migration.
343
Pgroll: zero-downtime, reversible schema migrations for Postgres
We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL
344
Use perfect hashing, instead of binary search, for keyword lookup
We've been speculating for a long time that hash-based keyword lookup ought to be faster than binary search, but up to now we hadn't found a suitable tool for generating the hash function. Joerg Sonnenberger provided the inspiration, and sample code, to show us that rolling our own generator wasn't a ridiculous idea…
345
Don't bother parsing: Just use images for RAG
If search is the game, looks matter
346
Introduction to PostgreSQL Indexes
Who’s this for Basics How data is stored in disk How indexes speedup access to data Costs associated with indexes Disk Space Write operations Query planner Memory usage Types of Indexes Btree Hash BRIN GIN GiST & SP-GiST Conclusion Who’s this for This text is for developers that have an intuitive knowledge of what…
347
Temporal quality degradation in AI models
A recent study from MIT, Harvard, The University of Monterrey, and other top institutions showed an experiment where 91% of their ML models degrade over time . This study is one of the first of its kind, where researchers focus on studying machine learning models' behavior after deployment and how their performance…
348
Backblaze Hard Drive Stats for 2016
We take a deep dive on hard drive performance stats from 73,653 hard drives. What are the most reliable hard drives by size, manufacturer, and model?
349
Neon Serverless Postgres is generally available
Neon is now Generally Available. We’ve shipped major improvements to Neon internals that, combined with our operating experience scaling up to 700,000+ databases over the past year, give us the confidence that Neon is ready to support your business-critical workloads. If you’re building or scaling an application, you…
350
Modern CSV version 2
And I think you’ll love it. I focused on several areas: Improved UI and user experience Faster performance Useful features Updated documentation For Mac users, Native Apple Silicon (ARM – M1, M2) compatibility If that’s all you need to know, you can buy a license here. Or if you already have a version 1 license, you…
351
352
NumPy 2.0
NumPy 2.0.0 is the first major release since 2006. It is the result of 11 months of development since the last feature release and is the work of 212 contributors spread over 1078 pull requests. It contains a large number of exciting new features as well as changes to both the Python and C APIs.
353
Databases in 2021: A Year in Review
Andy Pavlo - Carnegie Mellon University,
354
Scaling our spreadsheet engine from thousands to billions of cells
Causal has joined Lucanet to deliver Extended Planning and Analysis (xP&A) as part of the Lucanet CFO Solution Platform. Make smarter planning decisions with unified real-time insights across financial and operational planning.
355
Tips for a Healthier Postgres Database
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
356
Bunny Database
Deploy globally, query over HTTP, and scale reads with low latency. Bunny Database lets you build fast without paying the serverless tax.
357
Introduction to Zipline: A Trading Library for Python
This blogpost introduces zipline package in python with its benefits, how to install it, and using it code the moving crossover strategy for financial trade
358
359
Message DB: Event Store and Message Store for PostgreSQL
The Eventide Project team is excited to announce Message DB: A fully-featured event store and message store implemented in PostgreSQL for pub/sub, event sourcing, and evented microservices applicat...
360
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.