Recommendations for sql database editor

[chef 3745]

Currently, in many different parts of emby I am experiencing a repeating of database items.

 

In my devices tab, but also under auto organize in my series tab I have lots and lots of repeating series names which are not in my actual library.

 

I'd like to remove these by editing the db files directly.

 

I am on windows, but I can't seem to find a good editor online.

 

I need to remove rows from the db files and clean them up.

[PenkethBoy 2063]

DB Browser for sqlite - works well

[chef 3745]

DB Browser for sqlite - works well

I actually just tried that application, but I get an error when I try to remove rows in the table.

 

Something about a foreign key error.

[PenkethBoy 2063]

yes thats because the row you are trying to delete - is linked(foreign Key) to one or more other tables in the db - its the way Emby db is setup (normal db stuff) and not something the editor can "know" about

 

so you need to find which tables those are by checking which have linked iD's

 

e.g. in mediaItems take the id value of say a Movie and look for the same id in Chapters3, Mediastreams2 etc etc - can be several diff tables

 

delete from these tables the row or rows with the same id and repeat until you have removed all the foreign keys for each "other" table - THEN - you can delete the movie record from the MediaItems table