BedquiltDB vs pghoard: What are the differences?
What is BedquiltDB? *A Mongo-like JSON doc store built on Postgres *. BedquiltDB is an open-source PostgreSQL extension and set of code libraries, which wraps the PostgreSQL jsonb data type in a slick programmatic API inspired by NoSQL document stores.
What is pghoard? Tools for making PostgreSQL backups to cloud object storages. pghoard is a PostgreSQL backup daemon and restore tooling for cloud object storages.
BedquiltDB and pghoard belong to "Database Tools" category of the tech stack.
Some of the features offered by BedquiltDB are:
- Simple, developer-friendly programmatic API
- Easy to write clients in any programming language, as all the "smarts" are in the PostgreSQL extension
- All the power of a SQL database, including Constraints and Transactions
On the other hand, pghoard provides the following key features:
- Automatic periodic basebackups
- Automatic transaction log (WAL/xlog) backups (using either pgreceivexlog or archivecommand)
- Cloud object storage support (AWS S3, Google Cloud, OpenStack Swift, Azure, Ceph)
BedquiltDB and pghoard are both open source tools. pghoard with 903 GitHub stars and 65 forks on GitHub appears to be more popular than BedquiltDB with 253 GitHub stars and 9 GitHub forks.