Edgewall Software

Changes between Version 28 and Version 29 of TracDev/DatabaseApi


Ignore:
Timestamp:
Feb 6, 2014, 12:32:54 PM (10 years ago)
Author:
al.willmer@…
Comment:

Minor correction of microsecond database type

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseApi

    v28 v29  
    265265As you may know, support for SQL varies among different database systems. The requirements of Trac are relatively trivial, so we try to stick to a common subset that is supported by the majority of databases.
    266266
    267  - no native `date` or `time` database types; store date and time information in seconds as `int` fields (before 0.12) or better, in microseconds and `bigint` fields (since 0.12)
     267 - no native `date` or `time` database types; store date and time information in seconds as `int` fields (before 0.12) or better, in microseconds and `int64` fields (since 0.12, mapped by each `trac.db.IDatabaseConnector` to a suitable database specific type)
    268268 - no triggers
    269269 - you may use views if you feel you need them (but so far we didn't feel the need for Trac itself)