Presentation: SQL anti patterns and NoSQL alternatives
One of the presentations at NoSQL Brazil was Gleicon Moraes’ (@gleicon) list of SQL anti patterns which represents a very good checklist for situations in which we should take a step back, reanalyze requirements and figure out if a NoSQL solution might not be a better alternative:
- The eternal tree
- Dynamic table creation (and dynamic query building)
- Table as cache
- Table as queue
- Table as log file
- Stored procedures
- Row alignment
- Extreme JOINs
- Your schema must be printed on an A3 sheet
- Your ORM issues full queries for dataset iterations
For more details about these check slidedeck below:
