General DB General DB $9.99
33% OFF
General DB

General DB

5.7 for iPhone
$9.99 · $14.99
0

0 Ratings

Update Date

2020-02-19

Size

2.7 MB

Screenshots for iPhone

General DB Description
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!
General DB 5.7 Update
2020-02-19 Version History
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');
More
More Information
Price:
$9.99
Version:
5.7
Size:
2.7 MB
Update Date:
2020-02-19
Developer:
Portable Databases
Language:
English
More
You May Also Like
Developer Apps