MongoDB iReport, @kchodorow books

MongoDB iReport

Yippee! I can now write data (manually at the moment!) into MongoDB and read it out into iReport!

Big thanks to @mattdahlman

Tomorrow I’m going to explore unetbootin (thanks to Pete Griffiths) and maybe reformat the old dell to be a Linux machine. I can’t help but think having 3 different O/S in the eventual cluster is going to be troublesome.

I’ve also ordered 2 more @kchodorow books ‘50 Tips and Tricks for MongoDB Developers

http://www.amazon.co.uk/Tips-Tricks-MongoDB-Developers-ebook/dp/B005011IIM/ref=dp_kinw_strp_1

& ‘Scaling MongoDB’ – which hopefully will help me get my head around clustering/sharding within MongoDB.

http://www.amazon.co.uk/Scaling-MongoDB-ebook/dp/B004LRPBD4/ref=dp_kinw_strp_1

Advertisements

MongoDB connection from Jaspersoft ‘iReport’

I have created a few DBs (largely copying pp 137 from the excellent ‘7 databases in 7 weeks’) and manually entered a dozen or so rows. The Mongo equivalent of select * from is dbfind()

http://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&ved=0CCgQFjAB&url=http%3A%2F%2Fwww.amazon.co.uk%2FSeven-Databases-Weeks-Modern-Movement%2Fdp%2F1934356921&ei=wzGiUIGQO82W0QXwp4HAAg&usg=AFQjCNGDmifztGqAE-XoQzebWHDB3KjYVg

And I’ve managed to install Japsersoft iReport.

So far, so good.

But…When I create a datasource connection from within iReport to MongoDB I am asked for 3 things
1 MongoURI
2 Username
3 Password

The pre-filled default for 1 is ‘mongodb://HOST:27017/DB_NAME’
I assume I substitute DB_NAME for towns (my recently created database) – but this doesn’t work.
I also assume I can leave a username and password as blank?
– As show users (in Mongo shell) returns nothing (and I haven’t yet created any)

So, brick wall. Have raised a JIRA @ MongoDB, hopefully someone can help me out!

MongoDB

Bought a mini WiFi dongle and powered USB hub. The hub lets you plug more than 2 devices into a Pi. The Pi has just 2 USB outputs. So, if you need a mouse, keyboard, USB memory stick and wifi dongle you’re out of luck!

Needed to connect the RPi to the wifi ethernet wired port, which meant disassembling everything and moving downstairs to the router. Connected the RPi to the living room TV and went through various sudo apt-get update commands, which should hopefully have installed all the latest drivers etc. Then, it could sit happily back upstairs and pick up wi-fi internet (via the mini dongle) for updates etc.

TBH, it’s proving really hard to get the RPis operational. It was so S-L-O-W for a webpage to load via Mondrian browser, i got bored and tried something else, so am not sure if I was successful or not installing firmware etc. RPis and sharding on the backburner for now.

Instead, I chose to mess around with MongoDB just on the laptop, and worry about sharding later. I’ve inserted some dummy records and can already see how attractive a schema-free database can be, effectively adding ‘columns’ to a collection on the fly, not having to specify directories for log files etc etc.

I’m downloading community editions of Jaspersoft Studio, iReport, ETL. My plan for tomorrow is to see if I can see the data I created in something like Jaspersoft iReport.