Opening a database is a fairly straight forward process:
Open the dbHarbor App
Select a database from the list
Or click on "Open another database" button and choose a database
To edit table data inline, you can double-click on the data cell and enter new values. To add new table rows use the
+ button at the tables bottom. To remove one or more rows, select those and press ⌫ keyboard button or use the
- button at the tables bottom.
dbHarbor does not commit changes you made in visual editor to the database immediately. To commit changes to the database press ⌘ + S or use the menu File->Save.
Indeed the changes you make by running SQL queries are commited to the database immediately.
dbHarbor opens by default an SQL Editor View. You can allway add an additional SQL Editor View by clicking on + button on the top right window corner.
There is many possibilities to run a query in dbHarbor.
You can run all queries from SQL Editor View at once by pressing ⌘ + ⇧ + R
You can run a query positioned under the cursor by pressing ⌘ + U
To create a table click on the '+' button in the left bottom corner of the sidebar and select "New Table…".
dbHarbor will open a table editor view in the new tab on the left side of the main window.
Visual table editor lets you change the table name, add or remove columns, change column types and properties. You can also add foreign keys using by clicking on the arrow in the column named "FK".
When you are ready to push created table to the database, just press ⌘ + S and the table will be commited to the database.
To filter table data press the table options button (s. screenshot bellow) and choose the "Filter" menu item.
You can apply multiple filters to quickly filter out the records you want to see.
Go to the filter view again to refine the filter or to turn it off.