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

help-circle
  • GenderNeutralBro@lemmy.sdf.orgtoProgrammer Humor@lemmy.mlEverytime
    link
    fedilink
    English
    arrow-up
    7
    arrow-down
    2
    ·
    11 months ago

    Which is the greatest use case for ChatGPT.

    It’s been a while since I picked up a new language, but I remember the last time I did, the hardest part was just figuring out how to do trivial things. It’s crazy how long it took me to figure out how to do a simple thing like split a string into fields by a delimiter. I can literally paste a line of code into ChatGTP and say “convert this Python line into JavaScript” and it’ll just do it. Fantastic.

    Or yeah, I could spend five minutes reading the man page to remind myself of strptime’s date format every time I need to format a date. Orrrrrr I can just ask the bot something like How do I format this date to look like "YYYY-MM-DD HH-MM-SS" in python? Wed Oct 25 05:37:04 PDT 2023.



  • Does it need to be accessed by multiple people? Does it need to be updated frequently? Does it need to be accessed programmatically? Does performance matter? If you answered “yes” to any of these questions, you should probably use a database.

    If it’s something you interact with manually, has less than 100,000 rows, and is mostly static, then sure, use a spreadsheet.

    I used to have some scripts to convert and merge between CSV and sqlite3. Even a lightweight db like sqlite3 has value. Google Sheets fills some of the gaps with its QUERY statement but I still find it a bit awkward to use a lot of the time.