Under the Jacaranda
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
mox@lemmy.sdf.org to Programming@programming.dev · 4 months ago

Collection of insane and fun facts about SQLite

avi.im

external-link
message-square
37
fedilink
146
external-link

Collection of insane and fun facts about SQLite

avi.im

mox@lemmy.sdf.org to Programming@programming.dev · 4 months ago
message-square
37
fedilink
Collection of insane and fun facts about SQLite - blag
avi.im
external-link
Some of the interesting and insane facts I learned about SQLite
  • moonpiedumplings@programming.dev
    link
    fedilink
    English
    arrow-up
    8
    arrow-down
    2
    ·
    edit-2
    4 months ago

    Here’s a fun fact not noted in the article: Temporary files in sqlite are named etilqs_something in order to prevent people from contacting the sqlite developers for support when other applications (specifically, McAfee) have decided dump and not prune temp files.

    Source: https://github.com/sqlite/sqlite/blob/95f6df5b8d55e67d1e34d2bff217305a2f21b1fb/src/os.h#L57

    • mox@lemmy.sdf.orgOP
      link
      fedilink
      arrow-up
      10
      ·
      4 months ago

      Here’s a fun fact not noted in the article:

      It’s #19 in the article.

      • moonpiedumplings@programming.dev
        link
        fedilink
        arrow-up
        7
        ·
        edit-2
        4 months ago

        Well, I can’t read I guess.

        At least I linked to the code, since the article doesn’t seem to do that. The twitter thread it linked to probably does, but I can’t view the replies without logging in.

        • mox@lemmy.sdf.orgOP
          link
          fedilink
          arrow-up
          5
          ·
          4 months ago

          At least I linked to the code,

          I appreciate that. :)

Programming@programming.dev

programming@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: [email protected]

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you’re posting long videos try to add in some form of tldr for those who don’t want to watch videos

Wormhole

Follow the wormhole through a path of communities [email protected]



Visibility: Public
globe

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

  • 123 users / day
  • 1.07K users / week
  • 2.94K users / month
  • 7.14K users / 6 months
  • 1 local subscriber
  • 20.1K subscribers
  • 2.2K Posts
  • 34.6K Comments
  • Modlog
  • mods:
  • snowe@programming.dev
  • Ategon@programming.dev
  • MaungaHikoi@lemmy.nz
  • BE: 0.19.7
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org