Perl Database

Open-source Perl projects categorized as Database
Edit details
Topics: MySQL Postgresql Perl Sqlite MariaDB
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.
www.influxdata.com
featured

Top 6 Perl Database Projects

  • sqitch

    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

  • pg_sample

    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

  • 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

  • ensembl-compara

    The Ensembl Compara Perl API and SQL schema

  • pgaudit_analyze

    PostgreSQL Audit Analyzer

  • zabbix-mysql-partitioning-perl

    This script is a script written in Perl to partition the Zabbix database tables in time based chunks. We can use this script to replace the Zabbix housekeeper process which tends to get too slow once you hit a certain database size.

  • sms-db

    sms-db is a tool to build an SQLite database out of collections of SMS and MMS messages in various formats. The database can then be queried using standard SQLite queries, and the messages in the database can be exported in various formats.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Perl Database related posts

  • Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, and tabular JSON

    11 projects | news.ycombinator.com | 16 Mar 2023

  • Zabbix 6.0 and Postgres history_uint table size

    1 project | /r/zabbix | 24 Jan 2023

  • Zabbix meetup online: november 29 2022 by BGmot and Opensource ICT Solutions

    1 project | /r/zabbix | 6 Nov 2022

Index

What are some of the best open-source Database projects in Perl? This list will help you:

Project Stars
1 sqitch 2,721
2 pg_sample 279
3 ensembl-compara 48
4 pgaudit_analyze 37
5 zabbix-mysql-partitioning-perl 31
6 sms-db 30

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com