I’m planning to use SQLite rather than Postgres for Prose’s server component. Anyone care to explain why that might not be the best choice?
1286004
@shawn if things get complicated, the vast tools are nice. But yeah, sqlite is the wtb with a project like this IMO.
1286033
@33MHz I’ve seen a few people who work primarily with Swift choose Postgres, but I think it might just be preference. I should probably just ask them directly in case there’s some upside to Swift integration… but I’m shy
1286041
@shawn well psql has all the typing benefits I would think. But little projects with thousands of rows, few tables… sqlite is portable, simple.
1286042
@33MHz yeah, I don’t think it’s a huge deal either way. I was thinking Postgres could have better type parity but the myriad of sqlite3 based projects on GitHub means weird Swift integration bugs are pretty well documented.

🍅🥫🤷‍♂️
1286047