[love2cad]

Until recently I have been able to edit my database on my MAC with a nifty little app that I had placed on my desktop. I found this app a while back while looking through these forums. However, I am unable to find it again. Mostly I changed the genre of a movie and such. I, however, have inadvertently deleted it.

I am hoping that someone has a similar app that I can get my hands on. If not, what is the best way to edit the database, external from the software interface?

I am planning on moving my library to dedicated NAS. Would it be better to use MySQL to do this once I build the server?

[jelockwood]

Until recently I have been able to edit my database on my MAC with a nifty little app that I had placed on my desktop. I found this app a while back while looking through these forums. However, I am unable to find it again. Mostly I changed the genre of a movie and such. I, however, have inadvertently deleted it.

I am hoping that someone has a similar app that I can get my hands on. If not, what is the best way to edit the database, external from the software interface?

I am planning on moving my library to dedicated NAS. Would it be better to use MySQL to do this once I build the server?

The databases used by XBMC are in SQLite format. I have used a couple of free utilities to edit the video library database in the past. In no particular order they are

1. Navicat Lite - http://www.navicat.com/download/download.html
2. XBMCDBEditor - http://forums.plexapp.com/index.php/topi...exdbeditor

The later is a tool dedicated to editing the video library database, the former is a generic SQLite editor.

[snowdrift]

I've used SQLite Database Browser in the past. Its a bit clunky, but works.

[Hudson_Hawk04]

MySQL Workbench