Documentation/How Tos/Using SQLite With OpenOffice.org
The aim of this guide is to help OpenOffice.org users to take advantage of the SQLite database engine as a data source.
What is SQLite?
SQLite is a basic database engine that implements most of the features of SQL92. Unlike PostgreSQL and MySQL, SQLite stores a whole data base with all its tables a single file. Other benefits are: database access requires no database server, database files can be freely shared between machines with different byte orders and databases can be up to 2 terabytes (241 bytes) in size. Plus it is fast (twice as much as PostgreSQL and MySQL for most operations) and has a small memory footprint.
Data management can be achieved in the following ways:
- Via a C/C++ Linux library or Windows DLL.
- Via an in-line program (sqlite: available under Linux and Windows) that makes it possible to create and to manage the files of data bases.
- Via the SQLite PHP module or, if you have, PHP version 5 internally to a SQLite database.
- Via ODBC (Linux and Windows) which allows any application supporting this standard to reach a SQLite database.
- Using the experimental SDBC SQLite driver
This guide addresses ODBC which OpenOffice.org uses to attach to databases and SQLite, in particular.
|Content on this page is licensed under the Public Documentation License (PDL).|