-
Notifications
You must be signed in to change notification settings - Fork 20
/
TODO.taskpaper
49 lines (44 loc) · 1.62 KB
/
TODO.taskpaper
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Future Release:
SQLite API:
- authorizers
- loading of extensions
- 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
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_STAT2 option
- 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 )
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