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 🎩
@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 👨🏼💻
@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 👨🏼💻
@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 🎩
@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 👨🏼💻
@0xbob
Only to not query the DB too much or the FPL api 😂
1 reply
0 recast
1 reaction
Carl Gustaf 👨🏼💻
@0xbob
Ah that’s good! KV (Key, value) so I’m using it as like if people were betting I saved it in KV db intermediate: Bet 1: key: match:1 value: 1/X/2 As example and then when you submit it pushed everything to the DB. So I used some strategies like that and cached also the matches there instead of getting from db.
1 reply
0 recast
1 reaction
