Originally Posted by corona
I just used SQLite Expert -- free graphical sqlite program -- and opened up the database to delete dozens of the freebie books -- worked great.
Just make sure you delete the corresponding book and chapter entries in the "content" table and the entries in "volume_shortcovers" and "shortcover_page" as well.
There is also an XML file that contains the id's of book on the device but I haven't looked into that yet.
While the Kobo and the desktop software *should* work with a out if sync database having cluttering entries in the database is less than optimal.