General DB
Full-fledged SQL Database
Only for Mac
$9.99
Full-fledged SQL database on your Mac!
General DB is great for recording information quickly and flexibly into a modern, full-fledged 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
Spreadsheet-Like:
Lets you edit individual cells, or copy and paste selected cells to another app
Easily Create SQL Views:
For displaying only some of the fields of a table, or reordering the fields, or filtering out some of its rows
Print Labels:
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
SQL Console:
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:
* Searchable
* Sortable
* Selectable
Many apps are too specific to a subject, but General DB is flexible enough to handle many, many needs, such as:
- Inventories
- Customer info
- Membership lists
- Tracking Logs
- Accounts
- 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 formats.
The field formats allowed are Text, Number, Date, Time, Duration, Location, Photo, Barcode, Raw, Picker, and Lookup Table. 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 field formats 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!
more There is NOTHING intuitive in this program.I watched their videos on how to do things, like simply add a row. I still have no clue. I'm sure when you know it's easy as pie. I wanted to make a simple invintory list of 20 items and 3 columns. Not take a course in DB construction.
Developer Response Hi, sorry that you’re having trouble. Could you contact us on our website and we can assist.
There is NOTHING intuitive in this program.I watched their videos on how to do things, like simply add a row. I still have no clue. I'm sure when you know it's easy as pie. I wanted to make a simple invintory list of 20 items and 3 columns. Not take a course in DB construction.
Hi, sorry that you’re having trouble. Could you contact us on our website and we can assist.
This is a super little product that does far more than I expected. It certainly provides all the basics that I need and, with a little practice, is very easy to use. Thank you to the developer! It's just what I needed.
This is a super little product that does far more than I expected. It certainly provides all the basics that I need and, with a little practice, is very easy to use. Thank you to the developer! It's just what I needed.
I needed a Mac database to perform simple searches on a 1.5M record file (usually done with Access on Windows). General DB did the trick, and sooo much quicker than Access. Support questions sent to the developer were answered quickly. 5 stars!
I needed a Mac database to perform simple searches on a 1.5M record file (usually done with Access on Windows). General DB did the trick, and sooo much quicker than Access. Support questions sent to the developer were answered quickly. 5 stars!
I'm very satisfied with this app! Some of General DB's options include: building a customized table, searching tables, importing and exporting, and simple controls for quickly manipulating table attributes on the fly. And some power features such as setting field names and executing SQL are available as well.No database knowledge is required to use this app. If you’d like to track data for research, keep an accounting log, or perhaps maintain an inventory, General DB will very likely suit you.Also, for anyone necessitating the use of Voiceover accessibility, the developers have been working hard at improving the usability of the app over the last few weeks.All controls are properly labeled and you can navigate table data without any issues. There are keyboard shortcuts available as well.I want to thank Thomas and his team for being So receptive to my feedback, and for implementing accessibility enhancements So quickly. Because of their work, General DB has become one of my most used apps. If you need a general purpose database solution without paying a high cost, I definitely encourage you to consider General DB!
I'm very satisfied with this app! Some of General DB's options include: building a customized table, searching tables, importing and exporting, and simple controls for quickly manipulating table attributes on the fly. And some power features such as setting field names and executing SQL are available as well.No database knowledge is required to use this app. If you’d like to track data for research, keep an accounting log, or perhaps maintain an inventory, General DB will very likely suit you.Also, for anyone necessitating the use of Voiceover accessibility, the developers have been working hard at improving the usability of the app over the last few weeks.All controls are properly labeled and you can navigate table data without any issues. There are keyboard shortcuts available as well.I want to thank Thomas and his team for being So receptive to my feedback, and for implementing accessibility enhancements So quickly. Because of their work, General DB has become one of my most used apps. If you need a general purpose database solution without paying a high cost, I definitely encourage you to consider General DB!
- Getting Started window appears on first launch
- Regular expressions in SQL, such as:
SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed'
- SQLite 3.36.0
5.12 06/30/2021
- If you open a database that has a field value that cannot be displayed as a text string, then a special string is displayed instead. This is to prevent unexpected behavior when binary data is in the field but the Raw field format is not selected.
- Bug fixes
- SQLite 3.35.5
5.11.1 05/27/2021
Preferences window:
- Organized according to what is displayed
- Has an Apply and Revert button so that you can change multiple settings before it affects your open database windows.
SQLite 3.35.4:
- Built-in math functions, such as sin() and log()
- ALTER TABLE DROP COLUMN
- Generalized UPSERT
- RETURNING clause lets you see the values after an INSERT, UPDATE, or DELETE.
NOTE: This is a major release. If you have critical databases, you must back them up by copying them to another folder, or by using iCloud or Dropbox before updating this app!
5.11 04/06/2021
- Importing a text file now displays the number of rows imported in the status bar, instead of the log. This prevents the log file from growing too large if a large number of rows are imported.
- SQLite 3.34
- The generate_series() virtual table is now built in to this app. As an example, the SQL executed below would a virtual table of 6 rows with even values starting from 0 up to 10:
SELECT value FROM generate_series(0, 10, 2)
Note: Backing up your databases before a major software update is good practice and recommended. To backup your databases, use Time Machine, or go to Window > Databases in the app can copy them to another folder.
5.10 01/04/2021
New Map window lets you view selected locations and circular areas.
Add a semicolon between the coordinates of a location and the radius in meters to see it in the Map window.
Example below:
35.5,-78.1;500
5.9.1 11/18/2020
- Make a table or view a Picker Table and use it as the field format of a field in another table.
- Picker Types are now called Pickers that are stored in the system tables.
- Bug fixes
SQLite 3.33:
- Decimal math functions
- Support for UPDATE FROM
IMPORTANT: This is a major release. If you have critical databases, you MUST back them up before updating this app. To back them up, use Time Machine, or share them with iCloud, or upload to Dropbox.
5.9 09/14/2020
- More documentation for SQL functions
- Moved Refresh and Transpose buttons in the Clipboard Contents window to the bottom.
- SQLite 3.32.3
- Bug fixes
Although this is a minor release, it is good practice to back up any critical databases you have before updating the software.
5.8.1 07/07/2020
Hide tables and views in the List of Tables. This helps when working with databases that have a lot of tables and views, some of which you rarely use. It can also be useful if you are distributing your databases to others, who do not need to see all the tables. To hide a table or view, control-click it in the List of Tables and click "Hidden". To un-hide it, do the same thing to un-check the "Hidden" menu item. To show all hidden tables and views, click the settings (gear) button under the List of Tables and click "Show Hidden Tables". The next time the database is opened in the app, the hidden tables and views will be hidden again. Only tables and views can be hidden in this manner, not indexes or triggers.
Make any field an expanded field, not just fields with Text format. The expanded fields will be concatenated together in the Expanded Fields Section of the Row Display. Control-click a table in the List of Tables, and click "Name and Fields". The control-click a field and click "Show Expanded" to make it an expanded field.
The Expanded Fields Panel can now show multiple expanded fields. The expanded fields of the table are concatenated together so that you can easily see them, or copy and paste them to another app.
The Error Messages window is now the Diagnostics window and shows the version and release date of the SQLite library used in the app.
The SQL Console now has a Functions button that presents a window showing all the functions available in the app. Some have descriptions. Double-click the function to see the full description.
SQLite 3.32.2
Bug fixes.
NOTE: This is a major release. If you have critical databases, you MUST back them up before updating your software. To back them up, use Time Machine, or upload them to iCloud or Dropbox.
5.8 06/14/2020
IMPORTANT NOTES:
- This is a major release. If you have critical databases, you MUST back them up before updating the app. To back them up, either use Time Machine or open the Databases Window and copy and paste the database files within the app to another folder.
- When you start editing a cell in the Rows Console, it will switch modes to display the unformatted field value. After editing is complete, the formatted value will be restored. This does not change what is stored in the database, only what is displayed.
- When you edit a cell in the Rows Console that was NULL, then move off it without changing it, it remains NULL.
Other Changes:
- Date, Time, or Number fields can now be styled. Change the default style for all Date, Time or Number fields in the Preferences. Override the default styles for a table or view in the Name and Fields panel.
- The files within the app container can now be retrieved using SQL. Examples:
SELECT * FROM general_db_files
SELECT name FROM general_db_files WHERE size > 1024
- A Location field can now have its latitude and longitude separated by a comma.
- Choose the field storage format separately for Date and Time fields.
- Bug fixes
- SQLite 3.31.1
SQLite, starting with version 3.31, now supports "generated columns". The example SQL below can be entered into the SQL Console in this app to create a table with one field "generated" from the first two.
CREATE TABLE t1 (
a INTEGER PRIMARY KEY,
b INT,
c INT GENERATED ALWAYS AS (a * b) STORED
);
Then when adding rows to the "t1" table, you would enter the "a" and "b" fields and the "c" field would be automatically computed and stored.
The "c" field is ignored in this app when adding or updating rows in the Add Row Console.
Names are also notoriously difficult to search on. Some people go by one name only, and it is not always clear if it is a first name or last name.
Some cultures do not have the concept of first or last names.
To simplify searching by name you can add a generated column that concatenates the first and last names.
CREATE TABLE artist (
first_name TEXT,
last_name TEXT,
name TEXT GENERATED ALWAYS AS (first_name || ' ' || last_name)
);
INSERT INTO artist (first_name, last_name) VALUES
('Keith', 'Urban'),
('Prince', ''),
('Yoko', 'Ono');
5.7 02/19/2020
- Fix for importing text files with Chinese Unicode characters.
5.6.3 11/02/2019
- Last console for each open database window is restored when the app is launched.
- New windows that do not have a database assigned now have a title so they appear in the Windows menu and can be restored when the app is launched.
- When renaming a database, the .db extension is used if no extension is entered.
- SQLite 3.30.1
- Bug fixes
5.6.2 10/22/2019
IMPORTANT: Even though this is a minor release, it is good practice to backup your critical databases before updating the app. To back up your databases, use Time Machine or copy your database and image files manually.
- Easily hide or show the Tables List and Toolbar using the View menu. This is useful if you want to open the same database in multiple database windows, such as for seeing the changes in a sorted view of a table in one window while adding rows to the underlying table in a different window.
- "Auto-Refresh All Windows" option in the app Preferences sets the app to refresh the selected table or view in all other visible windows after changes are made in the current window (except after importing text files). Be sure to check the Auto-Refresh box if you open the same database in a different window.
- The View menu now lists each item in the toolbar as a "Console", to distinguish them from a SQL VIEW.
- The map region is remembered in the Edit Field panel for Location field formats.
- If a query is issued in the SQL Console that already exists in the history, it is moved to the top of the history list.
- You can prefix a query with a space character in the SQL Console if you do not want it to appear in the history list.
- The currently selected table is now included in the window title. This allows you to hide the Tables List in a window and still know what you are looking at. If a view is not designated as "Sorted on a unique key", it will display "(Limited Rows)" after its name in the window title.
- Bug fixes
5.6.1 07/12/2019
IMPORTANT: 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.
Easier to Create SQL Views:
After executing a SQL query that returns results in the SQL screen, you can now create a SQL view from those results. You can also change the field formats of the fields when creating a view. This is a very powerful feature yet very lightweight, as it does not add any rows to the database, but lets you rearrange fields, select only a few rows, or reorder the rows.
Raw Field Format:
The new "Raw" field format lets you see the actual bytes in hexadecimal that are stored in a field in a row in the database. This is useful if you are having any issues with your data, or are storing binary large objects (BLOBs). They are only displayed and cannot be edited. To change their value use the UPDATE statement in SQL.
Dates and Times:
When a field with the Date or Time format is stored in General DB, by default it includes the time zone in +/-HHMM format at the end. Now you can omit that if you know you will always be in the same time zone (without Daylight Savings Time), or if you want to use UTC time. The original format is recommended however, as omitting the time zone causes ambiguity in dates and times.
There are some new built-in functions for converting fields in the Date and Time format of General DB to that which can be used by SQLite date and time functions. The following SQL statements can be executed in the SQL screen in General DB to see how they work:
SELECT utc2date('2020-01-01');
SELECT utc2time('2020-01-01 13:05:30');
SELECT date2utc('2020-01-01 -0400');
SELECT time2utc('2020-01-01 13:05:30 -0400');
Other Changes:
- Number of rows loaded for a Lookup Table can be increased in the app Preferences. Only do this if you need to and have a fast computer with a lot of memory.
- In the SQL screen, the "Show in Rows View" button is now "Create View".
- SQLite 3.28
- Bug fixes
5.6 06/22/2019
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.
Lookup tables:
Check the "Lookup" box when creating a table and you can then use it as a data type for a field. The table should have at least two fields, or one field and the internal ROWID. In another table, select that lookup table as the data type of a field and you will be able to select values from the list. Up to 50 rows can be used in a lookup table.
Show any query in the Rows view:
You can show the results of any query from the SQL view in the Rows view (up to 1,000 rows). From there, you can select and copy cells to paste into another app, export the results, or print the results. This lets you use the new WITH clauses and other features in recent versions of SQLite.
ROWID no longer required for a VIEW:
You no longer need to include a ROWID field when creating a VIEW. To scroll through all the rows in the Rows view, the rows must be sorted on a unique key (use the "ORDER BY" clause in SQL), and you must check the "Sorted on Unique Key" box in the "Sort" panel. If you designate the VIEW as being sorted on a unique key when in fact it is not sorted on a unique key, then the order in which the rows are navigated can be unpredictable. If you do not check the "Sorted on Unique Key" box, the number of rows displayed in the Rows view will be limited to 1,000.
Other changes:
- The ROWID for a row is now displayed at the bottom of the Add Row view. This change was made to allow a VIEW without a ROWID and still be scrollable in the Rows view, and to allow a table to be defined without a ROWID.
- After adding a row in the Add Row view, you can now continue editing it even if it is not currently selected in the Rows view.
- Allows multiple search fields.
- Improved icons for database objects.
- Table rows are only editable in the Rows view and Add Row view if the table has the internal ROWID field and does not have a user-defined column named ROWID that is not an alias to the internal ROWID field. This covers any table created using General DB, as well as almost all other tables created manually using SQL or other means. Typically, only very advanced users create tables that do not have the internal ROWID field.
- The Command-. hot key is available for the bottom-right-most button on the Add Row view and Print view.
- Execute SQL in the SQL view even if no database is selected.
- SQLite 3.27.2
- Bug fixes
5.5 04/04/2019
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.
- Export view now shows the first row of the selected table.
- The options for importing and exporting are available by pressing the gear buttons on the Import and Export views.
- New options for importing files.
- Import text files that have newline separators within double-quotes.
- You can see NULL values in the Rows view (by checking the option in the settings) and the Add Row view.
- Set values to NULL using the Edit menu.
- Supports Dark Mode in macOS Mojave
- Icon changed to be more similar to a General's insignia. It is stylized though and not intended to represent any particular rank in our country's great military.
5.4 01/26/2019
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.
IMPORTANT CHANGES to the Rows view:
- The scrolling has been improved. Now you can swipe the trackpad to scroll through rows or fields. You can drag the scroller in the vertical scrollbar to pan through the rows. If you click outside the scrollbar, then the rows are now advanced a page at a time. You can restore the behavior of the previous version by holding down the Option key on the keyboard while clicking. That would take you to that row in the table. This change was made to make it more consistent with the behavior of macOS.
- Dragging the scroller in the horizontal scroll bar only scrolls one field at a time. This is because the widths of the fields can vary or can be changed per table.
Some menu items have been changed. Notably, the Images menu item has moved to the Windows menu. There is also a Databases menu item that shows the databases that are currently selected in database windows. Use the Databases window to delete any databases within the app container that you wish to delete.
- The Open Database window now has a "New Database" button to be more consistent with macOS. To show the databases in a Finder window, click the Window menu then "Databases". You can still drag and drop database files into the Open Database window.
- If you do a SELECT * from the SQL view and click the "Show in Rows View" button, the title of the window changes to indicate the SELECT * is active. To deactivate it, return to the SQL view and click the "Show in Rows View" button again.
5.3 11/28/2018
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.
IMPORTANT CHANGES to the Rows view:
- Command-double-click on a cell to bring up the improved Edit Field Panel. You can also press the Command-Return key combination on the keyboard.
- Double-clicking on a Location or Photo cell now begins editing the value. To show the map or photo in a separate window, Command-double-click on it.
- The thumbnails are no longer shown on the Rows view for Photo fields. They were too small. Now the filename is shown. To see the full image, open the Edit Field Panel and leave it open while navigating the Rows view.
- The Edit Field Panel now shows more than one line of a field. You can scroll up and down to see all the lines.
- The Edit Field Panel is now also used by the Add Row info button.
- In the Edit Field Panel, if the data type is Photo, press the Images button and then select an image from the Images window to change the field value.
- In the Edit Field Panel, Today and Now buttons for Time and Date data types are available.
- The text view in the Edit Field Panel now detects URLs and which can be clicked to open.
Other Improvements:
- The Tables list has a context menu for convenience
- Improved look and size of some buttons.
- SQLite updated to 3.25.2
- Bug fixes
5.2 10/25/2018
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.
Improvements:
- 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
Notes:
- 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.
5.1 07/08/2018
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.
5.0.1:
- Fix for displaying databases created outside of General DB.
5.0:
- Icons in the Tables list to indicate the type of database object
- Show index and trigger database objects in the Tables list
- Multiple choice picker types
- Open databases in windows more easily
- Support for importing files containing emoji characters
- See database error messages in the Error Messages Window
- Change the CSV separator for importing or exporting to files
- Bug fixes
5.0.1 05/22/2018
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.
- Icons in the Tables list to indicate the type of database object
- Show index and trigger database objects in the Tables list
- Multiple choice picker types
- Open databases in windows more easily
- Support for importing files containing emoji characters
- See database error messages in the Error Messages Window
- Change the CSV separator for importing or exporting to files
- Bug fixes
5.0 05/19/2018
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.
- Big improvements to printing, with a new interface and the ability to change fonts for fields!
- Add a table with the contents of the Clipboard
- More options in the app Preferences for the number of fields or rows shown
- "Paste by Adding Rows" menu item has been renamed to "Add Rows from Clipboard"
- Transform a table in the Clipboard Contents window (exchange rows and columns)
- Web Browser Bookmarks and Picker Types are now separate windows so they can be resized and moved out of the way
- Bug fixes and improvements
4.6 05/16/2016
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.
- Math window shows you the Total, Average, Minimum and Maximum of the group of selected cells
- Math window handles $ and other symbols and treats parenthesized numbers as negative
- The Sort and Search popover has been broken up into a search window and a sort window
- The Sort Fields window can be opened by clicking the gear button and then "Table Sort Fields"
- The grid popover is now a window that can be resized or moved out of the way
- Set date or time fields to the current date or time by clicking the Edit menu, then "Make Current"
- External databases can be opened in a new window
- The Close menu item was moved to the Window menu because it applies to other windows as well
- SQL query and Print design buttons always activate their windows, to be consistent with the other auxiliary windows
- Search window selects the current field when it is opened
- Other improvements and bug fixes
4.5 12/04/2015
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.
* Cut cells or rows for pasting using the Edit menu
* Clipboard Contents window lets you see what will be pasted
* Quickly add a blank table from the + menu
* Move the focus in the Rows view while the Edit window is open
* Copy and paste selected columns for up to 1,000 rows
Other Changes and Improvements:
- Option-click on a row # to make that row first in the Rows view. Option-click on a column header to make that column first in the Rows view.
- The + button now displays a menu that let you add a blank table or create a new table as before
- The Table Settings popover has been split in to a "Table Name and Fields" window and a "Table Schema" window
- Click View then Tables to move focus to the Tables list
- Drag and drop objects in the Layout window of the Print view
- The Add Blank Row menu item was removed. Use "Add Blank Rows..." and specify 1 row to add
- The width of the tables list is restored for each database
- The width of the # column is restored
- Able to sort on ROWID as well as up to 3 fields
- When a table column header is clicked, the focus is put on first cell at top of column (similar to spreadsheet)
- When a table row number is clicked, the focus is put on first cell in the row (similar to spreadsheet)
4.4 10/23/2015
NOTES:
* 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.
BIG CHANGES:
* Rows view:
- If you make changes to a cell and then press tab, shift-tab, or the up or down arrow keys, the changes are saved to the database. If you make changes to a cell that you want to discard, press the Escape key.
- Fields of type Date no longer display "(Invalid date)" for strings that cannot be converted to a date. They now display the entered string. Likewise for fields of type Time.
- Fields of type Date now allow shortcuts for USA users such as 3/1 for March 1 of the current year, or 5/2/14 for May 2, 2014
- Fields of type Photo and Location now show a selection window when they are double-clicked on or the return key is pressed when they have the focus. You can edit the values as well by holding down the Option key when double-clicking.
- You can now Paste data over existing rows, or Paste data by adding rows, using the Edit menu
* Print view and Layout window:
- The objects in the box are listed in order in the "Objects in Box" list
- To add a field, text, or a new line, press the + button under the "Objects in Box" list. The new object will be added immediately after the selected object.
- To delete one or more objects from the box, select them from the "Objects in Box" list and press the - button underneath it.
- The entire field now wraps in a the box. If you would like to limit the amount of text shown in the box, create a view from your table and use the SUBSTRING() function in SQL.
- The box and page settings are now in a scrollable list to the left of the Layouts list.
- The "Last Layout" has been renamed to "Default Layout". If you have no other layout selected, this is what will be used.
* Some keyboard shortcuts had to be changed for consistency between the Rows view and the Add Row view:
- The shortcut for the Add button in the Add Row view has been changed to Shift-Cmd-A to avoid conflicts with the OS X standard shortcut of Cmd-A for "Select All"
- The shortcut for the info button in the Add Row view has been changed to Cmd-E to match the shortcut for the new Edit menu in the Rows view.
- The shortcut for clearing cells in the Rows view has been changed to Cmd-L to match the shortcut for the Clear button in the Add Row view
- The shortcut for opening the Images window is now Cmd-I instead of Cmd-Shift-I to be similar to the shortcut for opening the Databases window
OTHER CHANGES:
- Edit a field in a separate larger window in the Rows view by cmd-double-clicking it or pressing Cmd-E (Edit in the Edit menu)
- Add one or more blank rows from the Edit menu
- Deselect rows, fields or cells from the Edit menu
- Open New Window in Database menu opens the current database in a new window
- New keyboard shortcuts in the Share menu
- bug fixes and other improvements
4.3 09/29/2015
NOTES:
* 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.
* Holding the shift key while pressing arrow keys no longer selects cells. To select cells, command-click or shift-click on the desired cells with your mouse. This change was made to allow select rows or cells anywhere in the database.
- Hold down the option key when pressing the table column header to see the Total of a column. This change was made so that you can select entire columns of data to copy and paste, or clear and replace, by simply clicking on a column header.
Major Improvements to Copy and Paste:
- Copy and paste rows and cells from anywhere in the database
- Copy and paste from the results in the SQL view
- Clear or Replace selected cells using the Edit menu
Other Changes:
- Easier to see whether the Tables list or the Rows list has the focus
- SQL queries are now ordered with the most-recently-executed query first in the list
- Bug fixes
4.2 08/13/2015
- Getting Started window appears on first launch
- Regular expressions in SQL, such as:
SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed'
- SQLite 3.36.0
more Version 5.12 06/30/2021
Data Not Collected The developer does not collect any data from this app.
