| From: | drh(at)hwaci(dot)com (D(dot) Richard Hipp) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL, GnuCash |
| Date: | 2004-08-02 02:13:45 |
| Message-ID: | 67125085.0408011813.234fa311@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Christopher Browne <cbbrowne(at)acm(dot)org> wrote in message news:<m3pt6ams2w(dot)fsf(at)wolfe(dot)cbbrowne(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kay-Uwe Genz | 2004-08-02 08:21:21 | Re: Where are all the users? |
| Previous Message | Christopher Browne | 2004-08-01 22:26:36 | Re: PostgreSQL, GnuCash |