General DB

General DB

Full-fledged SQL Database

21 ratings
43 reviews
$4.99

Details

  • Released
  • Updated
  • October 16, 2009
  • July 1, 2021

Features

General DB screenshot #1 for iPhone
General DB screenshot #2 for iPhone
General DB screenshot #3 for iPhone
General DB screenshot #4 for iPhone
General DB screenshot #5 for iPhone
General DB screenshot #6 for iPhone
General DB screenshot #7 for iPhone
General DB screenshot #8 for iPhone
General DB screenshot #9 for iPhone
iphone
ipad
🖼️Get Icon
Icons↘︎

About

This app allows users to create and manage custom databases for various needs, from personal collections to business inventories. It offers flexible data entry with multiple field formats and powerful SQL capabilities for advanced users. Data can be easily searched, sorted, and shared.

Customizable tables and fields
Multiple data field formats
Searchable and sortable data
SQL console for advanced users
Data import and export
Relational database capabilities
Cloud and file sharing options
Show original description

What's New in General DB

5.12

July 1, 2021

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

More

User reviews

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.
Show more

Response from developer

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.

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.

Response from developer

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.

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!

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.
Show more

Response from developer

Thanks for the kind words Paul!

PalmOS で JFile を使ってた人は最適?

表題の通りです.
Private バージョンでは,他のツールで作ったテクストファイルもこれに関連付けされてしまって,テクストファイルをクリックするとPrivate バージョンが立ち上がってしまい困ってましたが,General バージョンでは改善されてて快適です.

Developer apps

FAQ

What is General DB?

General DB is a versatile database application designed for both personal and business use. It allows you to create custom databases to record and manage information efficiently. You can define tables with specific fields and input data in various formats, making it suitable for tracking collections, customer information, inventories, and much more.

What are the key features of General DB?

Key features include the ability to create custom tables with various field formats (Text, Number, Date, Location, Photo, Barcode, etc.), making data entry flexible. The app offers robust data management with searchable, sortable, and selectable data. For advanced users, it provides an SQL console, the ability to join tables, create views, and import/export data. It also supports sharing databases via email or cloud services.

Is General DB free to use?

The description mentions a 'FREE Private DB app' to try before buying General DB. This indicates that General DB itself is a paid application, likely offering a more comprehensive feature set than the free version. Users can explore the functionality with the free app before committing to a purchase.

What devices is General DB compatible with?

The description specifically mentions customization for 'your iPhone or iPad', suggesting that the app is designed for Apple's mobile operating systems. It is likely available on the iOS App Store and can be used on iPhones and iPads.

What are some common use cases for General DB?

General DB is highly flexible and can be used for a wide range of purposes. Common use cases include managing personal collections (like bottles or books), tracking customer information, maintaining membership lists, creating detailed tracking logs for various activities, managing accounts, and organizing inventories for businesses. Its adaptability makes it suitable for many data organization needs.