My only request would be that you add some kind of flag that allows us to specify opening the database in UTF-16 mode via this interface.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Monday, May 03, 2010 7:48 AM To: sqlite-...@sqlite.org; General Discussion of SQLite Database Subject: [sqlite] Proposed new sqlite3_open_v3() interface Community feedback is requested for the following proposed new SQLite C API: int sqlite3_open_v3(const char*, sqlite3**, int, const char*); The new database connection constructor would work exactly like sqlite3_open_v2() with the following exceptions: (1) Foreign Key constraints would be enabled by default. (2) Recursive triggers would be enabled by default. (3) The default database file format would be format 4 (meaning that new databases would be unreadable by versions of SQLite prior to 3.1.3). (4) The misfeature of allowing double-quoted identifiers to fall back to being strings if no matching identifier could be found would be disabled. (5) PRIMARY KEY columns would automatically be NOT NULL. (The would not change the current INTEGER PRIMARY KEY behavior, only non-INTEGER PRIMARY KEYs.) We are very hesitant to make any of the above changes to SQLite for the default case since they run the risk of breaking legacy code. By making the newer behavior the default only for the new interface sqlite3_open_v3() and leaving the behavior unchanged for legacy constructors, we hope to encourage newer applications to use the newer features while avoiding breakage of older applications. Question 1: Are there any objections to this approach? Question 2: Are there other foibles that we could correct using sqlite3_open_v3? D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
