mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Using SQLite3 engine 3.7.7

The SQLite3 engine in latest version 3.7.7 has been commited to our Source Code repository:
- Add support for URI filenames
- Add the sqlite3_vtab_config() interface in support of ON CONFLICT clauses with virtual tables.
- Add the xSavepoint, xRelease and xRollbackTo methods in virtual tables in support of SAVEPOINT for virtual tables.
- Update the built-in FTS3/FTS4 and RTREE virtual tables to support ON CONFLICT clauses and REPLACE.
- Avoid unnecessary reparsing of the database schema.
- Added support for the FTS4 prefix option and the FTS4 order option.
- Allow WAL-mode databases to be opened read-only as long as there is an existing read/write connection.
- Added support for short filenames.

See http://synopse.info/fossil/info/4ce5e69f76

The corresponding .obj files have been updated in http://synopse.info/files/sqlite3obj.7z

I think I will publish soon a revision 1.14 to follow this change, and include a very important fix about negative currency values. See http://synopse.info/fossil/info/5facd35801