SQLite Database

Diving In

// get the library, and convert it to a localdatabaselibrary to expose its location 
var library = Cc["@songbirdnest.com/Songbird/library/Manager;1"].getService(Ci.sbILibraryManager)
                .mainLibrary.QueryInterface(Ci.sbILocalDatabaseLibrary);  

// make a query, and set it to use the database from the library 
var query = Cc["@songbirdnest.com/Songbird/DatabaseQuery;1"].createInstance(Ci.sbIDatabaseQuery); 
query.databaseLocation = library.databaseLocation; 
query.setDatabaseGUID(library.databaseGuid);

// add a query, execute it, then get the results.
var sql = <>
 SELECT count(*) FROM media_items
</>.toString()
query.addQuery(sql);
var start = new Date();
query.execute();
var end = new Date();

var results = query.getResultObject();

for (var j = 0; j < results.getColumnCount(); j++) {
    str += results.getColumnName(j) + "\t";
}
print(str); // be sure you're using a JS environment like XPCOMViewer's which provides this function

for(var i = 0; i < results.getRowCount(); i++) {
  var str = "";
  for (var j = 0; j < results.getColumnCount(); j++) {
    str += results.getRowCell(i, j) + "\t";
  }
  print(str);
}
print(results.getRowCount() + " rows. Time elapsed: " + (end - start) + " ms.");

Usage Notes

Advanced Usage

// add a query, execute it, then get the results.
query.addQuery("explain select count(*) from media_items");
query.execute();
var results = query.getResultObject();

for (var j = 0; j < results.getColumnCount(); j++) {
    str += results.getColumnName(j) + "\t";
}
// print is a handy function provided by the XPCOMViewer JS Shell, running this elsewhere will call window.print
print(str);

for(var i = 0; i < results.getRowCount(); i++) {
  var str = "";
  for (var j = 0; j < results.getColumnCount(); j++) {
    str += results.getRowCell(i, j) + "\t";
  }
  print(str);
}