• 0 posts
  • 21 comments
Joined 3 years ago
Cake day: August 17th, 2023
  • Infinite loop and hard coded magic constant; this should have a configurable timeout and a resource file the string is read from so we can internationalize the application. Additionally, the use of a goto with a hard coded line number is a runtime bug waiting to happen after unrelated refactors; it’s best to use a looping construct that has more deterministic bounds.

  • Storage data structures. Database tables are designed for fast read/write. Excel is designed for fast simultaneous parallel computation.

    To get a sense of what this looks like, you can read more about their data structures; Databases typically store data in what’s called a “B Tree” and spreadsheets typically store as a format that can be easily converted into a “Directed Acyclic Graph” (although Excel lets you turn off the “acyclic” part if you allow circular references).

    Although, with Excel specifically, there’s probably not much difference since it has some database functionality now.

  • Python is Spanish; a ton of people learned a bit in school and never picked it back up again. Places that speak it natively all have their own conventions because, even though the native languages were replaced by colonizers, a lot of the native languages patterns remained in place. Most places that speak it are super welcoming and stoked that you’re trying to learn.