Did some benchmarking of some relational db stuff ...
# randomt
thdxr
10/20/2021, 7:36 PMDid some benchmarking of some relational db stuff ahead of some of the work we're doing for RDS:
https://thdxr.com/post/serverless-relational-showdown
a
Adrián Mouly
10/20/2021, 8:17 PMSo I should move away from SQL then?
Adrián Mouly
10/20/2021, 8:18 PMAnd replace all with Dynamo?
t
thdxr
10/20/2021, 8:25 PMWell where it makes sense to. I can see why people would want to stay with a relational db though especially when you need to sort/filter data by a large set of attributes
thdxr
10/20/2021, 8:25 PMI think with data api and more so planetscale you get a pretty good experience
a
Adrián Mouly
10/20/2021, 8:27 PMWell reporting and such also.
Adrián Mouly
10/20/2021, 8:27 PMAnd SQL is flexible IMO.
Adrián Mouly
10/20/2021, 8:27 PMYou don’t know what you will need tomorrow.
t
thdxr
10/20/2021, 8:28 PMYeah dynamo does poorly with reporting or admin type interfaces
t
Tomasz Sobczyk
10/21/2021, 10:24 AMyeap - admin / reporting stuff is usually a table, easiest to map to ... structured tables - so SQL wins there 😄
s
Sean Matheson
10/26/2021, 2:57 PMNice dude. Great insight. Are these open sourced? 🙂
Sean Matheson
10/26/2021, 2:57 PMI had no idea about Planetscale. It looks frikken fantastic.
Sean Matheson
10/26/2021, 2:58 PMInterested to know if you just used a "native" mysql driver when querying it?
t
thdxr
10/26/2021, 3:40 PMare you asking if the benchmark is open sourced?
thdxr
10/26/2021, 3:40 PMYeah native mysql driver through kysely - they do some magic on their end to reinvent mysql's connection protocol so it doesn't map directly to transactions - which means it can scale to millions of conns whihc is perfect for lambda