Top 9 Perl Postgresql Projects

• pgbadger

  6 3,391 7.9 Perl

  A fast PostgreSQL Log Analyzer

Project mention: Site down due hosted on digitalocean | /r/django | 2023-06-30

It might also help to use pgbadger or something similar to process your postgres logs and see whether some event is aligned with your outages.

• sqitch

  7 2,717 7.2 Perl

  Sensible database change management

  

Project mention: The API database architecture – Stop writing HTTP-GET endpoints | news.ycombinator.com | 2024-05-10

Yeah, I fully agree. The tooling for putting that much logic into the database is just not great. I've been decently happy with Sqitch[0] for DB change management, but even with that you don't really get a good basis for testing some of the logic you could otherwise test in isolation in app code.

I've also tried to rely heavily on the database handling security and authorization, but as soon as you start to do somewhat non-trivial attribute-/relationship-based authorization (as you would find in many products nowadays), it really isn't fun anymore, and you spend a lot of the time you saved on manually building backend routes on trying to fit you authz model into those basic primitives (and avoiding performance bottlenecks). Especially compares to other modern authz solutions like OPA[1] or oso[2] it really doesn't stack up.

[0]: https://github.com/sqitchers/sqitch

[1]: https://www.openpolicyagent.org

[2]: https://www.osohq.com

• InfluxDB

  www.influxdata.com featured

  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.

  

• postgresqltuner

  3 2,556 0.0 Perl

  Simple script to analyse your PostgreSQL database configuration, and give tuning advice

• pg_stat_monitor

  1 429 7.7 Perl

  Query Performance Monitoring Tool for PostgreSQL

  

• LedgerSMB

  9 392 9.8 Perl

  Double-entry accounting & ERP for the web

  

• pg_sample

  1 278 5.4 Perl

  PostgreSQL utility for creating a small, sample database from a larger one

Project mention: Ask HN: What Underrated Open Source Project Deserves More Recognition? | news.ycombinator.com | 2024-03-07

"PostgreSQL utility for creating a small, sample database from a larger one"

https://github.com/mla/pg_sample

• minion

  2 222 6.1 Perl

  :octopus: Perl high performance job queue

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• pgaudit_analyze

  0 36 2.5 Perl

  PostgreSQL Audit Analyzer

  

• MirrorCache

  4 35 8.0 Perl

  Download Redirector

  

Perl Postgresql related posts

• Site down due hosted on digitalocean

  1 project | /r/django | 30 Jun 2023

• SQL: 2023 Has Been Released

  1 project | news.ycombinator.com | 1 Jun 2023

• Free quick books alt.

  1 project | /r/tax | 14 Apr 2023

• Accounting/bookkeeping software?

  1 project | /r/doulas | 9 Apr 2023

• Trust Fund Accounting Software.

  1 project | /r/Accounting | 9 Apr 2023

• Creating a bookkeepng software

  1 project | /r/Bookkeeping | 25 Mar 2023

• Postgresqltuner: Analyse Your PostgreSQL Database

  1 project | news.ycombinator.com | 11 Feb 2023
• A note from our sponsor - InfluxDB
  www.influxdata.com | 20 May 2024

  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. Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending Perl projects with our weekly report!