SQLite

[Werner Dirix]

Hi,

At the Euromnis 2015 conference we were warned by Andreas not to use SQLite in a multi-user environment.  SELECT operations will work fine but INSERTs may cause problems because SQLite has no built in locking system.  It depends on the locking system of the underlying filesystem.

The SQLite website has more info on this.

Werner


-----Oorspronkelijk bericht-----
Van: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] Namens Bastiaan Olij
Verzonden: dinsdag 7 maart 2017 23:14
Aan: omnisdev-en at lists.omnis-dev.com
Onderwerp: Re: SQLite

Hey Mike,

Hard to say, so far SQLite has been something I've played with but not used in production as for our business case, it is not a good fit. Well not as our main database, we will likely start using it for our mobile solution and for storing local data where needed.

The main thing I miss in SQLite is stored function support and their very limited capabilities of triggers. We are heavy stored function users having moved a lot of our business logic onto the backend but that isn't something that applies to every solution.

If you've got a solution where you're targeting a wider set of database engines it's more likely that you're not using that type of functionality anyway as this is one part of SQL where standards are non-existent. I have a feeling it is a much better fit for you guys seeing your solution is already focusing on supporting multiple database engines and keeping alot of the logic in Omnis.

As I said before SQLite is a really good fit if you have an application that targets single users, and can handle smaller enterprises (2 or 3 users on a LAN through filesharing similar to using a DF1) but where you upscale to a database server for your larger clients. As long as you stick to whats supporting in the SQL standard that transition should be relatively painless and where there are differences you can add the needed logic into your session objects and table base class to handle those differences.

Cheers,

Bas


On 7/03/2017 6:15 PM, Mike Matthews wrote:
> Hello Bas,
>
> Ah, yes, I think you are right, it data encryption, so that is me grabbing headlines again.
>
> That ability for SQLite to act for a single user is appealing indeed.  We have added MySQL to our list after FrontBase, and this year we are doing the addition of PG, so we will also look at SQLite as well.  I hope we don't do anything too fancy.
>
> Mike


_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com