Re: Feedback from downstreams presentation from DX hackfest 2015

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
 • 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:

I think it's a bit nicer in the (my) C++ wrapper, though it's
documentation there is a bare minimum:

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.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]