QAL Icon

QAL

Query Abstraction Layer

Add a Review
1 Download (This Week)
Last Update:
  Browse Code Git Repository

Description

QAL is a collection of libraries for mixing, moving and updating data from and to SQL databases and files.

Sources and destinations include different database backends, files format like .csv, XML and excel. And even untidy HTML web pages.

For SQL backends, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server.
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 and data types, which while not complete however should be sufficient for most usages. It is however easy to instead use backend specific SQL when the queries don't have to be backend-agnostic.

It is currently only distributed as a Python Library (.egg), but more formats are coming.

It is related to the Optimal BPM and UBE projects. Historically, the Optimal BPM project used to be DAL/QAL.

QAL Web Site

Categories

Features

  • Data transformation
  • Query Abstraction layer
  • Oracle
  • DB/2
  • PostgresSQL
  • MySQL
  • SQL server
  • flat file
  • XML
  • Python
  • Merge
  • Multi platform

Update Notifications





Write a Review

User Reviews

Be the first to post a review of QAL!

Additional Project Details

Registered

2013-08-11
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.