Sqlite4java R186

sqlite4java R186 comes to users as an impressive and simple minimalistic Java wrapper for SQLite. SQLite is a free, compact, robust, embeddable SQL database engine. sqlite4java is built with the purpose to provide high-performance, low-garbage interface to SQLite for desktop Java applications.sqlite4java is not a JDBC driver. Access to the database is made through the custom interfaces of com.almworks.sqlite4java package. Tighter integration with SQLite offers better performance and features not available through JDBC interfaces.sqlite4java is built for use on Windows, Linux and Mac OS X, although you can try to compile it on other platforms. Required JRE version is 1.5. SQLite is pre-compiled and distributed along with the Java classes as dynamic JNI libraries.sqlite4java is pretty much work in progress. The latest version is stable enough for us (ALM Works) to use it in production applications, however the API is not full yet, some of the methods or optimizations for specific data types may be missing. Feel free to request improvements or suggest patches.Major FeaturesThin JNI-based wrapper for SQLite C Interface. Most of SQLite's user functions (not extender functions) are either already provided by the library or can be easily added.Single-threaded model - each SQLite connection is confined to a single thread, all calls must come from that thread. Application may open several connections to the same database from different threads. Along with the Serializable isolation level from SQLite, this feature facilitates writing very predictable code.Bulk retrieval from SELECT statements, greatly improving speed and garbage rate via minimizing the number of JNI calls to step() and column...() methods.Interruptible statements support allows to cancel a long-running query or update.Support for incremental BLOB I/O maps to sqlite3_blob... methods, which provide means to read/write portions of a large BLOB.SQL Profiler collects statistics on the executed SQL.

sqlite4java R186 comes to users as an ...