3 ms·
I'm curious about pre SQL database times. What sort of solutions were out there? What did the DBs look like before SQL was a thing? NoSQL fixes a lot of the mi
by lugg 8y ago
I'm curious about pre SQL database times. What sort of solutions were out there? What did the DBs look like before SQL was a thing?
NoSQL fixes a lot of the mismatch with code models but imo doesn't really solve much else and lacks the expressive power of SQL when it comes to reporting software.
I suspect most developers don't realise how much they are not the main user or consumer of SQL. (Business excel spreadsheets)
- collyw 8y agoKey value stores, Berkely-db was a popular one as I understand.
- nabla9 8y agoNavigational databases predated SQL databases (hierarchal or network/graph based). SQL was seen as huge improvement over navigational databases. Basically navigational database is just set of links to records. Filesystem can be treated as hierarchal database. DOM model is modern version of hierarchal model.
- jhayward 8y agoThe main model was CODASYL [1], a hierarchical navigational database standard. There were also various vendor-supplied things like IBM IMS for simple indexed storage/retrieval. [1] https://en.wikipedia.org/wiki/CODASYL https://en.wikipedia.org/wiki/CODASYL