Re: The tragedy of SQL

Поиск
Список
Период
Сортировка
От Miles Elam
Тема Re: The tragedy of SQL
Дата
Msg-id CAALojA-waVaV89-0Zd2xW9TwqR9bKOCL0jXcgfJ0A6x7c3FTWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The tragedy of SQL  (Benedict Holland <benedict.m.holland@gmail.com>)
Список pgsql-general
On Fri, Sep 17, 2021 at 1:13 PM Benedict Holland <benedict.m.holland@gmail.com> wrote:
I don't get why there are so many programming languages out there. C is virtually perfect.

Oh my. Even its creators didn't believe this, and that was decades ago. Use after free. Dangling pointers. No array bounds detection. The YOLO that is (void *).

Decades of CERT advisories tell a different story.

Don't get me wrong, I like C. It's truly a marvel that such a simple language could be so powerful and flexible. But virtually perfect?

PostgreSQL is lauded as a great piece of C software—not just because it has a wonderful feature set, but because large scale C development is truly a difficult thing to get right even with the best, most dedicated developers. See: OpenSSL.

Buffer overflows, all too common and often hard to find, are largely impossible in some languages (Rust) and far less likely in others (Zig), and yet they account for far too many exploits out there leading to massive data leaks and ransomware.

We develop new languages precisely because C is not perfect. (This is not to say any of the newer languages are, just that C should not be the end of our search, especially in the domain-specific cases.)


В списке pgsql-general по дате отправления:

Предыдущее
От: Benedict Holland
Дата:
Сообщение: Re: The tragedy of SQL
Следующее
От: Tobias Meyer
Дата:
Сообщение: Remove duplicated row in pg_largeobject_metadata