Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> Interfacing with a DB using a fortran inspired query language is archaic.

Possibly amusing aside: Logica's RAPPORT, one of the earliest RDBs, was written in Fortran and was queried (or could be) via pre-processed Fortran. I don't know whether that was more faithful to the model than SQL.

Jaffer's Scheme RDB (https://people.csail.mit.edu/jaffer/slib/Relational-Database...) aimed to implement the model, possibly uniquely so at the time, he thought.



Actually, SQL seems more COBOL-inspired than FORTRAN-inspired to me.

As far as a "generic" query language not tied to relational databases, that's a rather tall order. Logic-based query languages are difficult to troubleshoot when you don't get the results you expected. It's kind of like a formalized version of Google: you get results, but you don't know if they are the best results, you don't know what you are missing, and you often don't know why you got what you did.

You have to have some kind of discipline and structure to the data in order to understand and troubleshoot results (at least for mortals and non-Sheldons). Some say relational is "too stiff" for some uses, but there is the Dynamic Relational proposal that gives it flexibility without abandoning relational and SQL. (Some argue it's not technically relational, which I don't agree with, but that issue doesn't change the similarity to existing RDBMS & SQL conventions.)

As far as relational-based alternatives to SQL, consider these discussions:

http://wiki.c2.com/?HowOtherQueryLanguagesAddressSqlFlaws

http://wiki.c2.com/?QueryLanguageComparison

http://wiki.c2.com/?ExperimentalQueryLanguageComparison




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: