PDO4You is a class that implements the Singleton design pattern for connecting the database using the PDO extension (PHP Data Objects). It provides an abstraction layer for accessing data, regardless of which database you are using, and ensures that there is a single object instance per database connection. It can connect to several possible SQL databases using the available PDO drivers. Currently it supports MySQL, PostgreSQL, SQLite, MariaDB, Oracle, Microsoft SQL server, Sybase, and CUBRID (a database highly optimized for Web applications). The class can also execute multiple queries at once given a string in JSON format that specifies the type of query, the tables, fields, field values, conditions, etc.
Web Based Inventory provides user-friendly management of inventory and sales. It features multi-store and multi-currency support, user friendly POS, inventory and sales charts, realtime inventory updates, translates to any language (localization), platform independence, PDF invoice and barcode generators, and highly-customizable user access. An online demo is available.
Web Based Restaurant POS is a user-friendly Point of Sale system for restaurants. It features touch screen optimizations (of course, it can be used with normal screens, too), magnetic card access (a waiter will slide a magnetic card through the card reader to log in), orders automatically printed in the production departments (kitchen, bar, etc.), advanced reports which can be filtered and sorted, graphical representation of reports, several access levels (administrator, manager, waiter, etc.), an easy-to-use recipe system (products contains several ingredients), and inventory updated in realtime based on product recipes. An online demo is available.
h2H Messenger is a secure messenger client that uses PHP OpenSSL functions, mcrypt, and PHPSecLib to encrypt messages at-rest using RSA keys. The user only creates an account and the application handles the public key generation, key management, key exchange, and encryption and decryption of messages. There are no algorithms or key sizes to choose. It uses strong standards (AES 256, 4096 bit RSA Keys, SHA1, SHA512, etc.) in the background, and requires two-factor authentication using a code sent via SMS or using Asterisk.
The YB.ORM library aims to simplify writing C++ code that has to deal with SQL databases. The goal is to provide a convenient interface like SQLAlchemy (Python) or Hibernate (Java). The library itself is cross-platform and supports a variety of SQL dialects: SQLite3, MySQL, Postgres, Oracle, and Firebird. Integration with Boost, Qt4, and wxWidgets is built-in. In a typical usage scenario, you would describe your database schema and table relationships in a simple XML-based format, generate SQL code to populate database schema with tables, generate C++ classes, add application-specific logic to the classes, and use these classes in cooperation with the Session object to query objects from the database, create new or modify/delete existing objects, or link and unlink objects using relations. Simple serialization to XML is supported along with connection pooling.
Tickets MDB is a Web-based personnel/membership database mainly aimed at voluntary organisations but applicable to any operation which needs to register member details and store member training records, abilities, equipment, vehicles, and clothing. It is based on TicketsCAD and allows integration to that platform for sharing of information with Tickets CAD as an operational dispatch system (However, Tickets MDB does not require Tickets CAD to function and is a standalone application in its own right.) Tickets MDB supports mapping of personnel locations using Open Streetmap and Open Layers and allows local storage of map images/tiles so it can work in a non-network environment (with the exception of email to members, which will require a network connection).