Mac OS Business
General DB is great for recording information quickly and flexibly into a modern, no-frills database.
General DB lets you edit data in your database as if it were a spreadsheet, and you can open multiple databases at once and copy-and-paste data or drag-and-drop tables between them.
Some valuable features:
Open Multiple Database Windows:
For dragging and dropping tables, or copying and pasting rows
Lets you edit individual cells, or copy and paste selected cells to another app
Good for postcards, stickers, envelopes, and forms
Copy and Paste Rows:
Copy and paste selected rows or cells to another database or app. Drag and drop tables between databases.
Import and Export Rows:
From CSV, tab-delimited, or pipe-delimited files
Execute SQL and make favorites
Designed for both casual users and power users, General DB can be used as a replacement for some spreadsheet tasks, or as a staging system for larger database systems, or for publishing data sets to iOS devices using the Private DB app, or for many other tasks.
Some example uses:
Say you have a bottle collection, and you want to keep up with what you have. You could make a table with these fields: Date Acquired, Bottle Type, Bottle Origin, Shape, Notes. Then whenever you add a new bottle to your collection, you can add a row to the table describing it.
If you want to track visits to different vacation sites, you can make a table with fields for the Date Visited, Location, Description, and Attraction. As you visit the sites, you can add corresponding rows to your table.
After you add rows to your tables, they will be:
Many apps are too specific to a subject, but General DB is flexible enough to handle many, many needs, such as:
- Customer info
- Membership lists
- Tracking Logs
- and many more !
No database knowledge is required to use this app, but you will pick some up as you go!
Distribute databases to either General DB for the iPhone and iPad, or the free Private DB!
For power users:
General DB allows easy data entry into a full-fledged SQLite database. To do so, it enhances it with field types.
The field types allowed are Text, Number, Date, Time, Duration, Location, Photo, Barcode, and custom picker types. There are convenient buttons next to some fields for easier input.
For administrators or IT manager, you can create a master database of reference information that you don't want your users to modify. This master database can be published on the internet and either the Private DB app or General DB can download and view it.
Some more powerful features:
- Import text files into tables
- Execute SQL
- Custom picker types to select values from a list
- SQL templates for tables
- Add SQL statements to your Favorites
- See and execute past SQL in the History
- Create views as JOINs of 2 or more tables for relational capabilities
- Export selected rows from your tables to a file
- Create databases
- And much more!
NOTE: This is a major release. If you have critical databases, you MUST back them up before installing this update. To back them up, use Time Machine or backup your database and image files manually.
This version has the same features as before, but some of the buttons were relocated for consistency or for easier usage on large screens. Also, the Grid button has been replaced with horizontal and vertical data scroller that do the same thing.
- The + button and the action (gear) button were moved from the toolbar to the bottom of the Tables list.
- The Search window is available by clicking the gear button then clicking "Search" from the menu.
- The Grid window was replaced with horizontal and vertical data scrollers that function similarly but are always available for tables that have more rows or fields than can fit in the window. Click above or below the vertical data scroller to change the rows displayed. Click to the left or right of the horizontal data scroller to change the fields displayed.
- To go to a specific row, click on the number of rows at the bottom left of the Rows view. Then enter a row number and press Return on your keyboard.
- The Rows view now does not have regular scrollbars. It only displays how many rows and fields can fit in the current window. You can expand the window to show more. You can also navigate up and down and left and right using the keyboard.
- The Rows view has a right-arrow button that lets you select which field to display first.
- The Import view now displays a list of files to be imported. You can drag and drop files into the "Files to Import" list and change their settings such as file type and encoding by control-clicking on them.
- The buttons for each of the views were moved to the the right. This was to improve productivity for users with large 27" screens. It decreases the voyage the mouse has to travel between the buttons.
- There is a status bar under each of the views where more information is displayed when needed. The number of rows is shown on each view now.
- Bug fixes
- Pressing the Tab key when editing the last field in the Add Row view takes you to the first field of the next row.
- Pressing the Shift-Tab key when editing the first field in the Add Row view takes you to the last field of the previous row.