okr765
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 1 年前

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

lemmy.dbzer0.com

message-square
289
link
fedilink
971

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 · 1 年前
message-square
289
link
fedilink
  • easily3667@lemmus.orgdeleted by creator
    link
    fedilink
    English
    arrow-up
    143
    ·
    edit-2
    1 年前

    deleted by creator

    • naught@sh.itjust.works
      link
      fedilink
      arrow-up
      58
      ·
      1 年前

      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 年前

        deleted by creator

        • wise_pancake@lemmy.cadeleted by creator
          link
          fedilink
          arrow-up
          3
          ·
          1 年前

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

    • morrowind@lemmy.ml
      link
      fedilink
      arrow-up
      50
      ·
      1 年前

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

      • The_Decryptor@aussie.zone
        link
        fedilink
        English
        arrow-up
        9
        ·
        1 年前

        How about a 6.4TB sqlite database?

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

        • morrowind@lemmy.ml
          link
          fedilink
          arrow-up
          6
          ·
          1 年前

          Should be enough to hold 60k rows

      • Korhaka@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        4
        ·
        1 年前

        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 年前

        deleted by creator

    • Hotzilla@sopuli.xyz
      link
      fedilink
      arrow-up
      4
      ·
      1 年前

      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.

  • 817 users / day
  • 3.86K users / week
  • 7.61K users / month
  • 16.8K users / 6 months
  • 1 local subscriber
  • 32.6K subscribers
  • 2.26K Posts
  • 79.4K Comments
  • Modlog
  • mods:
  • Feyter@programming.dev
  • adr1an@programming.dev
  • BurningTurtle@programming.dev
  • Pierre-Yves Lapersonne@programming.dev
  • BE: 0.19.18
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org