mortonpe
Joined 13 years ago
Joined 13 years ago
I have never been happier with a tool and am excited to explore their new offering.
>> That's just incorrect. What they MEANT to say is that they had a column to store filenames that was a varchar(255) column and people were running out of space with long directory paths and filenames. They could have moved to a TEXT column, but didn't because they thought it couldn't be indexed without specifying a length... But they were wrong, you CAN index a TEXT column without specifying the TEXT column length, you just have to specify the length of the substring you want to index.
Unless I am misunderstanding the SQL documentation, doesn't the prefix length specification essentially make it such that you can only partially index the field, up to the first 3072 bytes? (https://dev.mysql.com/doc/refman/8.0/en/create-index.html) After that limit, the index _may_ still be performant, but does not at scale I would imagine that YMMV. You make a fair point that there are other patterns.
IMHO The article was not about bashing MySQL rather the GitLab team decided to choose one database platform to support and provided some basic reasoning around why they chose Postgres over MySQL. Both are great platforms, but you should choose the right tool for the job. While I agree that some of their arguments are weak but I am not sure that matters given that their strategic choice was one or the other.
Frankly, I would have liked to have seen some data that represents what their install base utilizes. If it is 90% mysql and 10% postgres their choice would be strange given the weak arguments. We just don't have that data.
Technology is rewriting the future of this virus and I can’t help but to think what might have been different had he contracted HIV in a different time.
As for Cygwin sshd, it does work if posix is the order of the day but if you need a reliable terminal (for things like powershell) that scales to hundreds of servers and many admins Cygwin simply fails the test. Clunky domain authentication, private key auth is a joke, powershell only works sometimes (thanks PTY), network tokens are non-existent, etc. the list goes on and on.
- edit To be clear, the ridiculous names people are using are offensive. Game was fun until the children showed up.
As for the miles of filth and needles. I’ve seen too. I’ve seen it in New York, Chicago, San Francisco, Miami, the list goes on. When you have folks being displaced as rents and property prices increase, so goes the middle and lower income folks. Small cities naturally don’t have challenges at the same scale as large cities.
Complaining does not help-What are the solutions to these problems? I don’t know, but I am all ears.