News for hackers. Stuff that matters.

A comment on How SQL Database Engines Work, by the Creator of SQLite (2008) [video]. Parent comment

Re:How SQL Database Engines Work, by the Creator of SQLite (... by A_Person on Monday June 25, 2018 @05:44AM (#17391075)
Nope! I've never used postgres at all. Most of my RDBMS work was done on HN NSFW ALERT - oracle :-) But your comment supports my general point, which is, that data modelling and relational schema design skills are product agnostic; normalization is normalization, as it were.
[ Parent | on HN ]
Re:How SQL Database Engines Work, by the Creator of SQLite (... by justinclift on Monday June 25, 2018 @06:33AM (#17391265)
Just to point out, "PROGRESS 4GL" is a different thing, not PostgreSQL based.

It seems to be called OpenEdge Advanced Business Language these days:

https://en.wikipedia.org/wiki/OpenEdge_Advanced_Business_Lan...

And yeah, the terms you mentioned are foundational RDBMS terms, common to all reasonable implementations of RDBMS's. :)

[ Parent | on HN ]
Re:How SQL Database Engines Work, by the Creator of SQLite (... by A_Person on Monday June 25, 2018 @11:22AM (#17393087)
Ok. Oracle had/has a presumeably similar thing (PL/SQL). I misread his comment to mean, postgres SQL.
[ Parent | on HN ]
Re:How SQL Database Engines Work, by the Creator of SQLite (... by mmjaa on Monday June 25, 2018 @11:28AM (#17393144)
Yes indeed, I meant PROGRESS 4GL, which was sort of around before all the "RDBMS" hoopla congealed all this wonderful info into a single art. Its just that your last paragraph really sounded like a quote, near-verbatim, from the very guides published by PROGRESS just for the purposes of educating people on how to make their data relatable .. but of course that is because these are natural laws for databases.
[ Parent | on HN ]
Re:How SQL Database Engines Work, by the Creator of SQLite (... by A_Person on Monday June 25, 2018 @12:02PM (#17393431)
I remember when 4GLs were the hot new thing. Let's get into those! Oops, nope, forget that, now it's Data Dictionaries, let's get into those instead! Rinse & repeat ...
[ Parent | on HN ]