DB used with Xojo the most?

Databases
1

Hello.

May I ask what database everyone finds works best with Xojo? I mean, what db for just a few users would be recommended? What about a very large set of users?
Hope that’s not too general of a question. I’m just wondering what the majority tend to use.

Thanks in advance.
Tim

2

I think that’s sqlite that’s used the most. Others can be used next to it, remotely. It depends on your needs, not sure if there is a best DB.

3

[quote=467773:@Tim Lee]What about a very large set of users?
Hope that’s not too general of a question. I’m just wondering what the majority tend to use.[/quote]
I don’t think this is too general at all and I’m also curious to the answer as well.

I know the “industry” in general, more or less, considers Oracle or SQL Server at the top of the pile. But I’ve heard a lot of good things about https://www.postgresql.org/ on the forums here, as well as broadly in the industry. I think the fact that it’s free makes it quite popular too.

4

@Scott Cadillac. Thank you. I’m also interested in Postgresql. I’ve been looking into it. It looks pretty good.
I’ve also looked at others.
Thanks again.

5

Hello,
I use for single user applications SQLite,
for multiple/many users I mostly use MySQL or MariaDB.
All of them work well with Xojo.

6

Hello.

Postgresql

7

In my nearly 20 years of experience SQLite is by far the most used database for single user applications. We’ve even used it in a multi-user web applications with great success.

For multiple client databases it’s been MySQL followed in distant second by Postgres. MySQL isn’t free if you go through the licensing details whereas Postgres really is free. Used to be that installing and maintaining Postgres wasn’t easy but they’ve definitely cleared that up recently.

8

install postgres using bigsql installers and it’s as easy as it can be. even for older versions.
http://web.archive.org/web/20180509162831/https://www.openscg.com/bigsql/postgresql/installers.jsp/

this is a webarchive link, strange it seems the actual bigsql web site is only with the linux version.
anyone knows what happened ?

9

It depends what you’re doing, doesn’t it. I use SQLite as a replacement for fopen/fget etc, just as the SQLite folks say. At work, the Operations Group database used mysql for the two or three people who needed it. Even then I had to fight off the attempts by a fathead to insist that we should be using Oracle or as it might be postgres as these were “industry standards”. He backed off when it was pointed out that running Oracle or similar requires 0.5 to 1.0 FTE or something to manage it, and would be complete overkill.

Horses for courses.

10

I’ve had good times with postgres in the past few years.
you can download the enterprisedb distribution here:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

11

Here in Brazil, Firebird is still largely used, mostly because of Delphi developers base we have.

12

In the Windows world & probably more specifically New Zealand MS SQL is the favorite DB engine mostly because the community edition (free) fits 85% of NZ business requirements. Xojo’s recent improvements including API 2.0 have greatly enhanced using MS SQL.

However for the world at large I’d still recommend Postgres due to the licensing requirements of the other engines, and it’s quite awesome too!

13

how so?

14

Mostly due to not having to specify the bind type for prepared statements although that is x-db. Keeping the same session id in a connection is another. There have been some little enhancements that have made a quite big difference to how it all hangs together.

The reality is that those of us who need to deal with a whole bunch of DB engines, Xojo has just stepped up to being xDb as well as xPlat.

15

Is that unique to API 2 or just to IDE version?

-karen

16

I would say just another incremental improvement unlike the big step up that is API 2.0.

And yes STEP-UP is appropriate.

17

[quote=467950:@Jean-Yves Pochez]this is a webarchive link, strange it seems the actual bigsql web site is only with the linux version.
anyone knows what happened ?[/quote]
OpenSCG were acquired by Amazon some time ago. For a current list of installers for various platforms have a look to https://www.postgresql.org/download/

18

or EnterpriseDB.com where they have built a business around postgresql and have lots of items for download not JUST postgresql installers

19

Thanks everyone. I think I"ll try Postgres…

20

There are some good answers here. However, I’d recommend you consider your use case (volume, users, processing, location, reporting, etc) first. Then select the right dB for the job. As far as general databases go, Postgres and MySQL are popular. Do you need an in-memory Database? Key/value DB, Data warehouse, local dB/SQLite, etc, etc.

Lots of choices ;), but a little work up front might save you time later :wink: