Post AVaePcMhPkztVRFzQe by brendan@out.ruin.io
(DIR) More posts by brendan@out.ruin.io
(DIR) Post #AVaUblddlOaoCSKs4G by louis@emacs.ch
2023-05-12T18:50:26Z
1 likes, 0 repeats
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
(DIR) Post #AVaWq7mQRCW8pkQ0ga by dekkzz76@emacs.ch
2023-05-12T19:11:09Z
0 likes, 0 repeats
@louis is this your weekend project?
(DIR) Post #AVaWq8OMAArIjOAIoC by louis@emacs.ch
2023-05-12T19:15:26Z
0 likes, 0 repeats
@dekkzz76 Just daydreaming, although it's already late evening 🙂
(DIR) Post #AVaePcMhPkztVRFzQe by brendan@out.ruin.io
2023-05-12T20:40:17Z
0 likes, 0 repeats
@louis personally, I’d leave the Postgres part. The rest sounds great.
(DIR) Post #AVahnb4QBD2SIppivg by clacke@libranet.de
2023-05-12T19:21:49Z
0 likes, 0 repeats
@louis I don't have the details on #GoToSocial and haven't used it, but it covers at least half of that, and maybe it could be made to cover the other half too.
(DIR) Post #AVahnbghsrfCDZkIbY by louis@emacs.ch
2023-05-12T21:18:12Z
0 likes, 0 repeats
@clacke Thanks, yes it looks very interesting. Definitively on the right track - would be interesting to contribute.
(DIR) Post #AVbB5hsyTbEnK7T0FM by anthracite@dragon.style
2023-05-13T02:46:27Z
0 likes, 0 repeats
@louis That sounds pretty nice. Add in “separates presentation and styling so I can make my own custom about pages/themes/etc and have them persist across upgrades” and it’s basically what I’ve been dreaming of.Oh and “comes with sane remote media purge defaults” too.
(DIR) Post #AVecPi5CjVnjxnpVVg by ChlorideCull@masto.fuzzy.systems
2023-05-14T18:36:39Z
0 likes, 0 repeats
@louis Sounds too good to be true :dragnmlem:
(DIR) Post #AVfubnywcRQw4DmLM8 by alex@gleasonator.com
2023-05-15T09:35:14.506229Z
0 likes, 0 repeats
@louis How do you do full text search without elasticsearch or postgres?
(DIR) Post #AVfugo8vRpc80wpgx6 by charliebrownau@poa.st
2023-05-15T09:36:17.448122Z
0 likes, 0 repeats
@alex @louis Try SearX instead
(DIR) Post #AVfuhYEA6h8QwVdWV6 by louis@emacs.ch
2023-05-15T09:36:22Z
0 likes, 0 repeats
@alex Sqlite has a great FTS engine:RAILS_ENV=production ./tootctl --help
(DIR) Post #AVfuj7q7Bg85gJ8hcm by louis@emacs.ch
2023-05-15T09:36:40Z
0 likes, 0 repeats
@alex Sqlite has a great FTS engine:https://www.sqlite.org/fts3.html
(DIR) Post #AVfundO7pg6ygaCIs4 by alex@gleasonator.com
2023-05-15T09:37:24.600876Z
0 likes, 0 repeats
@louis Wow I didn't know that!
(DIR) Post #AVfv1wk6fZjalcIsmO by mint@ryona.agency
2023-05-15T09:39:18.140230Z
1 likes, 1 repeats
@alex @louis Sphinxsearch is still a thing as well.http://sphinxsearch.com/about/sphinx/
(DIR) Post #AVfv519shzFLKZp9Ki by louis@emacs.ch
2023-05-15T09:40:37Z
0 likes, 0 repeats
@alex btw. is there a way to migrate a Mastodon server to Soapbox/Rebased? I.e. a DB migration script?
(DIR) Post #AVfvO1B0rg6AtDPge0 by alex@gleasonator.com
2023-05-15T09:44:00.369989Z
2 likes, 0 repeats
@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.
(DIR) Post #AVfvySCXrgaB88VJA0 by alex@gleasonator.com
2023-05-15T09:50:34.317428Z
0 likes, 0 repeats
@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.
(DIR) Post #AVfxL5J1FwR8jet4DY by i@declin.eu
2023-05-15T10:05:58.346694Z
1 likes, 0 repeats
@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
(DIR) Post #AVfyBHp9xSv8cQoQaG by grips@cawfee.club
2023-05-15T10:15:05.637423Z
4 likes, 0 repeats
@alex @louis grep :trollface:
(DIR) Post #AVfz08A3e0V5Q0pclU by louis@emacs.ch
2023-05-15T10:24:33Z
0 likes, 0 repeats
@alex I'm always open for a good challenge 🙂 Mastodon currently has "only" 91 DB tables. What about Rebased?Unless there is some magical stuff in there, it should be possible to transform and map that data to the Rebase model?
(DIR) Post #AVg9hiZR9MeqKl7pGS by feld@bikeshed.party
2023-05-15T12:24:07.523441Z
0 likes, 0 repeats
> handles 20+ times the traffic on the same machineHow are you going to do 20x traffic with a database that is limited to one writer LOL
(DIR) Post #AVgJGmvnpOdfa6Nt56 by dragnucs@social.touha.me
2023-05-15T10:45:39Z
1 likes, 0 repeats
@alex @louis you van do with some alternatives like https://www.meilisearch.com/