Private DB 17+

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.

Developer Response ,

Hi, you can already designate the first row in a file to be the field names. On the Text File view, in the first section where it says "1st line", change it to "Field names".

Are you referring to the iPad version? You can change the field widths by tapping the button with the picture of a lock on it one the right side of the blue separator bar. Then the vertical separators between fields will turn blue and you can drag and resize them.

There are quote characters enclosing the fields? Can you send us a screenshot?

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!

Developer Response ,

Thanks for the review wilderness family 78! Python is cool too!

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.