Go back to the blog

Database Design

Learn to design your database model and organize information in your software with this series of articles!

Having NULL values in the database can be a little bit tricky for string columns — for simple queries like .where(name: "Frank"), a NULL value acts as an empty string. The problem comes when using the NOT predicate: empty columns are then ignored, even though they might match a query like .where.not(name: "Frank")

Read full article