PGObject::Simple::Role provides an interface to the PGObject service locator for Moo and Moose Perl classes. This service locator is intended to integrate Perl objects with PostgreSQL user-defined functions, and this uses the "simple" mapping approach. Between PGObject::Simple::Rrole and PGObject::Util::DBMethod, it is possible to write fully-declarative classes in which all calculation logic is handed off to database functions.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
mysqlblasy is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. It was written with automated usage in mind. For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
Barman (backup and recovery manager) for PostgreSQL is an administration tool for disaster recovery of PostgreSQL servers. It allows remote backups of multiple servers in business-critical environments and helps DBAs during the recovery phase. Barman's most-wanted features include backup catalogs, retention policies, remote recovery, archiving, and compression of WAL files and backups.
Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. It connects your Oracle database, extracts its structure, and generates an SQL script that you can load into your PostgreSQL database. It dumps the database schema (tables, views, sequences, indexes, grants) with primary, unique, and foreign keys into PostgreSQL syntax without editing the SQL code generated. It also dump Oracle data into PostgreSQL DB as online process or into a file. You can choose what columns can be exported for each table.
Libzdb is a database library with thread-safe connection pooling. The library can connect transparently to multiple database systems. It has zero runtime configuration and connections are specified via a URL scheme. A modern object-oriented API is provided. Libzdb supports MySQL, PostgreSQL, SQLite, and Oracle.
libosl, the object storage layer, is a library for storing small to medium-sized data in relational tables. It is easy to use, lightweight, fast, and portable. libosl is suitable for applications that need only a small fraction of the features a full database management system provides.