[a / b / c / d / e / f / g / gif / h / hr / k / m / o / p / s / t / u / v / vg / vm / vmg / vr / vrpg / vst / w / wg] [i / ic] [r9k / s4s / vip] [cm / hm / lgbt / y] [3 / aco / adv / an / bant / biz / cgl / ck / co / diy / fa / fit / gd / hc / his / int / jp / lit / mlp / mu / n / news / out / po / pol / pw / qst / sci / soc / sp / tg / toy / trv / tv / vp / vt / wsg / wsr / x / xs] [Settings] [Search] [Mobile] [Home]
Board
Settings Mobile Home
/g/ - Technology

Name
Options
Comment
Verification
4chan Pass users can bypass this verification. [Learn More] [Login]
File
  • Please read the Rules and FAQ before posting.
  • You may highlight syntax and preserve whitespace by using [code] tags.

08/21/20New boards added: /vrpg/, /vmg/, /vst/ and /vm/
05/04/17New trial board added: /bant/ - International/Random
10/04/16New board for 4chan Pass users: /vip/ - Very Important Posts
[Hide] [Show All]


Janitor acceptance emails will be sent out over the coming weeks. Make sure to check your spam folder!


[Advertise on 4chan]


Why is it the default? Who decided this?
>>
just represent your SQL as data to allow for dynamic manipulation
https://github.com/seancorfield/honeysql
>>
>>109405479
>Who decided this?
I would guess Oracle

Also, whats the problem with SQL? Skill issue?
>>
>>109405588
Where did I say I have a problem with SQL?
>>
File: Oracle CIA.png (41 KB, 758x129)
41 KB PNG
>>109405588
>>
>>109405479
It works.
>>
>>109405641
Use case for having a problem with SQL?
>>
>>109405684
makes my computer hot
>>
>>109405641
>Where did I say I have a problem with SQL?
It looked like you are complaining. I like SQL.
>>
>>109405661
Oracle 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?
>>
>>109405479
The 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_R
https://en.wikipedia.org/wiki/Ingres_(database)
>>
>>109405739
I'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...
>>
>>109405479
It just works. It's pretty good
>>
>>109405479
SELECT * FROM posts WHERE op NOT LIKE "%faggot%"
>>
>>109405479
it 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.
>>
File: IMG_9646.jpg (81 KB, 1178x663)
81 KB JPG
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
>>
File: 1767229860046759.png (37 KB, 412x393)
37 KB PNG
Someone got filtered by subqueries.
>>
>>109405479
Turns 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
>>
>>109405715
no 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.
>>
>>109405479
What'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
>SQL
meme language for real profits
>>
>>109407468
No 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.
>>
>>109405479
people smarter than you did
>>
>>109405479
It's not even a sequel to anything. Bah
>>
File: 1764962162103495.png (204 KB, 1021x1080)
204 KB PNG
>>109405479
>>
File: firebird-sql-logo.png (1.28 MB, 1024x1024)
1.28 MB PNG
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.
>>
>>109406405
a (you) for the only correct ans, once again /g/ is completely out of their depth when it comes to anything remotely technical
>>
>>109405479
it's just this good. nothing better has been invented since the 60s.
>>
>>109405479
it werks
databussin aint easy nigga
>>
File: edgarfcodd.jpg (43 KB, 500x633)
43 KB JPG
>>109406405
>>109407032
>>109409151



[Advertise on 4chan]

Delete Post: [File Only] Style:
[Disable Mobile View / Use Desktop Site]

[Enable Mobile View / Use Mobile Site]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.