Databases: Difference between revisions
Jump to navigation
Jump to search
>Dankula |
>Gamester17 No edit summary |
||
| Line 1: | Line 1: | ||
== XBMC Database Details == | ==XBMC Database Details== | ||
XBMC utilizes [http://www.sqlite.org/ 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=== | ===Accessing the Database via SQLite application=== | ||
Database files can be transferred via FTP to a Windows | 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 [http://sqlitebrowser.sourceforge.net SQLiteBrowser] or [http://bobmanc.home.comcast.net/sqlitecc.html SQLiteCC], (more available management-tools can be found in [http://www.sqlite.org/cvstrac/wiki?p=ManagementTools sqlite.org WIKI]). | ||
We recommend you use [http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm SQLiteSpy version 1.5.2] or higher.<br><br> | |||
===TO-DO (what needs to be added to this database article)=== | |||
*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]]. | |||
Revision as of 10:35, 12 September 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.