4 ms·

Interesting. Maybe take a look at R:BASE too. It was the first relational database for the PC. dBASE wasn't very relational (didn't emphasize referential integr

Interesting. Maybe take a look at R:BASE too. It was the first relational database for the PC. dBASE wasn't very relational (didn't emphasize referential integrity) at first. MicroRIM also took/takes pride in its code.

mamcx 6y ago
"referential integrity" is not necessary to make something relational. Is just that for some reasons, everyone on the RDBMS/relational space instantly add EVERYTHING that make a rdbms. Is like adding transactions to OO... and if a OO implementation don't have it claim is not OO. P.D: I'm building a relational language... And also start with FoxPro. What it not have at the time was well rounded SQL support but is until this day MUCH better rdbms tool than any other on the market, by a mile (considering the difference on time and scope, btw)
- airhead969 6y ago
  Never said that. And I'm having difficulty following what point you're trying to make because there's little coherence or grammar to your writing. Referential integrity is a real DBMS term, so I don't know why you're poo-pooing it. It means never having dangling foreign key references. The drop or preserve semantics of RI are dependent on R-E DBMS design (foreign keys). RI is fundamental to data hygiene, unless you'd prefer customers have a huge mess and then blame you for it. FoxPro is/was based on dBASE II/III. R:BASE predates it by 3 years. Good luck to you!
ghaff 6y ago
Relational databases were pretty new at the time of dBase II, although at least IBM and Oracle had SQL-based products. There were a bunch of other databases in the market however.
- airhead969 6y ago
  IBM's System R came out in 1977, and DB/2 in 83. R:BASE was the first RDBMS on the PC. Oracle existed in 1979 but was only ported to PC in 1984. NonStop SQL in 1987 was revolutionary.
tyingq 6y ago
Foxbase/FoxPro and Clipper also.
teilo 6y ago
I entirely forgot about R:BASE. Thanks for the memories. I worked in it only briefly, as a teenager. My uncle, an early PC adopter, introduced me to it.

mamcx 6y ago

"referential integrity" is not necessary to make something relational. Is just that for some reasons, everyone on the RDBMS/relational space instantly add EVERYTHING that make a rdbms. Is like adding transactions to OO... and if a OO implementation don't have it claim is not OO. P.D: I'm building a relational language... And also start with FoxPro. What it not have at the time was well rounded SQL support but is until this day MUCH better rdbms tool than any other on the market, by a mile (considering the difference on time and scope, btw)

airhead969 6y ago
Never said that. And I'm having difficulty following what point you're trying to make because there's little coherence or grammar to your writing. Referential integrity is a real DBMS term, so I don't know why you're poo-pooing it. It means never having dangling foreign key references. The drop or preserve semantics of RI are dependent on R-E DBMS design (foreign keys). RI is fundamental to data hygiene, unless you'd prefer customers have a huge mess and then blame you for it. FoxPro is/was based on dBASE II/III. R:BASE predates it by 3 years. Good luck to you!

ghaff 6y ago

Relational databases were pretty new at the time of dBase II, although at least IBM and Oracle had SQL-based products. There were a bunch of other databases in the market however.

airhead969 6y ago
IBM's System R came out in 1977, and DB/2 in 83. R:BASE was the first RDBMS on the PC. Oracle existed in 1979 but was only ported to PC in 1984. NonStop SQL in 1987 was revolutionary.

tyingq 6y ago

Foxbase/FoxPro and Clipper also.

teilo 6y ago

I entirely forgot about R:BASE. Thanks for the memories. I worked in it only briefly, as a teenager. My uncle, an early PC adopter, introduced me to it.