961
Common data model mistakes made by startups
Data modeling is hard. Here are some missteps to avoid when you're developing your models.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
962
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
963
964
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.
965
PlanetScale – Database for Developers
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
966
Why do database columns have a character length of 191?
`varchar(191)` is such an odd number - how did we get here?
967
The ClickHouse Community
Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.
968
969
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.
970
971
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.
972
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…
973
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.
974
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
975
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.
976
977
Using a disk-based Redis clone to reduce AWS S3 bill
Using SSDB to solve the Redis RAM limitation.
978
979
Prisma – ORM for Node.js and TypeScript
Learn about the motivation for Prisma ORM and how it compares to other Node.js and TypeScript database tools like ORMs and SQL query builders. Applies to Prisma ORM v6.
980
Using inflation tracking methods from 80s and 90s, inflation would be ~10%
The CPI chart on the home page reflects our estimate of inflation for today as if it were calculated the same way it was in 1990. The CPI on the Alternate Data Series tab here reflects the CPI as if it were calculated using the methodologies in place in 1980. In general terms, methodological shifts in government…
981
OpenSearch: AWS fork of Elasticsearch and Kibana
Today, we are introducing the OpenSearch project, a community-driven, open source fork of Elasticsearch and Kibana. We are making a long-term investment in OpenSearch to ensure users continue to have a secure, high-quality, fully open source search and analytics suite with a rich roadmap of new and innovative…
982
Best practices for writing SQL queries
SQL best practices: a brief guide to writing better SQL queries.
983
We scaled the GitHub API with a sharded, replicated rate limiter in Redis
Adventures in leveling up our API rate limiting infrastructure
984
Securing a Postgres Database
A comprehensive overview of the best practices for securing access to PostgreSQL databases.
985
100M Posts Analyzed: What You Need to Write the Best Headlines
Write better headlines with tactics from our analysis of 100 million headlines. Discover the best headline trigrams for Facebook, Twitter & more.
986
Kafka without ZooKeeper
Major milestone release Apache Kafka 4.0 removes ZooKeeper entirely, provides early access to Queues for Kafka, and enables faster rebalances, in addition to many other new KIPs.
987
988
Speeding up SQL queries by orders of magnitude using UNION
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
989
Amazon S3 Object Lambda
March 15, 2023 – You can now use S3 Object Lambda with Amazon CloudFront to tailor content for end users. August 13, 2024 – Added a note clarifying that, when following the walkthrough, you should not mark the Specify Lambda function version option that was added after this post was published. When you store data in…
990
Which color scale to use when visualizing data
This is part 1 of a series on “Which color scale to use when visualizing data” (Part …