Kyle Mathews
@kam
Big announcement! I'm now a co-founder at @electricsql along with the James/Valter and the brilliant team they've built. We're solving local caching of Postgres data. Electric is a VC-backed devtools OSS startup. We're close to our first beta release so come check us out!
7 replies
12 recasts
481 reactions
JB Rubinovitz ⌐◨-◨
@rubinovitz
Exciting! really looking forward to when electric is production ready enough for me to sync Farcaster data there
1 reply
0 recast
1 reaction
Kyle Mathews
@kam
That'd be a sweet use case! We're doing lots of stress testing right now. What roughly is the data volume and throughput farcaster has these days?
1 reply
0 recast
0 reaction
Kyle Mathews
@kam
Hmm or how would I get a real-time feed of farcaster into postgres? This would be an interesting experiment
1 reply
0 recast
0 reaction
JB Rubinovitz ⌐◨-◨
@rubinovitz
I’d need to lookup the first question, but this is the cheapest Farcaster -> Postgres service I’ve found One issue I foresee using the raw data is whether electric can handle aggregating reaction sums for posts. https://console.indexing.co/marketplace/66bc3153a7dc315543ae1480
1 reply
0 recast
1 reaction
Kyle Mathews
@kam
We don't manipulate the data ourselves, just replicate shapes. So any aggregation would be done at the destination
0 reply
0 recast
0 reaction
