Setting up gnucash to use postgesql back end - close but no cigar ...

[Sébastien de Menten]

On Saturday, March 14, 2015, John Ralls <jralls at ceridwen.us> wrote:

>
> On Mar 14, 2015, at 8:05 PM, Sébastien de Menten <sdementen at gmail.com
> <javascript:_e(%7B%7D,'cvml','sdementen at gmail.com');>> wrote:
>
> I just saw (and tested) that it is possible to create new functions and
> aggregates in sqlite dynamically (
> https://www.sqlite.org/c3ref/create_function.html). This could open the
> possibility to rewrite the "sum"."avg" aggregate in sqlite to handle
> properly decimals and store decimals as string in sqlite. For other SQL
> backend, the builtin decimal support could be used.
> Would this be a possible path for the future ?
>
>
> Maybe, though storing as a string is going to make it pretty slow. Isn't
> there a way to store an arbitrary binary?
>
> Yes through the blob affinity type.


> There's also a portability issue. We want to be able to use the same code
> to do the same things on all supported SQL backends.
>
> The DDL would be slightly different for SQLite wrt other backends but with
overwriting of functions/aggregate for SQLite (sum, cast, ...), the rest of
the SQL code (queries) could be the same.


> Regards,
> John Ralls
>