Use SQLite with SpiderBasic

Created a nice software using SpiderBasic ? Post you link here !
IdeasVacuum
Posts: 143
Joined: Tue Feb 25, 2014 1:27 pm

Re: Use SQLite with SpiderBasic

Post by IdeasVacuum »

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.
Dirk Geppert
Posts: 282
Joined: Fri Sep 22, 2017 7:02 am

Re: Use SQLite with SpiderBasic

Post by Dirk Geppert »

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..
the.weavster
Posts: 220
Joined: Sat Mar 01, 2014 3:02 pm

Re: Use SQLite with SpiderBasic

Post by the.weavster »

Dirk Geppert wrote:But UseSQLiteDatabase() failed..
The UseSQLiteDatabase() command doesn't exist in SpiderBasic but SQLite does work. Look at the example in the manual.
IdeasVacuum
Posts: 143
Joined: Tue Feb 25, 2014 1:27 pm

Re: Use SQLite with SpiderBasic

Post by IdeasVacuum »

the.weavster wrote:
Dirk Geppert wrote:But UseSQLiteDatabase() failed..
The UseSQLiteDatabase() command doesn't exist in SpiderBasic but SQLite does work. Look at the example in the manual.
The manual?
User avatar
Paul
Posts: 195
Joined: Wed Feb 26, 2014 6:46 pm
Location: Canada
Contact:

Re: Use SQLite with SpiderBasic

Post by Paul »

IdeasVacuum wrote: The manual?
The "Help File"... under "Database"
IdeasVacuum
Posts: 143
Joined: Tue Feb 25, 2014 1:27 pm

Re: Use SQLite with SpiderBasic

Post by IdeasVacuum »

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.
Dirk Geppert
Posts: 282
Joined: Fri Sep 22, 2017 7:02 am

Re: Use SQLite with SpiderBasic

Post by Dirk Geppert »

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..
User avatar
Peter
Posts: 1086
Joined: Mon Feb 24, 2014 10:17 pm
Location: 127.0.0.1:9080
Contact:

Re: Use SQLite with SpiderBasic

Post by Peter »

Dirk Geppert wrote:There is only one array to see..
... which however can be converted relatively easily.

So I would not store state secrets in it. ;)
Post Reply