Private DB lets you load and view databases on your mobile devices. You can import CSV or tab-delimited text files from the web, email, Dropbox, or share them from iTunes into tables in your database. 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 - Execute SQL commands in the SQL Console - Create views on tables to reorder or select a subset of fields
Limited Usecases
Would be nice, in addition to beng able to create a table from scratch (which seems to work fine), to be able to add rows with data.
Not full featured at all
You cannot enter new data! Wants you to pay $5 for another app which is exactly like this app but does it
Awesome and Full Featured App
Awesome app. Simply it just works! It’s also fully featured. I’m Python developer. When working with Pythonista I can easily create and manage my SQLite DB’s. Thanks for an awesome app!
Small enhancements would make this great
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.
Garbage
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.
Simple but effective app...
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.
Cant edit but still useful
I can download real estate data
SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed' - SQLite 3.36.0
Subscribe our newsletter and get useful information every week.