Email or username:

Password:

Forgot your password?
dansup

It's technically possible to run pixelfed with a sqlite database, though I can't guarantee that every SQL query is supported atm

I'm working to remove Redis as a dep

and

add basic sqlite support for one-click installs (meant for low use instances of 10 or fewer users)

Can you imagine, we don't require npm so this could be as easy as WordPress to install, or easier with a no-config sqlite db

8 comments
Cameron

@dansup Interesting. Are going to use some non-redis based memory caching to avoid the issue of SQLite not supporting concurrent writes to the database, or is the performance still ok even for 10 users?

dansup

@bitflipped Nope, the sqlite support is mostly for our tests, though it can be used but like you pointed out, the locking nature of sqlite would make it challenging

blhue

@dansup I’m always +1 on removing Redis from projects where possible. I find it’s often thrown in as a crutch to overcome a performance issue that could be handled better otherwise (schema/query improvements, Dynamo (or the like), etc.

dansup

@blhue Redis is really useful for larger instances, but for smaller ones, they can def get by with the database.

The challenges that masto/pf have are not common, and tbh would be probably better served with a graph database but that's a toot for another day

Morten Bech

@dansup That would be awesome! I’d love to be able to run a small personal instance 🤩

Rob Adamson

@dansup Watching you develop this out has been very educational as someone new to the Fediverse via Mastodon so thank you. Can’t wait to get my own instance up and running when its optimal for NAS/Docker. PixelFed more than other parts of the Fediverse suits a self host. And congrats on the Wired article!

Claudius

@dansup in a containerized world, I would not put too much effort into Sqlite support. Sqlite is great for other things.

Go Up