The first version of “dbHarbor: SQLite” is released and available to download on Mac AppStore.
This version comes with the following features:
Create SQLite database files
Create, design, modify and delete database tables
Create, define and delete indexes
Create, define and delete triggers
Browse, edit, add and delete records
Filter records without writing any SQL query
SQLite Database Explorer
Database explorer contains all your data sources and their schemas with tables, functions, and views, etc. divided into folders which can be collapsed and expanded.
- Data editor
The powerful data editor lets you add, remove, edit, and copy data rows. Navigate through the data by foreign keys and use the filter to find anything in the data displayed in the data editor.
- Backup SQLite Tables
It’s very easy to create a quick backup of the table before any data manipulations. Just right click on the table and select “Duplicate” from the pop-up menu.
- Code completion
dbHarbor for SQLite provides code completion, helping you to write SQL code faster. Completion is aware of the table’s structure, foreign keys, etc.
- SQL log
While updating data you can see which particular queries dbHarbor is running.
- Bulk Commit
All your changes in the data editor are stored locally and can be submitted all at once. Submit all changes with Cmd+S.
- Search in the database tree view
dbHarbor IDE supports the speed search for tables, functions, views, etc. Put cursor into the ‘Filter’ field and start typing. A matching database object will be highlighted. Great thing! Tree view filter supports fuzzy-search. For instance,
filli is enough to find