@jean-yvespochez how do you connect to a firebird database using xojo ?
I think through ODBC.
Years ago I started to write a RealBasic wrapper for Firebird's C API. I only really abandoned it because I had to use a third-party reporting tool for my project which meant I had to install the ODBC driver and set up a DSN anyway. Iirc RB didn't offer structures at the time either so I had to mess about with memory blocks and offsets.
Maybe when we have LLVM + Firebird 3 I'll ressurect it and polish it up.
For a long time the Firebird Foundation didn't do themselves any favours with their fusty old website. That's now, thankfully, had a refresh. I don't think the project itself was ever near death.
That must be why in the early 2000's I misinterpreted the (then) new born product for a moribond legacy one. I stand corrected.
@jean-yvespochez so firebird is definitely not for a mac ... at least xojo on a mac.
Not easily. I've not tried it, but this post talks about an ODBC Firebird driver for OS X .
@jean-yvespochez so no preparesqlstatements and may be have to buy a plugin to use it on a mac ?
that's a serious thing to consider compared to postgresql ...
But again this is unfair on Firebird. Firebird works fine on a Mac. Xojo supports postgresql but does not support firebird.
What can firebird do about that?
@Tim H It doesn't matter how good Firebird is if your xojo app can't use it. This is not a discussion of what's the best db, it's what's the best db to use with xojo.
But you can use firebird with xojo, I've done it, on windows. You can also use it on linux. In both cases you don't need any kind of database licence from xojo.
And on mac you can use it if you have Christian's plugins.
Firebird actually has a wire protocol which means you can communicate with the server directly using a TCP socket without having any middleware at all. Unfortunately the wire protocol is not well documented so to figure it requires looking at the source code :(