summaryrefslogtreecommitdiffstats
path: root/TODO.txt
blob: 32810b2f0536d41379b2e8d0b39e08458e930be3 (plain)
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
Missing pieces:

- fix long text index entries (for new general sort order)
  * ???
- implement foreign key index creation & relationship creation
  * MEDIUM
- implement table creation w/ complex columns
  * MEDIUM
- implement (optional) foreign key enforcement
  * MEDIUM
- implement write support for properties
  * EASY
- implement table, column, index renaming
  * EASY
- implement table, column, index deletion
  * EASY - MEDIUM
- implement more comprehensive unicode compression write support
  * EASY? (have the code, do we trust it?)
- implement createReadOnlyTemp(InputStream) (delete temp file on close)
  * EASY
- figure out how msaccess manages page/row locks
  * MEDIUM

Refactor goals:
- simplify public API (separate "internal" and "external" api)
- separate table creation objects from existing metadata objects
- remove "simple" index support?
- remove "table traversal methods" from Table?
- enable integrity by default?
- remove import/export methods from Database?
- move database open/create options to DBBuilder
- tweak how import filters work to make them more flexible?
- tweak lookup apis (specify column vs column name)
- separate classes into more packages (api,builder,util,impl)
- remove debug log blocks
- add Row interface
- change savepoint to use table number instead of name?
- don't use columnimpl for creating tables
  - clean up columnimpl/tableimpl constructors
- add updateCurrentRow(Map), add updateRow(Row)
- sort out query types