pghoard VS Deadpendency

• Multi-cloud object storage support
  pghoard supports backing up to multiple cloud storage providers including AWS S3, Google Cloud Storage, Azure Blob Storage, Swift, and local filesystem, giving flexibility in choosing or switching backup destinations.
• Streaming WAL archiving and compression
  It supports continuous WAL streaming and archiving with built-in compression (using algorithms like Snappy, LZMA, or zstd) and encryption, reducing storage costs and improving backup transfer efficiency.
• Point-in-time recovery (PITR)
  pghoard enables point-in-time recovery by combining base backups with WAL segments, allowing restoration of a PostgreSQL database to any specific moment, which is critical for disaster recovery scenarios.
• Open source and actively maintained by Aiven
  Being maintained by Aiven, a company specializing in managed database services, pghoard benefits from real-world production use, ongoing updates, and community contributions, ensuring reliability and continued support.
• REST API and monitoring integration
  It provides a REST API for managing and monitoring backup operations, and can integrate with monitoring systems, making it easier to automate backup workflows and track backup health in production environments.

Possible disadvantages

• PostgreSQL-specific tool
  pghoard is designed exclusively for PostgreSQL, so organizations using multiple database systems would need separate backup solutions for other databases, increasing operational complexity.
• Complex initial setup and configuration
  Setting up pghoard requires careful configuration of cloud storage credentials, encryption keys, and WAL-G-like settings, which can be complex for users unfamiliar with PostgreSQL internals or cloud storage APIs.
• Limited GUI or dashboard
  pghoard primarily operates via command-line and configuration files with a basic REST API, lacking a polished web-based dashboard for easier visualization and management compared to some commercial backup solutions.
• Documentation gaps for edge cases
  While basic documentation exists, users have reported that some advanced use cases, troubleshooting steps, and edge-case scenarios are not thoroughly documented, requiring deeper investigation into the source code.
• Smaller community compared to alternatives
  Compared to more widely adopted tools like pgBackRest or Barman, pghoard has a smaller user community and fewer third-party resources, tutorials, or plugins, which may limit support options for troubleshooting.

• Automated Dependency Monitoring
  Deadpendency automatically checks your project's dependencies for signs of being dead, unmaintained, or deprecated, saving developers from manually tracking the health of each dependency.
• GitHub Integration
  Deadpendency integrates directly with GitHub as a GitHub App, making it easy to set up and run as part of your existing pull request and CI workflow without requiring additional infrastructure.
• Early Warning System
  By catching dead or unmaintained dependencies early, Deadpendency helps teams avoid security risks and technical debt that come from relying on abandoned libraries.
• Multi-Language Support
  Deadpendency supports a wide range of programming languages and package ecosystems, making it useful for polyglot projects and diverse development teams.
• Low Configuration Overhead
  The tool is designed to work out of the box with minimal configuration, allowing teams to get value quickly without spending significant time on setup and customization.

Possible disadvantages

• Limited to GitHub
  Deadpendency is primarily a GitHub App, which means teams using other platforms like GitLab or Bitbucket cannot easily use the service without switching or mirroring their repositories.
• Potential False Positives
  The tool may flag dependencies as dead or unmaintained based on activity metrics, even when a library is stable and simply mature, leading to unnecessary concern or migration efforts.
• Niche Use Case
  Dependency health checking is a relatively narrow function. Teams may prefer more comprehensive dependency management tools that also handle vulnerability scanning, license compliance, and version updates in one solution.
• Reliance on External Signals
  Deadpendency relies on external signals like repository activity and release frequency to determine dependency health, which may not always accurately reflect the true maintenance status of a project.
• Limited Community and Ecosystem
  As a relatively niche tool, Deadpendency has a smaller user community compared to alternatives like Dependabot or Renovate, which can mean fewer resources, community support, and third-party integrations.

• Pgbackrest is no longer being maintained

  The "closest" would be using Barman with hook scripts (https://docs.pgbarman.org/release/3.18.0/user_guide/hook_scripts.html#hook-scripts-using-barman-cloud-scripts-as-hooks-in-barman) if you rely on cloud storage for storing backups.... - Source: Hacker News / 6 months ago

• Future PostgreSQL: improvement to the replication protocol

  This story starts with our own PgHoard, a PITR backup tool for PostgreSQL. PgHoard offers several methods to archive the WAL (Write Ahead Log), including pg_receivewal, a small application shipping with PostgreSQL which connects to a... - Source: dev.to / almost 5 years ago

• Deadpendency Open Sourced

  I created a tiny startup in Haskell which failed RIP. I decided to open source the code though. Source: over 3 years ago

• Twitch Streamers?

  I sometimes stream my Haskell work on deadpendency - https://www.twitch.tv/alistairbuzz. Source: over 5 years ago