Query Abstraction Layer: Difference between revisions

Revision as of 09:02, 5 November 2014

Latest revision as of 02:58, 11 August 2025

(25 intermediate revisions by 10 users not shown)

Line 1:

{{Infobox software

| name = Query Abstraction Layer

| released = {{Start date|2013|9}}<ref name="">First brokenBreak out of Optimal BPM ">[https://sourceforge.net/p/qal/code/ci/19b7acc042fc001bf1398709a5ff7c41907d65f0/log/?path= Commits breaking it out of Optimal BPM ]</ref>

| latest release version = 0.4.0<ref>Release news [https://sourceforge.net/p/qal/blog/2014/10/qal-040-is-out/ Release news]</ref>

| latest release date = {{release date|2014|10|31}}

| genre = [[Web:Category:Python application(programming frameworklanguage) libraries|Python libraries]]

| license = [[BSD license]]

| programming language = [[Python (programming language)|Python]]

Line 11:

| 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;<ref name="sf_project">[https://sourceforge.net/projects/qal/ Sourceforge project page]</ref> also in some cases, such as [[MongoDB]], [[database schema|schema]]s.

And in some cases, like for MongoDB, schemas.

== Description ==

Sources and destinations include different database backends, file formats like [[comma-separated values|<code>.csv</code>]], [[XML]] and spreadsheets. Even [[tag soup|untidy HTML]] web pages can be used as both a source and destination.

For [[:Category:Relational_database_management_systemsRelational database management systems|SQL/RDBMS backends]], it has a database abstraction layer that supports basic connectivity to [[Postgres]], [[MySQL]] / [[MariaDB]], DB2[[IBM Db2]], [[Oracle database|Oracle]] and [[MS SQL serverServer]].<ref name="db types">[http://optimalbpm.se/api/qal/_modules/qal/dal/types.html#db_types Database backends]</ref> It uses XML formats (the SQL schema is self-generated) for representation of queries, transformation and merging, making it all processable by scripts.

It uses XML formats(the SQL schema is self-generated) for representation of queries, transformation and merging, making it all scriptable.

With regards to [[SQL]], QAL uses a subset of SQL features<ref>[[http://optimalbpm.se/api/qal/qal.sql.html#qal.sql.sql SQL]] features supported]{{Dead link|date=July 2025 |bot=InternetArchiveBot |fix-attempted=yes }}</ref> and data types,<ref>[http://optimalbpm.se/api/qal/_modules/qal/sql/types.html#data_types SQL data types]{{Dead link|date=July 2025 |bot=InternetArchiveBot |fix-attempted=yes }}</ref> which while obviously not complete however should beis 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 (<code>.egg</code>)<ref>[https://pypi.python.org/pypi/qal PyPi repository page]</ref> and a debian[[Debian package]] file ([[deb (file format)|<code>.deb</code>]]).<ref>[https://sourceforge.net/projects/qal/files/?source=navbar Downloadable files]</ref>

It is related to the [[Optimal BPM]] ([[Business Process Management]]) project.<ref>[http://www.optimalbpm.se Optimal BPM site]</ref> The Optimal BPM [[SourceForge]] project used to be DAL/QAL.<ref name="Break out"/>

In fact, the Optimal BPM sourceforge project used to be DAL/QAL.

==References==

{{Reflist|30em}}

{{CC-notice|cc=zero|url= https://sourceforge.net/projects/qal/ https://sourceforge.net/projects/qal/}}

==External links==

* [http://www.optimalbpm.se/wiki/index.php/ QALDocumentationQAL Documentation and examples]{{Dead link|date=July 2025 |bot=InternetArchiveBot |fix-attempted=yes }}

* [http://optimalbpm.se/api/qal/index.html API documentation] {{Webarchive|url=https://web.archive.org/web/20170909131730/http://optimalbpm.se/api/qal/index.html |date=2017-09-09 }}

[[Category:Python (programming language) libraries]]

[[Category:Python web application frameworks]]

[[Category:Free software programmed in Python]]

[[Category:Python software]]

[[Category:Cross-platform free software]]