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.
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, so
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
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:
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 list of
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 will