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