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.
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).
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.
RecDB is a recommendation engine built entirely inside PostgreSQL 9.2. It allows application developers to build recommendation applications using a wide variety of built-in recommendation algorithms such as user-user collaborative filtering, item-item collaborative filtering, and singular value decomposition. Applications powered by RecDB can produce online and flexible personalized recommendations to end-users. It is easily used and configured and allows novice developers to define a variety of recommenders that fits their application's needs in few lines of SQL. It can seamlessly integrate recommendation functionality with traditional database operations.
InfiniSQL is a distributed in-memory NewSQL relational database management system (RDBMS). It excels at performing complex transactions which involve records on multiple server nodes. It is engineered around the actor model of concurrent programming, which enables unique scalability capabilities.
Triceps is an innovative embeddable Complex Event Processing (CEP) system. It can be thought of as an in-memory database driven by triggers, or a data-flow machine working on a stream of events, or a spreadsheet on steroids. The major architectural advantages of Triceps include the direct use of procedural logic (as opposed to all-SQL systems), support of both compiled and general scripting languages (C++, Perl), light weight, and easy extensibility.
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds. The actual backup can be performed by using tar, rsync, or rsnap.
pgFormatter is a SQL formatter/beautifier which supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, and SQL-2011, and PostgreSQL-specific keywords. It can work as a console program or as a CGI system. It will automatically detect its environment and output as text or as HTML according to the context.
ALTSE is an alternative search engine technology. It can index up to a couple million Web pages. Altse does not aim to replace existing search engine technologies such as Google, Yahoo, and so on. Instead, it aims to provide an affordable alternative to index Web pages for small size businesses and organizations.
OTRS is a platform independent Web-based help desk system that supports service organization of any kind (e.g. IT service, customer and technical product service, complaint management, public services, etc.) to increase their efficiency. It increases transparency as well as service quality and lowers your total cost of ownership. It has been certified ITIL V3 compatible by PinkVERIFY for incident, problem, change, service asset and configuration, request fulfillment, and knowledge management. Other ITIL processes like service catalog and service level management are supported as well.