I expected Database Desktop to be able to edit databases, but it seems I've either misunderstood how it works, or it doesn't work right. Namely, I wanted to use it to edit a SQLite database, but although it shows the database schema, it doesn't allow editing anything; on the other hand, I can create a dictionary from that database and edit it, but that's not the database itself.
Please someone point me what I'm doing wrong and how can I edit the database. If it's not possible, please tell me some recommendations for a good SQLite management application. There are several out there, but I'm not sure which to choose, so if someone has some experience with it, please tell. So far I've written everything directly in SQL, but as the base goes more complex, I'd prefer to have a quicker and simpler way to edit it.
Thanks,