Databases: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
Update database versions for rc1 |
||
| (One intermediate revision by the same user not shown) | |||
| Line 25: | Line 25: | ||
{|class="prettytable" | {|class="prettytable" | ||
! Kodi version !! Date !! Addons !! EPG !! MyMusic !! MyVideos !! Textures !! TV !! ViewModes !! ADSP | ! Kodi version !! Date !! Addons !! EPG !! Games !! MyMusic !! MyVideos !! Textures !! TV !! ViewModes !! ADSP | ||
|- | |- | ||
| style="width:120px;" | v10 - Dharma | | style="width:120px;" | v10 - Dharma | ||
| style="width:120px;" | December 2010 | | style="width:120px;" | December 2010 | ||
| 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:80px; text-align:center;" | 7 | | style="width:80px; text-align:center;" | 7 | ||
| Line 41: | Line 42: | ||
| style="width:120px;" | March 2012 | | style="width:120px;" | March 2012 | ||
| style="width:80px; text-align:center;" | 15 | | style="width:80px; text-align:center;" | 15 | ||
| 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:80px; text-align:center;" | 18 | | style="width:80px; text-align:center;" | 18 | ||
| Line 53: | Line 55: | ||
| style="width:80px; text-align:center;" | 15 | | style="width:80px; text-align:center;" | 15 | ||
| style="width:60px; text-align:center;" | 7 | | style="width:60px; text-align:center;" | 7 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 32 | | style="width:80px; text-align:center;" | 32 | ||
| style="width:80px; text-align:center;" | 75 | | style="width:80px; text-align:center;" | 75 | ||
| Line 64: | Line 67: | ||
| style="width:80px; text-align:center;" | 16 | | style="width:80px; text-align:center;" | 16 | ||
| style="width:60px; text-align:center;" | 7 | | style="width:60px; text-align:center;" | 7 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 46 | | style="width:80px; text-align:center;" | 46 | ||
| style="width:80px; text-align:center;" | 78 | | style="width:80px; text-align:center;" | 78 | ||
| Line 75: | Line 79: | ||
| style="width:80px; text-align:center;" | 16 | | style="width:80px; text-align:center;" | 16 | ||
| style="width:60px; text-align:center;" | 8 | | style="width:60px; text-align:center;" | 8 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 48 | | style="width:80px; text-align:center;" | 48 | ||
| style="width:80px; text-align:center;" | 90 | | style="width:80px; text-align:center;" | 90 | ||
| Line 86: | Line 91: | ||
| style="width:80px; text-align:center;" | 19 | | style="width:80px; text-align:center;" | 19 | ||
| style="width:60px; text-align:center;" | 10 | | style="width:60px; text-align:center;" | 10 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 52 | | style="width:80px; text-align:center;" | 52 | ||
| style="width:80px; text-align:center;" | 93 | | style="width:80px; text-align:center;" | 93 | ||
| Line 97: | Line 103: | ||
| style="width:80px; text-align:center;" | 20 | | style="width:80px; text-align:center;" | 20 | ||
| style="width:60px; text-align:center;" | 11 | | style="width:60px; text-align:center;" | 11 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 56 | | style="width:80px; text-align:center;" | 56 | ||
| style="width:80px; text-align:center;" | 99 | | style="width:80px; text-align:center;" | 99 | ||
| Line 108: | Line 115: | ||
| style="width:80px; text-align:center;" | 27 | | style="width:80px; text-align:center;" | 27 | ||
| style="width:60px; text-align:center;" | 11 | | style="width:60px; text-align:center;" | 11 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 60 | | style="width:80px; text-align:center;" | 60 | ||
| style="width:80px; text-align:center;" | 107 | | style="width:80px; text-align:center;" | 107 | ||
| Line 119: | Line 127: | ||
| style="width:80px; text-align:center;" | 27 | | style="width:80px; text-align:center;" | 27 | ||
| style="width:60px; text-align:center;" | 12 | | style="width:60px; text-align:center;" | 12 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 72 | | style="width:80px; text-align:center;" | 72 | ||
| style="width:80px; text-align:center;" | 116 | | style="width:80px; text-align:center;" | 116 | ||
| Line 130: | Line 139: | ||
| style="width:80px; text-align:center;" | 33 | | style="width:80px; text-align:center;" | 33 | ||
| style="width:60px; text-align:center;" | 13 | | style="width:60px; text-align:center;" | 13 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 82 | | style="width:80px; text-align:center;" | 82 | ||
| style="width:80px; text-align:center;" | 119 | | style="width:80px; text-align:center;" | 119 | ||
| Line 141: | Line 151: | ||
| style="width:80px; text-align:center;" | 33 | | style="width:80px; text-align:center;" | 33 | ||
| style="width:60px; text-align:center;" | 16 | | style="width:60px; text-align:center;" | 16 | ||
| style="width:60px; text-align:center;" | N/A | |||
| style="width:80px; text-align:center;" | 82 | | style="width:80px; text-align:center;" | 82 | ||
| style="width:80px; text-align:center;" | 121 | | style="width:80px; text-align:center;" | 121 | ||
| Line 152: | Line 163: | ||
| style="width:80px; text-align:center; background: #a0e75a;" | 33 | | style="width:80px; text-align:center; background: #a0e75a;" | 33 | ||
| style="width:60px; text-align:center; background: #a0e75a;" | 16 | | style="width:60px; text-align:center; background: #a0e75a;" | 16 | ||
| style="width:60px; text-align:center; background: #a0e75a;" | N/A | |||
| style="width:80px; text-align:center; background: #a0e75a;" | 83 | | style="width:80px; text-align:center; background: #a0e75a;" | 83 | ||
| style="width:80px; text-align:center; background: #a0e75a;" | 131 | | style="width:80px; text-align:center; background: #a0e75a;" | 131 | ||
| Line 162: | Line 174: | ||
| style="width:120px; background: skyBlue;" | TBD | | style="width:120px; background: skyBlue;" | TBD | ||
| style="width:80px; text-align:center; background: skyBlue;" | 33 | | style="width:80px; text-align:center; background: skyBlue;" | 33 | ||
| style="width:60px; text-align:center; background: skyBlue;" | | | style="width:60px; text-align:center; background: skyBlue;" | 22 | ||
| style="width:80px; text-align:center; background: skyBlue;" | | | style="width:60px; text-align:center; background: skyBlue;" | 1 | ||
| style="width:80px; text-align:center; background: skyBlue;" | | | style="width:80px; text-align:center; background: skyBlue;" | 84 | ||
| style="width:80px; text-align:center; background: skyBlue;" | 149 | |||
| style="width:80px; text-align:center; background: skyBlue;" | 14 | | style="width:80px; text-align:center; background: skyBlue;" | 14 | ||
| style="width:60px; text-align:center; background: skyBlue;" | | | style="width:60px; text-align:center; background: skyBlue;" | 48 | ||
| style="width:80px; text-align:center; background: skyBlue;" | 6 | | style="width:80px; text-align:center; background: skyBlue;" | 6 | ||
| style="width:60px; text-align:center; background: skyBlue;" | N/A | | style="width:60px; text-align:center; background: skyBlue;" | N/A | ||
Latest revision as of 20:27, 7 October 2026
Kodi Databases
See also: |
|---|
|
 Development Userdata |
Databases
|
Introduction
Kodi uses SQLite, an open source light-weight SQL database-engine, to store all the library, add-on, EPG, textures and PVR related data using a number of specific databases. By default, the database files (*.db) are stored in the Kodi data folder\Userdata folder, specifically in \Database\.
Using the Databases
The databases are automatically maintained by Kodi. It is recommended that Kodi users do not access the database without good working knowledge of relational databases and SQL.
Database software is required to access the SQL databases. DB Browser for SQLite is available for Windows, macOS, Linux and FreeBSD.
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
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. Note that future release database versions are subject to change during development.
| Kodi version | Date | Addons | EPG | Games | MyMusic | MyVideos | Textures | TV | ViewModes | ADSP |
|---|---|---|---|---|---|---|---|---|---|---|
| v10 - Dharma | December 2010 | 1 | N/A | N/A | 7 | 37 | 1 | N/A | 1 | N/A |
| v11 - Eden | March 2012 | 15 | N/A | N/A | 18 | 60 | 6 | N/A | 4 | N/A |
| v12 - Frodo | January 2013 | 15 | 7 | N/A | 32 | 75 | 13 | 22 | 4 | N/A |
| v13 - Gotham | May 2014 | 16 | 7 | N/A | 46 | 78 | 13 | 22 | 6 | N/A |
| v14 - Helix | December 2014 | 16 | 8 | N/A | 48 | 90 | 13 | 26 | 6 | N/A |
| v15 - Isengard | July 2015 | 19 | 10 | N/A | 52 | 93 | 13 | 29 | 6 | N/A |
| v16 - Jarvis | February 2016 | 20 | 11 | N/A | 56 | 99 | 13 | 29 | 6 | 0 |
| v17 - Krypton | February 2017 | 27 | 11 | N/A | 60 | 107 | 13 | 29 | 6 | 0 |
| v18 - Leia | January 2019 | 27 | 12 | N/A | 72 | 116 | 13 | 32 | 6 | 0 |
| v19 - Matrix | December 2020 | 33 | 13 | N/A | 82 | 119 | 13 | 38 | 6 | N/A |
| v20 - Nexus | 11 January 2023 | 33 | 16 | N/A | 82 | 121 | 13 | 40 | 6 | N/A |
| v21 - Omega | 2 April 2024 | 33 | 16 | N/A | 83 | 131 | 13 | 44 (v21.0) 46 (v21.1) |
6 | N/A |
| v22 - Piers | TBD | 33 | 22 | 1 | 84 | 149 | 14 | 48 | 6 | N/A |
| Legend | |
|---|---|
| Green | Current release |
| Blue | Future release |
See also
- Releases
- 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
| Return to top |
|---|