Working with Database Providers

Although LightSpeed tries to abstract you away from the underlying database engine, different databases do have different capabilities and characteristics and it’s important to be aware of these when using LightSpeed, whether to avoid using unsupported features or to ensure that you adhere to database-specific conventions.  Furthermore, in some cases LightSpeed provides special features for certain databases.

This chapter lists specific considerations for each database supported by LightSpeed.

DB2

MySQL

Oracle

PostgreSQL

SimpleDB

SQLite

SQL Server

SQL Server Compact

VistaDB 4

Low Level Database Access

Windows Azure Table Service