Skip to content

Latest commit

 

History

History
57 lines (50 loc) · 1.69 KB

TODO.md

File metadata and controls

57 lines (50 loc) · 1.69 KB

Future Release possibilties:

  • rebuild statement constants
  • look at all pragma statements

SQLite API:

  • authorizers
  • loading of extensions -- readfile / writefile
  • utf-16 integration
  • create_collation
  • encryption key support
  • expose sqlite3_strnicmp
  • table name and column name in a type map?
  • type conversion for manifest typing? how to allow it through?
  • explicit pragma handler
  • application_id pragma setter

Non backwards compatible changes:

  • change the schema objects to be more consistent
  • change taps to use to_proc protocol
  • convert type dependency to just use 'call'
  • integrate transaction and savepoint under the same api

SQLite Features:

  • activate SQLITE_ENABLE_ICU extension
  • activate SQLITE_ENABLE_LOCKING_STYLE
  • activate SQLITE_ENABLE_UNLOCK_NOTIFY
  • expose PRAGMA foreign_keys
  • virtual file system
  • full text search (FTS3)
  • expose the sqlite mutex lib
  • statement status ( sqlite3_stmt_status )
  • db status ( sqlite3_db_status )
  • library status ( sqlite3_status )
  • sqlite3_index_info
  • sqlite3_create_function has 4th parameter SQLITE_DETERMINISTIC
  • sqlite3_rtree_query_callback()

Drivers:

  • data mapper driver
  • sequel driver optimization

Features:

  • Think about moving from arrayfields to ordered hash?
  • add to command line which directory to pack into a rubylibs table
  • amalgalite command line tool
  • use ruby's ALLOC_N and hook into sqlite3_mem_methods

Functions to possibly expose:

  • sqlite3_backup_remaining, sqlite3_backup_pagecount
  • sqlite3_compileoption_used, sqlite3_compileoption_get
  • sqlite3_config
  • sqlite3_data_count - returns number of colums in the result set of a prepared statement
  • sqlite_sourceid, sqlite_source_id
  • sqlite3_strnicmp