MTGZone
  • Communities
  • Create Post
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 2 months ago

muskrat's data eng expert's hard drive overheats while processing 60k rows

lemmy.dbzer0.com

message-square
296
fedilink
974

muskrat's data eng expert's hard drive overheats while processing 60k rows

lemmy.dbzer0.com

SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 2 months ago
message-square
296
fedilink
  • easily3667@lemmus.org
    link
    fedilink
    English
    arrow-up
    144
    ·
    edit-2
    6 days ago

    deleted by creator

    • naught@sh.itjust.works
      link
      fedilink
      arrow-up
      59
      ·
      2 months ago

      i mean its even excel sized depending on how many columns. This is seriously sad and alarming

      • easily3667@lemmus.org
        link
        fedilink
        English
        arrow-up
        11
        ·
        edit-2
        6 days ago

        deleted by creator

        • wise_pancake@lemmy.ca
          link
          fedilink
          arrow-up
          3
          ·
          2 months ago

          Holy shit if this ids lm issue that’s too funny

    • morrowind@lemmy.ml
      link
      fedilink
      arrow-up
      50
      ·
      2 months ago

      Sqlite can easily handle millions of rows. Don’t sell it short

      • The_Decryptor@aussie.zone
        link
        fedilink
        English
        arrow-up
        9
        ·
        2 months ago

        How about a 6.4TB sqlite database?

        https://boyter.org/posts/searchcode-bigger-sqlite-than-you/

        • morrowind@lemmy.ml
          link
          fedilink
          arrow-up
          6
          ·
          2 months ago

          Should be enough to hold 60k rows

      • Korhaka@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        4
        ·
        2 months ago

        I have an sqlite db that is a few GB in size, game saves using the format. Sadly almost all blob data, would love to play with it if it was a bit more readable

      • easily3667@lemmus.org
        link
        fedilink
        English
        arrow-up
        1
        ·
        edit-2
        6 days ago

        deleted by creator

    • Hotzilla@sopuli.xyz
      link
      fedilink
      arrow-up
      4
      ·
      2 months ago

      60k is single json file

Programmer Humor@programming.dev

programmer_humor@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmer_humor@programming.dev

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

  • Keep content in english
  • No advertisements
  • Posts must be related to programming or programmer topics
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 789 users / day
  • 4.62K users / week
  • 9.2K users / month
  • 17.8K users / 6 months
  • 4 local subscribers
  • 23.1K subscribers
  • 1.39K Posts
  • 50.5K Comments
  • Modlog
  • mods:
  • Feyter@programming.dev
  • adr1an@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • BE: 0.19.5
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org