Optional postgres support

It would be nice if microblog.pub allowed using Postgres as a database, instead of SQLite. After a quick glance over the code it doesn't seem like there is anything SQLite-specific about the app, other than the hard-coded database connection string, so maybe it wouldn't be hard to add?

I know that for many SQLite is very convenient for its low setup overhead, but in my case, I already run a Postgres server which a few of my apps use, and I have all necessary infrastructure around it, such as backups, so consolidating all data in one place would simplify some things for me.


Assigned to
1 year, 5 months ago
1 year, 5 months ago
No labels applied.

~tsileo 1 year, 5 months ago*


Please take a look at: https://todo.sr.ht/~tsileo/microblog.pub/83

I understand your point, but to summarize, I don't think I will have the bandwidth to support multiple databases, and I have some work in progress that uses SQLite-specific extensions (FT5).

~nevkontakte 1 year, 5 months ago

I see, that's fair. SQLite it is then. Thanks for a quick response!

~tsileo REPORTED CLOSED 1 year, 5 months ago

Register here or Log in to comment, or comment via email.