Difference between revisions of "Documentation/How Tos/Using SQLite With OpenOffice.org"
(Imported from website, original author: yves.chaufour@wanadoo.fr, contributors Gerry Singleton) |
|||
Line 1: | Line 1: | ||
{{Documentation/BeingEdited}} | {{Documentation/BeingEdited}} | ||
− | {{Documentation/Imported|author=Yves Chaufour|contributors= | + | |
+ | =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?== | ||
+ | |||
+ | [http://www.sqlite.org/ 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<sup>41</sup> 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 [http://dba.openoffice.org/drivers/sqlite/index.htm experimental SDBC SQLite driver] | ||
+ | |||
+ | This guide addresses ODBC which OpenOffice.org uses to attach to databases and SQLite, in particular. | ||
+ | |||
+ | |||
+ | {{Documentation/Imported|author=[mailto:yves.chaufour@wanadoo.fr Yves Chaufour]|contributors=Gerry Singleton}} | ||
+ | {{PDL1}} |
Revision as of 15:46, 16 August 2007
Template:Documentation/BeingEdited
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 (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.
Template:Documentation/Imported
Content on this page is licensed under the Public Documentation License (PDL). |