Skip to main content

Universal Data Mapper

Project description


Building Status Documentation Status PIP Version

Pandora is a universal database proxy and SQL-Database engine, that implements high-performance and security requirements for large-scale enterprise analytical applications.

The primary goal of Pandora is to separate data integration and data analysis into independent tasks, by providing a unified (universal) data interface for machine learning- and data analysis applications. To achieve this goal, Pandora implements the two fundamental layers of a data warehouse:

The integration layer of Pandora utilizes SQLAlchemy to allow it's connection to a variety of SQL-Databases (e.g. IBM DB2, Oracle, SAP, MS-SQL, MS-Access, Firebird, Sybase, MySQL, Postgresql, SQLite, etc.). Thereupon it provides native support for flat file databases (e.g. CSV-Tables, R-Table exports), laboratory measurements and data generators.

The staging layer of Pandora is implemented as a native SQL-Database engine, featuring a DB-API 2.0 interface with full SQL:2016 support, a vertical data storage manager and real-time encryption. This allows the data analysis application to integrate a variety of different data sources, by using a unified data interface (and SQL dialect).

Pandora is open source, based on the Python programming language and actively developed as part of the Liquid Code framework at Frootlab. Pandora is developed as a generic data interface, which can be integrated into data analysis applications, to facilitate the integration of data.

Current Development Status

Pandora currently is in Pre-Alpha development stage, which immediately follows the Planning stage. This means, that at least some essential requirements of Pandora are not yet implemented. A comprehensive list of all currently supported data back-ends is given in the online manual.


Comprehensive information and installation support is provided within the online manual. If you already have a Python environment configured on your computer, you can install the latest distributed version by using pip:

$ pip install pandb


The latest Pandora documentation is available as an online manual and for download in the formats PDF, EPUB and HTML.


Contributors are very welcome! Feel free to report bugs and feature requests to the issue tracker provided by GitHub. Currently, as the Frootlab Developers team still is growing, we do not provide any Contribution Guide Lines to collaboration partners. However, if you are interested to join the team, we would be glad, to receive an informal application.


Pandora is open source and available free for any use under the GPLv3 license:

© 2019 Frootlab Developers:
  Patrick Michl <>
© 2018-2019 Patrick Michl

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pandb-0.1.11.tar.gz (27.2 kB view hashes)

Uploaded source

Built Distribution

pandb-0.1.11-py3-none-any.whl (47.8 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page