David, Thanks for the feedback. I should have been more specific on the usage of the data. The data will be some email addresses, names, department, and an indicator if the email address is internal to the business or an external contact. So, one table with these being the fields in each record should suffice. The users will be presented an interface that allows them to select one or more recipients to which a standardized email with a PDF attachment will be sent. All of this is no problem. I was concerned that with more than one user at a time potentially accessing the SQLite db at a time would be a problem, but I see from the SQLite site and from some discussions here on Tutor that this is perfectly fine. The users may add information to the db also, but since such writes will be infrequent this too should be OK. At least, that is the impression that I have gotten from what I have read here and other places. Just wanting to confirm that I have understood this correctly. Also, any other suggestions are welcome.
Thanks, Bill Allen On Sat, Dec 11, 2010 at 6:32 AM, David Hutto <smokefl...@gmail.com> wrote: > On Fri, Dec 10, 2010 at 10:23 PM, Bill Allen <walle...@gmail.com> wrote: > > This is somewhat non-Python specific I have an idea for a Python > > application that I want to write at work. The application needs to have > a > > data file be available to multiple users for access, read and write. I > > know that a typical database, such as mysql, would work ok. However, I > am > > trying to keep managed infrastructure down to a minimum so I am > considering > > using sqlite instead. Since there is not a database service running to > > handle requests to the sqlite database, how can I allow for multiple > people > > trying to use this database at the same time? Is this practical? > > No expert, but is it a single db file per user on a server, or a > single db file that adds a table for every user? > > > > > > Thanks, > > Bill Allen > > > > > > _______________________________________________ > > Tutor maillist - Tutor@python.org > > To unsubscribe or change subscription options: > > http://mail.python.org/mailman/listinfo/tutor > > > > >
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
