# 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 235518
# self = https://watcher.sour.is?offset=228636
# next = https://watcher.sour.is?offset=228736
# prev = https://watcher.sour.is?offset=228536
@aelaraji Same, I hope things get much better for you bud 🤗
Thank you @bender Much appreciated 🙏 and Sorry you/anyone had to read that...
Thank you @bender Much appreciated 🙏 and Sorry you/anyone had to read that...
I'm usually comfortable keeping my hardship to myself, most especially AWAY from the internet; an act of kindness of sorts towards others, "Everyone's got their own problems to worry about" kind of thing.. But maaan am I starting to believe creating a twitter account would be a healthy decision 🤣🤦 Read nothin' out there, just a one way echo chamber of sorts to let that shi_ out of my chest. It seem that's what everyone else's been using it for all this time.

A Bsky would be even better! 😂 I'd get to shi_ post and yap all I want, allll the way from terminal and never ever have to look back at it or whatever comes out of it. But I digress...

I FU_ing despise this ... whatever this is. I wish I could just wake up in some sort of parallel universe where everything is just sunshine and rainbows, alas, life would be just as meaningless.

_and sorry you had to read this if you did._
I'm usually comfortable keeping my hardship to myself, most especially AWAY from the internet; an act of kindness of sorts towards others, "Everyone's got their own problems to worry about" kind of thing.. But maaan am I starting to believe creating a twitter account would be a healthy decision 🤣🤦 Read nothin' out there, just a one way echo chamber of sorts to let that shi_ out of my chest. It seem that's what everyone else's been using it for all this time.

A Bsky would be even better! 😂 I'd get to shi_ post and yap all I want, allll the way from terminal and never ever have to look back at it or whatever comes out of it. But I digress...

I FU_ing despise this ... whatever this is. I wish I could just wake up in some sort of parallel universe where everything is just sunshine and rainbows, alas, life would be just as meaningless.

_and sorry you had to read this if you did._
@aelaraji sorry to hear, mate. Hoping and wishing everything gets, and stays, better.
🧮 USERS:1 FEEDS:2 TWTS:1207 ARCHIVED:83421 CACHE:2846 FOLLOWERS:17 FOLLOWING:14
Shit in my life has been spiraling out of control at an unbelievable rate. And just when you think life can't get shittier it dumps an even bigger N° 2 on yO face.
Shit in my life has been spiraling out of control at an unbelievable rate. And just when you think life can't get shittier it dumps an even bigger N° 2 on yO face.
@bender oh yeah i remember that part of the docs lol! honestly yeah i think sqlite is fine for the number of users i have which is like, 5 including me, and active users is just... me, but if i were to have more active users i could always spin up a separate instance as jank as that is
@bender oh yeah i remember that part of the docs lol! honestly yeah i think sqlite is fine for the number of users i have which is like, 5 including me, and active users is just... me, but if i were to have more active users i could always spin up a separate instance as jank as that is
@lyse thanks for checking! it is a work in progress. i journal as well so may just be a manual process to get some of the data back in, but not going to rush it unless it is dorking someone's feed.
@lyse thanks for checking! it is a work in progress. i journal as well so may just be a manual process to get some of the data back in, but not going to rush it unless it is dorking someone's feed.
@lyse thanks for checking! it is a work in progress. i journal as well so may just be a manual process to get some of the data back in, but not going to rush it unless it is dorking someone's feed.
Though my use of words wasn't the best, I would agree. It certainly is possible. 😅
@movq I was referring to their documentation advice, mostly:

> "GoToSocial supports both SQLite and Postgres as database drivers. Though it is possible in theory to swap your database from SQLite to Postgres or vice versa, we do not currently have tooling to support this, so you should consider your choice of database carefully when starting out.
>
> SQLite is the default driver and it's been shown to work brilliantly for instances in the range of 1-30 users (or maybe more)."
@movq wait until you hear of 2026. 😂
At least Minnesota won their bowl game. Go Gophers!
@prologic @eapl.me @bender I just found:

> Equilibrium problems are solved by method of relaxation numerically.
>
> – Manoj Kumar and Garima Mishra, https://www.scirp.org/html/8798.html

Reminds me of deliberately misattributed quotes from a funny German book series "Die Känguru-Chroniken", like:

> How much is the fish?
>
> – Karl Marx

I'm positively surprised there is even an English wikipedia page about The Kangaroo Chronicles. Somebody gathered a list with all of them.
@bmallred Oh no! Best of luck to restore everything. Unfortunately, I cannot provide you a copy of your twtxt feed. It turns out when the messages were gone from your feed and I refetched the now empty feed, all messages were also dropped from my local cache. :-/ But it looks like you're on something already. The message timestamps are all way off, though.
check out this awesome internet radio it looks cool and they play bangers https://radio.cock.institute/shows
check out this awesome internet radio it looks cool and they play bangers https://radio.cock.institute/shows
@kingdomcome https://www.youtube.com/watch?v=49RHJRUHfHw
@kingdomcome https://www.youtube.com/watch?v=49RHJRUHfHw
my apologies for anyone tailing this feed... turns out some data was corrupted from an unscheduled interruption and in the process of getting everything back online.
my apologies for anyone tailing this feed... turns out some data was corrupted from an unscheduled interruption and in the process of getting everything back online.
my apologies for anyone tailing this feed... turns out some data was corrupted from an unscheduled interruption and in the process of getting everything back online.
@ Are we sure it's not still 2005? That's more realistic imo
I have "gay for a girl" disease & it's fatal
@movq @kat Agreed!
@movq ooooh interesting!!! i am a mysql liker because postgres syntax confuses me (i know its faster but whatever) but i will look into this...
@movq ooooh interesting!!! i am a mysql liker because postgres syntax confuses me (i know its faster but whatever) but i will look into this...
@movq fake ass scifi year
@movq fake ass scifi year
@kat Pics or it didn't happen! We were already back at 14°C today. But there might be chance of snow towards the end of the week. Let's see.
“2025” doesn’t look right. That looks like a date which is absurdly far into the future. Like 2199 or something.
“2025” doesn’t look right. That looks like a date which is absurdly far into the future. Like 2199 or something.
“2025” doesn’t look right. That looks like a date which is absurdly far into the future. Like 2199 or something.
“2025” doesn’t look right. That looks like a date which is absurdly far into the future. Like 2199 or something.
@kat @bender We’ve used pgloader at work to migrate an old legacy application from MySQL to PostgreSQL. Their website says it also works with SQLite. 🤔
@kat @bender We’ve used pgloader at work to migrate an old legacy application from MySQL to PostgreSQL. Their website says it also works with SQLite. 🤔
@kat @bender We’ve used pgloader at work to migrate an old legacy application from MySQL to PostgreSQL. Their website says it also works with SQLite. 🤔
@kat @bender We’ve used pgloader at work to migrate an old legacy application from MySQL to PostgreSQL. Their website says it also works with SQLite. 🤔
… and then there’s SVED from SvarDOS at 6035 bytes. Oh, dear!

Good thing is, SVED is free software:

https://github.com/SvarDOS/core/tree/master/sved/trunk
… and then there’s SVED from SvarDOS at 6035 bytes. Oh, dear!

Good thing is, SVED is free software:

https://github.com/SvarDOS/core/tree/master/sved/trunk
… and then there’s SVED from SvarDOS at 6035 bytes. Oh, dear!

Good thing is, SVED is free software:

https://github.com/SvarDOS/core/tree/master/sved/trunk
… and then there’s SVED from SvarDOS at 6035 bytes. Oh, dear!

Good thing is, SVED is free software:

https://github.com/SvarDOS/core/tree/master/sved/trunk
@kat I think it is kind of impossible to switch from sqlite to Postgres. I have run GtS on sqlite from get go, no issues. Granted, single user instance, but still...
my fucking second drive for plex isn't auto mounting with fstab on reboot for some reason and i keep accidentally discovering this it's super annoying
my fucking second drive for plex isn't auto mounting with fstab on reboot for some reason and i keep accidentally discovering this it's super annoying
@kat i'm an LXQt girlie for life and i like the convenience of apt despite that they never update their god damn packages so i guess i'm stuck on lubuntu for everything
@kat i'm an LXQt girlie for life and i like the convenience of apt despite that they never update their god damn packages so i guess i'm stuck on lubuntu for everything
been thinking about trying arch linux but no i will not become the type of person that uses arch
been thinking about trying arch linux but no i will not become the type of person that uses arch
@kat fun* lol*
@kat fun* lol*
i wanna make more videos........ editing in shotcut is kinda fnu
i wanna make more videos........ editing in shotcut is kinda fnu
@bender epic!!!
@bender epic!!!
@kay "when it rains, it pours!" :-D
@kat wow, thanks for sharing that guide! I have now used it on my better tuned instance. Woot!
i need to try htmx out
i need to try htmx out
@kat i can't WAITTTTTTTTT
@kat i can't WAITTTTTTTTT
guys i might be getting a framework laptop from my aunt i'm freaking out
guys i might be getting a framework laptop from my aunt i'm freaking out
i'm pretty sure i'm running this all off sqlite so if i get too many users on here i might be cooked but oh well i can always try to migrate (<-- has heard migrations from sqlite to mysql/postgres are hell)
i'm pretty sure i'm running this all off sqlite so if i get too many users on here i might be cooked but oh well i can always try to migrate (<-- has heard migrations from sqlite to mysql/postgres are hell)
@bender soon there'll be dozens of us!!!!!!
@bender soon there'll be dozens of us!!!!!!
@kat ...

> "we are invading the humble twtxt/yarn network"

LOL. @prologic loves it. He wants it to grow a little. He told me. More than once!
[47°09′52″S, 126°43′43″W] Dosimeter overflow
@kat i still need to put it together so either i'll do it off camera or i'll wait till i get my memory card
@kat i still need to put it together so either i'll do it off camera or i'll wait till i get my memory card
i thought about making a chill little vlog putting together my new pi4 for KVM purposes but unless i make it go fast somehow i'd probably quickly exceed the 30 mins on the last mini DVD i have for recording lol
i thought about making a chill little vlog putting together my new pi4 for KVM purposes but unless i make it go fast somehow i'd probably quickly exceed the 30 mins on the last mini DVD i have for recording lol
@kingdomcome :DDDD
@kingdomcome :DDDD
@kat Spreading the good word (red velvet songs)
@kingdomcome if yarn had boosts i'd boost the shit out of this
@kingdomcome if yarn had boosts i'd boost the shit out of this
@kat Miku miku oo wee oo 🎶
getting my friends to join here is so fun. we are invading the humble twtxt/yarn network
getting my friends to join here is so fun. we are invading the humble twtxt/yarn network
@kingdomcome hiding in my wifi....
@kingdomcome hiding in my wifi....
@kingdomcome HIIIIIIIIII I'M VIBING AND INHALING COFFEE
@kingdomcome HIIIIIIIIII I'M VIBING AND INHALING COFFEE
The Ireneification of twtxt is in progress
HEY KAT WHAT'S UP!!!!!!!
IT'S SNOWING BTW IT'S SO PRETTY OUT
IT'S SNOWING BTW IT'S SO PRETTY OUT
@kat i'm reading this and i already have a gts server that i could secure with this but i'm thinking it'd be best for most of my public sites https://ovelny.sh/blog/a-complete-guide-for-your-gotosocial-server/
@kat i'm reading this and i already have a gts server that i could secure with this but i'm thinking it'd be best for most of my public sites https://ovelny.sh/blog/a-complete-guide-for-your-gotosocial-server/
hmmm i really should set up crowdsec and maybe a WAF like coraza or something. i don't look at my logs as much as i should because they scare me and ignorance is bliss but i should probably cut out as much false traffic as possible especially to my biggest site (superlove)
hmmm i really should set up crowdsec and maybe a WAF like coraza or something. i don't look at my logs as much as i should because they scare me and ignorance is bliss but i should probably cut out as much false traffic as possible especially to my biggest site (superlove)
morning friends (it is 1pm here)
morning friends (it is 1pm here)