Has anybody used databases at all while building maxscript tools? I was thinking about using SQLite, as it is portable. Any experience you have to share would be great.
Cheers,
Joel
I have a lot of experience using maxScript and a lot using databases, but every time I think I need to merge the two, it ends up being easier just to export the data into a static file and import it into max (repeatedly for a quasi real time effect).
I’m curious what situation you’ve found where you’d need to query a db for max.
I have a large vehicle database that I want to access from max. I want to be able to create instances of specific vehicles, and store them in a shared environment. I don’t need a constant connection to the db.
I’d love to see the Python code Dav. My first thought was to create a C# class that does the actual queries on the database. I’m learning as I go, but I like Python, so any chance to see some working code is great.
Hi, Joel,
I have used a Database before for version control, I have successfully done it with COM/OLE using the ADODB.Connection interface. I have also used python+com to do it which I found worked much better. If I can dig up the code (it was quite a while ago) ill post it up.
Cheers
Dav
I’m currently developing a VB Express with database access, SQL Express to be more precise. I think it’s quite possible to do something similar in Max using the .net framework.