search

sabrogden / Ditto

Ditto is an extension to the Windows Clipboard. You copy something to the Clipboard and Ditto takes what you copied and stores it in a database to retrieve at a later time.
https://ditto-cp.sourceforge.io/
3.91k stars 206 forks source link

Open Ditto.db with DB Browser (SQLite) #714

Open gunterzielke opened 2 months ago

gunterzielke commented 2 months ago

In the past, I was able to open the Ditto database with the DB Browser application. That does not seem to work anymore - when I try to open my Ditto.db I get the error:

executeSQL : "database table is locked (SELECT type, name, sql, tblname FROM \"main\".master;)" could not get list of db objects: database table is locked"

Is there still a way to look at the data of my Ditto.db to get rid of deleted clips? Thank you, Gunter

aPhilRa commented 2 months ago

What versions of Ditto and https://sqlitebrowser.org/ are you using?

gunterzielke commented 2 months ago

Should be the latest: DB Browser for SQLite Version 3.13.0

aPhilRa commented 2 months ago

I can confirm this is an issue starting with DB Browser for SQLite Version 3.13.0 The issue is already tracked in the SQLite Browser Github repo. See here: https://github.com/sqlitebrowser/sqlitebrowser/issues/3714

I think this can be closed.