Why is it the default? Who decided this?
just represent your SQL as data to allow for dynamic manipulationhttps://github.com/seancorfield/honeysql
>>109405479>Who decided this?I would guess OracleAlso, whats the problem with SQL? Skill issue?
>>109405588Where did I say I have a problem with SQL?
>>109405588
>>109405479It works.
>>109405641Use case for having a problem with SQL?
>>109405684makes my computer hot
>>109405641>Where did I say I have a problem with SQL?It looked like you are complaining. I like SQL.
>>109405661Oracle is the result of having to build up NSA mass surveillance.Google is the result of needing alhorithms to search through that vast amount of data.Every single big company in the USA has similar origins. The USA is play-pretend capitalism.
How is SQL the only good and widely used 4th generation language?
>>109405479The idea was that Business Executives could generate their own reports without having to depend on techies; little did they know, that Business Executives don't want to write SQL either.
>>109405479>Who decided this?https://en.wikipedia.org/wiki/IBM_System_Rhttps://en.wikipedia.org/wiki/Ingres_(database)
>>109405739I've always wondered this, too. It seemed like garbage collection would be a clear step on the path toward a more general-purpose 4th gen language, but alas...
>>109405479It just works. It's pretty good
>>109405479SELECT * FROM posts WHERE op NOT LIKE "%faggot%"
SELECT * FROM posts WHERE op NOT LIKE "%faggot%"
>>109405479it just werks and retards can learn it in a week, at least the basics
>>109405732> The USA is play-pretend capitalism.Of course, but it’s impolite to point it out.
Relational databases are the only thing the computer engineering discipline got right. SQL has some issues but dbs are a massive undertaking that have paid off. Wish I could say the same about operating systems or browsers
Someone got filtered by subqueries.
>>109405479Turns out it’s mathematically quite special. It’s an engineering implementation of a mathematical concept called relational algebra it’s not just tables with an annoying language from the age of cobol
>>109405479>Why is it the default?It literally just werks and is piss easy. But custom flat files can be way faster and are used a lot when speed matters.>Who decided this?SQLite
>>109405715no he isn't. He is just wondering why people began using SQL in almost everything. My guess is that SQL is convenient and you only need like 10% of the knowledge to do 95% of enterprise demands with it. I never encountered table joins, which I learned in university and I have 2 years of professional experience.
>>109405479What's wrong with MySQL?
>>109406405/thread
>>109406865>I never encountered table joins and I have 2 years of professional experience.WTF. Did you work at a mom & pop startup or something lmfao
>Why is this the default It solves all the CRUD problems very well and is a tried and true solution. If you want to avoid SQL you should have a good reason for why.
>>109405841>No records found.
>>109405479>SQLmeme language for real profits
>>109407468No i worked at small web firms and startups. Literally WordPress did the content distribution and the startup needs me to write lambda functions. I literally never had to use join queries so far. Just simple stuff that does CRUD.Mom and pop startup with 10 million evaluation sounds like a dream desu.Also to save costs startups rely on integrating nosql databases as part of a larger platform. Its so depressing desu.
>>109405479people smarter than you did
>>109405479It's not even a sequel to anything. Bah
>>109405479
I've been using Firebird SQL for recent projects. The ecosystem/library support is not that big, but I'm pretty happy with it so far. It supports embedded mode (like sqlite) and also running as a server (like postgres & mysql). So, you can write tests that run locally against the exact same rdbms that you use in production. You can also run hybrid, where maybe applications/scripts running on the same host as the database access it in embedded mode using file system permissions and skipping the loopback interface while applications/scripts on other boxes talk to the same database over the network. Running embedded also means you don't need to worry about N+1 selects (same as sqlite) if you would prefer not to. Anyway, cool software, and it makes me feel like a hipster to use it.
>>109406405a (you) for the only correct ans, once again /g/ is completely out of their depth when it comes to anything remotely technical
>>109405479it's just this good. nothing better has been invented since the 60s.
>>109405479it werksdatabussin aint easy nigga
>>109406405>>109407032>>109409151