News for hackers. Stuff that matters.
Re:What’s so exciting about Postgres? by aloukissas on Friday October 30, 2020 @05:13PM (#24946961)
It's been a while and don't remember the specifics, but when we implemented a POSIX-compliant filesystem at Maginatics (acq. by EMC), we used MySQL (Percona actually) to store the FS logic (inode numbers, filenames, etc) and case sensitivity was one of the FS features. Maybe Percona supports it? I do remember (at least at that time) that full utf-8 support was poor though.
Re:What’s so exciting about Postgres? by aloukissas on Friday October 30, 2020 @05:15PM (#24946971)
Btw, don't get me started about case-sensitive file systems - Windows got it right (case-preserving, but case-insensitive). Why should both /home/ellen/Music and /home/ellen/music exist? :)
Re:What’s so exciting about Postgres? by viraptor on Friday October 30, 2020 @05:25PM (#24947049)
Because once you go there, you have to answer questions which are not as easy. Does M match m? Does i match ı? Does a match あ? Does あ match ア? Does m match 𝓂? What happens when they need to coexist?
Re:What’s so exciting about Postgres? by aloukissas on Friday October 30, 2020 @07:57PM (#24947944)
But they're different! I see where you're coming from though (unfortunately I know all these examples too well..).