Zotero

zotero is a free Firefox extension, easy-to-use research tool that helps you gather and organize resources (whether bibliography or the full text of articles), and then lets you to annotate, organize, and share the results of your research. It includes the best parts of older reference manager software (like EndNote)—the ability to store full reference information in author, title, and publication fields and to export that as formatted references—and the best parts of modern software such as del.icio.us , like the ability to sort, tag, and search in advanced ways.

In zotero, data are stored using the sqlite, so using an external sqlite engine, you can query or update the database without firefox/mozilla:

pierre@linux:~/> echo ".tables" |./sqlite3-3.3.8.bin -separator '   ' -header ~/.mozilla/firefox/xxxx.default/zotero/zotero.sqlite

charsets               itemAttachments        tags
collectionItems        itemCreators           transactionLog
collections            itemData               transactionSets
creatorTypes           itemNotes              transactions
creators               itemSeeAlso            translators
csl                    itemTags               userFieldMask
fieldFormats           itemTypeCreatorTypes   userFields
fields                 itemTypeFields         userItemTypeFields
fileTypeMimeTypes      itemTypes              userItemTypeMask
fileTypes              items                  userItemTypes
fulltextItems          savedSearchConditions  version
fulltextWords          savedSearches


pierre@linux:~/> echo "select * from items order by dateAdded;" |./sqlite3-3.3.8.bin-separator '   ' -header ~/.mozilla/firefox/xxxx.default/zotero/zotero.sqlite

itemID  itemTypeID      title   dateAdded       dateModified
8423    4       Haplotypes in the gene encoding protein kinase c-beta (PRKCB1) on chromosome 16 are associated with autism.     2006-10-30 18:47:16     2006-10-30 18:47:56
15625   1               2006-10-30 18:48:11     2006-10-31 10:50:53

About sqlite: There is a video about this engine on google-video.

Technorati Keywords: sqlite zotero sql firefox extension mozilla