Documentation/How Tos/Using SQLite With OpenOffice.org

Introduction

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 (2⁴¹ 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:

1. Via a C/C++ Linux library or Windows DLL.
2. 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.
3. Via the SQLite PHP module or, if you have, PHP version 5 internally to a SQLite database.
4. Via ODBC (Linux and Windows) which allows any application supporting this standard to reach a SQLite database.
5. Using the experimental SDBC SQLite driver

This guide addresses ODBC which OpenOffice.org uses to attach to databases and SQLite, in particular.

Template:Documentation/Imported

Content on this page is licensed under the Public Documentation License (PDL).