Conversation

Notices

1. Embed this notice
   寮 (ryo@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:04:41 JST 寮
   OK, I'm done with soycial media, including Fediverse
   For I2P: http://ryocafe.i2p/blog/done-with-sns/
   For Tor: http://asc7ewkcvat2wsoi5yuwkej5ukyrqqnpnzpj4u34r2jxnoxhnbx6yqad.onion/blog/done-with-sns/
   • Udon and :tiny_star: :lts_1: ジュース :lts_2: :tiny_star: small penis association like this.
   • Embed this notice
     寮 (ryo@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:48:15 JST 寮

     in reply to

     • xianc78
     @xianc78 I will set up an XMPP server over the weekend, don't worry.
     The reason why I only did IRC for now is due to a lack of time.
     Setting that one up took quite a bit of time already, since it's my first time setting one up on the darknet.
   • Embed this notice
     xianc78@gameliberty.club's status on Friday, 09-Dec-2022 12:48:16 JST xianc78

     in reply to

     @ryo Sad to see you go, but I perfectly understand. I will try to get I2P to work with an IRC client. I wished you went with XMPP instead though (messages are temporarily archived and visible without typing some command).

     寮 likes this.
   • Embed this notice
     fluoride (fluoride@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:48:57 JST fluoride

     in reply to
     @ryo you will be missed o7 :boseki:
   • Embed this notice
     fluoride (fluoride@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:48:57 JST fluoride

     in reply to

     • fluoride
     @ryo actually see you on IRC when im on my real computer
     寮 likes this.
   • Embed this notice
     paulo (paulo@marsey.moe)'s status on Friday, 09-Dec-2022 12:49:06 JST paulo

     in reply to
     @ryo sad
     寮 likes this.
   • Embed this notice
     xianc78@gameliberty.club's status on Friday, 09-Dec-2022 12:51:14 JST xianc78

     in reply to

     @ryo Make sure you have archived messages.

     寮 likes this.
   • Embed this notice
     寮 (ryo@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:51:14 JST 寮

     in reply to

     • xianc78
     @xianc78 Of course.
   • Embed this notice
     寮 (ryo@social.076.ne.jp)'s status on Friday, 09-Dec-2022 12:52:39 JST 寮

     in reply to

     • xianc78
     • opal hart
     @xianc78 @opal I have yet to look into that, but so far what turns me off from that is that it's written in Python.
     I just don't want to waste time fixing it all the time.
   • Embed this notice
     xianc78@gameliberty.club's status on Friday, 09-Dec-2022 12:52:40 JST xianc78

     in reply to

     • opal hart

     @opal @ryo He really hates frameworks. I wish he would just set up a twtxt feed on his site instead.

     Udon likes this.
   • Embed this notice
     opal hart (opal@ap.maladaptive.art)'s status on Friday, 09-Dec-2022 12:52:42 JST opal hart

     in reply to

     • xianc78
     • opal hart
     @xianc78 i mean @ryo's reasons for leaving are hilarious, im reading the post right now and it makes no sense, but whatever
   • Embed this notice
     opal hart (opal@ap.maladaptive.art)'s status on Friday, 09-Dec-2022 12:52:46 JST opal hart

     in reply to

     • xianc78
     @xianc78 @ryo oh do i have to get on irc2p again
   • Embed this notice
     xianc78@gameliberty.club's status on Friday, 09-Dec-2022 14:49:40 JST xianc78

     in reply to

     • opal hart

     @ryo @opal It's just a text file and there are many different clients.

     I update my feed using
     echo -e "`date -Im`\tInsert text here" >> twtxt.txt!

     Though I only have two posts on my feed so far.

     寮 likes this.
   • Embed this notice
     寮 (ryo@social.076.ne.jp)'s status on Friday, 09-Dec-2022 14:51:19 JST 寮

     in reply to

     • xianc78
     • opal hart
     @opal @xianc78 Well, I literally explained within the blog post.
   • Embed this notice
     opal hart (opal@ap.maladaptive.art)'s status on Friday, 09-Dec-2022 14:51:21 JST opal hart

     in reply to

     • xianc78
     @xianc78 @ryo that doesnt explain valuing mysql over postgres at all lmao
   • Embed this notice
     寮 (ryo@social.076.ne.jp)'s status on Saturday, 10-Dec-2022 13:46:22 JST 寮

     in reply to

     • Wrongthink
     • SuperDicq
     • Nue :blobcatreadingsicp:
     @parappanon @SuperDicq @wrongthink
     MariaDB is less strict (it doesn't care if the value is an int or varchar for example), has less features (for example, you need to store booleans as integers, because MySQL doesn't have booleans), and is a little bit slower, but it's much easier to setup and maintain, SQL is more straightforward, doesn't come with weird bullshit (and if it does, it doesn't force you into using it), and at least from my experience it runs perfectly fine for many years.
     
     For Postgres, simply invert all of the above.
     
     Also, the main mascot for MySQL is a dolphin, Postgres is an elephant, and MariaDB is a seal.
   • Embed this notice
     Nue :blobcatreadingsicp: (parappanon@cdrom.tokyo)'s status on Saturday, 10-Dec-2022 13:46:24 JST Nue :blobcatreadingsicp:

     in reply to

     • Wrongthink
     • SuperDicq
     @SuperDicq @wrongthink @ryo My only big experience when it comes to databases is Postgres, and that's because I've needed it for the parappa.party Matrix. Overall I'd say Postgres is fine, but I'm up for trying out MySQL/Maria once I get the opportunity to.
     What would you say are the big differences between MySQL/MariaDB and Postgres?
   • Embed this notice
     SuperDicq (superdicq@cdrom.tokyo)'s status on Saturday, 10-Dec-2022 13:46:25 JST SuperDicq

     in reply to

     • Wrongthink

     @wrongthink @ryo Nope, Pleroma/Akkoma has a hard dependency on Postgresql.

     I’m personally more of a MySQL/MariaDB/Percona fan as well and would use that if it was possible.

   • Embed this notice
     Wrongthink (wrongthink@cdrom.tokyo)'s status on Saturday, 10-Dec-2022 13:46:26 JST Wrongthink

     in reply to

     @ryo I was going to dive into fediverse hosting but after reading up on the pleroma/akkoma split and then your insights on DBs, I think I’ll hold off for a bit. It looks like there’s no way I can substitute mariaDB into place during installation.

   • Embed this notice
     SuperDicq (superdicq@cdrom.tokyo)'s status on Saturday, 10-Dec-2022 21:08:49 JST SuperDicq

     in reply to

     • Wrongthink
     • Nue :blobcatreadingsicp:

     @parappanon @ryo @wrongthink From my experience MySQL/MariaDB is a lot smarter when it comes to caching and optimalization. From my experience with Postgresql it always needs constant maintenance like vacuum jobs and tweaking settings to keep it running, MySQL/MariaDB does a lot of these things automatically.

     寮 likes this.
   • Embed this notice
     xianc78@gameliberty.club's status on Sunday, 11-Dec-2022 01:39:55 JST xianc78

     in reply to

     • Wrongthink
     • ​:hyperfastparrot:​ nekobit ​:cat_sui_2:​

     @wrongthink @ryo I wonder how hard it would be to write an ActivityPub implementation from scratch. The official documentation for ActivityPub looks pretty confusing to me.

     You could just wait until Wormhole is finished. But I don't know what @neko is using for database.

     寮 likes this.