• Tutorials
• 1.8 Manual
• 1.7
• 1.6
• 1.5
• 1.4
• 1.3
• 1.2
• 1.1
• 1.0
• 1.9-dev
• API reference

Developer manual

• ^ Jelix components
• jDb: accessing to SQL database
  • Profiles and configuration
  • Executing queries
  • Schemas and tools

Jelix 1.8.1

Chapter: jDb: accessing to SQL database

« jForms: automatic forms

^ Jelix components

jKVDb: accessing to key/value databases »

Switch to language: FR

Jelix has an abstract database access system: jDb. jDb provides an API common to every databases. For the moment, featured drivers are those for:

• mysql
• postgresql
• sqlite
• oci (oracle)
• sqlsrv

And also the last one, pdo, allowing to specify to jDb to use pdo instead of the abstract classes internal to jDb.

If in the list above, there isn't a driver for your database, and if PDO doesn't provide the driver too, you can create your own driver.

Notice that, although jDb is a common API to all databases, it can't adapt your queries to specificities of the database.

• Profiles and configuration
• Executing queries
• Schemas and tools