how to access to the zotero.sqlite using javascript?

johnmy

https://www.zotero.org/support/dev/client_coding/direct_sqlite_database_access mentions zotero.sqlite database could be accessed. I would like to know which functions should be used to get the attachment items paths in zotero.sqlite database.

Could the codes in https://github.com/sql-js/sql.js be used?

var fs = require('fs');
var initSqlJs = require('sql-wasm.js');
var filebuffer = fs.readFileSync('test.sqlite');

initSqlJs().then(function(SQL){
// Load the db
var db = new SQL.Database(filebuffer);
});


dstillman

If you mean from the Run JavaScript window, you shouldn't be doing anything remotely like that. Zotero already has a connection to its database. You can issue SQL commands with Zotero.DB functions, though you shouldn't be doing any writes to the database via SQL.

If you mean from outside of Zotero, that's a general programming question, and you should ask in a general programming forum.

dstillman

@johnmy: But please post further development questions to zotero-dev — we try to keep technical questions there.

johnmy

thanks @dstillman .
I would like to run it in JavaScript window.

dstillman

OK, so it doesn't make sense there at all.