1Migrations
2----------
3
4- timestamp-based migrations like rails 2.1:
5  http://guides.rubyonrails.org/migrations.html
6
7- replace backend-specific structuredump with a PHP/JSON dump of schema and
8  data, including a corresponding importer. A simple YAML/JSON structure that
9  represents the PHP objects (TableDefinition, ColumnDefinition, IndexDefinition
10  - or alternately writes them out programmatically like a migration script)
11  would make it easiest to reconstruct identical tables between multiple
12  machines and multiple database types, and a simple JSON encoding of data (a
13  single header row, followed by one JSON array per database row per line) would
14  take care of most special characters and serialization issues, and allow for
15  fast line-by-line reading.
16
17- add convenience methods of calling $t->string('foo'), instead of
18  $t->column('string', 'foo'), inside migration scripts. Will need to introspect
19  the nativeDatabaseTypes() list from the connection for this.
20
21
22Dates
23-----
24
25- Handle Horde_Date objects in both input/output from Horde_Db.
26
27- what to do about '0000-00-00' with PostgreSQL?
28
29- http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html
30
31
32
33- integer sizing for mysql like the postgres backend does it?
34
35- port updates in schema_definitions.rb and schema_statements.rb
36
37- allow adding multiple indexes (and columns) at once, in an aggregate
38  operation. at the abstract level this will just execute the changes one at a
39  time; for databases like mysql that can run multiple changes at once, it will,
40  achieving much better efficiency.
41
42- rdo: add the ability to load a table once, then use it repeatedly in a
43  relationship (or to have it be a static array), instead of joining.
44
45- composite primary key support: what does http://compositekeys.rubyforge.org/
46  have that we don't?
47
48- port disable_referential_integrity?
49
50- port query_cache.rb
51
52- Support mysqlnd statistics:
53  http://developers.sun.com/databases/articles/mysql_php4.html#7
54