unboiled.info
  • Communities
  • Create Post
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 9 个月前

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

lemmy.dbzer0.com

message-square
271
link
fedilink
847

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 · 9 个月前
message-square
271
link
fedilink
  • easily3667@lemmus.org
    link
    fedilink
    English
    arrow-up
    135
    ·
    9 个月前

    60k is laughably, embarrassingly small. It’s still sqlite-sized.

    • naught@sh.itjust.works
      link
      fedilink
      arrow-up
      53
      ·
      9 个月前

      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
        7
        ·
        9 个月前

        Hey now that’s real close to the 65,535 16-bit limit (from 20 years ago)

        • wise_pancake@lemmy.ca
          link
          fedilink
          arrow-up
          2
          ·
          9 个月前

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

    • morrowind@lemmy.ml
      link
      fedilink
      arrow-up
      46
      ·
      9 个月前

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

      • The_Decryptor@aussie.zone
        link
        fedilink
        English
        arrow-up
        6
        ·
        9 个月前

        How about a 6.4TB sqlite database?

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

        • morrowind@lemmy.ml
          link
          fedilink
          arrow-up
          4
          ·
          9 个月前

          Should be enough to hold 60k rows

      • Korhaka@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        3
        ·
        9 个月前

        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
        ·
        9 个月前

        I’m not

    • Hotzilla@sopuli.xyz
      link
      fedilink
      arrow-up
      3
      ·
      9 个月前

      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.

  • 1 user / day
  • 1 user / week
  • 2.35K users / month
  • 12.2K users / 6 months
  • 2 local subscribers
  • 27.6K subscribers
  • 1.9K Posts
  • 48.9K Comments
  • Modlog
  • mods:
  • Feyter@programming.dev
  • adr1an@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • UI: unknown version
  • BE: 0.19.13
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org