请输入您要查询的百科知识:

 

词条 Query Abstraction Layer
释义

  1. References

  2. External links

{{Infobox software
| 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 .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, 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. ^[https://sourceforge.net/p/qal/code/ci/19b7acc042fc001bf1398709a5ff7c41907d65f0/log/?path= Commits breaking it out of Optimal BPM ]
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
{{CC-notice|cc=zero|url= http://sourceforge.net/projects/qal/ http://sourceforge.net/projects/qal/}}

External links

  • QAL Documentation and examples
  • API documentation

3 : Python libraries|Free software programmed in Python|Cross-platform free software

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/9/25 18:35:35