Re: PostgreSQL, GnuCash

Christopher Browne <cbbrowne@acm.org> wrote in message news:<m3pt6ams2w.fsf@wolfe.cbbrowne.com>...
>
>  -> SQLite does not impose any data type constraints, and stores
>     non-integer values as floating point values, which will not
>     calculate correct values for financial transactions.
>

This is very true.  For a financial applications in SQLite you would be
well advised to store all quantities as an integer number of cents
and shift the decimal point in the application itself.  SQLite version 3.0
uses a 64-bit integer so overflow shouldn't be a problem.