Should connection to the DB be always open or should I only open it when I need it?

@wowaname A script that parses the Mastodon profile static UI and saves every user and status it find into a DB

@matrix keeping db open is probably fine. sqlite db or something else?

@wowaname
Yeah. It's just SQLite. Should I do deduplication with the DB or in code? I want to make it multithreaded, so I think it's probably easier to just have the DB handle it.

@r000t
Experience. Your client is going to parse Mastodon's static UI? Awesome.
@wowaname

@matrix
Everyone is going to turn off the public API when that shit drops.

The static parser will be released shortly thereafter. I'm literally holding it back until admins start saying "phew! that client can't ever see my instance no matter what! I'm am very intelligent."

@wowaname

@r000t
That's a pretty great plan. I'm looking forward to the screeching. How are you going to handle Pleroma since it doesn't have a static UI?
@wowaname

Follow

@r000t @wowaname
If my attempt turns out ok. I might deploy it and make a simple web that's going to allow everyone to search through it.

@matrix @r000t would be cool to crowdsource all instance histories into one cohesive database for searching

yes i said fedi's ephemeral but theres the pyromaniac inside me calling this a good idea

@wowaname
That all comes down to getting signatures for every status and if I recall, that's one of the things authenticated fetch disables.
@matrix

Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.