You would need to reinvent ACID updates if you shared the catalog.<br><br><div class="gmail_quote">On Mon, May 4, 2009 at 12:34 PM, James Simmons <span dir="ltr"><<a href="mailto:jim.simmons@walgreens.com">jim.simmons@walgreens.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Carol,<br>
<br>
I would not use sqllite 3. The metadata for several hundred books could easily fit in memory. It would basically be a good sized spreadsheet. Python has a "pickling" feature which can save a bunch of objects in memory in a single file that can be easily reloaded into memory. I could store the pickle file as a Journal entry. I would not try to recreate ALL of Calibre, just the parts I would find the most useful. That way the Activity could be entirely self contained.<br>
<font color="#888888">
<br>
James Simmons</font><div><div></div><div class="h5"><br>
<br>
Carol Farlow Lerche wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Calibre makes a sqlite3 database which is the basis for its display. It seems to have a reasonable schema. (An easy way to examine it is with the Sqlite Manger, an excellent Firefox add-on if you haven't already discovered it).<br>
<br>
</blockquote>
<br>
<br>
</div></div></blockquote></div><br>