Brian Blais wrote: > Hello, > > I have more of a conceptual question about the way databases work, in a > web > framework, but I will be implementing things with CherryPy and SQLAlchemy. > If you make a web form that adds rows to a database, and use sqlite as > the engine, is there a danger of a race condition if several users at the > same time try to submit the > form? I want a unique row id, and make a unique identifier for the > submissions. Am I in danger of having multiple submissions given the same > identifier? > > I know that if I implemented things without a database, but used a flat > file or something like it, I would have that possibility, when two > processes try to read and update the file at the same time. > > If you want something more specific, I can throw some code together, but I > wanted to get an answer before that because it will change the way I > develop the code.
Usually, that is exactly what a RDBMS gives you. See the database connector module's threadsaftey property to see what exactly you can expect. Diez -- http://mail.python.org/mailman/listinfo/python-list
