pghoard vs SQLdep: What are the differences?
pghoard: Tools for making PostgreSQL backups to cloud object storages. pghoard is a PostgreSQL backup daemon and restore tooling for cloud object storages; SQLdep: Transform your SQL code into data flow maps. SQLdep is a cloud service generating data-lineage from SQL code or stored procedures. By transforming SQL code into visual maps developers are relieved from routine and time consuming tasks.
pghoard and SQLdep can be primarily classified as "Database" tools.
Some of the features offered by pghoard are:
- 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)
On the other hand, SQLdep provides the following key features:
- generating data-lineage
- metadata management
- reverse engineering of SQL code
pghoard is an open source tool with 903 GitHub stars and 65 GitHub forks. Here's a link to pghoard's open source repository on GitHub.