<html><head></head><body>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).<br>
<br>
But in any case, using SQLite, or really any read/write storage in VLC poses certain potential problems:<br>
- users with network mounted home directories<br>
- VLC crashing during an update<br>
- VLC freezing during an update<br>
- writes in one VLC process desynching data in another VLC process (e.g. deleting or updating an entry)<br>
- storage space accumulation / check-pointing<br>
- database layout changes upon software updates<br>
- I/O error handling<br>
<br>
SQLite won't do magic. It's unlikely that it effectively addresses all the issues.<br>
<br>
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".<br><br><div class="gmail_quote">Le 26 juin 2018 09:58:23 GMT+01:00, "Hugo Beauzée-Luyssen" <hugo@beauzee.fr> a écrit :<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">On Tue, Jun 26, 2018, at 1:23 AM, Rémi Denis-Courmont wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> Le lundi 25 juin 2018, 11:09:59 EEST Hugo Beauzée-Luyssen a écrit :<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> ---<br> contrib/src/sqlite/SHA512SUMS | 2 +-<br> contrib/src/sqlite/rules.mak | 12 ++++++------<br> 2 files changed, 7 insertions(+), 7 deletions(-)<br></blockquote> <br> AFAIR, SQLite cannot, by design, be used in multiple processes.<br> <br></blockquote><br>AFAIK it can, although multiple processes using the same database would lock it during write operations.<br>But in this specific case, I do not see an issue for VLC's use case<br><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> With that restriction, there may be some corner case uses for SQLite that do <br> not exist yet - but hardly a media library storage back-end.<br> <br></blockquote><br><br></pre></blockquote></div><br>
-- <br>
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.</body></html>