Sql toolkit for python?

Pipelines
1

Hi,

just want to ask you guys what is the commonly used sql toolkit in the cg industry when it comes to RDBMS? i am currently working on a database manager that will be used to track files etc…
my first option was sqlite but i have read that database files in sqlite has a possibility to be corrupt when accessed by multiple users. any insights?

thanks in advance!

Peter

2

I’m curious too what people use.

We use mySQL for multiuser (switched from MS SQL Server) and sqlite for single user/client side DBs.

sqlite is not really made for big multiuser apps, and you need to give users write access to the file, which ain’t good in general. You don’t want a user to open your mysql db and mess around or delete the file, etc. For small scale multiuser apps (e.g. web apps) sqlite can work - there’s even an option in Wikimedia to use sqlite (which we currently do for a 5 user wiki). Here the sqlite file is on your server and only accessible via your cgi script, so it’s safe (or as safe as your webserver is at least).

For access we use pyODBC because compiles easily for all versions of Maya, even very old ones. Otherwise we mostly use Qt’s DB module (which doesn’t work in Maya :frowning: ) but is pretty stable, fast and convenient when you work a lot with Qt.

3

We use MS SQL Server for multiuser tools, both local and remote/between studios, and SQLite for local client work for one particular tool. We’ve been happy with the performance of both.

I use SQLAlchemy ORM for working with our DBs from Python as much as possible. It rocks.

4

thanks for your replies!