Active Record connects business objects and database tables to create a persistable domain model where logic and data is presented in one wrapping. It’s an implementation of the object-relational mapping (ORM) pattern in which an object that wraps a row in a database table or view, encapsulates the database access, and adds domain logic on that data.
GetData is a library that provides an API to interface with dirfile databases. The dirfile database format is designed to provide a fast, scalable format for storing and reading binary, synchronously-sampled, time-ordered data. GetData was originally written for the BOOMERanG and BLAST experiments as a data format suitable for use for both quick-look and data reduction. It is now used by many other cosmological and astrophysical experiments including ACT, Planck, Spider, Keck, as well as other projects.
K.E.T.T.L.E (Kettle ETTL Environment) is a meta- data driven ETL (Extraction, Transformation, Transportation, and Loading) tool. This means that no code has to be written to perform complex data transformations. It is possible to create plugins to do custom transformations or access proprietary data sources. Kettle supports most databases on the market, and has native support for slowly changing dimensions on most database platforms.
LiteSQL is a C++ library that integrates C++ objects tightly to a relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL, and MySQL as backends. LiteSQL creates tables, indexes, and sequences to database and upgrades schema when needed. In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered, and ordered using a template- and class-based API with type checking at compile time.
The NCBI C++ Toolkit provides portable libraries and applications for assisting genetic science. These include libraries for networking, SQL and BerkeleyDB access, CGI and HTML handling, ASN.1 and XML handling, sequence alignment engines, sequence retrieval engines, BLAST database engines, FLTK and OpenGL graphics toolkits, and basic system utilities.
The OpenDBX libraries provide a unified and consistent API for software developers to different database management systems. The C and C++ libraries aim to implement access to the native database interfaces efficiently via a thin abstraction layer. They consist of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, ODBC, Oracle, PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported.
SPTK (Simply Powerful Toolkit) is a cross-platform toolkit that provides a set of C++ classes for fast and easy application development. It provides GUI components that use FLTK, and features database support with seamless connection to GUI components. There are drivers for use of SQLite and PostgreSQL directly, as well as support for other database engines through UnixODBC. SPTK includes many classes for working with strings, dynamic arrays, and maps, and is faster and has a smaller footprint than STL. It also supports reading, writing, and creating Excel 7 files, high-level GUI components with dataset support, support for automatic layouts, and support for Aspell.