There is also a Browser with GUI: http://sqlitebrowser.org/
Linux, Mac and Windows. BR, Micha. Am Sonntag, 23. September 2018, 19:25:15 CEST schrieb dt-list@stefan- klinger.de: > Patrick Shanahan (2018-Sep-23, excerpt): > > * kneops <[email protected]> [09-23-18 07:11]: > > > I imported a bunch of presets and now want to remove them (dozens), and > > > it > > > seems I can only remove them one by one. After each removal the list > > > jumps > > > back to the top of the list in Lighttable mode. I looked inside > > > .config/darktable/styles but the imported styles are not present there. > > > How > > > can I remove them more easily? > > > > edit ~/.config/darktable/data.db with sqlite3, style_items > > > > er, s/style_items/styles > > Hmmm, what I get from this answer is to do it like this: > > $ sqlite3 ~/.config/darktable/data.db > > You can check out which database tables are available: > > sqlite> .schema > ... > CREATE TABLE styles (id INTEGER, name VARCHAR, description VARCHAR); > ... > > The one I've shown is the one Patrick referred to. You can see what's > inside. > > sqlite> .header on > sqlite> select * from styles; > 2|spiegelstein modest| > 3|high-ISO NR|two instances of profiled denoise > 4|Sepia| > > So for me it's three styles. I want to delete the one with id 2: > > sqlite> delete from styles where id = 2; > sqlite> select * from styles; > id|name|description > 3|high-ISO NR|two instances of profiled denoise > 4|Sepia| > > So I guess that's what Patrick suggested. But this has only deleted > the (id, name, description) triplet. Where is the actual style > definition? Is that in style_items? I don't know... > > I really think that a file based storage with one file per style would > be so much more user friendly! ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
