SQLite Mobile Client 4+

Excellent Compatibility

I tested many SQLite programs and settled on three over the years, but one had a less than ideal interface and another had poor compatibility with the desktop version of SQLite. This app has never let me down as far as compatibility with the desktop version of SQLite is concerned. Raised my review to 5 stars.

Please debounce search

I need to text search 758,411 rows with 7 columns, but unfortunately, the search query runs every keypress, which means it seems promising with a page size of 1000 rows, but with a page size of 1,000,000 rows, the app lags for like 10 seconds every letter you type of your search query. If you could please just wait until the user stops typing to run the query over the page, then it would be a five star app. Also, I think the default of 1000 rows per page makes sense, except when you search for something and find no results, in that case, it could be better to automatically search the next page(s) all the way to the end. Just asking because I have a humongous medical database and need to type a symptom to find all the rows with that symptom easily. Thank you for making this app!

Developer Response ,

Thanks for the feedback. Please check the new version if it improves search performance.

No help

Nowhere in this app is there any link to anything approximating a help file. Which would be useful because the querying that you can do doesn’t seem to support tables that have foreign keys, which is precisely what I have, and is considered to be good practice in constructing a database. At the very least it would be nice if there was something to say, ‘standard SQLite features we do not support: foreign keys’ or some such. I don’t know that they don’t support them, but I can’t find any place where they say they do! And for that reason, this app is completely useless to me and I will be deleting it!