Conversation

Notices

1. Embed this notice
   Louis (louis@emacs.ch)'s status on Monday, 15-May-2023 18:35:22 JST Louis

   Hmm.. just contemplating.. how does a Mastodon™ API-compatible server, that runs on SQLite, offers full-text search w/o Elasticsearch, is a single binary, handles 20+ times the traffic on the same machine, fully migrates existing Postgres databases and supports multi-instance hosting, sound to you operators? 🤔

   I'm sure that must already exist somewhere? 🍿 I'm sure ...

   #MastoAdmin #instance #MastodonDevs

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Monday, 15-May-2023 18:35:20 JST Alex Gleason

     in reply to
     @louis How do you do full text search without elasticsearch or postgres?
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Monday, 15-May-2023 18:37:30 JST Alex Gleason

     in reply to
     @louis Wow I didn't know that!
   • Embed this notice
     Louis (louis@emacs.ch)'s status on Monday, 15-May-2023 18:37:31 JST Louis

     in reply to

     • Alex Gleason

     @alex Sqlite has a great FTS engine:

     https://www.sqlite.org/fts3.html

   • Embed this notice
      (mint@ryona.agency)'s status on Monday, 15-May-2023 18:41:26 JST 

     in reply to

     • Alex Gleason
     @alex @louis Sphinxsearch is still a thing as well.
     http://sphinxsearch.com/about/sphinx/
     Alex Gleason likes this.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Monday, 15-May-2023 18:44:04 JST Alex Gleason

     in reply to

     • 
     @mint @louis I want something embedded. I'm thinking about using a KV store and tacking on search somehow, but this is making sqlite more attractive.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Monday, 15-May-2023 18:50:39 JST Alex Gleason

     in reply to
     @louis Technically possible yes, but not worth it. https://gitlab.com/soapbox-pub/migrator This script no longer works. Fediverse software should just support dumping its data in ActivityPub format, but believe it or not Mastodon is not designed around ActivityPub, so it would be a big maintenance burden and they likely never will.
   • Embed this notice
     Louis (louis@emacs.ch)'s status on Monday, 15-May-2023 18:50:41 JST Louis

     in reply to

     • Alex Gleason

     @alex btw. is there a way to migrate a Mastodon server to Soapbox/Rebased? I.e. a DB migration script?

   • Embed this notice
     :blank: (i@declin.eu)'s status on Monday, 15-May-2023 19:16:15 JST :blank:

     in reply to

     • 
     • Alex Gleason
     @alex @louis @mint apache ignite could work, scaling from in memory to disk to cluster, with lucene indexing inbuilt, but then you're stuck with JVM/CLR for it to actually embed into...
     
     sqlite is inevitable
     Alex Gleason likes this.
   • Embed this notice
     feld (feld@bikeshed.party)'s status on Monday, 15-May-2023 21:24:18 JST feld

     in reply to
     > handles 20+ times the traffic on the same machine
     
     How are you going to do 20x traffic with a database that is limited to one writer LOL
   • Embed this notice
     التنينوكس (dragnucs@social.touha.me)'s status on Monday, 15-May-2023 23:11:39 JST التنينوكس

     in reply to

     • Alex Gleason

     @alex @louis you van do with some alternatives like https://www.meilisearch.com/

     Alex Gleason likes this.