- Mar 1, 2011, 5:54:41 PM (10 years ago)
v8 v9 8 8 9 9 SQL Database Access module provides simple generic API to access to SQL databases. Currently supported databases: 10 - [wiki:SQL/SQLite3 SQLite3] 10 - [http://www.oracle.com/us/products/database/index.html Oracle] is a well known commercial database management system ([wiki:SQL/Oracle driver notes]); 11 - [http://www.postgresql.org/ PostgreSQL] is a powerful, open source object-relational database system ([wiki:SQL/PostgreSQL driver notes]); 12 - [http://www.sqlite.org/ SQLite3] is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine ([wiki:SQL/SQLite3 driver notes]). 11 13 12 14 API contains two packages. The [browser:trunk/matreshka/source/sql/sql-databases.ads SQL.Databases] package provides SQL_Database type to connect to database server and manage transactions, and the [browser:trunk/matreshka/source/sql/sql-queries.ads SQL.Queries] package provides SQL_Query type to prepare, bind, execute queries and retrieve results.