Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
I scored 128 points in the Football Quiz on Falsenine! 🏆 Can you beat my score? @kmacb.eth 👀
1 reply
0 recast
7 reactions
KiddⓂ️etro 🎩 pfp
KiddⓂ️etro 🎩
@lorenzo-007
i was about to tag you for your predicition frame what did you use as the database backend i am looking for something free and can allow wide range of data
1 reply
0 recast
2 reactions
Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
Postgres and used upstash they have some good deals for free. It could be a bit rate limiting if you are developing and hitting database a lot. I used vercel and cache there to try to not get as much database queries and stuff. I would also use cloudflare now with their caching if I still built it.
1 reply
0 recast
2 reactions
Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
@lorenzo-007 sorry I meant neon Postgres and use KV db too from vercel for some caching logic.
1 reply
0 recast
1 reaction
KiddⓂ️etro 🎩 pfp
KiddⓂ️etro 🎩
@lorenzo-007
Alright thanks fam Already using it rn will think about the caching logic lol full meaning of KV please 😞
2 replies
0 recast
1 reaction
Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
Only to not query the DB too much or the FPL api 😂
1 reply
0 recast
1 reaction
KiddⓂ️etro 🎩 pfp
KiddⓂ️etro 🎩
@lorenzo-007
Now I understand what you mean 🤣🤣🤣 Let me fix it now I hope I can
1 reply
0 recast
1 reaction
Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
Haha yes and the fpl api is not documented either so I didn’t know if I hit it too much I would get time’d out so I just went for that instead creating a cache 😂
1 reply
0 recast
1 reaction
KiddⓂ️etro 🎩 pfp
KiddⓂ️etro 🎩
@lorenzo-007
Wait you were timed out for calling the api all the time?
1 reply
0 recast
1 reaction
Carl Gustaf 👨🏼‍💻 pfp
Carl Gustaf 👨🏼‍💻
@0xbob
Haha no I wasn’t but as it’s not documented I had no idea if it had any “rate limits” instead of just getting timed out if they had it. So I just played it safe and implemented the cache and a cron job on vercel every hour to check the fixture and stuff to update the cache.
1 reply
0 recast
1 reaction