Vala Data Access library has reached a 0.90 Beta 1 release.
VDA provides a set of interfaces to wraps database connection, execution of SQL commands and access to returned values of the queries. Read the previous introduction post.
This version supports:
- First Beta version of VDA
- Native implementation for PostgreSQL
- GDA implementation with support for SQLite and PosgreSQL
- Basic
SqlValueimplementation and conversion between values - Basic SQL commands parsing support for
SELECT,INSERT,DELETE,UPDATE, using parameters in order to provide the values required to execute it - Object Oriented API for SQL commands:
SELECT,INSERT,DELETE,UPDATE - Support for Parameters in queries using GDA declaration syntax
- SQL command parsing use GCalc from GNOME Calculator
- Async queries execution
- Support to map Row’s values to
GObjectbased classes’ properties usingDataObjectinterface - Support for row modification/insert using
DataObjectinterface DataObjectsupportsVda.SqlValueproperties, both generic or specificDataObjectsupport conversion betweenVda.SqlValuevalues and between basic properties’ types likestring,int,double,float,bool
No pre-releases was made, because the API was changed while implementing database providers and included most of the interfaces to implement for better more powerful features.
VDA return Vda.SqlValue objects when you access a Table’s row’s column’s value; the provider is responsible to create it when is requested, so no overhead is present for SQL queries execution.