• DefederateLemmyMl@feddit.nl
      link
      fedilink
      English
      arrow-up
      4
      arrow-down
      5
      ·
      edit-2
      2 months ago

      give me one use case where it makes sense having several files with the same name but different cases in the same directory

      Imagine a table in a database where the primary key is a case sensitive character field, because you know varchars, just like C char types and string types in other languages are case sensitive.

      Imagine a database administrator does the following:

      • Export all data with primary key = ‘Abcde’ to ‘Abcde.csv’

      Imagine a second database adminstrator around the same time does the following:

      • Export all data with primary key = ‘abcde’ to ‘abcde.csv’

      Now imagine this is the GDPR data of two different users.

      If you have a case insensitive file system, you’ve just overwritten something you shouldn’t have and possibly even leaked confidential data.

      If you have a case sensitive file system you don’t have to account for this scenario. If the PK is unique, the filename will be unique, end of story.