[LINUX] Any XBMC database editing tools for Linux available?

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #1
I started ordering my components for my Linux based HTPC build having been playing with the latest XBMC release on my Linux workstation.

One thing I have noticed is that the scraper for videos are not 100% accurate & I don't expect them to be.

In the Linux environment what tools are available to edit XBMC's database directly?? In Mediaportal for example in the setup app you can directly edit entries for Videos/Movies changing anything from the description to the graphic used.

In the windows environment there seem to be a few easy to use tools mentioned in the forums. What exists for the Linux environment?
find quote
althekiller Offline
Retired Team-Kodi Member
Posts: 5,002
Joined: May 2004
Reputation: 12
Post: #2
Any sql editor that does sqlite3 will work fine.
find quote
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #3
althekiller Wrote:Any sql editor that does sqlite3 will work fine.

Can you point me to a few that run under Linux naturally?
find quote
althekiller Offline
Retired Team-Kodi Member
Posts: 5,002
Joined: May 2004
Reputation: 12
Post: #4
Google broken? I've only used the "sqlite3" cli tool. Probably not what you want.
find quote
cowfodder Offline
Fan
Posts: 388
Joined: Jan 2010
Reputation: 2
Post: #5
You also just edit the theTVDB.com entry for the show. It is wiki style and most shows are open for editing. What shows specifically are you having issues with?
find quote
jw76 Offline
Member
Posts: 72
Joined: Sep 2008
Reputation: 0
Post: #6
Code:
sudo aptitude install sqlite3

It will install the binary "sqlite3". The XBMC dbs are located in ~/.xbmc/userdata/Database

Code:
MyMusic7.db  MyPrograms6.db  MyVideos34.db  ViewModes.db

to connect run: sqlite3 MyVideos34.db etc.. once connected, typing .help will sort you out..
find quote
killerbeesateme Offline
Junior Member
Posts: 9
Joined: Apr 2009
Reputation: 0
Post: #7
sqlite browser, its available in the ubuntu repos. i was just using it today to compare the xbmc db to the boxee db.
find quote
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #8
althekiller Wrote:Google broken? I've only used the "sqlite3" cli tool. Probably not what you want.

Google's not broken :-)

I'm at work. Can't spend too much time online. Doing a few 16h stretches so I can only get in bits & pieces of online time.
(This post was last modified: 2010-01-10 03:05 by kingnubian.)
find quote
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #9
cowfodder Wrote:You also just edit the theTVDB.com entry for the show. It is wiki style and most shows are open for editing. What shows specifically are you having issues with?

Not shows. The scraper for movies pulled in some wrong movie info & covers.
find quote
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #10
I'll give the suggestions a go.
find quote
mkortstiege Offline
Team-Kodi Developer
Posts: 3,016
Joined: Jan 2008
Reputation: 10
Location: Germany
Post: #11
You got a lot time to respond to yourself while working Wink

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules
For troubleshooting and bug reporting please make sure you read this first.
find quote
zosky Offline
Donor
Posts: 304
Joined: Dec 2008
Reputation: 1
Location: toronto. canada
Post: #12
sqlight3 is great for scripting; i use it in a BASH script to scrape URLs from ddtrailer.com & drop them back into my library. for small edits &/or general browsing, i use sqlitebrowser. both from the ubuntu repos

eight xbmc devices mostly openElec
atom/ion | iphone4 | hpTouchPad | raspberryPI ...
central mySQL db ( +20TB NAS ) +maraschino +IRtoy.v2 +yatse
[Image: widget]
find quote
kingnubian Offline
Junior Member
Posts: 9
Joined: Jan 2010
Reputation: 0
Post: #13
killerbeesateme Wrote:sqlite browser, its available in the ubuntu repos. i was just using it today to compare the xbmc db to the boxee db.

Thanks! Works great.
find quote
Klojum Offline
Junior Member
Posts: 22
Joined: Nov 2009
Reputation: 0
Post: #14
To whom it may concern...

For the simple viewing & editing, Firefox also has an add-on called SQLite Manager. It can be installed via the usual add-on menu option.
find quote
darkscout Offline
Posting Freak
Posts: 2,145
Joined: Jul 2008
Reputation: 12
Post: #15
With the latest SVN, phpmyadmin :0.
find quote