Supported types about sqlpp11 HOT 4 CLOSED

Hi Matthijs,

there are several types missing, of course (I mentioned BLOBs in an
earlier reply, which I plan to add soon). I'll have to go through the
SQL standard to see which ones I want to add to sqlpp11.

Other types or alternative implementations can be added by the connector
library. I haven't done that yet, but it should be fairly straight
forward to do. Just take a look at how the existing types are implemented.

If you want to give it a try, I'd be very interested in the results :-)

Best,

Roland

from sqlpp11.

Hi Roland,

Did you already take a look at the SQL standard for the types?

One question about the types:
Why did you put every type of an integer (tinyint, smallint, integer and bigint) in a int64_t ?
tinyint (1 byte)
smallint (2 bytes)
integer (4 bytes)
bigint (8 bytes)

Why not separate types?

Regards, Matthijs

from sqlpp11.

Hi Matthijs,

I took a look at the SQL standard types, although not long enough for a
complete answer.

BLOB and text seem to have the same interface as char/varchar, so I
guess I'll treat those a synonyms.

timestamp and date seem quite complex because different vendors offer
different interfaces (especially with respect to time zones). I tend to
leave those to the connector llibraries, but I am not sure yet.

As for the integral types:
Using the same type for all was the simplest start. Otherwise I would
have to adjust the type for operations like addition, or multiplication
etc. That's not impossible of course, but also not the most pressing
issue IMHO.

I am open to suggestions/patches, of course :-)

Cheers,

Roland

from sqlpp11.

I am closing this one with release 0.35, which brings day_point and time_point which correspond to date and datetime. See also the remarks on #23 .

If you are interested in specific types, please open new issues for those.

from sqlpp11.