For my RSS reader Fawn (It was Echo but apparently there was another Echo RSS so I decided to rename it to another nonsense 4 letter name) I’m using Firestore and I learned a lot about it.
I’ve never really used a database quite like Firestore before. I didn’t even know there was even such a thing as a non-SQL database because all throughout University the only database type anyone ever talked about was SQL.
And I really like NoSQL. Mostly because of the syntax. I find it much more intuitive than having to wrap your head around SELECT, WHERE, IN, HAVING, GROUP BY, etc. But it does take a bit more work to get working properly. In SQL you have access to any query you could possibly think of. NoSQL, at least with Firestore, is much more restrictive.
I’m still learning about it and today I just made another discovery.
Unique Key Constraints
Unique key constraints are something that are very easy to do in SQL and they are very useful. In fact I need this feature in my RSS app. This is because…
