#dev 2022-07-15

2022-07-15 UTC
gRegor and gerben joined the channel
#
@web2web3bot
web2: Follow me on twitter! web3: Follow me on webmentions!
(twitter.com/_/status/1547664740037472256)
mro and geoffo joined the channel
#
[tantek]2
angelo, scroll-up šŸ™‚
geoffo joined the channel
#
[chrisaldrich]
What is Wax?
#
Loqi
It looks like we don't have a page for "Wax" yet. Would you like to create it? (Or just say "Wax is ____", a sentence describing the term)
#
[chrisaldrich]
Anyone tried out https://minicomp.github.io/wax/ before? It appears to be an SSG based on Jekyll for images and image collections and popular in the digital humanities / education space.
geoffo, tetov-irc, mro_, mro, nertzy, gxt, AramZS, [jgmac1106] and jacky joined the channel
#
[jgmac1106]
Asking outside of #indieweb-known took a look, but still borked. Should I just find someone on a jobs board to sit and copy everything? try to rebuild the database?
#
Zegnat
I think it depends what it is you want to get done. I remember that running the update the way Known wants to do it made your server run our of resources. Depending on what your goal is there are probably several different ways to get the content out.
#
Zegnat
If the goal is to keep using Known, I would probably recommend going with a clean installation and then see if the content can be copied from one database to the other. If the goal is to migrate to a different CMS, you are probably also looking at some sort of database migration.
#
[jgmac1106]
i just want to protect my content first and foremost, the pagination in Known makes it hard, the rss export gets me ten last items
#
[jgmac1106]
I will try a fresh Known install and see if I can export my database and connect it
#
[jgmac1106]
maybe a different shared host
#
[jgmac1106]
probably due to a timeout issue loading next page
#
[jgmac1106]
now to wait for a 20 GB database to download
mro, gxt and jacky joined the channel
#
Zegnat
I think I had issues grabbing the full database. But if you can get that, you have basically secured all your content.
#
Zegnat
Else see if your host is able to send you a full database dump.
#
Zegnat
If you do think about moving things around, check the uploads folder too. I am not sure where Known had that one, but if you have any uploaded images etc you will want to grab those separately
#
[jgmac1106]
yean the database was 1.7 the upload folder 18.2
#
[jgmac1106]
I will figure it out the same day [Zegnat] decides on his stack
#
[tantek]2
[jgmac1106] I hope you're able to find a way to export all your content in a way you trust you got it all
#
[tantek]2
You're making another good case for avoiding databases as primary storage (even for "technical" users)
#
aaronpk
files++
#
Loqi
files has 1 karma in this channel over the last year (3 in all channels)
#
[tantek]2
files++
#
Loqi
files has 2 karma in this channel over the last year (4 in all channels)
jacky joined the channel
#
jacky
tugs at SQLite closely
jwhite0111[m] joined the channel
#
Zegnat
I was just thinking about saying that too, jacky, haha
#
[manton]
Iā€™m kind of curious, does Known keep full-resolution photo uploads? 18 GB seems like a lot of uploads. Maybe video too?
#
jacky
this makes me more interested in making the act of backing up my site as easy as possible
#
jacky
and even have some way to test it
petermolnar, mro, jacky and mro_ joined the channel
#
Zegnat
How are you backing up your SQLite files, jacky? I was looking into that the other day
#
petermolnar
.timeout 10000
#
petermolnar
Zegnat: the right way is https://www.sqlite.org/backup.html , on the command line it's ```sqlite3 "${sourcedb}" >/dev/null 2>&1 <<EOF
#
petermolnar
.backup "${targetdb}"
#
petermolnar
if it fails. same thing, but .dump and delete the backup in advance
#
Zegnat
I was experimenting with https://litestream.io/ which can stream the WAL files to a separate server as you use the database. Basically giving database replication for SQLite
jacky and gxt joined the channel
#
capjamesg_
This is interesting.
mro, jamietanna and jacky joined the channel
#
jamietanna
I'm looking at migrating to fly.io which has great support for litestream https://fly.io/blog/all-in-on-sqlite-litestream/
#
Zegnat
Fly.io does seem interesting. Any specific reason you are looking at them over other PaaS like Heroku et al, jamietanna?
gxt, jacky and mro joined the channel
#
@kevinmarks
ā†©ļø No, but the webmention overlay via http://webmention.herokuapp.com does
(twitter.com/_/status/1548049289615589378)
petermolnar joined the channel
#
[schmarty]
i dropped heroku after the github token fiasco (and months/years of slow neglect after salesforce bought 'em)
#
[schmarty]
moved my one major project over to fly.io where i found it a little more confusing to set up but otherwise it seems to work equivalently and more cheaply.
#
[schmarty]
(my app was over the heroku postgresql free tier of "10,000 rows" and needed slightly more than a free hobby dyno)
#
[schmarty]
coincidentally that project is for crowdsourced 3D printed sculptures and we just launched a new project today in memoriam of a member of the open source 3D printing community. https://www.wethebuilders.com/projects/12
geoffo, gRegor, tetov-irc and jacky joined the channel
#
jacky
Zegnat: right now, a cron job that scp's them to a folder in my personal minio instance (that syncs to digitalocean spaces)
#
jacky
but I do plan on using the backup API in the future, the *zar apps tend to use that too
#
jacky
capjamesg_: come to the single file db side :)
[James_Van_Dyne], jacky and callym[m] joined the channel