[Tutor] using a networked data file

[Bill Allen]

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 <smokefloat at gmail.com> wrote:

> On Fri, Dec 10, 2010 at 10:23 PM, Bill Allen <wallenpb at 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 at python.org
> > To unsubscribe or change subscription options:
> > http://mail.python.org/mailman/listinfo/tutor
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20101211/330c519b/attachment.html>