SQLite Mobile Client

Just found this app. For some time I've been trying to find a suitable app to run SQLite databases on my iPad. I was using one which gave event results but did not take parameters in queries, so the search string had to be hard coded each time. This app allows the use of parameters, either with a"?" or by using the ":ParamName" method. The only shortcoming I've found is that if a parameter is used more than once, it needs to be input multiple times. (However, copy & paste makes this a minor inconvenience only). [Update 21/Jan/2025] The app has now been changed so that a parameter which is used more than once now only needs to be entered once. BRILLIANT !

Very handy

App is useless for creating databases unless using paid upgrades

This tool gives me the functionality I was looking for to interact with my SQLite databases, but I wish it included better documentation or a Help function. For example, if the developer had included SQL query examples that produce the screens shown in the App Store’s entry, I would be able to better utilize the power of the tool. I looked at a lot of tools to use on my iPad, and this is the BEST one.

I am so so very pleased— with the results from, and everyday productivity— that has been facilitated by this wonderfully designed and highly refined application. For years, now, I have loved SQLmobile, and this is an app I will stand beside until the end. As a freelance organ sampleset developer, the world of relational database architecture becomes absolutely critical to go about correctly, and this fully-fledged app hits every point desirable for any query, transactional statement, or workflow tweak you could need. I’ve long since happily migrated my local databases into this app from their former editors and the projects have been a breeze ever since. Absolutely CHOOSE THIS APP!

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.

Can you list what the PRO features are, how they work.

2024-02-29 ~ One day after posting the review below. I wrote Filippo, the author, and he replied within 24 hours. I can now open the app again. There was an issue with iCloud, I had to toggle it off for the app; he said he’s submitted an update to Apple already. So far, in my light testing, I’ve been *very* impressed. Numerous nice touches like auto column sizing, rows can hold more than one line of text—so a field with a sentence versus just one word, can have its entirety shown. Low-light mode. Search the entire database and get the results in real time. Show & edit one record at a time. As an SQL newbie I’ve not yet tried its querying features. ____________ I tested the free version before deciding to pay to unlock it’s promised features. For 5 or 6 hours I gave it light testing and I was very impressed. I downloaded an SQLite db to it, entered data, and shared/exported the .db from it to another app which uploaded it to my mac and I edited it there no problem. It seemed to work mostly well but had issues with Apple Pencil ✏️ not always working, and tapping out of a cell didn’t commit the change, you must click Done. And other minor issues. But unfortunately after I added some triggers to my db and reimported the db, the app crashed at startup. I don’t know what it’s due to. Rebooting the iPad, trashing & reinstalling the app hasn’t helped so far. All I get is a crashing app. It crashes so quickly there’s no intro screen. This app has a lot of potential but in less than 12 hours use it won’t even open. And that’s after reinstalling the app and rebooting the iPad, both multiple times.

I’d appreciate it if App Store banned fake free apps where the only thing that a user can do is upgrade to the pro version.

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!