Release: dbHarbor: SQLite 1.0

Good News!

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 film_list.