Lately, I have been working with a lot of legacy SQL and this has caused me to think about what makes SQL (and database designs) good and bad. There is a concept called ACID, defined within ISO/IEC 10026-1:1992. ACID is an acronym, that stands for Atomicity, Consistency, Isolation, and Durability.Continue reading "What is good SQL?"
I was playing around with consumption of a CouchDB JSON feed when I received the familiar “Cross-Origin Request Blocked” error. The question is, “How do you enable CORS in CouchDB?” If you open the ‘Configuration’ tool, you will find ‘enable_cors’ under ‘httpd’. You want to change that value to ‘true’. Next, if you scroll down …Continue reading "CouchDB: How to enable CORS in CouchDB"
So, you just created a CouchDB database, added a user to it, and want access to be limited to that user? There is a simple way of doing this. Let’s use a previous example, for this demo. As you can see below, by default, you do not need to be authenticated, in order to interact …Continue reading "CouchDB: Requiring users of your database be valid users"
If you are like me, you probably have not had much of a reason to use NoSQL but you have been interested in it. I recently decided to check out CouchDB. CouchDB is an Apache project that was created in 2005 by Damien Katz. CouchDB is interesting in that it stores your data with JSON documents …Continue reading "CouchDB: Creation, population, and querying of a DB"
Database normalization is a process meant to reduce or eliminate data redundancy. Typically, a normalized database exists in first normal form (1NF), second normal form (2NF), or third normal form (3NF). First Normal Form In order for a database to be in first normal form, your tables must not contain repeating groups of data. Let’s look …Continue reading "Better living through database normalization"