How to use NOSQL MongoDB with GUI

(Last Updated On: January 19, 2016)
Learn the Secret

Get  our 2 Free Books

Get these now which land directly to their inbox.
Invalid email address

How to use MongoDB with GUI

I am tired of MYSQL lacking utilities thanks to Oracle. Postgres does not look stable in Mac OSX. That leaves me with SQLite or MongoDB. SQLite does not allow clustering while MongoDB does while it is fairly easy to setup. I plan to use MongoDB as a traditional relational database with Redis for in memory. Let’s see what happens with this combo.

 

Also according to DBEngines, it is getting very popular even overtaking Postgres.

http://db-engines.com/en/ranking

 

https://docs.mongodb.org/manual/tutorial/install-mongodb-on-os-x/

 

Best GUI client: https://coderwall.com/p/fb5dgg/the-best-mongodb-gui-for-mac-os-x

Go through Mongo Shell tuturial at https://docs.mongodb.org/getting-started/shell/query/#prerequisites

NOTE: I found RoboMongo kept crashing so I used MongoHub which seems stable. Retrieve under the headline of Download https://github.com/jeromelebel/MongoHub-Mac

On Mongo shell, create database: (http://www.tutorialspoint.com/mongodb/mongodb_create_database.htm)

use qln

Create collection via https://docs.mongodb.org/manual/reference/method/db.createCollection/

I decided to use Python to do all the database creation with collection and population of data.

For each new MongoDB table, export Excel to a CSV and import using the solution at

mongoimport --db myDb --collection myCollection --type csv --headerline --file /path/to/myfile.csv

http://stackoverflow.com/questions/25241500/how-to-import-excel-file-xlsx-to-mongodb

Join my FREE newsletter to learn more about how I plan to use this NOSQL for automated trading

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
This entry was posted in Quant Development and tagged , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs