31 October 2006


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.

No comments: