DB_Sqlite_Tools

[ AdvancedSearch | AreaMap ]

Welcome to DB_SqLite_Tools

Docs

DBC Encryption and Decryption

Install DB_Sqlite_Tools

Areas In
This Wiki

Main

Welcome to DB_SqLite_Tools

This is ALPHA software...

"...if it destroys your computer, rapes your pet, installs Win98 on your toaster and microwave, stops your pacemaker, causes sexual dysfunction, and turns your children into fucked-up trenchcoat-wearing teens carrying guns and worshipping Hitler, don't blame me because I told you it could do that and you went ahead and used it anyway."
--James Turinsky

Sqlite_Tools
Credits:
Lead: David Costa (aka gurugeek)
Developer: Ashley Hewson (XML export, parser,etc.)
Developer: Radu Negoescu (dbc autoexec help)

Introduction

Sqlite is a lightweight embedded database library. It is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine and is included by default with PHP 5.

DB_Sqlite_Tools is an object oriented interface to effectively manage and backup Sqlite databases. It also offeres the possibility to insert and retrieve encrypted data from/to an Sqlite database.

Why DB SQLite Tools

The stregth of Sqlite and its superb portability might also be seen as a weakness. Because each database is self contained in a file we do have a single point of entry and a single point of failure.

Client-Server relational databases implements a number of build-in features to make the db corruption a remote occurance.

Whilst Sqlite does offer some similar functionality (e.g. synchronous value), there are no PHP functions in this directions and there is little knowledge on how to successfully maintain and backup multiple database insuring the integrity of the initial and cloned database.

DB_SQlite_Tools provides you with a set of tools to produce secure backups of your database (both locally and remotely), XML export functionality,live replication, and database encryption (insert, fetch functionality).

DB_Sqlite_Tools Features

Sqlite_Tools functionality can be summarized in three different branches:

Database Manipulation and Maintenance

checkIntegrity : checks the integrity of one or more databases

cacheSize : checks or reset the default cache size in one ore more databases As a default value an sqlite database will hold 2000 disk pages in the memory each page requires approximately 1.5 K of memory For intensive UPDATE or DELETE queries an higher memory might result in a speed increase.

sync: checks or rest the synchronous value in one more more databases.At NORMAL (default mode) the sqlite engine will stop at most critical moment providing with a limited integrity protection of the database. In FULL mode the engine will stop more often thus ensuring and higher integrity level.
When OFF the engine will continue as soon as the new data is provided without stopping. Values are represented by an integer, 1 for NORMAL, 2 for FULL and 0 for off

dbFileInfo?: Fetch all the available information in one more more databases like size, permissions, last change etc

copySafe: performs a safe copy for a database, checks integrity on the cloned database

and others, each of the function is well commented so you should be able to understand its purpose.

Database backup or remote live replication

ftpBackup : backups one or more databases via ftp

localRsync: Rsync a database path locally, requires Rsync lib

remoteRsync: launch a local Rsync deamon for the purpose of remote

synchronization (experimental function)

createXMLDumps: creates an XML dump of one or more databases see the example
Sqlite_Tools Output and Usage

Database encyption functionality
DBcTutorial Insert and retrieve encrypted data on the fly from/to your sqlite database

Because DB_Sqlite_Tools is a just library its output for mostly of the function is basically raw and can be used in connection with the logs function which keeps each of the operations (e.g. database opened, database integrity check, database backup on ftp performed) output in a local sqlite logs database and further elaborated in any format you want. Ideally you should use DB_Sqlite_Tools with a cron job to regularly backup your databases or perform a live replication in a remote server.