# I am the Watcher. I am your guide through this vast new twtiverse.
#
# Usage:
# https://watcher.sour.is/api/plain/users View list of users and latest twt date.
# https://watcher.sour.is/api/plain/twt View all twts.
# https://watcher.sour.is/api/plain/mentions?uri=:uri View all mentions for uri.
# https://watcher.sour.is/api/plain/conv/:hash View all twts for a conversation subject.
#
# Options:
# uri Filter to show a specific users twts.
# offset Start index for quey.
# limit Count of items to return (going back in time).
#
# twt range = 1 8
# self = https://watcher.sour.is/conv/jjey7oq
been trying something
I first made a dump of the sqlite3 database mentioned in the 'Path' field on the picture. Then I used this python script I had to edit beforehand to get a mysql/mariadb dump. I had mariadb set up from earlier, same for gogs's config. I proceded to edit the dump to fix some odd details i've been having with my repos and then imported it from mariadb. Booted up gogs again and _poof_
it worked
post-datum: I'm biased against Postgres because I found it complex to even get a grasp of, and that was a couple years ago, and it seems like it still is...
I don't like any database really 😂 They're all too complicated 🤣
I don't like any database really 😂 They're all too complicated 🤣
@akoizumi The best ways I've found to store and manage data in anything I build is to treat everything as KV (key/value) pairs. Use an appropriate KV store. Use indexes when you need to and store files as files.
@akoizumi The best ways I've found to store and manage data in anything I build is to treat everything as KV (key/value) pairs. Use an appropriate KV store. Use indexes when you need to and store files as files.