Posts: 470
Joined: Jun 2009
Reputation:
0
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!!!
MINIX NEO U22-XJ | Denon AVC-X3800H | KEF Q750 | KEF Q250c | KEF Q150 | KEF Q50a | KEF Kube 10 MIE | LG OLED65G16LA | CoreELEC
Posts: 12,706
Joined: Nov 2003
Reputation:
129
spiff
Team-Kodi Member
Posts: 12,706
yes, you can use sqlite3 to read the db. however, i'd recommend fetching the sqlitebrowser package.
Posts: 470
Joined: Jun 2009
Reputation:
0
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!!
MINIX NEO U22-XJ | Denon AVC-X3800H | KEF Q750 | KEF Q250c | KEF Q150 | KEF Q50a | KEF Kube 10 MIE | LG OLED65G16LA | CoreELEC
Posts: 86
Joined: May 2006
Reputation:
2
.. 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.
freaksworth is not connected to or in any other way affiliated with XBMC, Team XBMC, or the XBMC Foundation.
Posts: 470
Joined: Jun 2009
Reputation:
0
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!!!
MINIX NEO U22-XJ | Denon AVC-X3800H | KEF Q750 | KEF Q250c | KEF Q150 | KEF Q50a | KEF Kube 10 MIE | LG OLED65G16LA | CoreELEC
Posts: 26,215
Joined: Oct 2003
Reputation:
187
when you run sqlite3 <name_of_database> then it tells you to do .help for help.