• Ron Fox (google)

    Frist again.

  • JustSomeDudette (unregistered)

    I heard you like content, so I put a content field in your content column, so you can be content with your content.

  • RobyMcAndrew (unregistered) in reply to JustSomeDudette

    That's rather contentious

  • squidgy (unregistered)

    O do belay your incontinence...

  • (nodebb)

    I recently came across an example of this: the WeightGurus app for smartphone-connected scales. It uses a sqlite database with one table to store 7 rows, the last of which is simply a varchar full of JSON which holds the actual data. (the app also always exits when pressing the back button, and appears to be made by some html-to-app converter)

  • Ian Tester (google)

    Does MySQL not have a JSON column type? PostgreSQL has for several releases and others probably do too.

    Who am I kidding? Everything seems to be done with fixed-length CHAR(x) strings in MySQL!

  • RichP (unregistered)

    What goes through the minds of the Duhvelopers that create these abominations? I'm picturing some hack stewing about the fact that they are forced to use a database instead of the flat file they believe to be faster.

    I mean, I'm a crappy coder and lousy DBA that can barely differentiate between third normal form and a third nipple, but even I can cook up something better.

  • Paul Neumann (unregistered)

    So... Was the Content column < 4k or does the LIKE simply not work?

  • If ain't broke? (unregistered)

    why fix it?

  • (nodebb)

    If elected your president, I promise to sent the Navy Seal to hunt down and find Blakeyrat (unregistered) and stop this nonsense...

  • TimothyB (unregistered)

    To be fair, MongoDB isn't all bad.

    Yes, 10Gen/MongoDB corp have an excessive amount of arrogance.

    There was the whole write-concern stupidity, they wasted a lot of energy defending the fire-and-forget default until they finally caved and changed it. But all the use cases were for storing Twitter feeds, and since each individual tweet is worthless, who cares if you lose some?

    Then I was at a MongoDB day and was asking about the state of the C++ drivers. One of the devs said she didn't understand why anyone would be writing in C++ because that's for important, critical applications like MongoDB itself. This was the chick who looked like she ought to be a Haskell programmer, so no superiority there, right?

    On the other hand, they do get unfair flack for data loss in fail-over cases. The thing is, it's so easy to set up a MongoDB replica set, that anyone can test fail-over. (Unfortunately, it's so easy to set up a MongoDB replica set, that anyone can try to test fail-over.) It takes me 40 minutes to install one copy of SQL Server, so I have no desire to mess with mirroring there. But I think the same sorts of edge cases will apply.

  • Ulysses (unregistered)

    Who's the bigger clown? Leakybrat or the folks who run this site? TRWTF is TDWTF once again.

  • Dude (unregistered)

    Yum, bread.

  • DeepThought (unregistered)

    Ok, It is terribly unwise to have unverified comments... I suggest implementing email verification AND "stealth banning" by IP and email. (Stealth ban will make comments appear posted, but only to the banned person.)

  • (nodebb)

    Re-enabling anonymous comments was a good idea wasn't it ?

  • Beep boop boop (unregistered)

    I, for one, like anonymous comments.

    But some basic automatic anti-spam would be great. Eg: preventing multiple images in one post (why do we even allow any images?), or checking that the compression ratio for a zip of the comment is no greater than 50%. Or limiting the number of non-ascii characters to x%.

    All with stealth-bans so they can't tell that the comment hasn't been posted.

  • Anonymous (unregistered)

    Just put greater restrictions on anonymous accounts e.g. no images, less characters, block Unicode ranges, etc.

  • messju (unregistered)

    FWIW: PostgreSQL supports indexes, unique constraints and foreign key contraints on values inside it's JSON data type. (Never used it myself, just read about it.)

  • Blakeyrat (unregistered)
  • Nate Scherer (google)

    "lots of queries with WHERE clauses like: WHERE Content LIKE '%"title":"Initech"%', which rank as one of the slowest possible queries you can run in SQL. "

    Maybe I'm missing something, but I thought this was a noSQL database. Do noSQL databases use SQL?

  • OPTX Skyland (unregistered)

    That design is preposterous to me.

    ACID (Atomicity, Consistency, Isolation, Durability)

    That is just a clusterfuck of data.

    if you can't convert DB to JSON then go back to Google University and study more.

    DB is DB.

    JSON is JSON.

    Interface is Interface.

  • Asd (unregistered)

    asd

  • apoorva786 (unregistered)
    Comment held for moderation.

Leave a comment on “OhgodnoSQL”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article