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.
SYMPLiK XTRACT4J is a stand-alone, pure Java program that can create XML files from one or more dependent or independent SQL queries. A post-processing hook can be applied to this XML file, e.g. using Oracle BI Publisher RTF template to create professional PDF report with embedded barcodes. It was originally designed as a drop-in replacement for Oracle Report, with highly configurable and easy-to-use features.
SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.
ERDesignerNG is a Java-based entity relationship design and database modeling tool. It has a powerful WYSIWYG interface for physical database design, supports 2D and 3D database modeling, browsing, and design, handles tables, relations, indexes, and comments, supports a central repository for all models (Model Repository), supports subject areas, supports domains, supports MySQL, Oracle, Microsoft SQLServer, PostgreSQL, and H2, creates the SQL DDL statements for schema creation, has an integrated schema version control system, can generate schema migration scripts for every change, stores the database definition as XML files for further processing, can export the database schema as GIF, BMP, JPEG, or SVG files, has an integrated reverse engineering module for existing schemas, has a build in schema compare feature, can generate schema documentation as PDF, HTML, RTF, and other formats, and supports schema conversion between different dialects.
LightProfiler provides performance analysis of Oracle databases. It generates detailed resource profiles for extended SQL trace files, containing information about the consuming of response time (by events, by cursors, etc.), data file usage, error analysis (SQL, PL/SQL), and much more. It also contains tools for additional processing of trace files (extracting session data, splitting files) and for management of a database's sessions (disconnecting, tracing, monitoring parameters, blocking locks, events, etc.).
websqlclient (WSQLC or wiskl) is a lightweight HTTP server which allows an end user to access JDBC data sources via automatically-generated data entry screens. It is designed to be used with standard Web browsers and wireless tablet PCs, and is highly configurable. It can connect to any JDBC data source. Its main purpose is to provide rapid data-model-driven development. The websqlclient data entry forms are generated by querying the database system table information, but can be configured manually. websqlclient includes a database-agnostic data loading utility (SQLLoader), a data unloading tool (SQLExport), and SQL scripting capabilities.
Maarch Entreprise is a professional Document Management System that natively answers a vast majority of the needs for operational document management. It has been designed by two experienced consultants in electronic archiving and automatic documents production. It offers guarantees of stability and scalability. Particular care has been taken to assure the best performance on standard hardware. As it is based on Maarch Framework, Enterprise is completely modular: functional features are grouped in modules that expose services, which can be enabled or disabled to best suit end-user needs. A skilled engineer can easily add or replace a module without changing the core of the system.