Official Kodi Wiki - User contributions [en]

HOW-TO:Install Kodi on Raspberry Pi

2023-01-19T10:50:29Z

Graysky: update Arch ARM selection

{{mininav|[[Raspberry Pi]]|page={{FULLPAGENAME}} }}
The basic hardware you will need is
* the R-Pi board itself
* a power supply (Micro-USB, 5V, upto 2500 mA)
* a (micro)SDHC memory card to install the software. (Because video decoding is more resource-intensive than many other operations, it may be more important to have a fast/high quality memory card for Kodi than for other uses.)

== Basic options ==

<section begin="install"/>
;Easy / Kodi centric distributions
* '''[[LibreELEC]] -''' [https://libreelec.tv/downloads_new/ Download] • [https://wiki.libreelec.tv Wiki] • [http://forum.libreelec.tv Forum]

* '''[[OSMC]] -''' [https://osmc.tv/ Home] [https://osmc.tv/download/ Installing] • [https://osmc.tv/wiki Wiki] • [https://discourse.osmc.tv Support Forum]

* '''[[XBian]] -''' [http://xbian.org/getxbian/ Installing] • [http://xbian.org/faq/ FAQ] • [http://xbian.org/getting-started/ Starters guide] • [http://forum.xbian.org/ Forum]

;Advanced / can be used with Kodi
* '''Arch Linux ARM -''' [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-4 RPi4] • [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-3 RPi3] • [http://archlinuxarm.org/platforms/armv7/broadcom/raspberry-pi-2 RPi2] • [http://archlinuxarm.org/platforms/armv6/raspberry-pi RPi1]

Note that Arch ARM provides different Kodi packages optimized for different RPi models. All builds offer some flavor of HW accelerated decoding just like LibreELEC. The following packages will supply the current stable version of Kodi:

[https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi kodi-rpi] for RPi 3/4/400

[https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi-legacy kodi-rpi-legacy] for RPi 2

Users wanting to track the master branch may select:

[https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi kodi-rpi-git] for RPi 3/4/400 only

* '''Batocera Linux -''' [https://batocera-linux.xorhub.com/#learn Learn More]

* '''[[Buildroot]]''' - For experienced users only !

* '''CarPC -''' [http://www.engineering-diy.blogspot.ro/2015/01/raspberrypi-carpc-tutorial.html Guide]

* '''Raspberry Pi OS -''' Up-to-date versions '''(Currently Leia 18.7)''' of Kodi are now on the default Raspbian repositories. See '''[[HOW-TO:Install Kodi on Raspberry Pi#Raspberry Pi OS|full guide here]]'''.

* '''Recalbox -''' [http://www.recalbox.com/diyrecalbox Installing]
<section end="install"/>

* '''RetroPie - ''' See '''[[HOW-TO:Install Kodi on Raspberry Pi#RetroPie|full guide here]]'''

== Specific install guides ==
For installs that don't directly include and/or boot into Kodi automatically.

=== Raspberry Pi OS ===
{{editor note|We need to expand on this section, but here are the basic commands if you are familiar with the command-line:}}

'''(Current Version - 18.7)'''

<pre>
sudo apt-get update
sudo apt-get install kodi
</pre>

;PVR Addons
* PVR Addons can be installed directly from the command line:
<pre>
sudo apt-get update
sudo apt-get install PACKAGENAMEHERE
</pre>
but replace '''PACKAGENAMEHERE''' with the PVR addon required.
<pre>example: sudo apt-get install kodi-pvr-hts</pre>
The PVR client add-on should now be installed. If Kodi was already running, restart it to load the add-on.

=== RetroPie ===
Here's a [https://www.youtube.com/watch?v=MyeCQS7ITnU youtube guide]:

{{#widget:YouTube|id=MyeCQS7ITnU}}

== Compiling Kodi ==
Notes for advanced users who wish to try and build Kodi from source code.
* Various good notes mentioned here: https://github.com/xbmc/xbmc/blob/master/docs/README.RaspberryPi.md

{{updated|22}}

[[Category:Manual]]
[[Category:Installation|Raspberry Pi]]
[[Category:Raspberry Pi]]
[[Category:How-to]]

Settings/Services/NFS Client

2023-01-19T10:44:36Z

Graysky: remove windows warning due to author's lack of windows knowledge

{{mininav| [[Settings]] | [[Settings/Services|Services]] }}

__TOC__

==NFS Protocol Version==
{|
|- valign="top"
| width=120px | {{nowrap|'''Settings level:'''}}
| Advanced
|- valign="top"
| '''Description:'''
| Toggle between NFSv3 or NFSv4 to match the settings used on the NFS export(s)
|-valign="top"
|}

{{updated|20}}

Settings/Services/NFS Client

2023-01-19T10:27:37Z

Graysky: create page with new setting in v20

{{mininav| [[Settings]] | [[Settings/Services|Services]] }}

__TOC__

{{warning| <center>'''These settings do not apply, and are not visible when using MS Windows'''</center>}}

==NFS Protocol Version==
{|
|- valign="top"
| width=120px | {{nowrap|'''Settings level:'''}}
| Advanced
|- valign="top"
| '''Description:'''
| Toggle between NFSv3 or NFSv4 to match the settings used on the NFS export(s)
|-valign="top"
|}

{{updated|20}}

HOW-TO:Install Kodi on Raspberry Pi

2021-04-18T12:04:30Z

Graysky: /* Basic options */ list alphabetically

{{mininav|[[Raspberry Pi]]|page={{FULLPAGENAME}} }}
The basic hardware you will need is
* the R-Pi board itself
* a power supply (Micro-USB, 5V, upto 2500 mA)
* a (micro)SDHC memory card to install the software. (Because video decoding is more resource-intensive than many other operations, it may be more important to have a fast/high quality memory card for Kodi than for other uses.)

== Basic options ==

<section begin="install"/>
;Easy / Kodi centric distributions
* '''[[LibreELEC]] -''' [https://libreelec.tv/downloads_new/ Download] • [https://wiki.libreelec.tv Wiki] • [http://forum.libreelec.tv Forum]

* '''[[OSMC]] -''' [https://osmc.tv/ Home] [https://osmc.tv/download/ Installing] • [https://osmc.tv/wiki Wiki] • [https://discourse.osmc.tv Support Forum]

* '''[[XBian]] -''' [http://xbian.org/getxbian/ Installing] • [http://xbian.org/faq/ FAQ] • [http://xbian.org/getting-started/ Starters guide] • [http://forum.xbian.org/ Forum]

;Advanced / can be used with Kodi
* '''Arch Linux ARM -''' [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-4 RPi4] • [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-3 RPi3] • [http://archlinuxarm.org/platforms/armv7/broadcom/raspberry-pi-2 RPi2] • [http://archlinuxarm.org/platforms/armv6/raspberry-pi RPi1]

Note that Arch ARM provides different Kodi packages optimized for different RPi models. All builds feature popcornmix's [https://github.com/popcornmix/xbmc/tree/gbm_matrix gbm_matrix] branch of Kodi and offer some flavor of HW accelerated decoding just like LibreELEC.
[https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi kodi-rpi] for RPi 3/4/400
[https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi-legacy kodi-rpi-legacy] for RPi 2 (popcornmix's [https://github.com/popcornmix/xbmc/tree/gbm_matrix gbm_matrix] branch)

* '''Batocera Linux -''' [https://batocera-linux.xorhub.com/#learn Learn More]

* '''[[Buildroot]]''' - For experienced users only !

* '''CarPC -''' [http://www.engineering-diy.blogspot.ro/2015/01/raspberrypi-carpc-tutorial.html Guide]

* '''Raspberry Pi OS -''' Up-to-date versions '''(Currently Leia 18.7)''' of Kodi are now on the default Raspbian repositories. See '''[[HOW-TO:Install Kodi on Raspberry Pi#Raspberry Pi OS|full guide here]]'''.

* '''Recalbox -''' [http://www.recalbox.com/diyrecalbox Installing]
<section end="install"/>

* '''RetroPie - ''' See '''[[HOW-TO:Install Kodi on Raspberry Pi#RetroPie|full guide here]]'''

== Specific install guides ==
For installs that don't directly include and/or boot into Kodi automatically.

=== Raspberry Pi OS ===
{{editor note|We need to expand on this section, but here are the basic commands if you are familiar with the command-line:}}

'''(Current Version - 18.7)'''

<pre>
sudo apt-get update
sudo apt-get install kodi
</pre>

;PVR Addons
* PVR Addons can be installed directly from the command line:
<pre>
sudo apt-get update
sudo apt-get install PACKAGENAMEHERE
</pre>
but replace '''PACKAGENAMEHERE''' with the PVR addon required.
<pre>example: sudo apt-get install kodi-pvr-hts</pre>
The PVR client add-on should now be installed. If Kodi was already running, restart it to load the add-on.

=== RetroPie ===
Here's a [https://www.youtube.com/watch?v=MyeCQS7ITnU youtube guide]:

{{#widget:YouTube|id=MyeCQS7ITnU}}

== Compiling Kodi ==
Notes for advanced users who wish to try and build Kodi from source code.
* Various good notes mentioned here: https://github.com/xbmc/xbmc/blob/master/docs/README.RaspberryPi.md

{{updated|18}}

[[Category:Manual]]
[[Category:Installation|Raspberry Pi]]
[[Category:Raspberry Pi]]
[[Category:How-to]]

HOW-TO:Install Kodi on Raspberry Pi

2021-04-18T12:02:22Z

Graysky: /* Basic options */ update Arch ARM packages

{{mininav|[[Raspberry Pi]]|page={{FULLPAGENAME}} }}
The basic hardware you will need is
* the R-Pi board itself
* a power supply (Micro-USB, 5V, upto 2500 mA)
* a (micro)SDHC memory card to install the software. (Because video decoding is more resource-intensive than many other operations, it may be more important to have a fast/high quality memory card for Kodi than for other uses.)

== Basic options ==

<section begin="install"/>
;Easy / Kodi centric distributions
* '''[[LibreELEC]] -''' [https://libreelec.tv/downloads_new/ Download] • [https://wiki.libreelec.tv Wiki] • [http://forum.libreelec.tv Forum]

* '''[[OSMC]] -''' [https://osmc.tv/ Home] [https://osmc.tv/download/ Installing] • [https://osmc.tv/wiki Wiki] • [https://discourse.osmc.tv Support Forum]

* '''[[XBian]] -''' [http://xbian.org/getxbian/ Installing] • [http://xbian.org/faq/ FAQ] • [http://xbian.org/getting-started/ Starters guide] • [http://forum.xbian.org/ Forum]

;Advanced / can be used with Kodi
* '''Raspberry Pi OS -''' Up-to-date versions '''(Currently Leia 18.7)''' of Kodi are now on the default Raspbian repositories. See '''[[HOW-TO:Install Kodi on Raspberry Pi#Raspberry Pi OS|full guide here]]'''.

* '''CarPC -''' [http://www.engineering-diy.blogspot.ro/2015/01/raspberrypi-carpc-tutorial.html Guide]

* '''RetroPie - ''' See '''[[HOW-TO:Install Kodi on Raspberry Pi#RetroPie|full guide here]]'''

* '''Recalbox -''' [http://www.recalbox.com/diyrecalbox Installing]

* '''Batocera Linux -''' [https://batocera-linux.xorhub.com/#learn Learn More]

* '''Arch Linux ARM -''' [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-4 RPi4] • [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-3 RPi3] • [http://archlinuxarm.org/platforms/armv7/broadcom/raspberry-pi-2 RPi2] • [http://archlinuxarm.org/platforms/armv6/raspberry-pi RPi1]

* Note that Arch ARM provides different Kodi packages optimized for different RPi models. All builds feature popcornmix's [https://github.com/popcornmix/xbmc/tree/gbm_matrix gbm_matrix] branch of Kodi and offer some flavor of HW accelerated decoding just like LibreELEC.
* [https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi kodi-rpi] for RPi 3/4/400
* [https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rpi-legacy kodi-rpi-legacy] for RPi 2 (popcornmix's [https://github.com/popcornmix/xbmc/tree/gbm_matrix gbm_matrix] branch)

* '''[[Buildroot]]''' - For experienced users only !
<section end="install"/>

== Specific install guides ==
For installs that don't directly include and/or boot into Kodi automatically.

=== Raspberry Pi OS ===
{{editor note|We need to expand on this section, but here are the basic commands if you are familiar with the command-line:}}

'''(Current Version - 18.7)'''

<pre>
sudo apt-get update
sudo apt-get install kodi
</pre>

;PVR Addons
* PVR Addons can be installed directly from the command line:
<pre>
sudo apt-get update
sudo apt-get install PACKAGENAMEHERE
</pre>
but replace '''PACKAGENAMEHERE''' with the PVR addon required.
<pre>example: sudo apt-get install kodi-pvr-hts</pre>
The PVR client add-on should now be installed. If Kodi was already running, restart it to load the add-on.

=== RetroPie ===
Here's a [https://www.youtube.com/watch?v=MyeCQS7ITnU youtube guide]:

{{#widget:YouTube|id=MyeCQS7ITnU}}

== Compiling Kodi ==
Notes for advanced users who wish to try and build Kodi from source code.
* Various good notes mentioned here: https://github.com/xbmc/xbmc/blob/master/docs/README.RaspberryPi.md

{{updated|18}}

[[Category:Manual]]
[[Category:Installation|Raspberry Pi]]
[[Category:Raspberry Pi]]
[[Category:How-to]]

MySQL/Advanced notes

2021-02-01T12:00:10Z

Graysky: /* Removing stale entries from the database */ refine wording a bit

{{:MySQL/Contents}}
{{mininav| [[MySQL]] }}
__TOC__
{{-}}
==advancedsettings.xml==
For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#musicdatabase/videodatabase]]'''

== Other databases (PVR and ADSP) ==

{{MySQL warning}}

==MySQL speed-up tweaks==

=== In advancedsettings.xml: ===
Use the IP address and NOT the hostname of your MySQL server<br />
eg.: 192.168.1.105 <<IP address>> instead of \\SERVER

==Removing stale entries from the database==
Occasionally, it can be beneficial to remove database entries that correspond to files that are no longer on available on the file-system. Note that these orphaned database entries are independent from the Kodi library status which is managed by Kodi [[https://kodi.wiki/view/List_of_built-in_functions#Library_built-in.27s built ins]] such as '''CleanLibrary()'''.

{{Warning|The database should ALWAYS be backed-up before attempting these commands.}}

To locate and delete orphaned database entries, connect to the box serving up the SQL database and log into the SQL database:
mysql -u root -p

Once authenticated, the following can be used to identify active databases on which to work:
SHOW databases;

For example, Matrix will generate a video database called, "MyVideos119."

Execute the following to identify possible rows for deleting:
USE MyVideos119;
SELECT * FROM files WHERE idfile not in (select idfile from episode) and idfile not in (select idfile from movie) and idfile not in (select idfile from musicvideo) ORDER BY `idFile` DESC;

If the command returns rows, these should be stale entries that can be safely removed by substituting DELETE for SELECT * in the last command:

DELETE FROM files WHERE idfile not in (select idfile from episode) and idfile not in (select idfile from movie) and idfile not in (select idfile from musicvideo) ORDER BY `idFile` DESC;

=== In my.cnf (my.ini for older versions): ===
The named file is located at /etc/mysql/my{{dot}}cnf<br />
1. $sudo nano /etc/mysql/my{{dot}}cnf<br />
2. Scroll down to '''[mysqld]''' section and add:<br />
# skip-name-resolve<br />
3. Press Ctrl+X, type y and hit Enter to validate changes and exit nano<br />
4. Restart your MySQL server. $sudo restart mysql

[[File:mysql.PNG|400px]]

==Automated Backup ==
=== Windows ===
This will allow you to make a regular backup of your MySQL database using the schedule of your choosing and saving the backups for however many days you choose. Recommend performing daily backups and saving for a minimum of 7 days. This will give you enough time to discover a problem with the DB and restore to a previous version that did not have problems.

To begin, go ahead and download the [http://www.7-zip.org/download.html command line version of 7zip]. We will use this to compress our MySQL dumps. Create a new folder in your C directory named KODISQLBACKUP. So you should have a C:\KODISQLBACKUP\ location now. In this location, create another new folder and name it zip. So you should now have C:\KODISQLBACKUP\zip. Extract the contents of the 7zip download to this location. Once complete you should have:
<br>
<pre>C:\KODISQLBACKUP\zip\7za.exe

C:\KODISQLBACKUP\zip\7-zip.chm

C:\KODISQLBACKUP\zip\license.txt

C:\KODISQLBACKUP\zip\readme.txt</pre>

We're going to create a down and dirty batch file to perform the actual backup, then we'll execute the batch script with the task scheduler built into Windows. For the purpose of these instructions, it is assumed that you are running MySQL 5.5 installed to the default location. If not, be sure to adjust your path(s) accordingly. It's also a good idea to save your backups to a network location to protect against local drive failure, so the paths here will reflect this. So here are the batch file contents:

<syntaxhighlight lang=winbatch enclose="div">
:: All lines that start with 2 colons are comments, they do not affect the script itself. These comments are explanations of each command, as well as instructions for the things that you will need to edit. Pay close attention to all comments.

:: These lines do not NEED to be edited
set year=%DATE:~10,4%
set day=%DATE:~7,2%
set mnt=%DATE:~4,2%
set hr=%TIME:~0,2%
set min=%TIME:~3,2%

IF %day% LSS 10 SET day=0%day:~1,1%
IF %mnt% LSS 10 SET mnt=0%mnt:~1,1%
IF %hr% LSS 10 SET hr=0%hr:~1,1%
IF %min% LSS 10 SET min=0%min:~1,1%

set backuptime=%mnt%-%day%-%year%-%hr%-%min%

:: User name for DB - NOTE that root credentials are needed for this script.
set dbuser=root

:: User password - NOTE that the root credentials are needed for this script.
set dbpass=password

:: Path to location where you would like to save the errors log file. For simplicity, I keep mine in the same location as the backups.
set errorLogPath="\\REMOTE\KODI_Database\backups\dumperrors.txt"

:: We need to switch to the data directory to enumerate the folders
pushd "C:\ProgramData\MySQL\MySQL Server 5.5\data"

:: We will dump each database to it's own .sql so you can easily restore ONLY what is needed in the future. We're also going to skip the performance_schema db as it is not necessary.

FOR /D %%F IN (*) DO (

IF NOT [%%F]==[performance_schema] (
SET %%F=!%%F:@002d=-!
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --user=%dbuser% --password=%dbpass% --databases --routines --log-error=%errorLogPath% %%F > "\\REMOTE\KODI_Database\backups\%%F.%backuptime%.sql"
) ELSE (
echo Skipping DB backup for performance_schema
)
)

::Now to zip all of the .sql files in this folder and move the resulting .zip files to our network location.

"c:\KODISQLBACKUP\zip\7za.exe" a -tzip "\\REMOTE\KODI_Database\backups\FullBackup.%backuptime%.zip" "\\REMOTE\KODI_Database\backups\*.sql"

::Now we'll delete the unzipped .sql files

del "\\REMOTE\KODI_Database\backups\*.sql"

::Now we'll delete all zip files older than 30 days. You can adjust the number of days to suit your needs, simply change the -30 to whatever number of days you prefer. Be sure you enter the path to your backup location.
Forfiles -p \\REMOTE\KODI_Database\backups\ -s -m *.* -d -30 -c "cmd /c del /q @path"

popd
</syntaxhighlight>

Save this as Kodibackup.bat at C:\KODISQLBACKUP
Make ''sure'' you include the .bat at the end.

After you have edited the above batch file to reflect your paths and saved it as a batch file, all that is left is scheduling it to run. Daily backups are best, but you can use whatever frequency you are comfortable with. To do this, open up the Windows Task Scheduler.

In the Task Scheduler click on "Create Task...", NOT "Create Basic Task...". In the new task window, in the Name box put Kodi MySQL backup (or whatever name you want).

Then click on the Triggers tab, followed by the New button. Select Daily (or whatever you want) and adjust the time you would like it to run. Click OK.

Click on the Actions tab and click New. In the Program/Script box enter C:\KODISQLBACKUP\Kodibackup.bat (or whatever you named your batch file) and in the start in box enter C:\KODISQLBACKUP

Click ok, then click ok in the task window. In the main task scheduler window, right click on the task you just created and select run. If everything works as it should, you should now have a zipped backup of your database(s) in your backup location. It will now do this for you automatically.

Enjoy!

=== Linux ===
[http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] is a script that is designed to keep daily, weekly and monthly backups of your databases. It is very customizable and reliable. There is useful information on installing and configuring the script here: http://www.linux.com/learn/tutorials/659107-how-to-do-painless-mysql-server-backups-with-automysqlbackup.
{{note|Detailed instructions on configuring AutoMySQLBackup should probably be added to this section as the linked page above could be deleted at any time and there is little beginner friendly information available on the web.}}

==Name tag==
{{#lst:MySQL/Setting up Kodi|name tag}}

==Multiple profiles with one MySQL database==
The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499

{{Updated|16}}

MySQL/Advanced notes

2021-02-01T02:10:29Z

Graysky: add section to clean stale entries, inspiration from forum post: https://forum.kodi.tv/showthread.php?tid=294011&pid=3010780#pid3010780

{{:MySQL/Contents}}
{{mininav| [[MySQL]] }}
__TOC__
{{-}}
==advancedsettings.xml==
For a full listing of the advancedsettings.xml parameters, see '''[[advancedsettings.xml#musicdatabase/videodatabase]]'''

== Other databases (PVR and ADSP) ==

{{MySQL warning}}

==MySQL speed-up tweaks==

=== In advancedsettings.xml: ===
Use the IP address and NOT the hostname of your MySQL server<br />
eg.: 192.168.1.105 <<IP address>> instead of \\SERVER

==Removing stale entries from the database==
Occasionally, it can be beneficial to remove database entries corresponding files that are no longer on available on the file-system. Take note that the database entries for such files are separate from the library status which can be managed by Kodi built in actions. The database should ALWAYS be backed-up before attempting these commands.

To clear the database entries, connect to the box serving up the SQL database and log into the SQL database:
mysql -u root -p

Once authenticated, the following can be used to identify active databases on which to work:
SHOW databases;

For example, Matrix will generate a video database called, "MyVideos119."

Execute the following to identify possible rows for deleting:
USE MyVideos119;
SELECT * FROM files WHERE idfile not in (select idfile from episode) and idfile not in (select idfile from movie) and idfile not in (select idfile from musicvideo) ORDER BY `idFile` DESC;

If the command returns rows, these should be stale entries that can be safely removed by substituting DELETE for SELECT * in the last command:

DELETE FROM files WHERE idfile not in (select idfile from episode) and idfile not in (select idfile from movie) and idfile not in (select idfile from musicvideo) ORDER BY `idFile` DESC;

=== In my.cnf (my.ini for older versions): ===
The named file is located at /etc/mysql/my{{dot}}cnf<br />
1. $sudo nano /etc/mysql/my{{dot}}cnf<br />
2. Scroll down to '''[mysqld]''' section and add:<br />
# skip-name-resolve<br />
3. Press Ctrl+X, type y and hit Enter to validate changes and exit nano<br />
4. Restart your MySQL server. $sudo restart mysql

[[File:mysql.PNG|400px]]

==Automated Backup ==
=== Windows ===
This will allow you to make a regular backup of your MySQL database using the schedule of your choosing and saving the backups for however many days you choose. Recommend performing daily backups and saving for a minimum of 7 days. This will give you enough time to discover a problem with the DB and restore to a previous version that did not have problems.

To begin, go ahead and download the [http://www.7-zip.org/download.html command line version of 7zip]. We will use this to compress our MySQL dumps. Create a new folder in your C directory named KODISQLBACKUP. So you should have a C:\KODISQLBACKUP\ location now. In this location, create another new folder and name it zip. So you should now have C:\KODISQLBACKUP\zip. Extract the contents of the 7zip download to this location. Once complete you should have:
<br>
<pre>C:\KODISQLBACKUP\zip\7za.exe

C:\KODISQLBACKUP\zip\7-zip.chm

C:\KODISQLBACKUP\zip\license.txt

C:\KODISQLBACKUP\zip\readme.txt</pre>

We're going to create a down and dirty batch file to perform the actual backup, then we'll execute the batch script with the task scheduler built into Windows. For the purpose of these instructions, it is assumed that you are running MySQL 5.5 installed to the default location. If not, be sure to adjust your path(s) accordingly. It's also a good idea to save your backups to a network location to protect against local drive failure, so the paths here will reflect this. So here are the batch file contents:

<syntaxhighlight lang=winbatch enclose="div">
:: All lines that start with 2 colons are comments, they do not affect the script itself. These comments are explanations of each command, as well as instructions for the things that you will need to edit. Pay close attention to all comments.

:: These lines do not NEED to be edited
set year=%DATE:~10,4%
set day=%DATE:~7,2%
set mnt=%DATE:~4,2%
set hr=%TIME:~0,2%
set min=%TIME:~3,2%

IF %day% LSS 10 SET day=0%day:~1,1%
IF %mnt% LSS 10 SET mnt=0%mnt:~1,1%
IF %hr% LSS 10 SET hr=0%hr:~1,1%
IF %min% LSS 10 SET min=0%min:~1,1%

set backuptime=%mnt%-%day%-%year%-%hr%-%min%

:: User name for DB - NOTE that root credentials are needed for this script.
set dbuser=root

:: User password - NOTE that the root credentials are needed for this script.
set dbpass=password

:: Path to location where you would like to save the errors log file. For simplicity, I keep mine in the same location as the backups.
set errorLogPath="\\REMOTE\KODI_Database\backups\dumperrors.txt"

:: We need to switch to the data directory to enumerate the folders
pushd "C:\ProgramData\MySQL\MySQL Server 5.5\data"

:: We will dump each database to it's own .sql so you can easily restore ONLY what is needed in the future. We're also going to skip the performance_schema db as it is not necessary.

FOR /D %%F IN (*) DO (

IF NOT [%%F]==[performance_schema] (
SET %%F=!%%F:@002d=-!
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --user=%dbuser% --password=%dbpass% --databases --routines --log-error=%errorLogPath% %%F > "\\REMOTE\KODI_Database\backups\%%F.%backuptime%.sql"
) ELSE (
echo Skipping DB backup for performance_schema
)
)

::Now to zip all of the .sql files in this folder and move the resulting .zip files to our network location.

"c:\KODISQLBACKUP\zip\7za.exe" a -tzip "\\REMOTE\KODI_Database\backups\FullBackup.%backuptime%.zip" "\\REMOTE\KODI_Database\backups\*.sql"

::Now we'll delete the unzipped .sql files

del "\\REMOTE\KODI_Database\backups\*.sql"

::Now we'll delete all zip files older than 30 days. You can adjust the number of days to suit your needs, simply change the -30 to whatever number of days you prefer. Be sure you enter the path to your backup location.
Forfiles -p \\REMOTE\KODI_Database\backups\ -s -m *.* -d -30 -c "cmd /c del /q @path"

popd
</syntaxhighlight>

Save this as Kodibackup.bat at C:\KODISQLBACKUP
Make ''sure'' you include the .bat at the end.

After you have edited the above batch file to reflect your paths and saved it as a batch file, all that is left is scheduling it to run. Daily backups are best, but you can use whatever frequency you are comfortable with. To do this, open up the Windows Task Scheduler.

In the Task Scheduler click on "Create Task...", NOT "Create Basic Task...". In the new task window, in the Name box put Kodi MySQL backup (or whatever name you want).

Then click on the Triggers tab, followed by the New button. Select Daily (or whatever you want) and adjust the time you would like it to run. Click OK.

Click on the Actions tab and click New. In the Program/Script box enter C:\KODISQLBACKUP\Kodibackup.bat (or whatever you named your batch file) and in the start in box enter C:\KODISQLBACKUP

Click ok, then click ok in the task window. In the main task scheduler window, right click on the task you just created and select run. If everything works as it should, you should now have a zipped backup of your database(s) in your backup location. It will now do this for you automatically.

Enjoy!

=== Linux ===
[http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] is a script that is designed to keep daily, weekly and monthly backups of your databases. It is very customizable and reliable. There is useful information on installing and configuring the script here: http://www.linux.com/learn/tutorials/659107-how-to-do-painless-mysql-server-backups-with-automysqlbackup.
{{note|Detailed instructions on configuring AutoMySQLBackup should probably be added to this section as the linked page above could be deleted at any time and there is little beginner friendly information available on the web.}}

==Name tag==
{{#lst:MySQL/Setting up Kodi|name tag}}

==Multiple profiles with one MySQL database==
The idea is to share information on files in the library (only scrape once) but have individual watch status for every profile. For information see the forum thread [http://forum.kodi.tv/showthread.php?tid=196821 [MYSQL<nowiki>]</nowiki> HOW-TO: 5 User XBMC] and for a setup for Kodi v16 see [http://forum.kodi.tv/showthread.php?tid=196821&pid=2280431#pid2280431 this post]. An older setup can be found at: http://forum.kodi.tv/showthread.php?tid=81095&pid=840499#pid840499

{{Updated|16}}

Action IDs

2021-01-30T14:54:58Z

Graysky: add reboot action, xbmc/interfaces/builtins/SystemBuiltins.cpp

<section begin="Action IDs" />
;Main actions
{| class="prettytable sort sortable"
|-
! Action
! Description
|-
| <code>Left</code> || Move left off a control.
|-
| <code>Right</code> || Move right off a control.
|-
| <code>Up</code> || Move up off a control.
|-
| <code>Down</code> || Move down off a control.
|-
| <code>Select</code> || Select a button, or an item from a list of thumb view.
|-
| <code>Enter</code> || '''?''' (ACTION_ENTER) Not sure about all areas, but on some windows this will be the same as the "done" on screen button.
|-
| <code>PageUp</code> || Scroll up on page in a list, thumb, or text view.
|-
| <code>PageDown</code> || Scroll down on page in a list, thumb, or text view.
|-
| <code>Highlight</code> || Highlight an item in a list or thumb view.
|-
| <code>ParentDir</code> || Go up a folder to the parent folder.
|-
| <code>PreviousMenu</code> || Go back to the previous menu screen.
|-
| <code>Back</code> || Go back in navigation.
|-
| <code>Info</code> || Show the information about the currently highlighted item, or currently playing item.
|-
| <code>Pause</code> || Pause the currently playing item.
|-
| <code>Stop</code> || Stop the currently playing item.
|-
| <code>SkipNext</code> || Skip to next video in playlist. If no playlist, then skip to next chapter in video.
|-
| <code>SkipPrevious</code> || Skip to previous video in playlist. If no playlist, then skip to previous chapter in video.
|-
| <code>FullScreen</code> || Toggles full-screen content playback (either visualisation or video playback)
|-
| <code>togglefullscreen</code> || Changes whether the app is displayed full-screen or windowed (on windowing OSs)
|-
| <code>AspectRatio</code> || Toggle through the various aspect ratio modes (Normal is the preferred option).
|-
| <code>StepForward</code> || Step forward 30 seconds in a video.
|-
| <code>StepBack</code> || Step back 30 seconds in a video.
|-
| <code>BigStepForward</code> || Step forward 10 minutes in video.
|-
| <code>BigStepBack</code> || Step back 10 minutes in video.
|-
| <code>SmallStepBack</code> || Step back 7 seconds in the current video.
|-
| <code>Seek(''##'')</code> || A definable seek action, where <code>''##''</code> is a number of seconds. For example, to make a seek action that goes forward 25 seconds use <code>Seek(25)</code>, and to make a seek action that goes back 36 seconds use <code>Seek(-36)</code>. '''(v15 Isengard addition)'''
|-
| <code>ChapterOrBigStepForward</code> || Go to to next chapter in video. If no chapters, then step forward 10 minutes in video. '''(v13 Gotham addition)'''
|-
| <code>ChapterOrBigStepBack</code> || Go to previous chapter in video, If no chapters, then step back 10 minutes in video. '''(v13 Gotham addition)'''
|-
| <code>NextScene</code> || Go to next scene that is marked in an [[Edit_decision_list]] file.
|-
| <code>PreviousScene</code> || Go to previous scene that is marked in an [[Edit_decision_list]] file.
|-
| <code>OSD</code> || Toggles the OSD (On Screen Display) while playing an item.
|-
| <code>PlayDVD</code> || Start playing a DVD (goes to the DVD menu)
|-
| <code>ShowVideoMenu</code> || Go to the DVD Video menu when playing a DVD.
|-
| <code>ShowSubtitles</code> || Toggles whether subtitles are shown or not.
|-
| <code>NextSubtitle</code> || Change to the next subtitle language, if there is more than one.
|-
| <code>SubtitleShiftUp</code> || '''?''' (ACTION_SUBTITLE_VSHIFT_UP)
|-
| <code>SubtitleShiftDown</code> || '''?''' (ACTION_SUBTITLE_VSHIFT_DOWN)
|-
| <code>SubtitleAlign</code> || '''?''' (ACTION_SUBTITLE_ALIGN)
|-
| <code>CodecInfo</code> || Show codec information about the currently playing item (during video or visualisation playback)
|-
| <code>NextPicture</code> || Move to the next picture in a slideshow.
|-
| <code>PreviousPicture</code> || Move to the previous picture in a slideshow.
|-
| <code>ZoomOut</code> || Used in picture, slideshow or video fullscreen to zoom out of the current image/video.
|-
| <code>ZoomIn</code> || Used in picture, slideshow or video fullscreen to zoom in to the current image/video.
|-
| <code>IncreasePAR</code> || Used in video fullscreen to increase the pixel aspect ratio (stretch).
|-
| <code>DecreasePAR</code> || Used in video fullscreen to decrease the pixel aspect ratio (stretch).
|-
| <code>Queue</code> || Queue the item to the current playlist
|-
| <code>PlayNext</code> || Queue the item to the next position in the current playlist
|-
| <code>Filter</code> || Opens the mediafilter dialog in the video and musiclibrary. Used in the [[Advanced_library_filtering|advanced filter]] for the video library.
|-
| <code>Playlist</code> || Toggle to playlist view from My Music or My Videos
|-
| <code>ZoomNormal</code> || Normal (fullscreen) viewing in My Pictures
|-
| <code>ZoomLevel1</code> || Zoom to 120% in My Pictures
|-
| <code>ZoomLevel2</code> || Zoom to 150% in My Pictures
|-
| <code>ZoomLevel3</code> || Zoom to 200% in My Pictures
|-
| <code>ZoomLevel4</code> || Zoom to 280% in My Pictures
|-
| <code>ZoomLevel5</code> || Zoom to 400% in My Pictures
|-
| <code>ZoomLevel6</code> || Zoom to 600% in My Pictures
|-
| <code>ZoomLevel7</code> || Zoom to 900% in My Pictures
|-
| <code>ZoomLevel8</code> || Zoom to 1350% in My Pictures
|-
| <code>ZoomLevel9</code> || Zoom to 2000% in My Pictures
|-
| <code>NextCalibration</code> || Used in Video + GUI calibration
|-
| <code>ResetCalibration</code> || Used in Video + GUI calibration
|-
| <code>AnalogMove</code> || Move in the calibration screens, and while zoomed in My Pictures.
|-
| <code>Rotate</code> || Rotate a picture in My Pictures
|-
| <code>rotateccw</code> || '''?''' (ACTION_ROTATE_PICTURE_CCW)
|-
| <code>Close</code> || Used to close a dialog
|-
| <code>subtitledelay</code> || '''?''' (ACTION_SUBTITLE_DELAY)
|-
| <code>SubtitleDelayMinus</code> || Decrease the delay amount of subtitles (use if subtitles are displaying too late)
|-
| <code>SubtitleDelayPlus</code> || Increase the delay amount of subtitles (use if subtitles are displaying too early)
|-
| <code>audiodelay</code> || '''?''' (ACTION_AUDIO_DELAY)
|-
| <code>AudioDelayMinus</code> || Decrease the delay amount of audio (use if audio is being heard too early)
|-
| <code>AudioDelayPlus</code> || Increase the delay amount of audio (use if audio is being heard too late)
|-
| <code>AudioNextLanguage</code> || Change to the next audio track in a video with multiple audio tracks.
|-
| <code>NextResolution</code> || Used in Video calibration
|-
| <code>Number''<0-9>''</code> || Used to input the number 0 through 9
|-
| <code>FastForward</code> || Toggle the fastforward speed between normal play, 2x, 4x, 8x, 16x, and 32x.
|-
| <code>Rewind</code> || Toggle the rewind speed between normal play, 2x, 4x, 8x, 16x, and 32x.
|-
| <code>Play</code> || Play the selected item (or folder of items).
|-
| <code>PlayPause</code> || Play the selected item (or folder of items). Will also pause media when something is already playing.
|-
| <code>Delete</code> || Used in My Files to delete a file.
|-
| <code>Copy</code> || Used in My Files to copy a file.
|-
| <code>Move</code> || Used in My Files to move a file.
|-
| <code>Rename</code> || Used in My Files to rename a file.
|-
| <code>HideSubmenu</code> || <depreciated>
|-
| <code>Screenshot</code> || Take a screenshot of the current screen.
|-
| <code>Reboot</code> || Reboot
|-
| <code>ShutDown()</code> || Shutdown and power off
|-
| <code>VolumeUp</code> || Increase the volume of playback.
|-
| <code>VolumeDown</code> || Decrease the volume of playback.
|-
| <code>Mute</code> || Mute the volume.
|-
| <code>volampup</code> || '''?''' (ACTION_VOLAMP_UP)
|-
| <code>volampdown</code> || '''?''' (ACTION_VOLAMP_DOWN)
|-
| <code>audiotoggledigital</code> || '''?''' (ACTION_TOGGLE_DIGITAL_ANALOG)
|-
| <code>BackSpace</code> || Used in the virtual keyboards to delete one letter.
|-
| <code>ScrollUp</code> || Variable speed scroll up for analog keys (stick or triggers)
|-
| <code>ScrollDown</code> || Variable speed scroll down for analog keys (stick or triggers)
|-
| <code>AnalogFastForward</code> || Variable speed fast forward for analog keys (stick or triggers)
|-
| <code>AnalogRewind</code> || Variable speed rewind for analog keys (stick or triggers)
|-
| <code>AnalogSeekForward</code> || Variable speed seeking for analog keys (stick or triggers)
|-
| <code>AnalogSeekBack</code> || Variable speed seeking for analog keys (stick or triggers)
|-
| <code>MoveItemUp</code> || Used to rearrange playlists
|-
| <code>MoveItemDown</code> || Used to rearrange playlists
|-
| <code>Menu</code> || Focus the menu control (e.g. sidebar in confluence) which is specified by the skin in different windows (e.g. Movies, Music, PVR etc.) '''(v16 Jarvis addition)'''
|-
| <code>ContextMenu</code> || Pops up a contextual menu
|-
| <code>Shift</code> || Used in Virtual Keyboard to switch to upper or lower case letters
|-
| <code>Symbols</code> || Used in Virtual Keyboard to switch to or from symbols mode
|-
| <code>CursorLeft</code> || Used in Virtual Keyboard to move the current cursor point to the left
|-
| <code>CursorRight</code> || Used in Virtual Keyboard to move the current cursor point to the right
|-
| <code>ShowTime</code> || Used to show the current play time in music + video playback
|-
| <code>visualisationpresetlist</code> || Shows the visualisation preset list
|-
| <code>ShowPreset</code> || Shows the current visualisation preset (milkdrop/spectrum)
|-
| <code>NextPreset</code> || Next visualisation preset
|-
| <code>PreviousPreset</code> || Previous visualisation preset
|-
| <code>LockPreset</code> || Lock the current visualisation preset
|-
| <code>RandomPreset</code> || Switch to a new random preset
|-
| <code>IncreaseRating</code> || Used to increase track rating in full screen playback (press info on track and use pageplus on keyboard/remote
|-
| <code>DecreaseRating</code> || Used to decrease track rating in full screen playback (press info on track and use pageminus on keyboard/remote
|-
| <code>ToggleWatched</code> || Toggles watched/unwatched status for Videos
|-
| <code>NextLetter</code> || Move to the next letter in a list or thumb panel. Note that SHIFT-B on the keyboard will take you to the B's.
|-
| <code>PrevLetter</code> || Move to the previous letter in a list or thumb panel. Note that SHIFT-Z on the keyboard will take you to the Z's.
|-
| <code>JumpSMS''<2-9>''</code> || Jump through a list using SMS-style input (eg press 2 twice to jump to the B's.)
|-
| <code>FilterSMS''<2-9>''</code> || Filter a list in music or videos using SMS-style input.
|-
| <code>verticalshiftup</code> || '''?''' (ACTION_VSHIFT_UP)
|-
| <code>verticalshiftdown</code> || '''?''' (ACTION_VSHIFT_DOWN)
|-
| <code>scanitem</code> || '''?''' (ACTION_SCAN_ITEM)
|-
| <code>reloadkeymaps</code> || Reload keymap, loading any changes made to the keymap since started up.
|-
| <code>increasevisrating</code> || '''?''' (ACTION_VIS_RATE_PRESET_PLUS)
|-
| <code>decreasevisrating</code> || '''?''' (ACTION_VIS_RATE_PRESET_MINUS)
|-
| <code>firstpage</code> || '''?''' (ACTION_FIRST_PAGE)
|-
| <code>lastpage</code> || '''?''' (ACTION_LAST_PAGE)
|-
| <code>guiprofile</code> || '''?''' (ACTION_GUIPROFILE_BEGIN)
|-
| <code>red</code> || '''?''' (ACTION_TELETEXT_RED)
|-
| <code>green</code> || '''?''' (ACTION_TELETEXT_GREEN)
|-
| <code>yellow</code> || '''?''' (ACTION_TELETEXT_YELLOW)
|-
| <code>blue</code> || '''?''' (ACTION_TELETEXT_BLUE)
|-
| <code>CreateBookmark</code> || Creates a bookmark of the currently playing Video '''(v13 Gotham addition)'''
|-
| <code>CreatEpisodeBookmark</code> || Creates an episode bookmark of the currently playing multi-episode file (e.g. S01E01E02). An episode bookmark specifies the end of the one and the begin of the other episode '''(v13 Gotham addition)'''
|-
| <code>NextChannelGroup</code> || [[PVR]] Goes to the next channel group when using live TV. Works only within PVR windows + channel osd. '''(v13 Gotham addition)'''
|-
| <code>PreviousChannelGroup</code> || [[PVR]] Goes to the previous channel group when using live TV. Works only within PVR windows + channel osd. '''(v13 Gotham addition)'''
|-
| <code>ChannelUp</code> || [[PVR]] Used to switch up to the next channel. Works only if you playback TV or radio '''(v13 Gotham addition)'''
|-
| <code>ChannelDown</code> || [[PVR]] Used to switch down to the previous channel. Works only if you playback TV or radio'''(v13 Gotham addition)'''
|-
| <code>PlayPvr</code> || [[PVR]] Starts playback a TV or radio channel depends on the last played channel. '''(v13 Gotham addition)'''
|-
| <code>PlayPvrTV</code> || [[PVR]] Starts playback a TV channel. Will playback the last played channel if available. '''(v13 Gotham addition)'''
|-
| <code>PlayPvrRadio</code> || [[PVR]] Starts playback a radio channel. Will playback the last played channel if available. '''(v13 Gotham addition)'''
|-
| <code>Record</code> || [[PVR]] record current playing channel or selected item in windows like EPG '''(v13 Gotham addition)'''
|-
| <code>StereoMode</code> || Toggle 3D/Stereoscopic mode '''(v13 Gotham addition)'''
|-
| <code>ToggleStereoMode</code> || Toggle 3D/Stereoscopic mode '''(v13 Gotham addition)'''
|-
| <code>SwitchPlayer</code> || Select player to use, such as internal (DVDPlayer/PAPlayer), UPnP "play using" targets, external players. '''(v13 Gotham addition)'''
|-
| <code>UpdateLibrary(video)</code> || Update Movie/TV-Show library (only tested with v13 Gotham addition).
|-
| <code>SetRating</code> || For use when playing music. Will pop-up a 1-10 userrating select dialog, to rate the currently playing song. '''(v17 Krypton addition)'''
|-
|}

;Other
{| class="prettytable"
! Action
! Description
|-
| <code>noop</code> || No action. Used to specifically disable a key.
|}
<section end="Action IDs" />

== Removed action IDs ==
* <code>PresetList</code> - replaced with <code>visualisationpresetlist</code> in a previous version (unknown?)

== See also ==
* [[Keymaps]]
* [[Window IDs]]
* [[Built-in scripting]]

{{Isengard updated}}

[[Category:Remotes]]
[[Category:Skin development]]

Databases

2020-12-21T15:53:50Z

Graysky: /* Database Versions */ update month

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ('''''[[Music_library|Music]], [[Video_library|Video]]''''', and Program databases). By default, the database files (*.db) are stored in the '''''[[Userdata]]''''' folder, specifically in userdata/Database.

Performing certain actions on video files will also add content to the database even if it has not been scanned or scraped. For example if you change any OSD setting while watching it, this will be saved in the database as a preference. Resume points are also stored in this database for unscraped videos.<section end="intro" />

= Using the Databases =
Databases are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music_library|Music]] and [[Video_library|Video]] files on their respective pages.

The following sections detail the database structure, tables, fields and their properties.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON-RPC API]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music tagging | Import-export library | NFO files}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10 - Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11 - Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12 - Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13 - Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14 - Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15 - Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16 - Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17 - Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px; background:#a0e75a;" | v18 - Leia
| style="width:120px; background:#a0e75a;" | January 2019
| style="width:80px; text-align:center; background:#a0e75a;" | 116
| style="width:80px; text-align:center; background:#a0e75a;" | 72
| style="width:80px; text-align:center; background:#a0e75a;" | 13
| style="width:80px; text-align:center; background:#a0e75a;" | 27
| style="width:80px; text-align:center; background:#a0e75a;" | 6
| style="width:60px; text-align:center; background:#a0e75a;" | 32
| style="width:60px; text-align:center; background:#a0e75a;" | 12
| style="width:60px; text-align:center; background:#a0e75a;" | 0
|-
| style="width:120px; background: skyBlue;" | v19 - Matrix
| style="width:120px; background: skyBlue;" | December 2020
| style="width:80px; text-align:center; background: skyBlue;" | 119
| style="width:80px; text-align:center; background: skyBlue;" | 82
| style="width:80px; text-align:center; background: skyBlue;" | 13
| style="width:80px; text-align:center; background: skyBlue;" | 33
| style="width:80px; text-align:center; background: skyBlue;" | 6
| style="width:60px; text-align:center; background: skyBlue;" | 37
| style="width:60px; text-align:center; background: skyBlue;" | 13
| style="width:60px; text-align:center; background: skyBlue;" | N/A
|}

{| class="prettytable"
|-
! colspan="2"| Legend
|-
| style="background:#a0e75a;"| Green
| Current release
|-
| style="background:skyBlue;"| Blue
| Future release
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|18}}
[[Category:PVR]]
[[Category:Add-ons]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Databases

2020-12-21T15:53:21Z

Graysky: /* Database Versions */ update for latest git

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ('''''[[Music_library|Music]], [[Video_library|Video]]''''', and Program databases). By default, the database files (*.db) are stored in the '''''[[Userdata]]''''' folder, specifically in userdata/Database.

Performing certain actions on video files will also add content to the database even if it has not been scanned or scraped. For example if you change any OSD setting while watching it, this will be saved in the database as a preference. Resume points are also stored in this database for unscraped videos.<section end="intro" />

= Using the Databases =
Databases are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music_library|Music]] and [[Video_library|Video]] files on their respective pages.

The following sections detail the database structure, tables, fields and their properties.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON-RPC API]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music tagging | Import-export library | NFO files}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10 - Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11 - Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12 - Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13 - Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14 - Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15 - Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16 - Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17 - Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px; background:#a0e75a;" | v18 - Leia
| style="width:120px; background:#a0e75a;" | January 2019
| style="width:80px; text-align:center; background:#a0e75a;" | 116
| style="width:80px; text-align:center; background:#a0e75a;" | 72
| style="width:80px; text-align:center; background:#a0e75a;" | 13
| style="width:80px; text-align:center; background:#a0e75a;" | 27
| style="width:80px; text-align:center; background:#a0e75a;" | 6
| style="width:60px; text-align:center; background:#a0e75a;" | 32
| style="width:60px; text-align:center; background:#a0e75a;" | 12
| style="width:60px; text-align:center; background:#a0e75a;" | 0
|-
| style="width:120px; background: skyBlue;" | v19 - Matrix
| style="width:120px; background: skyBlue;" | June 2020
| style="width:80px; text-align:center; background: skyBlue;" | 119
| style="width:80px; text-align:center; background: skyBlue;" | 82
| style="width:80px; text-align:center; background: skyBlue;" | 13
| style="width:80px; text-align:center; background: skyBlue;" | 33
| style="width:80px; text-align:center; background: skyBlue;" | 6
| style="width:60px; text-align:center; background: skyBlue;" | 37
| style="width:60px; text-align:center; background: skyBlue;" | 13
| style="width:60px; text-align:center; background: skyBlue;" | N/A
|}

{| class="prettytable"
|-
! colspan="2"| Legend
|-
| style="background:#a0e75a;"| Green
| Current release
|-
| style="background:skyBlue;"| Blue
| Future release
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|18}}
[[Category:PVR]]
[[Category:Add-ons]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Codename history

2020-12-21T15:51:13Z

Graysky: grammar

{{mininav| [[New features]] }}

{| class="wikitable"
|-
! Codename !! First released as version !! To what the name refers?
|-
| Atlantis || XBMC 8.10 || The science fiction television series 'Stargate Atlantis'. <ref>http://xbmc.org/xbmc-future-versioning-and-codenames</ref>
|-
| Babylon || XBMC 9.04 || The space station in the cult classic science fiction television series 'Babylon 5'. This codename also references the mythical city of Babylon. <ref>http://forum.kodi.tv/showthread.php?tid=51636&pid=331014#pid331014</ref>
|-
| Camelot || XBMC 9.11 || The mythical 'Camelot' from the King Arthur tales.
|-
| Dharma || XBMC 10.0 || The 'Dharma Initiative' in the television series 'Lost'.
|-
| Eden || XBMC 11.0 || The mythical 'Garden of Eden' from the Bible
|-
| Frodo || XBMC 12.0 || Erwin Beckers, one of the three founders. <ref>http://www.team-mediaportal.com/about-the-team/about-frodo</ref>
|-
| Gotham || XBMC 13.0 || The main city from the 'Batman' franchise.
|-
| Helix || Kodi 14.0 || The science fiction television series 'Helix'
|-
| Isengard || Kodi 15.0 || The 'Iron fortress' from Tolkien's many stories about Middle-Earth.
|-
| Jarvis || Kodi 16.0 || The A.I. that Tony Stark (Ironman) owns, Just A Rather Very Intelligent System, or J.A.R.V.I.S
|-
| Krypton || Kodi 17.0 || The planet where Superman was born.
|-
| Leia || Kodi 18.0 || Princess Leia Organa of Alderaan, later known as General Leia Organa (Star Wars). <ref>https://kodi.tv/kodi-18-leia/</ref>
|-
| Matrix || Kodi 19.0 || The 1999 science fiction film written and directed by the Wachowskis <ref>https://forum.kodi.tv/showthread.php?tid=330506</ref><ref>https://kodi.tv/article/kodi-19-gets-codename</ref>
|}

== References ==
<references />

{{updated|19}}

HOW-TO:Install Kodi on Raspberry Pi

2020-05-14T10:26:56Z

Graysky: /* Basic options */ link model specific kodi packages

{{mininav|[[Raspberry Pi]]|page={{FULLPAGENAME}} }}
The basic hardware you will need is
* the R-Pi board itself
* a power supply (Micro-USB, 5V, upto 2500 mA)
* a (micro)SDHC memory card to install the software. (Because video decoding is more resource-intensive than many other operations, it may be more important to have a fast/high quality memory card for Kodi than for other uses.)

:''See also: [[Raspberry Pi FAQ]]''

== Basic options ==

<section begin="install"/>
;Easy / Kodi centric distributions
* '''[[LibreELEC]] -''' [https://libreelec.tv/downloads_new/ Download] • [https://wiki.libreelec.tv Wiki] • [http://forum.libreelec.tv Forum]

* '''[[OSMC]] -''' [https://osmc.tv/ Home] [https://osmc.tv/download/ Installing] • [https://osmc.tv/wiki Wiki] • [https://discourse.osmc.tv Support Forum]

* '''[[XBian]] -''' [http://xbian.org/getxbian/ Installing] • [http://xbian.org/faq/ FAQ] • [http://xbian.org/getting-started/ Starters guide] • [http://forum.xbian.org/ Forum]

;Advanced / can be used with Kodi
* '''Raspbian -''' Up-to-date versions '''(Currently Krypton 17.3)''' of Kodi are now on the default Raspbian repositories. See '''[[HOW-TO:Install Kodi on Raspberry Pi#Raspbian|full guide here]]'''.

* '''CarPC -''' [http://www.engineering-diy.blogspot.ro/2015/01/raspberrypi-carpc-tutorial.html Guide]

* '''RetroPie - ''' See '''[[HOW-TO:Install Kodi on Raspberry Pi#RetroPie|full guide here]]'''

* '''Recalbox -''' [http://www.recalbox.com/diyrecalbox Installing]

* '''Batocera Linux -''' [https://batocera-linux.xorhub.com/#learn Learn More]

* '''Arch Linux ARM -''' [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-4 RPi4] • [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-3 RPi3] • [http://archlinuxarm.org/platforms/armv7/broadcom/raspberry-pi-2 RPi2] • [http://archlinuxarm.org/platforms/armv6/raspberry-pi RPi1]

* Note that Arch ARM provides different Kodi packages optimized for different RPi models. Be sure to pull down the correct package for your specific model!
* [https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rbp4 kodi-rbp4] (popcornmix's [https://github.com/popcornmix/xbmc/tree/gbm gbm] branch)
* [https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rbp3 kodi-rbp3] (popcornmix's [https://github.com/popcornmix/xbmc/tree/newclock5 newclock5] branch)
* [https://github.com/archlinuxarm/PKGBUILDs/tree/master/alarm/kodi-rbp kodi-rbp] (popcornmix's [https://github.com/popcornmix/xbmc/tree/newclock5 newclock5] branch)

* '''[[Buildroot]]''' - For experienced users only !
<section end="install"/>

== Specific install guides ==
For installs that don't directly include and/or boot into Kodi automatically.

=== Raspbian ===
{{editor note|We need to expand on this section, but here are the basic commands if you are familiar with the command-line:}}

'''(Current Version - 17.3)'''

<pre>
sudo apt-get update
sudo apt-get install kodi
</pre>

;Alternative source
* Pplware has a build of 17.1 for Raspbian, see [https://www.raspberrypi.org/forums/viewtopic.php?p=832735#p832735 here] for a guide and detailed instructions on how to set up Kodi for Raspbian

;PVR Addons
* PVR Addons can be installed directly from the command line:
<pre>
sudo apt-get update
sudo apt-get install PACKAGENAMEHERE
</pre>
but replace '''PACKAGENAMEHERE''' with the PVR addon required.
<pre>example: sudo apt-get install kodi-pvr-hts</pre>
The PVR client add-on should now be installed. If Kodi was already running, restart it to load the add-on.

=== RetroPie ===
Here's a [https://www.youtube.com/watch?v=MyeCQS7ITnU youtube guide]:

{{#widget:YouTube|id=MyeCQS7ITnU}}

== Compiling Kodi ==
Notes for advanced users who wish to try and build Kodi from source code.
* Various good notes mentioned here: https://github.com/xbmc/xbmc/blob/master/docs/README.RaspberryPi.md

{{updated|18}}

[[Category:Manual]]
[[Category:Installation|Raspberry Pi]]
[[Category:Raspberry Pi]]
[[Category:How-to]]

HOW-TO:Install Kodi on Raspberry Pi

2020-05-14T10:12:50Z

Graysky: /* Basic options */ update Arch ARM for 4 major Pi models

{{mininav|[[Raspberry Pi]]|page={{FULLPAGENAME}} }}
The basic hardware you will need is
* the R-Pi board itself
* a power supply (Micro-USB, 5V, upto 2500 mA)
* a (micro)SDHC memory card to install the software. (Because video decoding is more resource-intensive than many other operations, it may be more important to have a fast/high quality memory card for Kodi than for other uses.)

:''See also: [[Raspberry Pi FAQ]]''

== Basic options ==

<section begin="install"/>
;Easy / Kodi centric distributions
* '''[[LibreELEC]] -''' [https://libreelec.tv/downloads_new/ Download] • [https://wiki.libreelec.tv Wiki] • [http://forum.libreelec.tv Forum]

* '''[[OSMC]] -''' [https://osmc.tv/ Home] [https://osmc.tv/download/ Installing] • [https://osmc.tv/wiki Wiki] • [https://discourse.osmc.tv Support Forum]

* '''[[XBian]] -''' [http://xbian.org/getxbian/ Installing] • [http://xbian.org/faq/ FAQ] • [http://xbian.org/getting-started/ Starters guide] • [http://forum.xbian.org/ Forum]

;Advanced / can be used with Kodi
* '''Raspbian -''' Up-to-date versions '''(Currently Krypton 17.3)''' of Kodi are now on the default Raspbian repositories. See '''[[HOW-TO:Install Kodi on Raspberry Pi#Raspbian|full guide here]]'''.

* '''CarPC -''' [http://www.engineering-diy.blogspot.ro/2015/01/raspberrypi-carpc-tutorial.html Guide]

* '''RetroPie - ''' See '''[[HOW-TO:Install Kodi on Raspberry Pi#RetroPie|full guide here]]'''

* '''Recalbox -''' [http://www.recalbox.com/diyrecalbox Installing]

* '''Batocera Linux -''' [https://batocera-linux.xorhub.com/#learn Learn More]

* '''Arch Linux ARM -''' [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-4 RPi4] • [https://archlinuxarm.org/platforms/armv8/broadcom/raspberry-pi-3 RPi3] • [http://archlinuxarm.org/platforms/armv7/broadcom/raspberry-pi-2 RPi2] • [http://archlinuxarm.org/platforms/armv6/raspberry-pi RPi1]

* '''[[Buildroot]]''' - For experienced users only !
<section end="install"/>

== Specific install guides ==
For installs that don't directly include and/or boot into Kodi automatically.

=== Raspbian ===
{{editor note|We need to expand on this section, but here are the basic commands if you are familiar with the command-line:}}

'''(Current Version - 17.3)'''

<pre>
sudo apt-get update
sudo apt-get install kodi
</pre>

;Alternative source
* Pplware has a build of 17.1 for Raspbian, see [https://www.raspberrypi.org/forums/viewtopic.php?p=832735#p832735 here] for a guide and detailed instructions on how to set up Kodi for Raspbian

;PVR Addons
* PVR Addons can be installed directly from the command line:
<pre>
sudo apt-get update
sudo apt-get install PACKAGENAMEHERE
</pre>
but replace '''PACKAGENAMEHERE''' with the PVR addon required.
<pre>example: sudo apt-get install kodi-pvr-hts</pre>
The PVR client add-on should now be installed. If Kodi was already running, restart it to load the add-on.

=== RetroPie ===
Here's a [https://www.youtube.com/watch?v=MyeCQS7ITnU youtube guide]:

{{#widget:YouTube|id=MyeCQS7ITnU}}

== Compiling Kodi ==
Notes for advanced users who wish to try and build Kodi from source code.
* Various good notes mentioned here: https://github.com/xbmc/xbmc/blob/master/docs/README.RaspberryPi.md

{{updated|18}}

[[Category:Manual]]
[[Category:Installation|Raspberry Pi]]
[[Category:Raspberry Pi]]
[[Category:How-to]]

Databases

2020-04-20T12:09:07Z

Graysky: /* Database Versions */ update database versions for latest git

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ('''''[[Music_library|Music]], [[Video_library|Video]]''''', and Program databases). By default, the database files (*.db) are stored in the '''''[[Userdata]]''''' folder, specifically in userdata/Database.

Performing certain actions on video files will also add content to the database even if it has not been scanned or scraped. For example if you change any OSD setting while watching it, this will be saved in the database as a preference. Resume points are also stored in this database for unscraped videos.<section end="intro" />

= Using the Databases =
Databasess are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music Library|Music]] and [[Video Library|Video]] files on their respective pages.

The following sections detail the database structure, tables, fields and their properties.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON RPC]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music tagging | Import-export library | NFO files}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10 - Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11 - Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12 - Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13 - Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14 - Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15 - Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16 - Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17 - Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px; background:#a0e75a;" | v18 - Leia
| style="width:120px; background:#a0e75a;" | January 2019
| style="width:80px; text-align:center; background:#a0e75a;" | 116
| style="width:80px; text-align:center; background:#a0e75a;" | 72
| style="width:80px; text-align:center; background:#a0e75a;" | 13
| style="width:80px; text-align:center; background:#a0e75a;" | 27
| style="width:80px; text-align:center; background:#a0e75a;" | 6
| style="width:60px; text-align:center; background:#a0e75a;" | 32
| style="width:60px; text-align:center; background:#a0e75a;" | 12
| style="width:60px; text-align:center; background:#a0e75a;" | 0
|-
| style="width:120px; background: skyBlue;" | v19 - Matrix
| style="width:120px; background: skyBlue;" | January 2020
| style="width:80px; text-align:center; background: skyBlue;" | 116
| style="width:80px; text-align:center; background: skyBlue;" | 75
| style="width:80px; text-align:center; background: skyBlue;" | 13
| style="width:80px; text-align:center; background: skyBlue;" | 27
| style="width:80px; text-align:center; background: skyBlue;" | 6
| style="width:60px; text-align:center; background: skyBlue;" | 36
| style="width:60px; text-align:center; background: skyBlue;" | 13
| style="width:60px; text-align:center; background: skyBlue;" | 0
|}

{| class="prettytable"
|-
! colspan="2"| Legend
|-
| style="background:#a0e75a;"| Green
| Current release
|-
| style="background:skyBlue;"| Blue
| Future release
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|18}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Databases

2019-06-27T22:34:03Z

Graysky: /* Database Versions */ update for v19 prealpha1

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ('''''[[Music_library|Music]], [[Video_library|Video]]''''', and Program databases). By default, the database files (*.db) are stored in the '''''[[Userdata]]''''' folder, specifically in userdata/Database.

Performing certain actions on video files will also add content to the database even if it has not been scanned or scraped. For example if you change any OSD setting while watching it, this will be saved in the database as a preference. Resume points are also stored in this database for unscraped videos.<section end="intro" />

= Using the Databases =
Databasess are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music Library|Music]] and [[Video Library|Video]] files on their respective pages.

The following sections detail the database structure, tables, fields and their properties.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON RPC]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music tagging | Import-export library | NFO files}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10 - Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11 - Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12 - Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13 - Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14 - Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15 - Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16 - Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17 - Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v18 - Leia
| style="width:120px;" | January 2019
| style="width:80px; text-align:center;" | 116
| style="width:80px; text-align:center;" | 72
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 32
| style="width:60px; text-align:center;" | 12
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v19 - Matrix
| style="width:120px;" | July 2019
| style="width:80px; text-align:center;" | 116
| style="width:80px; text-align:center;" | 72
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 34
| style="width:60px; text-align:center;" | 12
| style="width:60px; text-align:center;" | 0
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|18}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Archive:HOW-TO compile Kodi for Linux on Arch/Manjaro

2019-05-14T19:37:23Z

Graysky: clean-up header to article

The recommended method to build/install Kodi on Arch Linux or Manjaro (and other Arch clones), is to build from a PKGBUILD rather than building/installing by hand. The primary reason to build this way is that it allows all files to be managed by pacman which is adventitious for numerous reasons.

* To build the official Kodi package, use a utility such as [https://wiki.archlinux.org/index.php/Arch_Build_System#Retrieve_PKGBUILD_source_using_Git asp] which will pull the needed files.
* To build a dev version of Kodi, download a PKGBUILD the [https://wiki.archlinux.org/index.php/Arch_User_Repository AUR] which hosts [https://aur.archlinux.org/packages/kodi-devel/ kodi-devel].

The remainder of this article shows steps to manually build and install.

== Getting the source code ==
First, we are going to install git, which is needed to download the Kodi source-code. Enter the following into the command line.

<syntaxhighlight lang="bash">
sudo pacman -S git
</syntaxhighlight>

Once git is installed, we can now get the Kodi source-code

<syntaxhighlight lang="bash">
cd $HOME
git clone git://github.com/xbmc/xbmc.git kodi
</syntaxhighlight>

== Installing the required packages ==
Kodi needs several third party packages, most of them can be installed from the official Arch/Manjaro repository

<syntaxhighlight lang="bash">
sudo pacman --needed --asdeps -S alsa-lib autoconf automake avahi bluez-libs bzip2 cmake curl cwiid dbus ffmpeg \
flatbuffers fmt fontconfig freetype2 fribidi fstrcmp gawk giflib glu gperf jre8-openjdk libao libass libbluray \
libcap libcdio libcec libcrossguid libjpeg-turbo libltdl libmariadbclient libmicrohttpd libmpcdec libnfs libplist \
libpng libpulse libssh libsystemd libtool libusb libva libvdpau libxml2 libxmu libxrandr libxslt libxt lsb-release \
lzo mesa nasm openssl pcre python2 python2-pillow rapidjson shairplay smbclient sqlite swig taglib tinyxml yasm zlib
</syntaxhighlight>

In addition to those, Kodi needs a few packages that are currently unavailable in the official repo, but they can be installed from the AUR (Arch User Repo)[https://aur.archlinux.org/].
<syntaxhighlight lang="bash">
cwiid fstrcmp
</syntaxhighlight>

Those can either be installed manually[https://wiki.archlinux.org/index.php/Arch_User_Repository#Installing_packages] or by using a AUR Helpers[https://wiki.archlinux.org/index.php/AUR_helpers].

''Optional:'' For developers and anyone else who compiles frequently it is recommended to use ccache
<syntaxhighlight lang="bash">
sudo pacman -S ccache
</syntaxhighlight>

== How to compile ==
To create the Kodi executable manually perform these steps:

;Notes
* By adding -j<number> to the 'cmake --build' command, you describe how many concurrent jobs will be used. So for dualcore the command is: <code>make -j2</code>
* You may need to run the 'make install' command with sudo if your user doesn't have write permissions to the prefix you have provided.

<syntaxhighlight lang="bash">
cd $HOME/kodi/
mkdir kodi-build
cd kodi-build
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local
cmake --build . -- VERBOSE=1 -j4
sudo make install
</syntaxhighlight>

This will install Kodi in the prefix provided (/usr/local).

== How to run ==
How to run xbmc depends on the type of installation you have done.
If you chose to install Kodi using the '/usr' or '/usr/local' prefix, you can just issue 'kodi' in a teminal session.

<syntaxhighlight lang="bash">
kodi
</syntaxhighlight>

You can also simply run from the application menu ofcourse.

In case you've overridden the prefix to install Kodi into some non-standard location, you will have to run kodi from a terminal, specifying the full path

<syntaxhighlight lang="bash">
/opt/kodi/bin/kodi
</syntaxhighlight>

== Uninstalling ==
If you ever need to uninstall Kodi, you can use the following command

<syntaxhighlight lang="bash">
cd $HOME/kodi/kodi-build
sudo make uninstall
</syntaxhighlight>

== See also ==
* https://github.com/xbmc/xbmc/blob/master/docs/README.linux

[[Category:Linux]]
[[Category:Compiling]]

Archive:HOW-TO compile Kodi for Linux on Arch/Manjaro

2019-02-21T19:52:53Z

Graysky: Link recommended method for Arch-based distros

The recommended method to build/install Kodi on Arch Linux or Manjaro (and other Arch clones), is to build from a PKGBUILD rather than building/installing by hand. The primary reason to build this way is that it allows all files to be managed by pacman which is adventitious for numerous reasons.

One can download a PKGBUILD for Kodi from the [https://wiki.archlinux.org/index.php/Arch_User_Repository AUR] which hosts [https://aur.archlinux.org/packages/kodi-devel/ kodi-devel]. The remainder of this article shows steps to manually build and install.

== Getting the source code ==
First, we are going to install git, which is needed to download the Kodi source-code. Enter the following into the command line.

<syntaxhighlight lang="bash">
sudo pacman -S git
</syntaxhighlight>

Once git is installed, we can now get the Kodi source-code

<syntaxhighlight lang="bash">
cd $HOME
git clone git://github.com/xbmc/xbmc.git kodi
</syntaxhighlight>

== Installing the required packages ==
Kodi needs several third party packages, most of them can be installed from the official Arch/Manjaro repository

<syntaxhighlight lang="bash">
sudo pacman -S autoconf automake cmake curl jre8-openjdk gawk gperf libao alsa-lib libass avahi bluez-libs libbluray \
bzip2 libcap libcdio libcec curl dbus fontconfig freetype2 fribidi giflib mesa glu libjpeg-turbo libltdl lzo libmicrohttpd \
libmpcdec libnfs pcre libplist libpng libpulse shairplay smbclient sqlite libssh openssl ffmpeg taglib tinyxml libtool \
libsystemd libusb libva libvdpau libxml2 libxmu libxrandr libxslt libxt lsb-release rapidjson nasm python2 python2-pillow \
swig yasm zlib libmariadbclient libcrossguid flatbuffers
</syntaxhighlight>

In addition to those, Kodi needs a few packages that are currently unavailable in the official repo, but they can be installed from the AUR (Arch User Repo).

We need the yaourt package in order to install packages from the AUR, so let's install it first

<syntaxhighlight lang="bash">
sudo pacman -S yaourt
</syntaxhighlight>

Once yaourt is installed, we can now get the last packages Kodi needs

<syntaxhighlight lang="bash">
yaourt -S cwiid fmt fstrcmp
</syntaxhighlight>

''Optional:'' For developers and anyone else who compiles frequently it is recommended to use ccache
<syntaxhighlight lang="bash">
sudo pacman -S ccache
</syntaxhighlight>

== How to compile ==
To create the Kodi executable manually perform these steps:

;Notes
* By adding -j<number> to the 'cmake --build' command, you describe how many concurrent jobs will be used. So for dualcore the command is: <code>make -j2</code>
* You may need to run the 'make install' command with sudo if your user doesn't have write permissions to the prefix you have provided.

<syntaxhighlight lang="bash">
cd $HOME/kodi/
mkdir kodi-build
cd kodi-build
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local
cmake --build . -- VERBOSE=1 -j4
sudo make install
</syntaxhighlight>

This will install Kodi in the prefix provided (/usr/local).

== How to run ==
How to run xbmc depends on the type of installation you have done.
If you chose to install Kodi using the '/usr' or '/usr/local' prefix, you can just issue 'kodi' in a teminal session.

<syntaxhighlight lang="bash">
kodi
</syntaxhighlight>

You can also simply run from the application menu ofcourse.

In case you've overridden the prefix to install Kodi into some non-standard location, you will have to run kodi from a terminal, specifying the full path

<syntaxhighlight lang="bash">
/opt/kodi/bin/kodi
</syntaxhighlight>

== Uninstalling ==
If you ever need to uninstall Kodi, you can use the following command

<syntaxhighlight lang="bash">
cd $HOME/kodi/kodi-build
sudo make uninstall
</syntaxhighlight>

== See also ==
* https://github.com/xbmc/xbmc/blob/master/docs/README.linux

[[Category:Linux]]
[[Category:Compiling]]

Databases

2019-01-12T16:19:40Z

Graysky: /* Database Versions */ update for rc5

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ([[Music Library|Music]], [[Video Library|Video]], and Program databases). By default, the database files (*.db) are stored in [[The UserData Folder]], specifically in userdata/Database.

In addition to indexing media files when activated by user-selected Content settings, Kodi also puts a video in its database if you change any OSD setting while watching it. Resume points are stored in this database as well. These entries are added to the database whether the affected video is part of the Video Library or not.<section end="intro" />

= Using the Databases =
Databasess are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music Library|Music]] and [[Video Library|Video]] files on their respective pages.

Since Kodi maintains the databases on its own, the only time a developer really needs to access the databases is for display information. The following sections discuss how you can access the information contained in Kodi's databases, and give some brief examples of how to use it.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON RPC]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music_tagging | Import-Export_library | nfo}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10- Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11- Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12- Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13- Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14- Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15- Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16- Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17- Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v18- Leia
| style="width:120px;" | January 2018
| style="width:80px; text-align:center;" | 116
| style="width:80px; text-align:center;" | 72
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 32
| style="width:60px; text-align:center;" | 12
| style="width:60px; text-align:center;" | 0
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|17}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Databases

2018-10-28T13:23:21Z

Graysky: since b4 these have not changes/assuming final for Leia

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ([[Music Library|Music]], [[Video Library|Video]], and Program databases). By default, the database files (*.db) are stored in [[The UserData Folder]], specifically in userdata/Database.

In addition to indexing media files when activated by user-selected Content settings, Kodi also puts a video in its database if you change any OSD setting while watching it. Resume points are stored in this database as well. These entries are added to the database whether the affected video is part of the Video Library or not.<section end="intro" />

= Using the Databases =
Databasess are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music Library|Music]] and [[Video Library|Video]] files on their respective pages.

Since Kodi maintains the databases on its own, the only time a developer really needs to access the databases is for display information. The following sections discuss how you can access the information contained in Kodi's databases, and give some brief examples of how to use it.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON RPC]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music_tagging | Import-Export_library | nfo}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10- Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11- Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12- Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13- Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14- Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15- Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16- Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17- Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v18- Leia
| style="width:120px;" | August 2018
| style="width:80px; text-align:center;" | 112
| style="width:80px; text-align:center;" | 72
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 32
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|17}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]

Databases

2018-09-05T19:00:49Z

Graysky: /* Database Versions */ update versions for 18b1

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]] }} }}

= Introduction =
<section begin="intro" />Kodi uses [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ([[Music Library|Music]], [[Video Library|Video]], and Program databases). By default, the database files (*.db) are stored in [[The UserData Folder]], specifically in userdata/Database.

In addition to indexing media files when activated by user-selected Content settings, Kodi also puts a video in its database if you change any OSD setting while watching it. Resume points are stored in this database as well. These entries are added to the database whether the affected video is part of the Video Library or not.<section end="intro" />

= Using the Databases =
Databasess are automatically maintained whenever you use Kodi. You can activate the most powerful database functionality by setting the Content property on all of your media sources, and using Kodi Library Mode. This view mode allows you to browse your media based on the details available in the databases, rather than using simple folder and filenames for details. You can read more about Library Mode for [[Music Library|Music]] and [[Video Library|Video]] files on their respective pages.

Since Kodi maintains the databases on its own, the only time a developer really needs to access the databases is for display information. The following sections discuss how you can access the information contained in Kodi's databases, and give some brief examples of how to use it.

== Building SQL Queries ==
SQLite queries can be incredibly powerful (and extraordinarily complicated). If you are not already familiar with SQL syntax, it would probably be a good idea to check out a general tutorial, such as [http://www.1keydata.com/sql/sql.html this one].

For most Kodi development projects, you're going to be doing select statements. "Select" is a SQL command used to gather data (in the form of "rows") out of a SQL database. Your select statement will include:
* A list of all the data fields (columns in the database table) you want for each row.
* A list of all the tables you need to get information from
* A list of comparisons used to narrow down your results. This last component is optional, but it makes sure your results are relevant and is often used to link database entries across multiple tables.

Below are a few sample select statements, so you can see how it works.

This query grabs all of the information for every movie in the Video Library.
<pre><nowiki>select * from movie</nowiki></pre>

Note that "*" is used to indicate all fields. Also,there is no "where" clause in this statement, so it returns every row in the table.

This query narrows down the results to just those movies released in 2007.
<pre><nowiki>select * from movie where c07 = 2007</nowiki></pre>

Note that the column containing the movie's release year is labelled simply "c07." The tables further down this page help you find out which columns contain the information you're looking for.

This query example is more semantic. Lists your movies including, in this order, internal ID, internal file ID, rating, movie year, IMDB ID, movie name and movie plot.
<pre><nowiki>select idMovie,idFile,c05,c07,c09,c00,c03,c02 from movie;</nowiki></pre>

Now the following query is a bit more complex because it joins 3 movie-related tables (movie, files and path) to list a single useful view of your movies. In human language it lists movie ID, movie year, IMDB rating, IMDB ID, movie name and full path of the movie file, ordered by IMDB rating with highest rating appearing first:
<pre><nowiki> select idMovie,c07,c05,c09,c00,path.strPath||files.strFilename from movie, files,path where movie.idFile=files.idFile and files.idPath=path.idPath order by c05 desc;</nowiki></pre>

You could also use less than or greater than symbols to get newer or older movies.

This query gets just the path and filename of all of the video files from season two of Chuck.
<pre><nowiki></nowiki></pre>

If you're not familiar with SQL queries, this query probably looks pretty complicated. It serves as a good demonstration of why there are so many tables in the list below, and how to use them. Many of the elements of a TV show's path and filename and used repeatedly, so SQL allows us to save space and speed up our searches by storing each of those elements just once, in one place, and referencing them repeatedly by the same ID.

In this case, the root path that contains your video files is a long string that repeats at the beginning of many files. The name of a TV series, too, is repeated in every single episode of that series, so it makes the most sense to save the series name once (along with all information relevant to the series). We do that in the table tvshow, and every episode of the TV show can access all of that information using just the TV show's ID.

== Accessing the Databases with Kodi Python ==
Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using [[JSON RPC]]

== Tags ==
Incorporated into the tables below are the related music metadata tags that are read from music files, and the NFO XML tags exported and imported by Kodi.
{{see also | Music_tagging | Import-Export_library | nfo}}

= Database Versions =
<section begin="database versions" />The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use [[MySQL]] sharing.

{|class="prettytable"
! Kodi version !! Date !! MyVideos !! MyMusic !! Textures !! Addons !! ViewModes !! TV !! EPG !! ADSP
|-
| style="width:120px;" | v10- Dharma
| style="width:120px;" | December 2010
| style="width:80px; text-align:center;" | 37
| style="width:80px; text-align:center;" | 7
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:80px; text-align:center;" | 1
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v11- Eden
| style="width:120px;" | March 2012
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 18
| style="width:80px; text-align:center;" | 6
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v12- Frodo
| style="width:120px;" | January 2013
| style="width:80px; text-align:center;" | 75
| style="width:80px; text-align:center;" | 32
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 15
| style="width:80px; text-align:center;" | 4
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v13- Gotham
| style="width:120px;" | May 2014
| style="width:80px; text-align:center;" | 78
| style="width:80px; text-align:center;" | 46
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 22
| style="width:60px; text-align:center;" | 7
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v14- Helix
| style="width:120px;" | December 2014
| style="width:80px; text-align:center;" | 90
| style="width:80px; text-align:center;" | 48
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 16
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 26
| style="width:60px; text-align:center;" | 8
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v15- Isengard
| style="width:120px;" | July 2015
| style="width:80px; text-align:center;" | 93
| style="width:80px; text-align:center;" | 52
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 19
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 10
| style="width:60px; text-align:center;" | N/A
|-
| style="width:120px;" | v16- Jarvis
| style="width:120px;" | February 2016
| style="width:80px; text-align:center;" | 99
| style="width:80px; text-align:center;" | 56
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 20
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v17- Krypton
| style="width:120px;" | February 2017
| style="width:80px; text-align:center;" | 107
| style="width:80px; text-align:center;" | 60
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 29
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|-
| style="width:120px;" | v18- Beta 1
| style="width:120px;" | August 2018
| style="width:80px; text-align:center;" | 112
| style="width:80px; text-align:center;" | 72
| style="width:80px; text-align:center;" | 13
| style="width:80px; text-align:center;" | 27
| style="width:80px; text-align:center;" | 6
| style="width:60px; text-align:center;" | 32
| style="width:60px; text-align:center;" | 11
| style="width:60px; text-align:center;" | 0
|}
<section end="database versions" />

== Links ==
* http://www.rieter.net/content/xot/xbmc-database-versions/ - another site keeping track of Kodi DB changes
* https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
* https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

== See also ==
* [[Releases]]

{{Top}}

{{updated|17}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]