• hobbsc@lemmy.sdf.org
    link
    fedilink
    arrow-up
    7
    ·
    1 year ago

    There’s a really fine line between needing a spreadsheet and needing a database and I’ve not yet found it. It’s probably more fuzzy than I realized but I have participated on so many programming projects that amounted to a spreadsheet that lived too long.

    • GenderNeutralBro@lemmy.sdf.org
      link
      fedilink
      English
      arrow-up
      4
      ·
      1 year ago

      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.

    • Big P@feddit.uk
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      At some point you end up surpassing databases and end up with a giant pile of spreadsheets called a data warehouse

  • RagingHungryPanda@lemm.ee
    link
    fedilink
    arrow-up
    3
    ·
    edit-2
    1 year ago

    We’ve finally evolved from Excel!

    Edit: I saw a presentation on functional programming where the guy said, “Do you know what the most widely used functional programming language is and that the world would stop running without? Excel!” (or something to that effect)

    • Digestive_Biscuit@feddit.uk
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      I can believe that. Where I work people use the Bi system to dump data out to Excel to then build the reports they want to see. Madness.

  • phorq@lemmy.ml
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    The article doesn’t seem to say what type of database they moved to, I’d like to imagine it’s an excel spreadsheet…

  • Awkwardparticle@artemis.camp
    link
    fedilink
    arrow-up
    1
    ·
    1 year ago

    Not going to lie. I have made it really far using Google sheets as a database until I had to move to a full DB. Google Sheets is just an interface to a Google run DB anyways. A lot of the time I would just load sheets(tables) into data structures from a SQL library and use it like a regular database.

    • xmunk@sh.itjust.works
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      Nobody is dumb enough to insult postgres - we’ll fucking burn you at a stake for heresy like that.