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.
[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.
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.
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.
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!
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.
[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/
There are some good answers here. However, Id 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