Private DB

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

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