4 ms·
The only way you can get away with creating an application without touching sql is of you offload the logic to your backend language, and then I don't think you
by Incipient 5mo ago
The only way you can get away with creating an application without touching sql is of you offload the logic to your backend language, and then I don't think you'd be efficient enough to scale.
Also can someone actually understand the logic of joins, indexes, pks, etc enough to create an efficientand scalable db, and not simply have learned sql by proximity?
- runako 5mo ago> The only way you can get away with creating an application without touching sql Please look at app platforms like Firebase[1]. There are absolutely complex Web applications running at scale that do not use SQL anywhere in the stack. Aside from that, MongoDB and Redis are 17 years old; CouchDB is over 20. NoSQL is well-established at this point. All of the hyperscalers offer proprietary NoSQL databases, and have done so for years. A large number of developers uses those databases in production. In our API-centric environment, there are a lot of apps that don't do much in the way of managing their own data directly at all, using mixtures APIs for auth and other key application functions. > can someone actually understand the logic of joins, indexes, pks, etc enough to create an efficientand scalable db If you are not using a relational database, these concepts do not necessarily apply. 1 - https://firebase.google.com/docs/firestore/query-data/queries https://firebase.google.com/docs/firestore/query-data/querie...