MongoDB

MongoDB is a NoSQL database. It is pretty easy to use on the command line interface.

So far my favorite aspect of NoSQL is making collections (tables in SQL) and entries on the fly. It doesn't require a schema, although a schema still helps organize and validate Mongo databases. If you don't have a collection then it makes the collection for you to put in your new data entry. SQL is a lot harder to modify without massively disrupting existing tables and code.

I recommend you try MongoDB the next time you need a database.

SQL Column Name Differences

In MySQL, column names are escaped using the back tick like `miles/hour` but double quotes can be used, "miles/hour" when ANSI mode is enabled. This is important because regular SQL does not support back ticks and PostgresSQL only supports double quotes.


So, when setting up your database to be ported into any language, make sure to enable ANSI mode in MySQL and use double quotes around any column names with special characters.