1
Databases in 2021: A Year in Review
Andy Pavlo - Carnegie Mellon University,
New
The latest blog posts to take off on Hacker News. 176 posts.
2
Getting Started with QGIS, PostgreSQL and PostGIS
Visualizing spatial data is an important task. This tutorial helps you with getting started with visualizing OSM data with PostGIS and QGIS.
3
Average color of each country (using satellite imagery)
*Couple of weeks ago we have noticed the article getting attention around twitter. As it is using our WMS EOxMaps endpoint we have asked Erin Davis if we could host her idea here. At EOX we endorse brilliant and unique ideas that utilize our tools and data. Thank you for this most interesting contri ...
4
Postgres is a great pub/sub and job server (2019)
If you need a publish/subscribe or job server at any point in your project, try using Postgres. It'll give you lots of data integrity and performance guarantees, and it doesn't require you or your team learning any new technology.
5
Using an ETL framework vs. writing yet another ETL script
Writing an ETL script is easy; making it production-ready and maintainable is much harder. Why to use an open-source EL(T) framework instead.
6
What's New in ClickHouse 21.12
What’s New in ClickHouse 21.12
7
Find anything fast with Google's vector search technology
Recently, Google Cloud partner Groovenauts, Inc. published a live demo of MatchIt Fast . As the demo shows, you can find images and text similar to a selected sample from a collection of millions in a matter of milliseconds:
8
How to make any immutable data structure distributed
Spark-style distributed datasets can be modeled with a few lines of code, using Unison's distributed computing library. This article teaches you how.
9
Pg_GraphQL: A GraphQL Extension for PostgreSQL
GraphQL support is in development for PostgreSQL + Supabase.
10
Realtime Postgres Row Level Security
Realtime database changes are now broadcast to authenticated users, respecting the same PostgreSQL policies that you use for Row Level Security.
11
Scaling Kafka at Honeycomb
See how Honeycomb reduced Kafka cost by a total of 87% per megabyte/sec of throughput w/ AWS’s new Amazon EC2 lm4gn instance family and Confluent Tiered Storage.
12
SQLite Release 3.37.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
13
Peritext: A CRDT for Rich-Text Collaboration
Collaboration on rich text is hard to model with plain-text approaches. We review the challenges and how to construct a CRDT for rich text.
14
How We Turn Authorization Logic into SQL
How we developed Oso to let you query your database using your authorization policy.
15
Why IndexedDB is slow and what to use instead
Struggling with IndexedDB performance? Discover hidden bottlenecks, advanced tuning techniques, and next-gen storage like the File System Access API.
16
ChaosDB Explained: Azure's Cosmos DB Vulnerability Walkthrough
This is the full story of the Azure ChaosDB Vulnerability that was discovered and disclosed by the Wiz Research Team, where we were able to gain complete unrestricted access to the databases of several thousand Microsoft Azure customers.
17
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.
18
PlanetScale is now generally available
PlanetScale is now GA.
19
20
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.
21
Build an Elixir Redis Server that’s faster than HTTP
Build a redis server in Elixir
22
23
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.
24
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.
25
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.
26
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.
27
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.
28
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.
29
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.
30
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.