What if we treated Postgres like SQLite?

TLDR: a dude ponders if postgres could be used instead of sqlite. Close to zero useful information, no learnings from serious production use.

Indeed pondering! The dude here. I think writing a little piece like that often sparks some interesting discussions here and elsewhere. :-)

I upvoted this, because while it was critical it didn't feel meanspirited and it was factually correct.

After fully reading the article I came to understand it really was not referring to anything sqllite specific, was really 'what if you ran postgres as an application on a server', there really is nothing more to be gained from reading the article beyond this, and this is kind of the most basic deployment model for postgres for like the last 40 years.

I agree. Having read my comment I must apologize as it came out too dismissive. Keep pondering, dude :)

Sure, you are correct! But I've already learned about pglite and sqlite-vector from the comments here alone. So if one reads the article AND the comments, I hope it's a net-positive for you, too, even if the article alone didn't give you anything.

And if not, I hope you didn't spend too long reading. :-)

No worries. :-) Thank you for your follow-up, kind stranger on the internet.