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 which 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, Shaolan intends on optimizing the code being used and increasing the functions available throughout the SQL query.

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 ()