Re: [SlimDevices: Beta] DB content comparison

2011-08-13 Thread Phil Meyer
>I've been using SQLite Expert, which seems to work well. I don't do >anything fancy with it, mostly just viewing data and running SELECT >queries. The personal version is free. > That's what I was using, but seemed to fail when the switch to WAL was made. However, I see there's a newer version,

Re: [SlimDevices: Beta] DB content comparison

2011-08-13 Thread JJZolx
Philip Meyer;649026 Wrote: > I need to find a new SQLite DB browser, as mine doesn't seem to work in > WAL mode. I've been using SQLite Expert, which seems to work well. I don't do anything fancy with it, mostly just viewing data and running SELECT queries. The personal version is free. http://

Re: [SlimDevices: Beta] DB content comparison

2011-08-11 Thread erland
Philip Meyer;649026 Wrote: > > Maybe as easy as exporting tables as CSV and then doing a file > comparison. > > I need to find a new SQLite DB browser, as mine doesn't seem to work in > WAL mode. > If you just like to get some simple csv extracts you can use the Database Query plugin, that wil

Re: [SlimDevices: Beta] DB content comparison

2011-08-11 Thread JJZolx
Philip Meyer;649026 Wrote: > I'm wondering if there would be benefit in somehow comparing table > content between a 7.5.6 and 7.6.1 scan (ignoring primary/foreign key > id's), to see if obvious issues can be identified? > > e.g. I have a problem with my "No Artist" album. > > By comparing a lis

Re: [SlimDevices: Beta] DB content comparison

2011-08-11 Thread andyg
7.6 has changed a bit, for example the artwork IDs are now hex instead of integers. -- andyg andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292 View this thread: http://forums.slimdevices.com/showthread.

[SlimDevices: Beta] DB content comparison

2011-08-11 Thread Phil Meyer
Am I right in thinking that the schema hasn't changed at all between 7.5.6 and 7.6.1? I'm wondering if there would be benefit in somehow comparing table content between a 7.5.6 and 7.6.1 scan (ignoring primary/foreign key id's), to see if obvious issues can be identified? e.g. I have a problem