If you know a bit about sql syntax, you can do with it whatever you want. Since sqlite is not designed for parallel access though, I would stop Firefly while you manipulate the DB.
It *might* work even with it running — it’s got retries set up, so as long as you don’t use a persistent connection to the db, you *ought* to be able to much around with it as long as you don’t do long-running queries.
Or so theory says, anyway.
What ccrdude said is right, though… turning off the server while mucking with the db will always work, whereas leaving it running *should probably* work.
But you know how that goes.
Best documentation for how the playlists work is to look at the existing playlists… The only fields you need to fill in for a self-built “smart” playlist (iirc) is “name”, “type” (1), and “query”. You can leave the rest defaults.
— Ron