General DB 17+

Full-fledged SQL Database

Portable Databases

Designed for iPad

    • 4.5 • 20 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

4.5 out of 5
20 Ratings

20 Ratings

Probably Older Than You ,

Capable Database Viewer and Editor

My original mistaken review is below; as can perhaps be seen, the developers wrote back, letting me know I overlooked the option to get the database back out.
__________

In limited testing with a small database. . .

If you have an older iPad/iOS, this is a good app to view and edit your SQLite database files.

Definitely try the free Private DB first to get a feel for how it works.

It’s not quite as intuitive as I’d like, none of the icons are labeled, so one must experiment by tapping on them to find out what they do, which is potentially dangerous with databases. Figuring out how to adjust the column widths took longer than I wanted.

Updating a record is troublesome when the field is low on the screen, the keyboard entirely covers it, so you can’t see what you’re typing.

Moving through the columns isn’t a matter of swiping, as with rows.

But the app hasn’t crashed yet.

__________
Original Mistaken Subject: Exports/Shares as a text file only, not a .db

I mistakenly thought I could get my database back out as a SQLite .db, which is how it got in.

But the Share button only allows for sharing selected rows, or exporting the whole db as a .txt file which then can only be imported, apparently through iTunes.

Developer Response ,

You can share your database as well without exporting to text files. Just tap on the Files tab then tap the Database tab then tap the row of the database file you want to share, such as general.db which is the name of the default database file. Then tap the share icon button in the toolbar. Please contact us on our website if you have any issues with that.

Thank you for updating your review and rating. We will get to work on those other issues you mentioned.

TexasClodhopper ,

Support

I added GeneralDB to my iPadPro and could not make it operate even though I’ve been using this app on my iPhone for years.

Once I contacted Tom for a little support, I got a bunch of support; almost instantly. The problem was solved by that afternoon, and a reset of my iPad got me back into the app. +1 for support of this useful tool.

Developer Response ,

Thanks for the kind words Paul!

EricNSacramento ,

Just awesome!

I find this app to be perfect. Very easy to use, handy, helpful, powerful and long overdue. Wish I had found this years ago. Love it!

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, for example, based on 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

Writemator - Plain Text Editor
Productivity
TextCrafter 2 ~ Craft & Share
Productivity
Ultimate Database
Productivity
HanDBase for iPad
Productivity
Navicat for PostgreSQL
Productivity
FAQ: Support Your Customers
Productivity