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!


-- 
http://stefan-klinger.de                                        o/X
I prefer receiving plain text messages, not exceeding 32kB.     /\/
                                                                  \
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]

Reply via email to