Man… I thought this was going to be a proper rant about using maps where you should be using other things… No, it’s a make sure you type your function inputs rant…
Family Man, Cheer Dad, Software Engineer, Metal Head \m/, proud supporter of #spiritexpressions, senior frontend engineer at AWS Insights and Optimizations / Console Platform.
Man… I thought this was going to be a proper rant about using maps where you should be using other things… No, it’s a make sure you type your function inputs rant…
Ah, yes… good old sqlite… I guess the main reason I go the route I go is that I like writing map/ reduce functions… much more than reorganizing tables because I structured them poorly to start.
In fact, the project I'm on right now at paid job has a lot of structure transformation… and I'm enjoying it so much that I'm not even pining for one of my million side projects.
While it's not the most performant way to do things, I feel like data structure manipulation is one of the easiest to read ways to get from point a to point b.
Except when you're not worried about scale because you're building a small side project… I don't want to pay for a db (or the hardware to host it) for my play projects. My in-home play server is a very old home PC that is very underpowered for today's software.
API gateway all the things… it's annoying at times, but I don't want to have to manage a dbs… or write SQL.
Of course, there's always some data store to manage, but I prefer the ones with fewer switches and easier scaling (like DynamoDB).
In the end, it's a matter of preference. I prefer writing custom map reduce functions, you prefer SQL indexes.
Honestly, the amount of requests and data I'm handling for personal projects could be easily handled by the filesystem… so, ddb is great and I stay free tier… like always.
I'm seriously very surprised to still see so many relational databases in the top responses… guess I'm just in fantasy land. I hate writing SQL… good at it, but it's not fun (to me).
I would like that! Very much!