Private DB
| Category | Price | Seller | Device |
|---|---|---|---|
| Business | Free | Portable Databases | iPhone, iPad, iPod |
NOTE: You can view and sort and search tables with this app, but cannot add, edit or delete rows. To do that, please use General DB.
With Private DB, your rows are:
* Searchable
* Sortable
* Selectable
This app is great for IT managers who want to distribute company data in table form, and don't want to worry about their users modifying the data.
It is also ideal for publishers of reference data tables, who do not want their users tampering with the data.
Some capabilities:
- download and import tab-delimited or CSV text files
- download from the web or Dropbox, or share from iTunes
- import text files from the Mail app
- download and execute SQL files
- download and switch to SQLite databases
- sort on up to three fields
- search on any field
- use simple SQL select commands or the advanced SQL Console
- create views on tables to select a subset of fields or reordered fields
Reviews
Portable database
photousa
This thing isn't worth a hoot. All they want to do is move you up the notch to a more pricy app. I uninstalled almost immediately after receiving and setting up. They really need to clean up the interface and include a tutorial of some kind. There are an awful lot of us fourth graders out here trying to get this stuff to work. MLM.
AWESOME APP!!
Mink33333
This app is AWESOME! If you want to check out how it works you should probably start out with the parent app MAJOR GENERAL DB. Its worth well over the price it sells for. Private DB is pretty much a simple and powerful database viewer app that doesn't hog up iPad resources like others. Trust me, I searched high and low downloading every type of database viewing software, an this IS THE BEST! The app is AWESOME and the Developer is Hands down the best in the biz. He answered every question and bent over backward for me at times. If you need a database solution buy this app and MAJOR GENERAL and you will be unstoppable.. Basically you import your data into MAJOR GENERAL and export the .DB file to PRIVATE DB. this comes in really handy if you want to give friends or co-workers read only database tables with minimum cost and effort......BUY BUY BUY!!!
Simple but effective app...
Emkai
Has done the job for me. The ability to search within data was the clincher! I also requested some support & the developer was extremely helpful in sorting out the small issue I was having. Highly recommended.
Garbage
Patton's Boot
Complete waste of time. Importing anything, even a flat text file, the app will "import" it and the preview looks perfect but then it provides nothing but disjointed code remnants for the rows and columns. Seems to display the same garbage after the import no matter what I tried importing. The same ~120 rows of programming code appears in lieu of the data. Pure waste of time and glad I didn't pay to try it out. Avoid.
Small enhancements would make this great
kcrossen
First, when importing CSV or TSV, the first row should be allowed to be the field names in place of “Field 1” etc. To be fair, this is covered on the product support page. Second, field widths should either be manually controllable or auto-width with some upper limit. Third, displaying text fields enclosed in quotes is a waste of screen real estate. Suppose you have the first field as a 6 letter ID, followed by a second field of 64 characters of text description. It would be useful for the screen widths occupied by these two fields to be either manually (preferably permanently) set and/or automatically preset individually to some width that reasonably makes the content visible (perhaps with some way to set an upper width limit). Now all fields are the same (unhelpful) width without any obvious way to change. Changing field widths is not obvious, not standard, and not covered on your support page. Given the narrow field widths, the inclusion of quote characters enclosing the characters of fields, and thereby wasting field display space, adds insult to injury. All text and date fields are displayed enclosed in double quotes. Your support page, under the “Rows” section, even shows an example of a date, exactly as it would be displayed in the product. One further annoyance is that horizontal scrolling operates in chunks via the ‘<‘ and ‘>’ buttons rather than the more precise iOS standard horizontal swipe. The result is that if you want the third through seventh columns to be simultaneously visible, you’re out of luck. This requirement is quite common in practice, and may be possible, but it’s not obvious how.
