Which database should I use?

  1. ‹ Older
  2. 4 years ago

    Dirk C

    5 Jun 2015 Pre-Release Testers, Xojo Pro Belgium, Zedelgem

    @jean-yvespochez how do you connect to a firebird database using xojo ?

    I think through ODBC.

  3. Jean-Yves P

    5 Jun 2015 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    @Dirk C I think through ODBC.

    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 ...

  4. 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.

  5. Paul L

    5 Jun 2015 Xojo Inc, Third Party Store http://docs.xojo.com

    @jean-yvespochez how do you connect to a firebird database using xojo ?

    * Using Firebird with Xojo blog post
    * Using ODBC webinar

  6. Jean-Yves P

    5 Jun 2015 Pre-Release Testers, Xojo Pro Europe (France, Besançon)
    Edited 4 years ago

    Note, there are only ODBC drivers available for Windows and Linux.

    so firebird is definitely not for a mac ... at least xojo on a mac.

  7. Simon B

    5 Jun 2015 Europe (Wiltshire, UK)

    @jean-yvespochez so firebird is definitely not for a mac ... at least xojo on a mac.

    Not unless you use the SQLPlugin from MBS.

  8. Louis D

    5 Jun 2015 Pre-Release Testers, Xojo Pro QC, Canada

    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.

  9. Paul L

    5 Jun 2015 Xojo Inc, Third Party Store http://docs.xojo.com

    @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 .

  10. @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?

  11. Tim H

    5 Jun 2015 Pre-Release Testers Portland, OR USA

    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.

  12. Edited 4 years ago

    @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.

  13. 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 :(

    There are client libraries available for Python , NodeJS and Go that use the wire protocol.

  14. Bob K

    6 Jun 2015 Pre-Release Testers, Xojo Pro, Third Party Store Kansas City

    And this discussion is way beyond what the OP was asking for.

  15. 11 months ago

    Richard D

    29 Nov 2018 Pre-Release Testers, Xojo Pro Europe (UK, London)

    @Jack K It can work in embedded mode just like Sqlite but with far superior support for official SQL standards, e.g right join.

    does not include embedded version for mac though

or Sign Up to reply!