[vlc-devel] [RFC PATCH 1/8] contrib: Update & reactivate sqlite

[Rémi Denis-Courmont]

Hmm, my understanding of SQLite locking is probably out of date, and it seems that the  analysis depends on the SQLite method used (e.g. WAL).

But in any case, using SQLite, or really any read/write storage in VLC poses certain potential problems:
- users with network mounted home directories
- VLC crashing during an update
- VLC freezing during an update
- writes in one VLC process desynching data in another VLC process (e.g. deleting or updating an entry)
- storage space accumulation / check-pointing
- database layout changes upon software updates
- I/O error handling

SQLite won't do magic. It's unlikely that it effectively addresses all the issues.

So far the problem only exists for the configuration and the plugins cache. But they are much easier to handle, as we treat them as "all or nothing".

Le 26 juin 2018 09:58:23 GMT+01:00, "Hugo Beauzée-Luyssen" <hugo at beauzee.fr> a écrit :
>On Tue, Jun 26, 2018, at 1:23 AM, Rémi Denis-Courmont wrote:
>> Le lundi 25 juin 2018, 11:09:59 EEST Hugo Beauzée-Luyssen a écrit :
>> > ---
>> >  contrib/src/sqlite/SHA512SUMS |  2 +-
>> >  contrib/src/sqlite/rules.mak  | 12 ++++++------
>> >  2 files changed, 7 insertions(+), 7 deletions(-)
>> 
>> AFAIR, SQLite cannot, by design, be used in multiple processes.
>> 
>
>AFAIK it can, although multiple processes using the same database would
>lock it during write operations.
>But in this specific case, I do not see an issue for VLC's use case
>
>> With that restriction, there may be some corner case uses for SQLite
>that do 
>> not exist yet - but hardly a media library storage back-end.
>> 
>
>
>
>-- 
>  Hugo Beauzée-Luyssen
>  hugo at beauzee.fr
>_______________________________________________
>vlc-devel mailing list
>To unsubscribe or modify your subscription options:
>https://mailman.videolan.org/listinfo/vlc-devel

-- 
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.videolan.org/pipermail/vlc-devel/attachments/20180626/6181ca22/attachment.html>