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

Re: Use SQLite with SpiderBasic

by IdeasVacuum Wed Sep 20, 2017 6:15 pm

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: 215
Joined: Fri Sep 22, 2017 7:02 am

Re: Use SQLite with SpiderBasic

by Dirk Geppert Fri Feb 19, 2021 8:38 am

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: 193
Joined: Sat Mar 01, 2014 3:02 pm

Re: Use SQLite with SpiderBasic

by the.weavster Mon Feb 22, 2021 10:31 am

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: 141
Joined: Tue Feb 25, 2014 1:27 pm

Re: Use SQLite with SpiderBasic

by IdeasVacuum Mon Feb 22, 2021 9:34 pm

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: 105
Joined: Wed Feb 26, 2014 6:46 pm
Location: Canada

Re: Use SQLite with SpiderBasic

by Paul Mon Feb 22, 2021 10:24 pm

IdeasVacuum wrote:The manual?


The "Help File"... under "Database"
IdeasVacuum
 
Posts: 141
Joined: Tue Feb 25, 2014 1:27 pm

Re: Use SQLite with SpiderBasic

by IdeasVacuum Tue Feb 23, 2021 1:32 am

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: 215
Joined: Fri Sep 22, 2017 7:02 am

Re: Use SQLite with SpiderBasic

by Dirk Geppert Tue Feb 23, 2021 7:41 am

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: 867
Joined: Mon Feb 24, 2014 10:17 pm
Location: 127.0.0.1:9080

Re: Use SQLite with SpiderBasic

by Peter Tue Feb 23, 2021 7:51 am

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. ;)
Return to Showcase

Who is online

Users browsing this forum: No registered users and 1 guest