Query Abstraction Layer
| Developer(s) | Nicklas Börjesson |
|---|---|
| Initial release | September 2013[1] |
| Stable release | 0.4.0[2]
/ October 31, 2014 |
| Written in | Python |
| Engine | |
| Operating system | Cross-platform |
| Type | Python libraries |
| License | BSD license |
| Website | www |
Search Query Abstraction Layer on Amazon.
QAL is an open-source development project that aims to create a collection of libraries for mixing, moving, merging, substituting and transforming data;[3] also in some cases, such as MongoDB, schemas.
Description
Sources and destinations include different database backends, file formats like .csv, XML and spreadsheets. Even untidy HTML web pages can be used as both a source and destination.
For SQL/RDBMS backends, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL / MariaDB, IBM Db2, Oracle and MS SQL Server.[4] It uses XML formats (the SQL schema is self-generated) for representation of queries, transformation and merging, making it all processable by scripts.
With regards to SQL, QAL uses a subset of SQL features[5] and data types,[6] which while obviously not complete however is sufficient for most usages. It is however easy to instead use backend-specific SQL when the queries do not have to be backend-agnostic.
It is currently distributed as a Python Library (.egg)[7] and a Debian package file (.deb).[8]
It is related to the Optimal BPM (Business Process Management) project.[9] The Optimal BPM SourceForge project used to be DAL/QAL.[1]
References
- ↑ 1.0 1.1 Commits breaking it out of Optimal BPM
- ↑ Release news
- ↑ Sourceforge project page
- ↑ "Database backends". Archived from the original on 2014-11-05. Retrieved 2014-11-05. Unknown parameter
|url-status=ignored (help) - ↑ "SQL features supported". Archived from the original on 2014-11-05. Retrieved 2014-11-05. Unknown parameter
|url-status=ignored (help) - ↑ "SQL data types". Archived from the original on 2014-11-05. Retrieved 2014-11-05. Unknown parameter
|url-status=ignored (help) - ↑ PyPi repository page
- ↑ Downloadable files
- ↑ "Optimal BPM site". Archived from the original on 2014-11-05. Retrieved 2014-11-04. Unknown parameter
|url-status=ignored (help)
File:CC0-icon-80x15.png This article incorporates https://sourceforge.net/projects/qal/ text available under the CC0 license.
External links
- QAL Documentation and examples[permanent dead link]
- API documentation Archived 2017-09-09 at the Wayback Machine
This article "Query Abstraction Layer" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Query Abstraction Layer. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
