Private DB

Private DB

SQLite Database Viewer

59 ratings
10 reviews
Free

Details

  • Released
  • Updated
  • January 5, 2011
  • July 1, 2021

Features

Private DB screenshot #1 for iPhone
Private DB screenshot #2 for iPhone
Private DB screenshot #3 for iPhone
Private DB screenshot #4 for iPhone
Private DB screenshot #5 for iPhone
iphone
ipad
๐Ÿ–ผ๏ธGet Icon
Iconsโ†˜๏ธŽ

About

Easily view and manage SQLite databases on your mobile device. Import data from various sources like CSV or tab-delimited files, and search or sort through your tables. Ideal for IT managers and data publishers who need to distribute data without modification.

โœ“Import CSV and tab-delimited text files
โœ“Load databases from web, email, Dropbox, iTunes
โœ“Searchable and sortable tables
โœ“Execute SQL commands
โœ“Create views on tables
โœ“Sort on up to three fields
Show original description

What's New in Private 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

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.

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!

Images can cause crashing

A reasonably laid out app that functions well enough on my iPad when displaying โ€˜basicโ€™ tables from my SQLite databases.
However, it crashes every single time I touch a record in a table view that includes a jpg image file in a BLOB field.

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

Good app, but needs iPhone 6 Plus screen size

This seems to be a well developed app and it is nice to use on my iPad.
However, the screen resolution needs updating for the iPhone 6! At the moment it looks awfully enlarged.

Developer apps

FAQ

Can I edit data in Private DB?

No, Private DB is designed for viewing and sorting data only. You cannot add, edit, or delete rows. For editing capabilities, you would need to use a different application like General DB.

What file formats can Private DB import?

Private DB can import tab-delimited or CSV text files. It can also load SQLite databases directly.

Where can I import data from with Private DB?

You can import data from the web, email clients, Dropbox, or share files from iTunes. It also supports importing from the Mail app.

Does Private DB allow sorting and searching?

Yes, Private DB allows you to search any field within your tables and sort your data on up to three fields. You can also create views to reorder or select specific subsets of fields.

What is the age rating for Private DB?

Private DB has an age rating of 17+, indicating it is intended for mature users. This is likely due to the technical nature of database management.

How often is Private DB updated?

The latest version of Private DB is 5.12, which was last updated on July 1, 2021. While not frequently updated, it has been available since 2011.

Is Private DB available on Android?

Based on the provided data, Private DB is supported on iPhone, iPad, and iPod. There is no information indicating support for Android devices.

Does Private DB have ads?

No, Private DB does not contain advertisements. It is a free application without any ad interruptions.