Part I. Getting started

Table of Contents

Introduction

Architecture

Foreword about abstraction

Variables syntax in SQL
NULL handling when using variables
SQL identifiers
Binary large objects (BLOBs)

Installation

Getting the library

Installing from the sources

Compiling your code using the Libgda library

Configuring

Configuration for development
Configuration for accessing a database
Provider's specific information

Code examples

Initializing

Executing queries

Managing data models

Example using random access
Example using an iterator
Freeing data models

Managing transactions

Managing connection's events and errors

Full example

DDL example

Binary large objects (BLOBs) example

Other examples

Migration from 1.X versions

GdaValue and GdaDataModel changes
GdaClient, GdaConnection and GdaError
Various API changes

Migration from 3.X versions

New unique parser

GdaQuery and GdaCommand merge into GdaStatement

Dictionary changes

Statement execution

Other changes

Multi threading environment
Configuration management
Database provider's changes
API changes
List of removed objects and interfaces
List of removed functions

Migration from 4.X versions

Overview
GDA_TYPE_NULL

Provider's notes

The gda_file_exists() function
The gda_hex_print() function
The gda_hex() function
The gda_rmdiacr() function
The gda_upper() and gda_lower() functions
The regexp_match() function

For SQLCipher

How to create and encrypted database
How to encrypt an existing plaintext database to an encrypted database file
How to change the passphrase of an encrypted database
How to decrypt an existing database to a plaintext database

Authentication
Mapping to GdaDataModel

How it works
JDBC drivers' location
Connection parameters

Limitations

Global limitations

Multi threaded environment
Statements execution
Timezone information

For PostgreSQL

BLOB handling
Last inserted row's values
Multi threaded environment
Statements execution
Timezone information

Last inserted row's values
Date and time
Timezone information
Multi threaded environment
Error reporting

For SQLCipher

User name
SSL/TLS certificate validation

For JDBC based providers

Last inserted row's values
Multi threaded environment