• 0 Posts
  • 29 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle




  • There’s a couple things… First, it’s a habit to be constantly pressing CTRL+S. I’ve been doing it for many years, I’ll continue to do it probably until I stop using a keyboard. It’s such an easy keystroke, since my hands are almost always hovering over the keyboard. Second, in some software you can create new documents without first creating a file on disk. This means that when I go to hit CTRL+S, it prompts me to save the file. That’s not to say that some software can’t save a recovery version of the document in the event the software crashes, but I’m not going to bet money on it working 100% of the time. I’d rather be proactive and personally make sure my work is saved. Gives me peace of mind.





  • I was heavy into skateboarding as a kid, and I was interested in making some skateboarding media website with images and videos. I had initially began with wix, because I had no idea programming was a thing (I barely used technology, or even a phone). I messed around with it for a while, and then learned that I could make websites with just a simple html file… And the rest was history. Ended up getting into PHP, then game development with Java, etc.


  • Staying on the SQL theme… The company I work for has a fairly old (~20 years) system. There’s a feature for users and site admins to export massive amounts of data, with the option to export data from when the system was first released. Purely CSV or XML data formats. On large datasets, the time for export would vary from 10-20+ hours, and would frequently timeout, forcing you to split exports into multiple timeframes and manually merging them into a single file. The solution? Indexes! Indexes were non-existent. After adding them, export times have dropped to ~10-15 minutes, which is a rather insane performance increase, especially since a single export is accepted per account at a time.



  • Yeah, same here. I spend all day at a computer, last thing I want to do is spend more time at a computer. I’ve also spent more time working on my own vehicle’s, and just generally being outside more often.

    One thing that I do enjoy from time to time is graphics/game programming. Nothing really ever results from any of my projects, but it is something I enjoy, as i don’t do graphics programming at my job… It’s usually systems/web development, so the difference in the type of projects I choose to do as hobby programming has helped for me.