1. NodeBox 1
    1. Homepage
    2. NodeBox 3Node-based app for generative design and data visualization
    3. NodeBox OpenGLHardware-accelerated cross-platform graphics library
    4. NodeBox 1Generate 2D visuals using Python code (Mac OS X only)
  2. Gallery
  3. Documentation
  4. Forum
  5. Blog

MySQLdb Used for Photobjects?

Posted by Sarah on Oct 10, 2007

I am trying to develop a project like Photobjects, specifically, I want to query images from a database. I am assuming that Photobjects uses MySQLdb, the MySQL-Python library. I am having trouble geting MySQLdb to import into Nodebox, although it runs fine on its own. I assume it has to do with setting it up and setting up the path. How do I solve this problem, or, what did you use for your database for Photobjects.

thanks!


 
Posted by Tom De Smedt on Oct 15, 2007

Photobjects stores the files in folders and has a database with an index of search keywords linked to specific images in the folders. The database itself is in SQLite format, it uses the NodeBox Database library. An SQLite database is a simple file you can store anywhere on disk, which I find to be an advantage in projects that move around a lot.

Best regards,
Tom



Posted by Sarah on Oct 15, 2007

I have been able to get MySQLdb to in fact start working with NodeBox and I will let you know when I get something awesome working. Thanks for your help!



Posted by Tom De Smedt on Oct 19, 2007

Keep it up! And if you have some visual output, please show us.



Posted by Sarah on Oct 24, 2007

So far I have just gotten the db to display a picture from my query. I am working with MySQLdb because I thought it would be easier to cull a database of media belonging to my research group. Since we have rows in our database with keywords and annotation about the media, I thought I could couple that with the linguistics library to determine if a picture is emotional. I am still working on it but will send out images as soon as I get some decent ones. Thanks for your help.