🏒 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.
Nicolás Parada
Impressive. Feels very fast even tho it doesn't have any read optimization. Kudos.
🏒 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?
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.