General DB 17+

Full-fledged SQL Database

Portable Databases

Designed for iPad

    • 3.0 • 2 Ratings
    • £4.99

Screenshots

Description

Full-fledged SQL database on your phone!

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.

What’s New

Version 5.12

- Regular expressions in SQL, such as:
SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed'
- SQLite 3.36.0

Ratings and Reviews

3.0 out of 5
2 Ratings

2 Ratings

AbleBakerCharlie ,

Super program - superb service

An excellent app. Set up is extremely straightforward, just a few simple clicks and you have a table with fields dedicated to your desired data type. This reduces the keystrokes required for data entry to a minimum. Flexible data sorting allows any hierarchy of fields to be selected. You can review data either by using a simple search query or, for a more complex enquiry, the basic and to some extent pre-programmed SQL input scheme provided. But best of all, the support is absolutely superb. This reviewer required some help in recalling the correct syntax for SQL. At least 6 e-mails were answered over the course of no more than a few hours (some of which seemed to be around 4 am at their end!). Thanks to their patience and persistence I now have full use of this little gem of a program. Two minor niggles. One is that only two fields of the database are shown on the summary screen - the other fields can be accessed via a tap on the entry. The font of the second field displayed is a little small. I thoroughly recommend this app and cannot praise too highly the support team.

jrh68uk ,

Great for keeping track

I have used this app for a while now, to track all of my 35mm film. It allows me to see at a glance how much is in the freezer, how much is in the fridge and how much is out. I don’t have to keep searching around and I can see when I need to re-stock. It’s simple and it works.

The most recent update caused the row definitions to display nonsense (not the actual figures, thankfully - just the definitions) which gave me a good reason to trim down and improve my tables by re-defining. Yes, I could have marked down for this but I don’t agree with marking down for technical reasons in reviews, particularly as I didn’t even need to invoke support. It’s still great and it does what I need it to do.

tw@face ,

Excellent & Flexible

I use this data base every day for my courier business. Its ideal for keeping track of jobs, mileages, rates, quotes etc and for checking against receipts and invoices later. Features like hitting the "now" button automatically enters the current time & date making it fast enough to use in the field. I can easily email myself a .csv copy to keep a backup from within the app. I'm looking forward to promised improvements on next update (thanks Tom, great service)

App Privacy

The developer, Portable Databases, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary based on, for example, the features you use or your age. Learn More

Supports

  • Family Sharing

    Up to six family members can use this app with Family Sharing enabled.

More By This Developer

Area Code Directory
Reference
Private DB
Business
Antibiograms
Medical
Use By Date
Lifestyle
Antimicrobial Guide
Medical

You Might Also Like

Ultimate Database
Productivity
Writemator - Plain Text Editor
Productivity
Edit HTML
Productivity
TextCrafter 2 ~ Craft & Share
Productivity
eScribo
Productivity
CDBF
Business