About

From EuSqlite
Jump to: navigation, search

EUSQLite is a wrapper for the SQLite libraries, from the original libraries by Ray Smith.

Ray is no longer programming with euphoria, but has left his euphoria programs on his web site.

If you don't know what Euphoria is, then check out the links to your left.

SQLite is multi-platform (or at least bi-platform) running on both Windows and Linux. The libraries are very small, and produce very compact and fast databases (see the SQLite homepage for more information), and can be used to power web based databases, and any other applications where databases are required. SQLite has some difficulty with record locking over a network, as it is not a true client/server database, but it should be possible to write an application to act as a server to network based requests.

SQLite uses a (large) subset of SQL - I have included some SQL tutorial links if you are new to SQL. Or just use a google search to find one that appeals to you.

Other databases are available - EDS (the euphoria database system - included with euphoria, not SQL (unless you use one of the libraries written for this)), MYSQL, and Tsnami, and all have there disadvantages and advantages - choose for yourself.

There are 2 versions of SQLite - the older 2.x series (of which at the time of writing 2.8.15 was the most current), and the 3 series (most current 3.08). These produce databases which are incompatible with each other. The 3 series produce more compact databases for the same data, and include the ability to store BLOBs.

SQLite 2 will no longer be supported, but the old wrappers will continue to remain here.

With the eu wrappers the syntax for accessing the databases is exactly the same - ie it is transparent to the euphoria program which sql library you are using.

If you have any questions regarding the use of the library, or the use of SQL, just post them to the eu mailing list.

Chris