Query Abstraction Layer: Difference between revisions

Revision as of 09:08, 5 November 2014

Revision as of 09:24, 5 November 2014

Line 1:

{{Infobox software

| name = Query Abstraction Layer

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

| latest release version = 0.4.0<ref> [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 application framework]]

Line 16:

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 [[:Category:Relational_database_management_systems |SQL/RDBMS backends]], it has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server<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 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]</ref> and data types<ref>[http://optimalbpm.se/api/qal/_modules/qal/sql/types.html#data_types SQL data types]</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 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)<ref>[https://pypi.python.org/pypi/qal PyPi repository page]</ref> and a debianDebian package file(.deb)<ref>[https://sourceforge.net/projects/qal/files/?source=navbar Downloadable files]</ref>.

It is related to the Optimal BPM(Business Process Management) project.

In fact, the Optimal BPM sourceforge project used to be DAL/QAL.<ref name="Break out"/>

==References==