Relationships with MongoDB Even if MongoDB is classified as a document database, the pieces of information stored in the database still have relationships between them. Understanding how to represe...

One of the most common misconceptions about data modeling in MongoDB is that modeling is schemaless, meaning that it doesn’t really matter which field documents have or how different the documents ...

Aggregation Framework The aggregation framework in its simplest form is just another way to query data in MongoDB. Everything we know how to do using the MongoDB query language (MQL) can also be do...

MQL Operators Update Operators: Example: $inc, $set, $unset These update operators enable us to modify data in the database. Query Operators: Query Operators provides additi...

Inserting New Documents Every MongoDB document must have unique _id value. ANd every _id field in a collection must have a unique value from the rest of the documents in the collection. Likewise, ...

How Does MongoDB Store Data? MongoDB uses documents to store data. When we view or update documents in the MongoDB shell, you’re working in JSON which stands for ‘JavaScript Standard Object Notati...

What is a MongoDB Database? A database, meaning a structured way to store and access data. More specifically, it is a NoSQL database. NoSQL databases mean that it doesn’t use the traditional appro...

sql2csv : documentation sql2csv: executes an SQL query on a large variety of SQL databases (e.g. MS SQL, MySQL, Oracle, PostgreSQL, Sqlite) outputs the result to a CSV ...

What is csvkit? csvkit: is a suite of command-line tools is developed in Python by Wireservice offers data processing and cleaning capabilities on CSV files ...