Our Object-Relational Mapper (ORM) then populated that list via a SQL join. In our code, we had a ManufacturingCompany class that had a list of contacts. Each ManufacturingCompany had one or more Contacts a one-to-many relationship via foreign keys. In one app that I migrated to NoSQL, we had a table ManufacturingCompany and a table Contacts. In NoSQL, models should be based on how the app interacts with the data rather than how the model can be stored as rows in one or more tables. We have been bending to the will of the database rather than the database bending to our apps. Developers coming from a relational database world invariably default into a model friendly to relational databases, even if that model is not friendly to the app itself. The outcome is often ugly and fails to realize the benefits of NoSQL stores.Ĭonsider, for example, the shape of your objects. Like a developer writing C++ using Visual Basic paradigms or attempting mutable object-oriented programming in functional Haskell, so also is the developer who exclusively uses relational database ideas in a NoSQL database. NoSQL changes the storage game, yet humans persist in old modes of thinking. Breaking Out of the Relational-Only MindsetĪ primary challenge when moving to NoSQL databases is, surprisingly, human rather than technical. NET Core, but the lessons here are general enough to apply to many NoSQL databases. My experience is primarily with RavenDB, a NoSQL database built on. In this article, I pass that wisdom on to you, dear reader: pitfalls to avoid, riches to reap, new ways of thinking.
Personally, I've experienced both worlds, having developed and maintained SQL and NoSQL apps and migrated several large apps to NoSQL.
What are the challenges facing developers moving from SQL to NoSQL? Many developers and enterprises are migrating or looking to do so, yet a great chasm exists between traditional SQL databases and NoSQL databases. We are in the midst of a shift towards NoSQL data stores across the software world, especially in the web and mobile space.
0 kommentar(er)
