You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cordova.apache.org by GitBox <gi...@apache.org> on 2020/12/15 09:04:59 UTC
[GitHub] [cordova-ios] Magu0013 opened a new issue #1043: Opening Websql Database on IOS
Magu0013 opened a new issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043
I took over an Cordova cross platform app that still uses websql and need it to switch to the sqllite plugin. I had no problem doing this with android, but im stuck with the IOS version.
My main problem is, that I need to acces the Websql database one last time to copy the data to the new sqllite DB. On Android everything works, but no matter what I do on IOS, it says that websql ist deprecated. I know its deprecated but the customers still have data on the old Database, and the App in the store still uses websql. To move to a new standard I need to acces the Websql DB one last time to transfer the data.
Also the app thats aleready published in the store works without any problems, so websql still works ther.
What can I do to save the Data inside the old websql DB?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] Magu0013 commented on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
Magu0013 commented on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-745981003
Yeah the problem is I already tried this. I asked on Stackoverflow and only found someone with same problem but no solution. I also asked directly in the apple developer forums and also got no response. It seems like no one has a clue about this.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek edited a comment on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek edited a comment on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
If WebSQL no longer works in the webview then migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible to migrate WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] NiklasMerz closed issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
NiklasMerz closed issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] NiklasMerz commented on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
NiklasMerz commented on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-745301527
As far as I understand this is not a Cordova issue in particular. WebSQL is part of the webviews API (UIWebView or WKWebView). I suggest you to search stackoverflow etc. for WebSQL in WKWebView or UIWebView on iOS. You may be lucky there.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek edited a comment on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek edited a comment on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
If WebSQL no longer works in the webview then migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible migrating WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek edited a comment on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek edited a comment on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
If WebSQL no longer works in the webview then migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible to migrate WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
Even if the WebSQL physical files are there you may not be able to read it. I don't know what the format is. Local storage files are just simply an sqlite database.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
If happen to find the websql file and you hexdump it. Look at the first address line. If you see something like:
`5153 694c 6574 6620 726f 616d 2074 0033` then you're working with a SQLite 3 database.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek edited a comment on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek edited a comment on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
If WebSQL no longer works in the browser then migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible migrating WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek commented on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek commented on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
Migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible migrating WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org
[GitHub] [cordova-ios] breautek edited a comment on issue #1043: Opening Websql Database on IOS
Posted by GitBox <gi...@apache.org>.
breautek edited a comment on issue #1043:
URL: https://github.com/apache/cordova-ios/issues/1043#issuecomment-746270479
If WebView no longer works in the browser then migrating data is going to be impossible without some plugin with some native code. Even then I'm not sure if is possible migrating WebSQL.
There is a plugin that we used to migrate WKWebView local storage (with file:// based origin) to WKWebView using schemes (in this case... ionic:// scheme). I would _expect_ the WebSQL physical files to be located along side of the `LocalStorage` directory or something, so that's where I'll be prodding around. I think you can use xcode to browse through the app's private data.
https://github.com/totalpave/cordova-plugin-migrate-localstorage/blob/master/src/ios/MigrateLocalStorage.m
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@cordova.apache.org
For additional commands, e-mail: issues-help@cordova.apache.org