You're blocking ads, which pay for BlenderNation. Read about other ways to support us.

DbBlender at MySQL Conference, Santa Clara - Help Needed

20

mysqlconf.gifNathan Letwory is integrating Blender and MySQL, which allows new ways of using Blender such as working with huge scene files or distributed/team work. If you though that is cool, wait for this: he has been invited by MySQL to present this at the MySQL Conference in Santa Clara on April 16! After the conference he'll be showcasing his work and for that he can use your help.

Nathan writes:

In April I'll be holding a session about DbBlender (Blender and MySQL integration), at the MySQL Conference in Santa Clara, California.

I've also been asked to showcase it at the DotOrg Pavilion, and for that I receive 4 passes for entrance to the conference and one full conference pass (shared) for entrance to all events. I'll be needing a few people who can help me out at the DotOrg Pavilion booth for showcasing DbBlender.

If you're in the area and able/willing to come, contact me through e-mail ( jesterking at letwory dot net), then we can discuss this in more detail.

About DbBlender

DbBlender is a project to integrate MySQL in Blender as a data backend. The idea is that using a database can enable new ways of using Blender, like huge scenes when dynamic loading (streaming) of the ".blend" is implemented. Also teamwork can be managed through this, with the possibility to create ie. web-based management interfaces to the database, user roles and so on. Databases are created to handle saving data, lots of data, so this power we can use.

This project is currently being prototyped using BPy, but after the conference closer integration into Blender, likely in Blender2.5, will be done.

Demo videos

About Author

Bart Veldhuizen

I have a LONG history with Blender - I wrote some of the earliest Blender tutorials, worked for Not a Number and helped run the crowdfunding campaign that open sourced Blender (the first one on the internet!). I founded BlenderNation in 2006 and have been editing it every single day since then ;-) I also run the Blender Artists forum and I'm Head of Community at Sketchfab.

20 Comments

  1. Sweet idea!

    I dunno, but this kind of integrations sounds like a killer feature which - when implemented - will help a lot the inclusion of Blender in more studios' pipelines. =)

  2. Sounds great, but the choice of database weird.
    Would MySQL need to be running as a service, or be installed on the machine?
    Maybe SQLite its a much better choice.

  3. @bob, the database would run Somewhere Handy. In a production environment you'd have it on a dedicated server. Of course, having it run on your own machine is possible too, but would rather defeat the idea behind it...

    /Nathan

  4. "Also teamwork can be managed through this, with the possibility to create ie. web-based management interfaces to the database, user roles and so on."

    PLEASE DO THIS!!!

    I'm trying to start a project to create a 3D virtual central coast, a region in NSW, Australia. The portion I'm want done is about 286km²!!! And also in high level of detail in the environment... not Toy Story 2 level of detail... like GTA game level of detail. Everything is also meant to be accurate to the metre or less. All the signs, all the roads, all the houses, all the trees, and all textured.....

    A database system using MySQL built-in to Blender to manage the project and the people involved would be a god send gift! It's either this or I have to use my programming skills to create my own system.... which I don't want to do... cause I'm too lazy :P

    I'll (not now, it's 2:10am here) see if I can do anything to help them. I'm not the best programmer but maybe I could help here and there. I REALLY WANT THIS BAD!

  5. @aussiedude, drop me a line at jesterking (at) letwory (dot) net, so that I can approach you when I get into beta testing. Your kind of project is exactly what this is intended for :)

    /Nathan

  6. Well, I didn't quite think it was that useful to do something like this, until I saw aussiedude's post - yeah, storing everything in a DB would be much, much easier than flat files (and permissions managed by the underlying OS)

    I think MySQL isn't right for the job though - this would be handled, with aplomb, by SQLite - compile it right into blender, statically, so it's MUCH easier for users to use and configure.

    Not that I want to sound like a MySQL downer - I use it all the time for my stuff...

  7. SQLite would be ok only for local installations, and then you still have the limit of your local storage space. I haven't really done any benchmarking, but I know I can count on support from MySQL in doing this integration (and hey, I get to talk at the conference, my first trip to the US of A!). For the vast amounts of of data that will have to move across the network, I'm sure that MySQL can offer what I need to achieve at least some degree of usability.

  8. If you want help testing this I'd be glad to help...

    I'm running...
    Vista Home Premium
    MySQL 5.1
    Python 2.51

    and of course Blender...

    ...everything a growing Blenderhead needs...

    ...Let me know if I can be of assistance...:)

  9. Great initiative Nathan.
    I'm working in a opensource game dev team and one of our problems is distributing art files (.blends) between our members. Right now we are using SVN but there is always a risk that two people alter the same file and the artists have to commit and update the repository outside blender, that they sometime forget. Having everything inside blender would be awesome.

  10. /Nathan,

    I guess you are aware but 'just in case'...

    From Python 2.5 on, a feature is integrated to support .dll's.

    + You need to 'convert' the .dll to .pyd, which means recompile and enclose an initfunction for Python and rename the extension to .pyd
    + The '.dll'-support isn't at level 'full-support'.
    + I am not aware of possible 'platform-problems'

    Niels

    ps.
    I guess the real goal is doing the implementation directly in Blender (...and offer access from Python).

  11. /Nathan,

    The relation?...
    Mmm, MySQL(.dll) can be spoken to from within Python already using .pyd?
    This would make 'right away in C' a better choice than 'eventually in C'...

    Niels

  12. I'll be writing out binary data (the raw data) to which BPy doesn't provide an API. Of course, I could add that to the BPy, but I'd be the only one using it. Dunno how useful that'd be. It'd be an easy way to prototyping, though. hmmm.

    /Nathan

Leave A Reply

To add a profile picture to your message, register your email address with Gravatar.com. To protect your email address, create an account on BlenderNation and log in when posting a message.