1501
Google Analytics 4
Universal Analytics is sunsetting next year. Prepare now by moving over to the next generation Analytics solution, Google Analytics 4.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1502
Introduction to K-Means Clustering
Under unsupervised learning, all the objects in the same group (cluster) should be more similar to each other than to those in other clusters; data points from different clusters should be as different as possible. Clustering allows you to find and organize data into groups that have been formed organically, rather…
1503
Filesystems can experience at least three different sorts of errors
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
1504
Shopify's Data Science and Engineering Foundations (2020)
Shopify’s Data team uses these foundational approaches to data warehousing and analysis empowering us to deliver the best results for our ecosystem.
1505
FoundationDB: A distributed unbundled transactional key value store
This paper from Sigmod 2021 presents FoundationDB, a transactional key-value store that supports multi-key strictly serializable transacti...
1506
Phases of Netflix’s real-time data infrastructure
The blog post will share the four phases of Real-time Data Infrastructure’s iterative journey in Netflix (2015-2021). For each phase, we will go over the evolving business motivations, the team’s unique challenges, the strategy bets, and the use case patterns we discovered along the way.
1507
Postgres Auditing in 150 lines of SQL
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
1508
How can we know if paid search advertising works?
Addressing causal problems on major eBay and Facebook
1509
Non blocking and zero downtime ALTER statements in PostgreSQL with pg-osc
pg-osc is a CLI tool for making non-blocking, zero downtime schema changes in PostgreSQL
1510
IPFS Backed by Decentralized Storage
Filebase now supports IPFS! Learn more about our latest network integration and how you can pin data onto IPFS in seconds, at a fraction of the cost of existing services.
1511
New JSON query operators in SQLite 3.38.0
SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...
1512
PlanetScale increases plans to include billions of reads
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
1513
1514
Optimizing Postgres text search with trigrams
In this post, we’ll implement and optimize a text search system based on Postgres Trigrams
1515
Timescale raises $110M Series C
Timescale just raised $110 million in our Series C, led by Tiger Global alongside all existing investors: Benchmark, New Enterprise Associates.
1516
1517
1518
Machine Learning Algorithms Cheat Sheet
Machine learning is a subfield of artificial intelligence (AI) and computer science that focuses on using data and algorithms to mimic the way people learn, progressively improving its accuracy. This way, Machine Learning is one of the most interesting methods in Computer Science these days, and it'
1519
Squeezing Performance from SQLite: EXPLAINing the Virtual Machine
The virtual machine? Yep, but not the Java Virtual Machine.
1520
Static B-Trees: A data structure for faster binary search
This section is a follow-up to the previous one , where we optimized binary search by the means of removing branching and improving the memory layout. Here, we will also be searching in sorted arrays, but this time we are not limited to fetching and comparing only one element at a time.
1521
Apache Arrow Flight SQL: Accelerating Database Access
This post introduces Arrow Flight SQL, a protocol for interacting with SQL databases over Arrow Flight. We have been working on this protocol over the last six months, and are looking for feedback, interested contributors, and early adopters.
1522
The Unbundling of Airflow
Star us on GitHub In each subdomain of software, we have seen the same story over and over again. Products start small, in time, add adjacent verticals and functionality to their offerings and end up becoming a platform. Once these platforms become big enough, people start to figure out how
1523
I used Benford’s law to analyze Covid-19 in 113 countries (2020)
Spoiler alert: I found some intriguing patterns…
1524
A Hairy PostgreSQL Incident
It was 5:17pm today, just as I was wrapping up work for the day, and my manager pinged me with the following chat: <manager>: Hi Jeremy – we have a <other team> ticket – esc…
1525
The world of PostgreSQL wire compatibility
A wire protocol is the format for interactions between a database server and its clients. It encompasses authentication, sending queries, receiving responses, and so on. It is a description of the exact bytes sent and received by servers and clients. It does NOT encompass the actual query language itself, let alone…
1526
How PostgreSQL stores rows
poking inside postgres pages
1527
1528
The Plausibly Deniable DataBase (PDDB)
The problem with building a device that is good at keeping secrets is that it turns users into the weakest link.
1529
Raid-Z Expansion Feature for ZFS Goes Live
The Foundation sponsored feature reflows existing data to rewrite it onto a new arrangement of disks thereby freeing space at the end of the logical RAID-Z group The FreeBSD Foundation funded the project to ensure the completion and release of an easy-to-use and practical application. The project came in under budget…
1530
Read “Data and Reality”
Once more: we are not modeling reality, but the way information about reality is processed, by people. — Bill Kent I've got this working theory that you can...