App Shopper: General DB (Business)
App Shopper: General DB (Business)
General DB is a general-purpose database app that lets you record information quickly and easily.
Try our FREE Private DB app to get a feel for General DB before you buy.
For example, if you have a bottle collection, 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!
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 supported 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:
– Download files from the web or Dropbox
– Import text files into tables
– Execute SQL files
– Extract .zip or .gz files
– Manage your image files and create thumbnails
– Preview all the lines in a file before importing it
– Custom picker types to select values from a list
– Add your own image files from you computer using iTunes
– SQL Console for executing SQL statements
– Mark SQL statements as favorites
– See and execute past SQL statements in the History
– Built-in web browser to download files from
– Save websites in the Bookmarks
– Easily create a SQL VIEW (subsets of fields from a table)
– JOIN 2 or more tables or views for relational capabilities
– Export selected rows from your tables to a file
– Email your files to others
– Share your database via Email or Dropbox
– Create databases
– And much more!
If you have any questions, or if you need your business database customized for your iPhone or iPad, feel free to contact us on our website.
Show More…
What’s New
IMPORTANT: 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 Dropbox or iCloud or sync them with your computer.
– Fields with formats of Date, Time, or Number can now be styled. Change the default style for all Date, Time or Number fields in the app info screen. Override the default styles for a table or view in the table settings.
– 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’);
Free direct download Android Games,Android latest version Apps,obb,pro,apk,mod,data.Mobile , device phone and Tablet
unlimited money . revdl . rexdl mob.org برنامج مهكر كامل احدث اصدار
النسخه المدفوعه مهكر كامل للاندرويد تحميل تطبيق تنزيل apkpure apk mirror
0 Response to "App Shopper: General DB (Business)"
Post a Comment