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.
__________
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.
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.
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 バージョンでは改善されてて快適です．
Private バージョンでは，他のツールで作ったテクストファイルもこれに関連付けされてしまって，テクストファイルをクリックするとPrivate バージョンが立ち上がってしまい困ってましたが，General バージョンでは改善されてて快適です．
Using this to collect field data on an ipad
success!
thanks for an SQLite DB mgr; on iOS 13 howto ...
How do I turn on ‘dark mode’ for General DB to take advantage of this new iOS feature?
Response from developer
Working on it. Thank you for the review!
データがサクサク作れる
操作性にちょっとクセありますが、慣れるとサクサクデータ作れて快適です。
これで作成したデータをcsv形式ファイルで書き出してExcelに取り込むなどして活用しています。
これで作成したデータをcsv形式ファイルで書き出してExcelに取り込むなどして活用しています。
Awesome App
This app is awesome. The current version resolved a memory leak issue causing import problems with very large files. Customer service has been fantastic! Quick responses and follow ups. Also willing to spend the time in helping me with the import issue.
This app allows me to carry large amounts of data that I can easily access. In app searches are very quick.
This app allows me to carry large amounts of data that I can easily access. In app searches are very quick.
Show more
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.
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.
Show more
Штрихкод
Не распознает
Great App
I have a pretty large database with 8 tables and 10k+ rows - this runs great on my iPad and iPhone 6 sharing with Dropbox.
The only thing missing for me is the ability to have the 'picker types' dynamic, For example being able to define a field as a lookup in a related table rather than a static list of picker values. - UPDATE: I found out that the picker values ARE actually stored as hidden tables (view in settings). Now I can use triggers to update these picker values dynamically based on other tables. Very cool - can almost build a complete application now. Simple Form capability would make this app complete for me.
Keep up the good work
The only thing missing for me is the ability to have the 'picker types' dynamic, For example being able to define a field as a lookup in a related table rather than a static list of picker values. - UPDATE: I found out that the picker values ARE actually stored as hidden tables (view in settings). Now I can use triggers to update these picker values dynamically based on other tables. Very cool - can almost build a complete application now. Simple Form capability would make this app complete for me.
Keep up the good work
Show more
As Advertised
Solid app that does what it’s advertised to do. Here are the features I like about General DB:
- Despite being a mobile app, it is powerful with a query interface and a SQLite console.
- The database easily handles large data tables with many records. In contrast, another popular database app I have groans with large data tables.
- The corresponding OS-X app makes it handy to share data files with my iMac. This can be done through iTunes or through Dropbox. To share With Dropbox, you must have the free Dropbox app on your mobile device — I learned the hard way.
- Tech support through email is responsive and friendly.
I hope General DB’s developers continue to refine the app. I would like to see more varieties of field types such as integer, decimal, and boolean.
- Despite being a mobile app, it is powerful with a query interface and a SQLite console.
- The database easily handles large data tables with many records. In contrast, another popular database app I have groans with large data tables.
- The corresponding OS-X app makes it handy to share data files with my iMac. This can be done through iTunes or through Dropbox. To share With Dropbox, you must have the free Dropbox app on your mobile device — I learned the hard way.
- Tech support through email is responsive and friendly.
I hope General DB’s developers continue to refine the app. I would like to see more varieties of field types such as integer, decimal, and boolean.
Show more
I love it!!
Good app! But I need "Open in" Please!!
Great UI and a Great Import Capability
Works with CSV files using either single quote marks or double quotes. Imports xlsx. Very powerful SQL implementation. I am very happy with this app so far!
PERFECT!! NOTHING BETTER THAN THIS
got everything I need!! clear, the way it is is JUST RIGHT!!! Thanks a bunch!!
Help?
Seems to work well but can someone tell me how to change the field names? When I try to do it, there is no save button, and it disappears...
Non-relational
If you're looking for a relational database, look elsewhere. This isn't it. Just a set of flat tables. May as well use Numbers.
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.
Show more
May be basic, but it's great!
I wanted a simple database that kept track of the books I've read - the titles, the authors, the dates, and a synopsis. The fact that it is searchable, and modifiable, is a real bonus. Of course, I could've added many more fields if I needed. This is definitely worth the $2.99 upgrade. Thanks for developing this.
Show more
