Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Discussions

Bass Bass I need better writers.
  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    Another thing to add. Every time I go to a forum or random website and the whole thing crashes with mysql_* errors (which hilariously, is often), I think, "well at least they aren't losing any data ['that was accepted' :)]". It's not a bug, it's a feature! Total win on that developer's part!

    At least he can know MySQL is hard at work prioritizing against the 0.001% chance it might lose some important data, like people's last 30 seconds of bullshit blog comments. Anything else is totally like writing to /dev/null!!

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    I just want to add that too much of database design is all about these weird corner cases. Well, what if my database server explodes? Well holyshit man, that's a problem. Better code that condition into our database. These SQL DB developers need to design all these random features to keep our data safe from supernovas and *, they forget to design the database for the most simple use case: storing and retrieving data.

    Literally, I can not store data in a SQL database without either using some retarded COBOL inspired language that can not function well with the rest of my code base, or use some bizarre hacky mess framework called an ORM that literally you have be a masochist to enjoy working with. Just to do the most basic of operations. This is why SQL databases are garbage salad.

    I was a SQL true believer once. Just a few years ago. When I was first made aware of MongoDB, which I never heard of, I was like lets do a YouTube search. And well f**k, the first result was that "MongoDB is web scale". It was hilarious. MongoDB is like writing to /dev/null! Ha ha! Stupid hipsters! I was like showing that video to everyone, lol how stupid people must be for not using the tried and true MySQL DB with it's built in nuclear apocalypse mitigation. *puts on sunglasses*

    Until I started actually using MongoDB. It was like the best thing that ever happened. Holyshit, you can write stuff to a database simply by calling "save" on the object as is? I don't need to design a schema or work with ORMs or SQL or all that nonsense? I just call a single method? Holy crap man, I've been missing out on this all this time? After awhile of using NoSQL, it became obvious that developers who like SQL are (1) ignorant of the options, (2) completely batshit insane. There exists no alternate possibilities.

    That's the reason why NoSQL is getting huge. Because, developers are becoming enlightened to it. And that is totally awesome.

    The End.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , evildictait​or wrote

    Here is an easy fix for MongoDB's inability to do transactions or safely store data.

    Take the thing you want to store. JSON serialize it. Put that in a SQL table (called JSONtable) stored under a GUID index.

    When you want it back, select the object you want by its GUID and then deserialize it.

    Voila and congratulations. Now you have all of the benefit of a schema-less database, plus the transactionality, able-to-deal-with-lots-of-data-ness and likely-to-not-get-corrupted-ness of SQL.

    You're welcome.

    You could do that, but well.. yeah. That would work.

    But doing MapReduce or indexing on arbitrary properties of the JSON object would be kind of um, challenging to say the least. A lot of that can be solved simply by using PostgreSQL. Nevermind that though, f**k SQL. :)

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , bondsbw wrote

    *snip*

    This by itself is a virtue. :)

    Indeed. SQL is a relic of the 1970s that just won't go away. It was designed in a era before the Internet, before PCs, back when vaguely English-looking ALL CAPS languages like COBOL were all the rage and programmers wore suits.

    And of course, it was designed completely without regard to object-oriented programming and people now suffer with ORMs to this day because of that. Simply awful. It's like they don't realize better options exist.

    I think it's completely amazing that these days I can like store data in a database by like, telling my database, well, store the data. Whoa dude. What a f**king concept! :) Totally revolutionary!!

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , AndyC wrote

    *snip*

    It's only a virtue if you know what you're doing. So many web devs writing systems that would massively benefit from SQL and having it cripple or corrupt things by using NoSQL because they think being newer os better or cooler (or anything that uses the phrase web scale!)

    That's not a virtue, that's just being ignorant.


    It's only a virtue if you know what you're doing. So many web devs writing systems that would massively benefit from COBOL and having it cripple or corrupt things by using C# because they think being newer os better or cooler.

    That's not a virtue, that's just being ignorant.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , ScanIAm wrote

    When the product is written by the same company that made the OS?  Closed source in that case will always have an advantage.

    So the Microsoft Windows team and SQL team are working together to give their DB an advantage over 3rd party DBs on Windows? Interesting. I think some investigators over in the European Union and US Department of Justice could use some more information.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , spivonious wrote

    Absolutely. The need for NoSQL came about from Google and Facebook handling terabytes of data. But web programmers seem to be jumping all over MongoDB even for tiny datasets. Part of me wants to think that it's because they're too lazy to learn SQL and want to do everything in JS. A good, well-setup RDBMS can be extremely fast and efficient.

    Yup, I believe that's 99% of the reason to use MongoDB. Most people never run into the scaling issues of SQL because they work with "small" datasets (which I will define something less then Google). So the reason most are using MongoDB is indeed, due to laziness and a desire to avoid SQL. By the way, laziness is one of the principal virtues of a good developer.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    @spivonious:

    MapReduce.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    , RealBboy360 wrote

    Yeah, I know some things are better in some situations and nosql is probably more scalable, but could this reverse the trend of everyone going to mongodb or whatever?  The only enterprise part is no fun though.

    MongoDB's primary advantage is that it is schema-less and uses JavaScript and JSON (BSON), which tends to also be the kind of data organization web applications often use tons of.

    It's also really fast and web scale. SQL is not web scale. But seriously, that video is criticizing a really old version of MongoDB that didn't support journaling.

    You can still turn it off of course! Without journaling, MongoDB will write to memory, and only write to disk when it is optimal to do so. If MongoDB or the server it is running from crashes, you will likely lose some data.

    It wouldn't be MongoDB without supporting probabilistic durability and consistency. Because you know there is still a decent chance that your data will be stored even without enabling full durability, and writes especially will be noticeably faster if you disable it. Not every application the planet needs 100% durability all the time, especially when there is a massive unavoidable cost in overall performance for that guarantee.

  • So is SQL Server 2014 in memory Hekaton gonna crush nosql?

    Redis.