1
New
The latest blog posts to take off on Hacker News. 314 posts.
2
Anonymized data is rarely anonymous
Justin Sherman for Wired points out the farce that is anonymized data: Data on hundreds of millions of Americans’ races, genders, ethnicities, religions, sexual orientations, political beliefs, int…
3
Databases in 2021: A Year in Review
Andy Pavlo - Carnegie Mellon University,
4
Consider SQLite
If you were creating a web app from scratch today, what database would you use? Probably the most frequent answer I see to this is Postgres, although there are a wide range of common answers: MySQL, MariaDB, Microsoft SQL Server, MongoDB, etc. Today I want you to consider: what if SQLite would do just fine?
5
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.
6
Advent of Code Surveys: Results
Results dashboard with the yearly (unofficial) Advent of Code participant survey
7
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 ...
8
Everything I've seen on optimizing Postgres on ZFS
Looking to run Postgres on ZFS? I've gathered some of the information and sage advice out there to give you a head start on figuring out how to do it safely and efficiently.
9
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.
10
Why start a new database conference?
Somehow I am organizing a conference called Have you tried rubbing a database on it?
11
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.
12
What's New in ClickHouse 21.12
What’s New in ClickHouse 21.12
13
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:
14
15
Postgres, Kafka, and a mysterious 100 GB
Lately I’ve been trying to learn more about Amazon Web Services (AWS) and some other popular technologies. Since I work at a large tech company, I spend a lot of my professional time using pr…
16
17
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.
18
Pg_GraphQL: A GraphQL Extension for PostgreSQL
GraphQL support is in development for PostgreSQL + Supabase.
19
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.
20
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.
21
Is watching the 1984 Ghostbusters movie killing people?
Is watching the 1984 Ghostbusters movie killing people? English adults under 60 who have watched the 1984 Ghostbusters movie are dying at twice the rate of people who have watched the 2021 Ghostbusters move the same age.And have been for six months. The chart may seem unbelievable or impossible but it is correct…
22
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 .
23
24
Things I learned from building a production database
In 2017, I went to Facebook on a sabbatical from my faculty position at Yale. I created a team to build a storage system called Delos at the bottom of the Facebook stack (think of it as Facebook’s version of Chubby). We hit production with a 3-person team in less than a year; and subsequently scaled the team to 30+…
25
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.
26
How We Turn Authorization Logic into SQL
How we developed Oso to let you query your database using your authorization policy.
27
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.
28
Back to basics: Writing an application using Go and PostgreSQL
Learn how to use PostgreSQL with the Go programming language using the pgx driver and toolkit in a very productive manner. Furthermore, with the provided source code, you'll be able to learn how to write efficient and sound unit and integration tests, ready to be run locally or on a Continuous Integration environment…
29
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.
30
One of these JPEGs is not like the other
“JPEG” or the image encoding specification by the “Joint Photographic Experts Group” (JPEG) is a truly universal format at this stage. You really cannot go very far on the internet without seeing a JPEG file. The amount of content encoded in JPEGs must be surely biblical by now. If there is one thing that is going to…