Hi,

I'm wondering if you have plans for direct support for these types.

I am wondering about a typical OLTP app that frequently is using these types in predicates. That is, to get great performance on things like

amount > 10.50
orderDate = Date(2009-08-20)
lastUpdate > Timestamp(...)

etc

Another way of asking the question would be... are you confident of getting good performance for these types of expressions without built in support for these types?

SDBTable supports indexes but the only type it supports are strings (lexicographical order). You can encode the types you mentioned as strings, for example, numbers would need to be encoded as '0000000099', '0000000100', etc. Then you could do an index query of tail('0000000090') to find all rows > 90. Timestamps can be encoded similarly. BigTable works like this - they have a number of utility classes for encoded various types as strings.

You should get good performance (it's a tree search regardless of whether the db supports more complex types or not), and it scales horizontally over your cluster anyway.

Oh also, yes, we do plan to release a data model with built in types for dates and numbers, etc.