L E F L I
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 2 years ago

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

lemmy.dbzer0.com

message-square
292
link
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 years ago
message-square
292
link
fedilink
  • easily3667@lemmus.orgdeleted by creator
    link
    fedilink
    English
    arrow-up
    145
    ·
    edit-2
    1 year ago

    deleted by creator

    • naught@sh.itjust.works
      link
      fedilink
      arrow-up
      60
      ·
      2 years ago

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

      • easily3667@lemmus.orgdeleted by creator
        link
        fedilink
        English
        arrow-up
        11
        ·
        edit-2
        1 year ago

        deleted by creator

        • wise_pancake@lemmy.cadeleted by creator
          link
          fedilink
          arrow-up
          3
          ·
          2 years ago

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

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

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

      • The_Decryptor@aussie.zone
        link
        fedilink
        English
        arrow-up
        9
        ·
        2 years 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 years ago

          Should be enough to hold 60k rows

      • Korhaka@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        4
        ·
        2 years 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.orgdeleted by creator
        link
        fedilink
        English
        arrow-up
        1
        ·
        edit-2
        1 year ago

        deleted by creator

    • Hotzilla@sopuli.xyz
      link
      fedilink
      arrow-up
      4
      ·
      2 years 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
    • If the mod doesn’t find it funny, you’re banned. Ha-ha!.. For real: do not use the community for “statements”. There are other places for such content. Keep it chill and funny.
Visibility: Public
globe

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

  • 433 users / day
  • 3.2K users / week
  • 7.09K users / month
  • 15.1K users / 6 months
  • 1 local subscriber
  • 33.3K subscribers
  • 2.39K Posts
  • 85.2K Comments
  • Modlog
  • mods:
  • Feyter@programming.dev
  • adr1an@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • BE: 0.19.19
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org