SQLite Mobile Client

Best SQLite 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!

I like it so far but would like to request the ability to move table columns around in a db edit feature (using ui)

I tried importing and Django SQL Lite table using the direct import for SQL Lite, and once I selected the tables to import, I received an error message saying general error, with no description as to why it continually fails.

Gains a star for UI and usability, but there are a bunch of bugs that pop up error messages when trying to edit tables, making the app unusable, which is a shame, because I like the app, and because I payed for a buggy unlocked version

Created a table , and fields , can’t add any data to it , so no use .