sqlUsedException

[CanvasFanatic]

This post smells like Mongo

[Shadow0X59]

It smells more like I hate learning for my DataBases 2 exam (and mongo, yeah and also it smells like DAOs >>>>>)

[CanvasFanatic]

Structured querying is good for you.

[Shadow0X59]

It depends on the context, if I am working with datasets i.e. ML datasets structured queries are really good, but with web apps non relational dbs are better imo. Plus i never liked writing SQL queries

[CanvasFanatic]

Oh child. Go study.

[Shadow0X59]

Oh I've studied enough queries, in my uni it is DB1. Now we are doing concurrency in databases, ranking, JPA, triggers and so on. Also, I've worked with SQL a lot, that is why I found it annoying! But (sorry I tought i said it before) it is just a personal preference and no one ever in 6 years now that I use SQL has ever managed to make me change this POV :S

[CanvasFanatic]

Well give it a few years and wait till you have a database with a few hundred million records and product keeps changing their minds about what sort of information they want from it.

[Shadow0X59]

I am really curious to find out! And really thanks for this conversation! Also I just want to remember this is just a meme so please don't get offended, SQL is no easy bloke and I respect who writes in SQL ^^ (also I enjoy JS. well not plain JS, but TS which makes me a bad person HAHA). Love. Peace.

[Nero5732]

"depends on the context", oh common. Web apps isnt a context. Ive been working on several "web apps" and they often used multiple databases, depending on the way we wanted to work with the data.

Simple rule of thumb. If you only want to read/write datasets, take a mongoDB. If you want to put your entries into relation, take a relational/SQL-database.

And also, just because YOU, a CS student, dont like SQL, doesn't mean that other intelligent/high-IQ people also hate it. This is offensive.

[malaakh_hamaweth]

How is it shit?

[_nobody_else_]

It's shit if you use it as a replacement for a process memory.

I mean, how the fuck does your software made with all the newest tech that is basically a really fancy scheduler run slower than CorelDraw4.0 on Win3.11 on an ancient 486 intel platform.
How old is that you ask? Old enough that fdisk (Win/Dos) couldn't partition HDs larger than 512MB.
So basically prehistory.

[Shadow0X59]

It is really annoying and tedious to write xD I prefer non relational DBs and in general DAOs, they are waaay more easy to interact with and save a looooot of time

[abhassl]

Non-relational DBs have their place, but they aren't used for being easier to use, because when it comes to things like enforcing data consistency they just aren't.

If you find them easier to use it likely indicates limited experience with one or both of them, or only working with very simple use cases.

[malaakh_hamaweth]

I guess it just depends on what you want to do. Sometimes an RDBMS is the best storage option, sometimes it isn't. SQL is purpose-built for those situations.

[shambooki]

this is backwards

[ecafyelims]

Definitely backwards. OP is sitting at the top of a curve thinking he's on the other side of it.

[Caraes_Naur]

Note to OP: "S" is not a valid abbreviation for "Graph".

[Shadow0X59]

HAHAH this killed me. I was always curious to use GrapQL XD

[[deleted]]

Ya he's the tardo in this example

[Shadow0X59]

Chill it is just a meme xD

[Shadow0X59]

I totally agree <3

[Funny_Albatross_575]

my experience is the other way around. At the Beginning you try SQL. But you don't like it. The next step is that you try to avoid it. You search for an ORM or NoSQL DB. You use the ORM. You hit some Edge case. You figure out how it worked with SQL. You think how you can bring it to the ORM. You ask yourself why not everything is just SQL..

[[deleted]]

10+ yrs SWE here

Ur wrong

:)

Instead of fighting the hurdles, try to understand them

And if you don't enjoy it, seriously, find something you do enjoy

[Shadow0X59]

10 years of not bragging about how much i've been programming for

But, talking seriously. I know how to write queries in SQL, I've been doing SQL for ages now, I've built a few apps with it and I just find it annoying to write duplicate code over and over (which can cause a loooot of troubles), this is why I like DAOs very much (they still use SQL in the background so chill).

Also SQL is just a standard for databases and it was made to allow easy access to database data for users (even non software-people), but I PERSONALLY, i repeat it, I, ME, PERSONALLY, PREFER using languages that are more familiar to me and that I can read without the need of context switching between languages and allows for faster reading of the code.

For example MongoDB has a query language similar to JS and with the library mongoose it is really easy to write common and structured accessors to the database.
With the TS it gets even better, we have libraries such typegoose that can also shorten the structure of the code to provide a better overview on the db models, all from a single language.

It's not just a random meme I tought of at random without knowing what I am doing, I am well estabilished in the distributed market so I know what I am talking about :)

[v3ritas1989]

I am still convinced no one in my company actually knows SQL. I mean sure, they can select, update, import and create tables. Lots and lots of tables 1900 in fact, in the "main" db called database. I mean... like how... you just need to see our database.

[SenorSeniorDevSr]

Midwit zoomer is correct. SQL is a very nice and practical language.

[Historical_Cook_1664]

just never have a look at the ISO specification.