[MacUsers]

Hi there,

Is there anyway SQLite command line interface can be used to access the Library database? If I try, I get an error: "file is encrypted or is not a database". I use MySQL as everyday basis but never used SQLite before. Am I doing extremely stupid thing? Cheers!!!

[spiff]

yes, you can use sqlite3 to read the db. however, i'd recommend fetching the sqlitebrowser package.

[MacUsers]

Thanks spiff; I've downloaded both but it looks like it will take a little while for me to get familiar with the SQL GUI. I yet to figure out how to "sort" table in the GUI.

Previously I installed "sqlite" which didn't work with XBMC database. Cheers!!

[freaksworth]

.. you can switch xbmc to use a mysql database, then use "mysql" or something on cli.
There´s also a nice SQLite-"Browser" as a firefox addon.

[MacUsers]

I got almost nothing on the box apart from the XBMC and the dependent/related packages; its a XBMCbuntu, hence no [gnome] desktop or firefox etc. I've no problem with SQLite being used by XBMC; I was just wondering if I can access the database the normal I do with MySQL.
sqlite3 <db-name> does work bit show tables; doesn't work, as a start. Still trying though....... Cheers!!!

[jmarshall]

when you run sqlite3 <name_of_database> then it tells you to do .help for help.