Databases: Difference between revisions
Jump to navigation
Jump to search
>Sho No edit summary |
>Sho No edit summary |
||
Line 5: | Line 5: | ||
===Accessing the Database via SQLite application=== | ===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 [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]). | 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]).<br> | ||
We recommend you use [http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm SQLiteSpy version 1.5.2] or higher. | |||
We recommend you use [http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm SQLiteSpy version 1.5.2] or higher. | *[[HOW-TO: Use your computer to edit XBMC's (SQL) database-files]]. | ||
===TO-DO (what needs to be added to this database article)=== | ===TO-DO (what needs to be added to this database article)=== | ||
*The layout etc. will be explained in more detail here later. | *The layout etc. will be explained in more detail here later. | ||
[[Category:Incomplete]] | |||
[[Category:Inner Workings]] | [[Category:Inner Workings]] |
Revision as of 13:34, 11 June 2007
XBMC Database Details
XBMC utilizes SQLite, an open sourced light-weight SQL database-engine, to store all its library related data (Music, Video and Program databases). 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.