词条 | Query Abstraction Layer |
释义 |
| name = Query Abstraction Layer | released = {{Start date|2013|9}}[1] | latest release version = 0.4.0[2] | latest release date = {{release date|2014|10|31}} | genre = Python libraries | license = BSD license | programming language = Python | operating system = Cross-platform | developer = Nicklas Börjesson | website = {{URL|http://www.optimalbpm.se/wiki/index.php/QAL}} }} 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. Sources and destinations include different database backends, file formats like For SQL/RDBMS backends, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL / MariaDB, 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 ( It is related to the Optimal BPM (Business Process Management) project.[9] The Optimal BPM SourceForge project used to be DAL/QAL.[1] References1. ^1 [https://sourceforge.net/p/qal/code/ci/19b7acc042fc001bf1398709a5ff7c41907d65f0/log/?path= Commits breaking it out of Optimal BPM ] {{CC-notice|cc=zero|url= http://sourceforge.net/projects/qal/ http://sourceforge.net/projects/qal/}}2. ^[https://sourceforge.net/p/qal/blog/2014/10/qal-040-is-out/ Release news] 3. ^[https://sourceforge.net/projects/qal/ Sourceforge project page] 4. ^Database backends 5. ^SQL features supported 6. ^SQL data types 7. ^[https://pypi.python.org/pypi/qal PyPi repository page] 8. ^[https://sourceforge.net/projects/qal/files/?source=navbar Downloadable files] 9. ^Optimal BPM site External links
3 : Python libraries|Free software programmed in Python|Cross-platform free software |
随便看 |
|
开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。