The Future of SQLite

No. I tried both Safari and Chrome. Same result.

There must really be some politics regarding this one … as a developer I can’t even imagine why you would want to remove support for something as ubiquitous as SQLLite from the platform!

The politics are discussed in this blog post:
https://blog.appstudio.dev/2019/09/the-future-of-sqlite/

I just tried running SQLSample1 on an iOS 13.1 iPhone 8 and on the Mac Desktop, with the changes to the settings. It worked on both platforms.

Give my sample a try:
https://www.appstudio.dev/i/SQLSample1/

Hi,

I have an update. What it appears to be is that SQL Lite does run in the Safari browser window. I was trying to run it from the shortcut that I sent to the “home” screen of iOS which runs the apps without the web browser’s window elements. I can, at least, run it now. Thanks.

Sure would be nice if Apple would put SQLite back on iOS so it can run locally like it seems to from the “home screen” icon. Is NSBasic actually running in native mode on iOS (as opposed to a web app) when accessed through that home screen icon?

Thanks,

-bwr-

I just tried it - you’re right. This can only be seen as a bug on Apple’s part.

We have filed a bug report with Apple. Hopefully, they fix this!

If you’d like to file your own bug report on this problem, you can do so here:

https://feedbackassistant.apple.com/

Hey … I just filed a bug report as well. Here’s hoping that they fix it. SQLite has been a pretty important part of iOS, very odd that they just removed it. NSBasic can’t be the only developer implementing solutions with it!

Is it a bug or does it run with the settings that were set at the time your app was ‘Saved to desktop’? I’m having trouble with a few Apple users, well most of my Apple users really ;{, and seems if they reinstall when the Websql is enabled it runs ok. If I disable Websql in Safari, my apps that were installed when websql was enabled, still operate.

So far that’s what I can do on my daughter’s ipad and users aren’t getting back to me…fingers crossed.

I’ve tried every way I can imagine, no go. The app simply will no longer use SQLLite on the local device, at all. No longer present in iOS. Get a dialog stating that “SQLite is not supported”. NSBasic still runs on the device, just no database support there any more. Shame. I can think of NO reason why the support would have been removed other than for some kind of “political” reason.

Does SQLite work as a web app on your device? There should only be a problem when saving to the home screen, if your Safari settings are correct.