181
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.
New
The latest blog posts to take off on Hacker News. 314 posts.
182
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!
183
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…
184
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.
185
186
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…
187
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.
188
189
Common data model mistakes made by startups
Data modeling is hard. Here are some missteps to avoid when you're developing your models.
190
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
191
192
193
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.
194
PlanetScale – Database for Developers
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
195
Why do database columns have a character length of 191?
`varchar(191)` is such an odd number - how did we get here?
196
The ClickHouse Community
Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.
197
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…
198
Debugging random slow writes in PostgreSQL
Understanding & mitigating randomly slow writes in PostgreSQL
199
Good data scientist, bad data scientist
What separates a good Data Scientist from a bad one?
200
201
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.
202
203
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.
204
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…
205
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.
206
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
207
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.
208
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.
209
Practical SQL for Data Analysis
What you can do without Pandas
210
Why are there so many Canadians in India?
Any time India comes up in the context of Firefox and Data I know it’s going to be an interesting day. They’re our largest Beta population: They’re our second-largest English user…