31
Demystifying OpenZFS 2.0
Explore the changes and reasons behind OpenZFS 2.0. This article clarifies the transition from feature flags and its impact on FreeBSD 13.
New
The latest blog posts to take off on Hacker News. 314 posts.
32
PlanetScale is now generally available
PlanetScale is now GA.
33
34
Databricks response to Snowflake's accusation of lacking integrity
Analyze the claims made by Snowflake regarding price/performance compared to Databricks and the counterarguments presented.
35
Build an Elixir Redis Server that’s faster than HTTP
Build a redis server in Elixir
36
Breakdown of data on homeless populations across the U.S.
Many people see a homelessness crisis, but what does the data say? We examine different locations, rates of change, types of homelessness, and mental health and substance abuse issues.
37
38
Lesser-known Postgres features
Features you already have but may not know about!
39
The LZ4 introduced in PostgreSQL 14 provides faster compression
Haiying Tang takes you on a tour of LZ$ TOAST, the new column opton compression in PostgreSQL 14, and shows the speed and compression ratio gains.
40
41
Zillow, Prophet, time series, and prices
So I made a mildly controversial tweet. Lots of people enjoyed it, but the LinkedIn-adjacent section of data science Twitter is not happy about it. I want to provide as much context for it as I can…
42
Spending $5k to learn how database indexes work
At Superwall we’re building an SDK to help App Developers increase their revenue by showing the right offer to the right person at the right time. Follow me on twitter for little tips and articles like this one.
43
44
Deconstructing the Postgres planner to find indexing opportunities
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
45
Encrypting Postgres Data at Rest in Kubernetes
An example of how you can encrypt Postgres data at rest using PGO, the open source Postgres Operator from Crunchy Data using AWS EBS gp2 volumes.
46
Tao: Facebook’s distributed data store for the social graph
The papers over the next few weeks will be from (or related to) research from VLDB 2021 - on the horizon is one of my favorite systems conferences SOSP . As always, feel free to reach out on Twitter with feedback or suggestions about papers to read! These paper reviews can be delivered weekly to your inbox , or you…
47
DuckDB-Wasm: Efficient analytical SQL in the browser
DuckDB-Wasm is an in-process analytical SQL database for the browser. It is powered by WebAssembly, speaks Arrow fluently, reads Parquet, CSV, and JSON files backed by Filesystem APIs or HTTP requests, and has been tested with Chrome, Firefox, Safari, and Node.js. You can try it at shell.duckdb.org or on Observable.
48
Open-Source Babelfish for Postgres
Babelfish for PostgreSQL is an Apache-2.0 and PostgreSQL open source project that adds a Microsoft SQL Server-compatible end-point to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands.
49
Comparing SQLite, DuckDB and Arrow with UN trade data
This is not a competition, is just to show how to use the hardware with relative efficiency, being the idea is to show something collaborative rather than competitive.
50
Building a recommendation engine inside Postgres with Python and Pandas (2020)
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
51
We need new data books, so we published one
A site around enabling companies and knowledge workers to be informed and enabled with the data they need for their work.
52
Which jobs most often pair together among married couples
Find out which jobs most often pair together among married couples.
53
Postgres audit tables saved us from taking down production
Learn how audit tables helped us avoid a serious incident, and how you can create audit tables in your own Postgres databases.
54
How we built a serverless SQL database
CockroachDB serverless is the first truly scalable serverless SQL database. Learn how it works and how a serverless sql database can relieve the operational burden of developers.
55
EBCDIC is incompatible with GDPR
Welcome to acronym city! The Court of Appeal of Brussels has made an interesting ruling. A customer complained that their bank was spelling the customer's name incorrectly. The bank didn't have support for diacritical marks. Things like á, è, ô, ü, ç etc. Those accents are common in many languages. So it was a little…
56
57
We analyzed 425k favicons
The humble favicon was messily birthed with the pernicious IE5 release. Since that fateful day, browsers have slowly expanded favicon technology to encompass many wildly differing and lightly documented use cases. Here in 2021 favicons are found primarily in browser tabs, home screens, and Google search results, but…
58
Scientific notation bug in MySQL left AWS WAF vulnerable to SQL injection
We provide around-the-clock threat detection and incident response, backed by expert consulting to keep your organization secure.
59
Function pipelines: Building functional programming into PostgreSQL
Function pipelines allow you to analyze data by composing multiple functions in SQL and express complex logic in PostgreSQL in a cleaner way.
60
Deleting an S3 Bucket Costs Money
Deleting an S3 bucket is harder than you think, and may even cost you money.