Nicolás Parada Subreply feels pretty fast. Which stack does it use? Have you writen any technical showoff of it @lucian ? I've been making a social app on youtube and I've taken inspiration from subreply youtube.com/playli... :)

🏒 Lucian Marin I'm using a Python stack: Falcon as web framework, Django for ORM, PostgreSQL, PgBouncer to keep DB connections hot, Gunicorn for async and multithreading HTTP requests, sockets for connections between each stack component to reduce latency. I pay vultr.com/?ref=894... for a high frequency Intel server to reduce latency even further.

Nicolás Parada Awesome. Doesn't look anything crazy. Maybe it is just a well designed and simple database schema... How do you query the feed from SQL. Do you use fan-out, or fan-in?

🏒 Lucian Marin For feed I fetch ids of friends and pass them as filter to entries table. The only optimization here is that you friend yourself when you register. With Subreply and github.com/lucianm... I want to prove that Python can be fast enough for real world usage.