SQLJet A free and pure Java version of a popular SQLite database engine
Download

SQLJet Ranking & Summary

SQLJet Tags

library engine database database library java database database engine

SQLJet Description

A free and pure Java version of a popular SQLite database engine SQLJet is an open source software library that provides API that enables Java applications to access and modify mostly any of SQLite-created and managed databases. Here are some key features of "SQLJet": · Fine-grained API to create, access and modify SQLite databases. · Database format is fully compatible with SQLite 3.6. · No native binaries are needed. · Runs on JVM 1.5 or newer. · Current version only supports SQL in schema. Requirements: · Java 1.5 or later What's New in This Release: New features: · DB schema: IF NOT EXISTS statement support added (-r631, -r648) · DB schema: ALTER statement support and corresponding API methods added (-r677) · Affinity mode for column types (issue #75) (-r653) · New ISqlJetCursor methods to get row count, current row and go to row (issue #92) (-r652) · New ISqlJetCursor.setLimit(...) method (issue #92) (-r701) · New insert and update methods with ON CONFLICT statement logic support (-r702) · Performance optimizations. Bugfixes: · Fields size was stored in db schema as x.x (float numbers), fixed (-r637) · NPE in SqlJetMemPage.clearCell fixed (issue #112) (-r649) · Problems using case mismatching names of tables and indices fixed (-r674, 679, 700) · Table and indices names with '$' was not supported, fixed (issue #116) (-r765)

SQLJet Related Software