1741
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1742
Cloudera taken private for $5.3B, acquires Datacoral and Cazena
Cloudera Blog is your source for expert guidance on the latest data and AI trends, technology innovation, best practices, success stories, and more.
1743
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
How to decide what to use for autogenerated primary keys: UUID, serial or identity column? Recommendations are given!
1744
PostGIS at 20, the Beginning
Twenty years ago today, the first email on the postgis users mailing list (at that time hosted on yahoogroups.com) was sent, announcing the first numbered release of PostGIS. The early history of PostGIS was tightly bound to a consulting company I had started a few years prior, Refractions Research. My first contracts…
1745
PostgreSQL EXPLAIN Output Explained
UPDATED July 2023: How to use EXPLAIN ANALYZE in PostgreSQL, learn tools to visualize the output. See query execution time and row count.
1746
1747
Potemkin Data Science (2020)
Huge swathes of people, in Europe and North America in particular, spend their entire working lives performing tasks they secretly believe…
1748
A journey to io_uring, AIO and modern storage devices
We performed experiments to find out how different Linux system calls perform for available devices.
1749
1750
Common data model mistakes made by startups
Data modeling is hard. Here are some missteps to avoid when you're developing your models.
1751
An early look at Postgres 14: Performance and monitoring Improvements
We take a look at whats new in Postgres 14, with idle and active connection scaling, memory monitoring, query IDs and more
1752
1753
1754
The data model behind Notion's flexibility
Notion’s data model enables the product’s most foundational component: blocks. Through blocks, we allow users more flexibility over their information.
1755
PlanetScale – Database for Developers
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
1756
Why do database columns have a character length of 191?
`varchar(191)` is such an odd number - how did we get here?
1757
The ClickHouse Community
Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.
1758
Replacing Elasticsearch with Rust and SQLite (2017)
Caveat: Elasticsearch is a multi-purpose, distributed, battle-tested, schema-free, log and document storage engine. We’ll be replacing it with a single-purpose, relational schema, me-tested, and custom nginx access log storage engine. Knowing that, let’s begin. Find this project on Github After building my home…
1759
Debugging random slow writes in PostgreSQL
Understanding & mitigating randomly slow writes in PostgreSQL
1760
Good data scientist, bad data scientist
What separates a good Data Scientist from a bad one?
1761
1762
Estimation of total mortality due to COVID-19
Our updated modeling strategy now estimates total COVID-19 mortality, including unreported deaths due to COVID-19.
1763
1764
Faster DISTINCT queries on PostgreSQL
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.
1765
Apache Arrow 4.0
The Apache Arrow team is pleased to announce the 4.0.0 release. This covers 3 months of development work and includes 711 resolved issues from 114 distinct contributors. See the Install Page to learn how to get the libraries for your platform. The release notes below are not exhaustive and only expose selected…
1766
TimescaleDB raises $40M
We just raised a $40M Series B to bring our relational database for time-series to developers everywhere. Learn how we got started and what’s still yet to come.
1767
Just Say No to Paxos Overhead: Replacing Consensus with Network Ordering (2016)
Jialin Li, Ellis Michael, Naveen Kr. Sharma, Adriana Szekeres, and Dan R. K. Ports, University of Washington
1768
Backblaze Drive Stats for Q1 2021
A look at the quarterly and lifetime failure rates of 175,443 drives, including a comparison of failure rates of HDD and SSD boot drives.
1769
An opinionated map of incremental and streaming systems
Disclaimer: I used to work for Materialize which is one of the systems being compared in this post.
1770
Practical SQL for Data Analysis
What you can do without Pandas