XSI and MySQL

[JDex]

I haven't explored this line of research yet myself, but have thought of it.

I'd think that Python would have good ties to MySQL and you could use some PHP scripting through the netview if you run a local or networked webserver (even local only)... I've had some ideas for this that I plan to explore in my next gig when R&D opportunities come up, so I'll be interested to see any findings that you can share as you go down this path.

[byanfu]

I will, it would be interesting to find out what kind of uses this might have. Ideally PHP would be nice since I am also at the beginning stages of learning that language. I'm sure it would take quite a bit of technical know how to implement something like this, but there really seems to be some exciting possibilities here.

[Atyss]

>>> it would be interesting to find out what kind of uses this might have.

At Big Bang we use MySQL with XSI for two primary purposes:
1- submitting jobs to the render farm
2- keeping track of assets written to disk (models and XML granules).

Future uses will include retrieving framework data for use in scripts and other MySQL transactions.



>>> I'm sure it would take quite a bit of technical know how to implement something like this

Strictly speaking about interfacing with MySQL from Python, not really. As you have seen in my XSI Base post it's very straightforward and high-level.

It all comes down to programming design and knowledge.

The MySQL syntax is extraordinarily easy to learn; with a good reference book and a good query tool (to edit the databases - I use MySQL Browser and MySQL Administrator) you can get up to speed very quickly.

Python on the other hand is not as straightforward and simple as MySQL, but still the better choice over other language availble in XSI imvho, for plenty of reasons. Good online Python ressources include the official Python mailing list and the Tutor list (check out python.org), and Python books are numerous (check out the O'Reilly ones).

Now as for programming design, well, that is based on your experience. Don't hesitate to submit your ideas for critics.



Cheers
Bernard

[byanfu]

Thanks again Bernard,

Sorry about the cross post (with xsibase), all this info is extremely helpful. I have been looking at all of your post on xsibase, and xsi-blog and Its nice to see all the technical information that you have been so helpful in sharing.

I have been looking at a few of the O'Reilly books on Python and have decided to get a few. I'm sure they are a little beyond my level at this point, but I'm determined to learn it regardless. The more I learn about databases the more I love them, and of course XSI :)

[byanfu]

Just a little insite into my motivations. I was hoping that I would set up a future database for the use of the construction of organic 3d topologies based on information in a database. I'm not sure how realistic this is, but I'll try to find out regardless. At least now I have a starting point to work from:)

[Strang]

jscript can be used also if its going to be used in a web context... jscript php and mysql can be quite powerful. python for web development isn't quite there. at least not what i have seen. i would hope someone thats more knowledgable about python and web programming correct me.

[byanfu]

Hi Strang, My only concern with Javascript is that I heard on a recent edition of the podcast “Security Now” that the most recent Black Hat conference in Los Vages talked about some very serious security flaws in Javascript. According to Steve Gibson, they were not easily fixed and it was a fundamental flaw in client side scripting languages. I worry about investing too much time into learning a language that might be unsecured down the road. What are your thoughts on this?

[Strang]

what type of securities are interested in? if this is internal studio, then you should handle security at the door. but if its going to be accessed outisde the studio then i am not familiar with security methods

sorry

[CGTalk Moderation]

This thread has been automatically closed as it remained inactive for 12 months. If you wish to continue the discussion, please create a new thread in the appropriate forum.