Awake SQL is a virtual JDBC Driver and a framework that enables remote JDBC access through HTTP. It allows Android and Java desktop app developers to use regular JDBC calls to access remote SQL databases in the cloud. It implements the main data types including blobs/clobs, and supports transactions. Security has been taken into account from the design stage: server-side configuration lets admins specify strong authentication and security rules in order to protect the databases.
eBag is software project focused on company (factory) administration via PHP+MySQL solutions, on the local network, using browsers as terminals to access the company database. The server solution provides platform independence and collaborative work. PHP offers flexibility and the ability to change (or upgrade) the source code to personal needs, and MySQL innoDB provides transactional safe, recoverable tables. Using language files provides easy and quick translation to any language, and MVC with a CSS customizable user interface.
FuzzyIndex indexes text for performing fuzzy searches using PHP and SQLite. It can process a list of text strings and build a database which indexes snippets of those strings and the locations where they appear. The class can also search for given keywords and returns the locations of the indexed strings where the best-matching text appears. It uses SQLite to store the indexed text database, but the class can be extended to use a different database type. It uses certain heuristics to extract the snippets from the indexed text. These heuristics are implemented as separate classes which can be used interchangeably.
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.
Enrollix manages enrollment of people to associations, communities, groups, classes, teams, magazines, and events like meetings, parties, etc. It collects detailed personal data of members and of their enrollments (with a possible fee), selects them according to any kind of filter, and produces a balance of the revenues which can be saved in a CSV (comma separated value) file. This file can be opened with a spreadsheet like Calc or Excel. It is possible to prepare different models of certificates (like a receipt or a certificate of membership) within the software and print them with the data of any member, with a possible progressive number (like a protocol) within it. It can print labels of addresses or lists of payments of the selected (filtered) members, and it's possible to save their postal addresses or all their personal data in a CSV file, or to copy their email addresses to the clipboard, to paste them into the recipient field of a new message. The personal data of each member may contain a picture, which is saved in a directory with the same name and path of the file in use. It is possible to export selected members from the file in use to another Enrollix file, or to import all the members from it. Each member and his or her enrollments are internally identified by a unique mark (a UID number).
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.
DataStatix manages data of every kind, creates statistics and graphs, and exports data easily to the R environment. Its features include user management (create, delete, modify password) within the software, different levels of user data access (administrator, standard, read-only), user-defined templates (models) of data, the ability to create new databases easily, importation and exportation of data in CSV format, and synchronization of existing data from a CSV file created with DataStatix.
Groonga is a fast and accurate full text search engine based on an inverted index. Newly registered document instantly appears in search results, and updates are allowed without read locks. These characteristics result in superior performance for real-time applications. It is also a column-oriented database management system (DBMS). Compared with well-known row-oriented systems, such as MySQL and PostgreSQL, column-oriented systems are more suited for aggregate queries.