SQLite

[Alain Stouder Omnis]

Hi Bas,

An area where Sqlite shines is full text search! The FTS module is spectacular but it's tricky to setup with Omnis.

Just saying,
Alain

---
Learn something new every day!

> On 8 Mar 2017, at 02:34, Bastiaan Olij <bastiaan at basenlily.me> wrote:
> 
> Hey Werner,
> 
> That is strange, SQLite has both a (simplistic) transaction log and uses
> file locking for inserts/updates so in theory multi user should work.
> They do indeed warn that it is not recommended and not the intended us
> of SQLite.
> 
> The problem is that it will do a full file lock when modifications are
> made so any high volume operation will grind to a halt. It also means it
> most likely suffers from the same drawbacks as running DF1s on file
> shares. This is worth a read on the subject:
> https://www.sqlite.org/faq.html#q5
> 
> All in all, the advise to not use SQLite for anything other then a
> single user setup is probably sound, but again, switching to a free
> database like PostgreSQL in that scenario should be pretty straight
> forward as long as you keep to plain vanilla SQL.
> 
> Cheers,
> 
> Bas
> 
>> On 8/03/2017 9:34 AM, Werner Dirix wrote:
>> 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
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com