Databases: Difference between revisions
Jump to navigation
Jump to search
>Gamester17 No edit summary |
>Slorv |
||
| Line 14: | Line 14: | ||
*The layout etc. will be explained in more detail here later. | *The layout etc. will be explained in more detail here later. | ||
*Write a [[HOW-TO: Use your computer to edit XBMC's (SQL) database-files|step-by-step HOW-TO guide about editing database files on a PC]]. | *Write a [[HOW-TO: Use your computer to edit XBMC's (SQL) database-files|step-by-step HOW-TO guide about editing database files on a PC]]. | ||
*Write a [[HOW-TO: Use your non-Windows computer to edit XBMC's (SQL) database-files|step-by-step HOW-TO guide about editing database files on a non-Windows computer]]. | |||
Revision as of 07:47, 1 October 2006
XBMC Database Details
XBMC utilizes SQLite, a open sourced light-weight SQL database-engine, to store all its library related data (My Music, My Videos and My Programs). By default, the database files (*.db) are stored in $HOME\UserData\Database\.
Accessing the Database via SQLite application
Database files can be transferred via FTP to a Windows-based computer and edited or analyzed with a SQLite graphical client. XBMC's version of the database engine should be compatible with the standard clients such as SQLiteBrowser or SQLiteCC, (more available management-tools can be found in sqlite.org WIKI).
We recommend you use SQLiteSpy version 1.5.2 or higher.
TO-DO (what needs to be added to this database article)
- The layout etc. will be explained in more detail here later.
- Write a step-by-step HOW-TO guide about editing database files on a PC.
- Write a step-by-step HOW-TO guide about editing database files on a non-Windows computer.