This application based on the SQLite database engine and lets you create, view and modify databases. The database handling can happen via the GUI or there is an SQL command shell to serve any needs. There is a preliminary support for open xml spreadsheet files which can be converted to databases and even to native Amiga spreadsheets.
This is a must for the Hollywood SQLite users. Now with UTF8 support!
The main window has four important sections.
The left side displays the database structure. The tables are shown in the upper part and the fields of the selected table is shown below it.
1. Tables You can select the table by clicking on the list.
2. Fields The fields of the selected table. Double click selects the sorting order of the data view.
3. Values Shows the data in the selected table. It loads the full table content to the list in memory, so large databases may take some time to load. This behaviour may be changed in the future. Double click enters the row values to the console or to the edit edit panel according to which one is selected.
4. Query To make a query which contains filtered records.
5. Console This is an SQLite console.
6. Edit Edit the table contents.
Design, code: Lazi
Donations are welcome!