7
Handling Customized, JSON, and Blob Data Types
Some database management systems offer a way of storing niche column types such as JSON and Blob-related data. These column types are useful for rapid prototyping, handling schemaless data, and sending and receiving buffered data.
Typically, an application would use a NoSQL database, such as MongoDB, to process and query JSON documents, but this comes with a set of its own problems. We can no longer adhere to some sort of normalization for our structures without an extensive list of validations, and the NoSQL database cannot perform transactions nor provide ACID-compliant capabilities.
Note
Some NoSQL databases claim to offer ACID compliance, but they often come with stipulations and limitations ...
Get Supercharging Node.js Applications with Sequelize now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
