SQLite is a very good database library, you can find it here: http://www.sqlite.org/.
A few developers implement SQLite to JavaScript, you can find the project here: https://github.com/kripken/sql.js/.
I implement a part of an example in SpiderBasic:
Code: Select all
; Begin-----------------------------------------------------------------
; Directives----------------------------------------------------------
EnableExplicit
; Sub LoadScript------------------------------------------------------
Procedure LoadScript(script.s, *func)
!$.getScript(v_script, p_func);
EndProcedure
; Function UseSQLiteDatabase------------------------------------------
Procedure.i UseSQLiteDatabase()
Protected sql.i
!var v_sql = window.SQL;
ProcedureReturn sql
EndProcedure
; Function OpenDatabase-----------------------------------------------
Procedure.i OpenDatabase(sqlite.i)
Protected database.i
!var v_database = new v_sqlite.Database();
ProcedureReturn database
EndProcedure
; Sub Main------------------------------------------------------------
Procedure Main()
Protected SQLite.i, database.i, strsql.s, res.i, value.s
SQLite = UseSQLiteDatabase()
If Not SQLite
ProcedureReturn
EndIf
database = OpenDatabase(SQLite)
If Not database
ProcedureReturn
EndIf
strsql = "CREATE TABLE hello (a int, b char);"
strsql = strsql + "INSERT INTO hello VALUES (0, 'hello');"
strsql = strsql + "INSERT INTO hello VALUES (1, 'world');"
!v_database.run(v_strsql);
!v_res = v_database.exec('SELECT * FROM hello');
!v_value = v_res[0].values[0]
Debug value
!v_value = v_res[0].values[1]
Debug value
EndProcedure
; Main----------------------------------------------------------------
LoadScript("sql.js", @Main())
; End-------------------------------------------------------------------
Enjoy it.
Cheers
Stefan