Support for SQLite: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
Starting with Chrome 119, Google has deprecated SQlite. They have been warning of this for a while. (If you're interested in why they are doing this, [[check out this posthttps://groups.google.com/a/chromium.org/g/blink-dev/c/fWYb6evVA-w/m/pziWcvboAgAJ?pli=1|check out this post]]).
Starting with Chrome 119, Google has deprecated SQlite, also referred to as WebSQL. They have been warning of this for a while. (If you're interested in why they are doing this, [[check out this posthttps://groups.google.com/a/chromium.org/g/blink-dev/c/fWYb6evVA-w/m/pziWcvboAgAJ?pli=1|check out this post]]).


There are a couple of workarounds. In the short run, you can register your site for an [[Origin Trialhttps://googlechrome.github.io/OriginTrials/developer-guide.html|Origin Trial]], which restore the functionality until May 28, 2024 when Chrome 124 is scheduled to appear. Directions how to do this follow.
There are a couple of workarounds. In the short run, you can register your site for an [[https://googlechrome.github.io/OriginTrials/developer-guide.html|Origin Trial]], which restore the functionality until May 28, 2024 when Chrome 124 is scheduled to appear. Directions how to do this follow.


For a permanent solution, you will need to include the SQLite code as a library in your project, since it will no longer be built into the browser. This solution is referred to as SQLite WASM: we will be providing instructions how to use it in the near future.
For a permanent solution, you will need to include the SQLite code as a library in your project, since it will no longer be built into the browser. This solution is referred to as SQLite WASM: we will be providing instructions how to use it in the near future.
Line 7: Line 7:
'''How to Register Your App to Continue to Use SQLite'''
'''How to Register Your App to Continue to Use SQLite'''


1. Go to this page: [[Register to WebSQL Trialhttps://developer.chrome.com/origintrials/#/register_trial/|Register to WebSQL Trial]]
1. Go to this page: [[https://developer.chrome.com/origintrials/#/register_trial/|Register to WebSQL Trial]]


2. Fill in the URL for your site in the Web Origin. For example. https://www.nsbasic.com
2. Fill in the URL for your site in the Web Origin. For example. https://www.nsbasic.com
Line 16: Line 16:


5. You will then see a screen like this:
5. You will then see a screen like this:
[[File:WebSQL Registration.png|thumb]]
[[File:WebSQL Registration.png]





Revision as of 18:21, 2 November 2023

Starting with Chrome 119, Google has deprecated SQlite, also referred to as WebSQL. They have been warning of this for a while. (If you're interested in why they are doing this, check out this post).

There are a couple of workarounds. In the short run, you can register your site for an [Trial], which restore the functionality until May 28, 2024 when Chrome 124 is scheduled to appear. Directions how to do this follow.

For a permanent solution, you will need to include the SQLite code as a library in your project, since it will no longer be built into the browser. This solution is referred to as SQLite WASM: we will be providing instructions how to use it in the near future.

How to Register Your App to Continue to Use SQLite

1. Go to this page: [to WebSQL Trial]

2. Fill in the URL for your site in the Web Origin. For example. https://www.nsbasic.com

3. Check the 4 square disclosure boxes.

4. You may also need to Sign In into Google.

5. You will then see a screen like this: [[File:WebSQL Registration.png]



6. Copy the Token from that screen.

7. In AppStudio Project Properties, go to ExtraHeaders and add this line:

<meta http-equiv="origin-trial" content="Avihurku4HHj...">

8. Your app should now work properly.