This is an administration and development tool for the SQLite database.
SQLite Expert Personal can be a nice tool if you are developing a SQLite based application.. It is a feature rich administration and development tool for SQLite. SQLite Expert should be useful to all kinds of all users, whether making up simple SQL queries or making up a really complex database. The interface lets you deal with SQLite features easily. It includes an SQL editor with syntax highlighting and code completion and visual table and view designers. The ease of use does not, obviously, apply to all and sundry. This application is for developers and it is this community that will be pleased with the interface and its features. Some of these features include visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints, restructuring of complex table without losing data and any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying the changes.
Data edit features include editing of data in the grid using in-place editors, image editor supports JPEG, PNG, BMP, GIF and ICO formats as also ability to visualize and modify BLOB fields using the integrated Hex editor. Being Unicode compatible, this tool is able handle the multi byte languages that include the Asian languages. The visual query builder makes complex query to be built easily, query parsing and analysis. If your work involves a lot of development in the SQLite environment, this here tool is a nice one to make your work easy and productive.