>>13006
I don't know about bun's postgres module, but SQL databases are more than capable of handling the load of a site like this. Halfchan runs on MySQL (probably a very old version). You don't actually need super extensive scaling. Most of the workload on the database is ready-heavy operations, which are simple to cache, so requests don't even have to hit your database at all. You can use stuff like memcached, Redis, Varnish (fullchan definitely uses this), etc.
I don't think you can leverage the advantages Mongo would offer, while the drawbacks are immediate. I'm pretty sure it doesn't make the site any faster.
I'd be more interested in the backend of this site if it used SQL because I personally like SQL and don't like Mongo too much.