SQLite4
Update of "todolist"
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview

Artifact ID: 1fb854965fa1a7fc51fa3dc511aa5c976d28094e
Page Name:todolist
Date: 2013-05-07 14:31:55
Original User: dan
Content
  1. Add support for a SHARD KEY in the table definition. This is passed down into the storage engine as a hint. The storage engine is free to ignore the hint.

  2. Add a COVERING clause to CREATE INDEX. The value of the key/value entry for each index row is the union of the indexed columns and the covering columns. Short-hand notation "COVERING ALL" generates a covering index.

  3. Send PRAGMA commands into the storage engine as is done with SQLite3.

  4. Forward port all query optimizer enhancements implemented in SQLite3 over the previous year into SQLite4.

  5. Review all other changes made to SQLite over the previous year and forward port all that seem appropriate.

  6. Use decimal arithmetic everywhere within the code. Avoid the use of IEEE 754 binary floating point, except for APIs that have "double" parameters or return values.

  7. Carefully review the entire API and look for other ways to make it simpler and more robust.

  8. Add an extra "unsigned int flags" parameter to sqlite4_close(). Currently unused. Reserved for future features.

  9. Change the callback of sqlite4_exec() to pass down an array of sqlite4_value pointers rather than an array of strings.

  10. Change memory allocation routines to be methods of sqlite4_mm instead of methods of sqlite4_env.

    1. sqlite4_mprintf()
    2. sqlite4_vmprintf()
    3. sqlite4_malloc()
    4. sqlite4_free()
    5. sqlite4_realloc()
  11. Provide a new routine: sqlite4_msize().

  12. In sqlite4_prepare(), instead of returning a pointer to the first character past the end of the parse, return the number of bytes of SQL text consumed by the parser.

  13. Remove the sqlite4_memory_used and sqlite4_memory_highwater interfaces. The functionality is subsumed by sqlite4_mm_stat().

  14. Get rid of sqlite4_create_function_v2(). Let there be just a single interface for creating functions.

  15. Rename some poorly named interfaces:

    1. sqlite4_user_data -> sqlite4_context_appdata
    2. sqlite4_get_auxdata -> sqlite4_auxdata_fetch
    3. sqlite4_set_auxdata -> sqlite4_auxdata_store
    4. sqlite4_get_autocommit -> sqlite4_db_transaction_status
    5. sqlite4_sql -> sqlite4_stmt_sql
    Maybe suggest different alternative names
  16. For routines like sqlite4_column_text, sqlite4_value_text(), sqlite4_column_blob(), sqlite4_value_blob(), and so forth, add an extra OUT parameter which returns the number of bytes in the string or blob.
  17. Change the type of text values in places like "sqlite4_column_text()" to "char*" instead of "unsigned char*".

  18. sqlite3_set_authorizer() needs to be two routines: sqlite4_authorizer_push() and sqlite4_authorizer_pop() and there needs to be a destructor.

  19. Add a new extended error code for every error where doing so makes any sense at all.