SQLite (was: That pesky libpq.dylib came back to haunt me, SHA2 certification)

[Mike Matthews]

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

> On 6 Mar 2017, at 23:30, Bastiaan Olij <bastiaan at basenlily.me> wrote:
> 
> Hey Mike,
> 
> I haven't looked into that part very much yet but I think that is more
> around encryption of data stored in the datafile then having a secure
> connection.
> 
> SQLite really shines as a local database, either for stand alone
> applications or as a way to simply store local data, say configuration
> or if you want to build an offline mode for your application that syncs
> data to a database.
> As a multi user solution it suffers from similar short comings as the
> Omnis datafile as it is essentially a file based system with all the
> cross platform locking issues that come with it (but less performance
> issues).
> 
> What I find particularly appealing is that if you build an application
> based on SQLite you have a single user version of your application
> without the need of installing anything outside of Omnis while you can
> easily upscale to multi user using the same code base but connecting to
> say a PostgreSQL database.
> Well, as long as you stick to very basic platform independent SQL
> functions :)
> 
> Cheers,
> 
> Bas
> 
> On 7/03/2017 10:11 AM, Mike Matthews wrote:
>> It was said very much tongue in cheek, but I still dream of the old innocent days. :)
>> 
>> But I see SQLite is now secure and something about v8.03 supporting it.  Not sure how secure is secure though.
>> 
>> Sent from my iPad
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com