1801
13% of my website visitors block Google Analytics
There’s widespread use of adblockers on the web but users are increasingly blocking cookies and other tracking scripts too. Browsers such as Safari, Firefox and Brave are privacy-focused.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
1802
Moving our warehouse off DuckDB
We moved our warehouse product off DuckDB and DuckLake onto our own flavor of Trino and a new open table format, HogLake. Here's what broke at scale and why.
1803
1804
DuckDB 0.8
The DuckDB team is happy to announce the latest DuckDB release (0.8.0). This release is named “Fulvigula” after the Mottled Duck (Anas Fulvigula) native to the Gulf of Mexico. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many…
1805
1806
The many faces of DISTINCT in Postgres (2017)
3 interesting uses of DISTINCT in PostgreSQL
1807
1808
PostgreSQL Encryption: The Available Options
On an episode of Postgres FM , the hosts had a (very brief) discussion of data encryption in PostgreSQL. While Postgres FM is a podcast well worth a subscribe, the hosts aren’t data security experts, and so as someone who builds a queryable database encryption system , I found the coverage to be somewhat… lacking. I…
1809
Building AI agents to query your databases
In the world of AI agents, the ability to understand and analyze structured data is a game-changer. While large language models excel at understanding natural...
1810
Tips for a healthier Postgres database (2021)
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
1811
Chess in SQL
What if I told you SQL could play chess? No JavaScript, no frameworks - just pure SQL rendering a full chess board in your browser.
1812
PostgreSQL Schema Design
The Postgres database is rich with features well beyond that of any other
1813
Pg_later: Asynchronous Queries for Postgres
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
1814
DuckDB 1.0.0
The DuckDB team is very happy to announce that today we’re releasing DuckDB version 1.0.0, codename “Snow Duck” (anas nivis).
1815
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.
1816
1817
A Primer on Database Replication (2017)
A Primer on Database Replication
1818
No general method to detect fraud
The parts of a convincing deception
1819
Your File System Is Already A Graph Database
Karpathy recently posted about using LLMs to build personal knowledge bases — collecting raw sources into a directory, having an LLM “compile” them into a wiki of interlinked markdown …
1820
Redis Anti-Patterns
Learn to dodge common Redis pitfalls like large keys and hot keys. Boost both your performance and stability. Try it today.
1821
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
1822
Can you use autoregressive diffusion to generate market data?
The following is part of a series of posts about 2026 summer intern projects – for more, see “What the interns have wrought, special jumbo 2026 edition”
1823
In-memory key-value store in C, Go and Python
"Coder's paternity leave turns into polyglot key-value store adventure"
1824
1825
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
1826
LogDevice: a distributed data store for logs
Visit the post for more.
1827
pg_duckdb: Splicing Duck and Elephant DNA
Introducing the DuckDB + Postgres Extension: You can have your analytics and transact them too with pg_duckdb by DuckDB Labs, MotherDuck, Hydra, Neon and Microsoft. | Reading time: 8 min read
1828
PostgreSQL B-Tree index deduplication
PostgreSQL 13 development is coming along nicely, Postgres 13 Beta3 was released on 8/13/2020 . The Postgres Beta 1 and 2 releases were released in May and June 2020. One of the features that has my interest in Postgres 13 is the B-Tree deduplication effort. B-Tree indexes are the default indexing method in Postgres…
1829
PostgreSQL 9.5 Released
Stamp 9.5.0. Branch ------ REL9_5_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/cdd4ed5449bf317cc71b45a8deee0173822e7592 Modified Files -------------- configure | 18 +++++++++--------- configure.in | 2 +- doc/bug.template …
1830
Google Analytics 4
Universal Analytics is sunsetting next year. Prepare now by moving over to the next generation Analytics solution, Google Analytics 4.