Databases: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
>Sho
>Blittan
Line 8: Line 8:
===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]).<br>
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.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLiteSpy version 1.5.2] or higher.
*[[HOW-TO: Use your computer to edit XBMC's (SQL) database-files]].
*[[HOW-TO: Use your computer to edit XBMC's (SQL) database-files]].



Revision as of 09:54, 7 October 2007

Incomplete.png INCOMPLETE:
This page or section is incomplete. Please add information or correct uncertain data which is marked with a ?

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\.

Also XBMC puts a video in it's database if you change any OSD setting while watching, resume points are also stored here. That is independant of if the video is part of the Video Library or not.

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.