31
I'm all-in on server-side SQLite
Ben Johnson has joined Fly.io
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 308 posts.
32
SQLite Is a Library of Congress Recommended Storage Format
SQLite is a Recommended Storage Format for datasets according to the US Library of Congress . Further information:
33
Spanner: TrueTime and external consistency
Understand Spanner's TrueTime and external consistency, ensuring globally consistent reads and writes across the distributed database.
34
Sizing Up Twitter Users
Twitter users are younger, more likely to identify as Democrats, more highly educated and have higher incomes than U.S. adults overall.
35
A database for 2022
we moved from etcd to SQLite for a simpler, more scalable database solution. Learn about Litestream, live replication, and lessons learned.
36
Quirks, Caveats, and Gotchas in SQLite
The SQL language is a "standard". Even so, no two SQL database engines work exactly alike. Every SQL implementation has its own peculiarities and oddities, and SQLite is no exception to this rule.
37
Jepsen: CockroachDB beta-20160829
CockroachDB is a distributed SQL database, loosely patterned after Google Spanner and designed for semi-synchronous networks. It speaks the PostgreSQL wire protocol , supports a reasonable dialect of SQL , and combines replication for durability with transparent scale-out sharding for large tables. Its most…
38
MongoDB 3.4.0-rc3
In the past year and a half, MongoDB has put a good deal of work into improved read safety, enabled by the adoption of their new replication protocol and the WiredTiger storage engine. Dirty reads were addressed in 3.2 by introducing a majority read concern , and stale reads were addressed with the introduction of the…
39
SQLite Begin Concurrent
Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands.
40
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.
41
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
42
A Better Default Colormap for Matplotlib
An overview of the colormaps recommended to replace 'jet' as default.
43
Amazon S3 Update – Strong Read-After-Write Consistency
When we launched S3 back in 2006, I discussed its virtually unlimited capacity (“…easily store any number of blocks…”), the fact that it was designed to provide 99.99% availability, and that it offered durable storage, with data transparently stored in multiple locations. Since that launch, our customers have used S3…
44
The top programming languages
Explore the top programming languages on GitHub—and what languages are growing the fastest.
45
Backblaze Releases the Reed-Solomon Java Library for Free
Today we are releasing our latest open-source project: Backblaze Reed-Solomon Java library for erasure coding. Click for details on how to use and download.
46
Farming Hard Drives: How Backblaze Weathered the Thailand Drive Crisis
The rain started in August and by mid-October 2011, violent floods in Thailand had damaged the factories that helped produce nearly half of the world’s
47
The database servers powering Let's Encrypt
Let’s Encrypt helps to protect a huge portion of the Web by providing TLS certificates to more than 235 million websites. A database is at the heart of how Let’s Encrypt manages certificate issuance. If this database isn’t performing well enough, it can cause API errors and timeouts for our subscribers. Database…
48
SQLite: Wal2 Mode
"Wal2" mode is very similar to "wal" mode. To change a database to wal2 mode, use the command:
49
Limbo: A complete rewrite of SQLite in Rust
we forked SQLite with the libSQL project. What would it be like if we just rewrote it?
50
51
How JPEG XL compares to other image codecs
The JPEG XL is a powerful codec – find out how it compares to other codecs, including JPEG XL vs HEIC and JPEG XL vs JPEG.
52
Scaling Datastores at Slack with Vitess
From the very beginning of Slack, MySQL was used as the storage engine for all our data. Slack operated MySQL servers in an active-active configuration. This is the story of how we changed our data storage architecture from the active-active clusters over to Vitess — a horizontal scaling system for MySQL. Vitess is…
53
Savings are now more liquid and part of “M1 money”
Money is marvelously nuanced. Because different assets can be used as money, we need several categories and definitions to keep track of it. M1 describes the most liquid and widely...
54
Demonstrations and Political Violence in America: New Data for Summer 2020
The report covers 2020 trends in political violence and demonstrations in the US, focusing on the BLM movement.
55
Latest Data on COVID-19 Vaccinations by Race/Ethnicity
KFF is collecting and analyzing data on COVID-19 vaccinations by race/ethnicity to gain increased insight who is receiving the vaccine and whether some groups are facing disparities in vaccination.
56
Amazon’s Consumer Business Turned Off Final Oracle Database
Over my 17 years at Amazon, I have seen that my colleagues on the engineering team are never content to leave good-enough alone. They routinely re-evaluate every internal system to make sure that it is as scalable, efficient, performant, and secure as possible. When they find an avenue for improvement, they will use…
57
Cloudflare R2 storage: Rapid and reliable object storage, minus the egress fees
Introducing Cloudflare’s S3-compatible Object Storage service, with zero egress bandwidth charges and automatic migration from S3-compatible services.
58
We Can Do Better Than SQL
The questions we often hear are "Why create a new query language?" and "What's wrong with SQL?". This blog post contains answers to both.
59
37signals: A/B testing part 3: Finalé
I was an A/B test skeptic. Maybe we don’t want to be second-guessed. Maybe we don’t want to cater to the lowest common denominator. Designers are taught—explicitly and implicitly—to follow certain visual rules and the final design will work great. The whole A/B testing concept probably …
60
Keeping Open Source Open – Open Distro for Elasticsearch
中文版 – At AWS, we focus on solving problems for customers. Over the years, customer usage and dependencies on open source technologies have been steadily increasing; this is why we’ve long been committed to open source, and our pace of contributions to open source projects – both our own and others’ – continues to…