Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
veganism.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Veganism Social is a welcoming space on the internet for vegans to connect and engage with the broader decentralized social media community.

Administered by:

Server stats:

293
active users

veganism.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.0-alpha.5

#sqlite3

0 posts0 participants0 posts today
Michal :verified: :btw:<p>Aaand upgrade done, overall took ~30min to migrate my family <a href="https://toot.kottman.xyz/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Nextcloud</span></a> from <a href="https://toot.kottman.xyz/tags/Sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Sqlite3</span></a> to <a href="https://toot.kottman.xyz/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Postgres</span></a> </p><p>It does feel much snappier now, especially when loading many thumbnails.</p><p>Unfortunately the process does take a software engineering degree to finish (--clean-schema does not work due to missing `drop table oc_news_* ... *cascade*`), it's a lot of babysitting and manual corrections.</p>
Michal :verified: :btw:<p>Turns out <a href="https://toot.kottman.xyz/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> does not have a built-in function to validate <a href="https://toot.kottman.xyz/tags/utf8" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>utf8</span></a> - it just does GIGO (garbage in, garbage out): <a href="https://sqlite.org/invalidutf.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite.org/invalidutf.html</span><span class="invisible"></span></a></p><p>So one quick hack of a utf8 validation loadable extension, I ran `select * from oc_filecache where isutf8(name) is null` and there was one (!!!) among the 3.5M entries (it was an external file).</p><p>`delete from oc_filecache where fileid=287791` and I'm ready to go again. Setting `cpupower frequency-set -g performance` and now it's just 20min left.</p>
bert hubert 🇺🇦🇪🇺🇺🇦<p>"The second advantage of WAL-mode is that writers do not block readers and readers to do not block writers. This is mostly true" - coming to you live from the part where this is not true. <a href="https://fosstodon.org/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://sqlite.org/wal.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite.org/wal.html</span><span class="invisible"></span></a></p>
La vie dans mon jardin en code et en image<p><strong>Codeforterra : mODIFICATION DE LA FENETRE D’AFFICHAGE DES&nbsp;PLANTES…</strong></p> <p><span>⭐</span></p><p><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span class="">Note&nbsp;: 1&nbsp;sur 5.</span></p> <p><span></span></p><p><a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/listwidget/" target="_blank">#listwidget</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/pyside6/" target="_blank">#pyside6</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/python/" target="_blank">#python</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/sqlite3/" target="_blank">#sqlite3</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/tablewidget/" target="_blank">#tablewidget</a></p>
VegansExploreLive feeds
About