The possibility of SB using SQLite is really good (I think perhaps Fred has pencilled it for the next release?).
What is very important for those of us writing apps for Android/iOS is that the db file can be saved locally and never requires an Internet connection.
Use SQLite with SpiderBasic
-
- Posts: 285
- Joined: Fri Sep 22, 2017 7:02 am
Re: Use SQLite with SpiderBasic
Hi folks,
is there any news on this? Will SQLiIte be implemented directly in SB?
Unfortunately, the example no longer works. Presumably this is the current link to SQL.js:
https://cdnjs.cloudflare.com/ajax/libs/ ... sql.min.js
But UseSQLiteDatabase() failed..
is there any news on this? Will SQLiIte be implemented directly in SB?
Unfortunately, the example no longer works. Presumably this is the current link to SQL.js:
https://cdnjs.cloudflare.com/ajax/libs/ ... sql.min.js
But UseSQLiteDatabase() failed..
-
- Posts: 222
- Joined: Sat Mar 01, 2014 3:02 pm
Re: Use SQLite with SpiderBasic
The UseSQLiteDatabase() command doesn't exist in SpiderBasic but SQLite does work. Look at the example in the manual.Dirk Geppert wrote:But UseSQLiteDatabase() failed..
-
- Posts: 143
- Joined: Tue Feb 25, 2014 1:27 pm
Re: Use SQLite with SpiderBasic
The manual?the.weavster wrote:The UseSQLiteDatabase() command doesn't exist in SpiderBasic but SQLite does work. Look at the example in the manual.Dirk Geppert wrote:But UseSQLiteDatabase() failed..
Re: Use SQLite with SpiderBasic
The "Help File"... under "Database"IdeasVacuum wrote: The manual?
-
- Posts: 143
- Joined: Tue Feb 25, 2014 1:27 pm
Re: Use SQLite with SpiderBasic
Oh right, sorry, my misunderstanding.
Looking at the examples, I'm not sure the saving of the DB file on Android is valid. Google recently added a lot of security measures, Android 10 and up basically sandbox Apps (similar to Apple IOS I think). Now, there are only two directories an App can use. The App directory (App Private Directory) itself which has read-only resources and the App Specific Directory which is read-write and where the DB file should be.
Looking at the examples, I'm not sure the saving of the DB file on Android is valid. Google recently added a lot of security measures, Android 10 and up basically sandbox Apps (similar to Apple IOS I think). Now, there are only two directories an App can use. The App directory (App Private Directory) itself which has read-only resources and the App Specific Directory which is read-write and where the DB file should be.
-
- Posts: 285
- Joined: Fri Sep 22, 2017 7:02 am
Re: Use SQLite with SpiderBasic
Thx IdeasVacuum, for that hint. The Sqlite example from the help works.
It's also interesting that the stored text in the database is not visible in the browser debugger in the web storage.
There is only one array to see..
It's also interesting that the stored text in the database is not visible in the browser debugger in the web storage.
There is only one array to see..
Re: Use SQLite with SpiderBasic
... which however can be converted relatively easily.Dirk Geppert wrote:There is only one array to see..
So I would not store state secrets in it.