A Database for 2022

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • litestream

    Streaming replication for SQLite.

  • They're using litestream [1] to replicate a SQLite database, which streams additions to the SQLite WAL file to object storage and can replay it back. This is fairly hands-off from SQLite's perspective. There's also the recently released Session Extension [2] that builds some of this functionality directly into sqlite.

    [1]: https://github.com/benbjohnson/litestream

    [2]: https://www.sqlite.org/sessionintro.html

  • cockroach

    CockroachDB - the open source, cloud-native distributed SQL database.

  • > The Licensor may make an Additional Use Grant, above, permitting limited production use.

    See the text of the Additional Use Grant for CockroachDB [1]:

    > Additional Use Grant: You may make use of the Licensed Work, provided that you may not use the Licensed Work for a Database Service.

    > A “Database Service” is a commercial offering that allows third parties (other than your employees an contractors) to access the functionality of the Licensed Work by creating tables whose schemas are controlled by such third parties.

    (disclaimer: I work at Cockroach Labs)

    [1] - https://github.com/cockroachdb/cockroach/blob/master/license...

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • bolt

  • bleve

    A modern text/numeric/geo-spatial/vector indexing library for go

  • etcd

    Distributed reliable key-value store for the most critical data of a distributed system

  • goleveldb

    LevelDB key/value database in Go.

  • sshuttle

    Transparent proxy server that works as a poor man's VPN. Forwards over ssh. Doesn't require admin. Works with Linux and MacOS. Supports DNS tunneling.

  • > Using openssl with a wrapper service?

    One of tailscale's founders already built this: https://github.com/sshuttle/sshuttle

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • (Ignoring the fact this may be an April fools joke.)

    > We’re going to put everything in a single file on disk again.

    For most small scale projects I'm just reading and writing lines to a file on disk. Sure, I could over-engineer some database, or I could get a minimal viable project off of the ground and worry about scaling later. Most projects run into issues long before scalability.

    I found myself recently wanting a lightweight key-value store for random structures. For this purpose, I created a toy single-file key-value store [1] in less than 256 lines of C. It's not quite ready for prime time, but it's incredibly easy to use.

    [1] https://gitlab.com/danbarry16/u-database

  • raft

    Discontinued UNMAINTAINED: A Go implementation of the Raft distributed consensus protocol. (by goraft)

  • rclone

    "rsync for cloud storage" - Google Drive, S3, Dropbox, Backblaze B2, One Drive, Swift, Hubic, Wasabi, Google Cloud Storage, Yandex Files

  • > One activity question for HN: why do you think Dropbox continues to exist today while copycats like Barracuda Copy have failed?

    FWIW, i've been using Dropbox since practically the day they went online, and have been a subscriber for all but the first few months of that time. They've never once failed me, never been offline when i needed them, never lost anything, they created a Linux sync client out of the box (whereas Google first claimed the would make GDrive for Linux but never did), and it's easy to manage via multiple interfaces (mainly their own web UI and https://rclone.org's tool, which can proxy your dropbox behind an add-hoc FTP server running in your LAN).

    They're extremely pricey compared to the same storage in GDrive, but Dropbox has never let me down so i'm in no hurry to drop them.

  • kvbench

    Server for benchmarking pure Go key/value databases

  • Yes, it has it's own trade-offs, but is certainly a top-performer for certain workloads: https://github.com/smallnest/kvbench

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts