3 ms·

If you run into issues with non nullable types and missing of real data structures then i guess you dont get the purpose of SQL and its tech. Its a query langua

If you run into issues with non nullable types and missing of real data structures then i guess you dont get the purpose of SQL and its tech. Its a query language to retreive data. thats the only purpose. With under the hood a crafty machine that enables atomic principles and depending on the sql tech other different functionalities like scalability and more.. No Libraries? There are a zillion battle tested libs out there. Some are used by companies like Paypal, SpaceX, Tiktok, youtube, Gmail and many more. And why you would unit test datasets in a database? You normally use mocks to test against your data layer. Most if not all software stacks have mock libs available.

lmm 3y ago
> If you run into issues with non nullable types and missing of real data structures then i guess you dont get the purpose of SQL and its tech. Its a query language to retreive data. thats the only purpose. That's no excuse for making it bad. > No Libraries? There are a zillion battle tested libs out there. Not in SQL. > And why you would unit test datasets in a database? For the same reason as anywhere else. > Most if not all software stacks have mock libs available. Exactly. They're a basic piece of functionality you'd expect most languages to provide, but not SQL, because it's awful.