Re: Feedback from downstreams presentation from DX hackfest 2015

[Bastien Nocera <hadess hadess net>]

On Wed, 2015-02-11 at 14:21 +0100, Murray Cumming wrote:
> On Tue, 2015-02-10 at 16:11 +0000, Philip Withnall wrote:
> > Problems building SQL and SPARQL queries
> >  • https://bugzilla.gnome.org/show_bug.cgi?id=741777
> >  • SQLite: can’t think of a decent way of fixing this
>
> libgda has the GdaSQLBuilder API. It's a bit odd, but it works, and
> handles different SQL dialects:
> https://developer.gnome.org/libgda/stable/GdaSqlBuilder.html#GdaSqlBuilder.description
>
> I think it's a bit nicer in the (my) C++ wrapper, though it's
> documentation there is a bare minimum:
> https://developer.gnome.org/libgdamm/unstable/classGnome_1_1Gda_1_1SqlBuilder.html#details
>
> I use the C++ version lots in Glom.
>
> At the least, it's a big help to avoid SQL injection that can creep in
> when you just concatenate strings.
>
> I would never use any database API without using some abstraction layer
> such as libgda. They are all far too strange. I'd rather port one day
> from one sane abstraction layer to another sane abstraction layer than
> from some gnarly specific database API to one that's just gnarly in
> another way.

I tried using libgda from both C and Javascript, and it was an absolute
pain to get going. Which is why I ended up working on gom.