Family Man, Cheer Dad, Software Engineer, Metal Head \m/, proud supporter of #spiritexpressions, senior frontend engineer at AWS Insights and Optimizations / Console Platform.

  • 0 Posts
  • 9 Comments
Joined 9 months ago
cake
Cake day: September 24th, 2023

help-circle




  • philwills@programming.devtoProgramming@programming.dev...
    link
    fedilink
    arrow-up
    1
    ·
    edit-2
    9 months ago

    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.



  • 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.