LuaSQL v0.1 – Lua database for the PSP

Need to access a database with your PSP? Why not try shaolan‘s LuaSQL v0.1? This library allows homebrew developers to access SQL through PHP. Users can now create web-based applications with lots of data entries as well as access various security features that are inherent with SQL.

More information about LuaSQL v0.1 can be found in the full article.

Download: LuaSQL v0.1

Need to access a database with your PSP? Why not try shaolan‘s LuaSQL v0.1? This library allows homebrew developers to access SQL through PHP. Users can now create web-based applications with lots of data entries as well as access various security features that are inherent with SQL.

To use this program, you will need a server that supports PHP and has an SQL Database. The library uses the first WiFi connection by default and works on Lua Player v0.16. Since this is the first release of the program, the developer intends on optimizing the code of the homebrew and increasing the functions available via SQL queries.

If you plan on using the program, shaolan included some basic code blocks that you will need to access the database.

Starting a session:
French:

–// appelle de la librairie
dofile(“SQLRequest.lua“)
–// Initialisation de la connexion
SQL.init(serveur,database,login,password)
–// Connexion à la base de données
SQL.connect()

English:

Calls to the bookstore
Dofile ( “SQLRequest.lua”)
Initializing connection
SQL.init (server, database, login, password)
Connect to the database
SQL.connect ()

Queries:
French:

–// Requete SELECT
variable = SQL.select(table,champ,parametre)
–// Requete UPDATE
SQL.update(table,champ,valeur,parametre)

English:

–//SELECT Request
Variable = SQL.select (table, field, parameter)
–//UPDATE Request
SQL.update (table, field value parameter)

Ending a session:
French:

–// Ferme la connexion SQL
SQL.close()

English:

–//Closing connection SQL
SQL.close ()

Download: LuaSQL v0.1

Via XtremeLUA