LibSQL-1.0

  • 3 pages found
NameAuthorLast updated byUpdated on
NameAuthorLast updated byUpdated on
API / Nov 28, 2010
Field Types and Flags Humbedooh Humbedooh Nov 27, 2010
LibSQL-1.0 Humbedooh Humbedooh Nov 28, 2010
Primer Humbedooh Humbedooh Nov 24, 2010
Main Humbedooh Humbedooh Nov 26, 2010
LibSQL is a library that incorporates a simple relational database (rdbms) into whatever awesome addon you're working on. For a quick guide, see the LibSQL Primer. For in-depth documenation, see Api/LibSQL-1.0 The SQL object is available in three variants: Conventional SQL access The standard way to communicate with an SQL server local db = LibSQL:New() -- make a table db:Execute("CREATE myTable (name STRING UNIQUE, level INTEGER, id INTEGER AUTO_INCREMENT)") -- insert some stuff...
What works and what doesn't Humbedooh Humbedooh Nov 22, 2010
Latest revision checked: r16. CREATE Works: Creating tables using either db:Create(tablename) or db:Execute("CREATE tablename (fields)") Doesn't work: Multiple field flags DROP Works: DROP tablename TRUNCATE Works: TRUNCATE tablename UPDATE Works: UPDATE tablename SET fielda = "data", fieldb = 123, fieldc = function(moo) WHERE clause SORT BY stuff LIMIT a,b tbl:Find("clause"):Update({ fielda = "data", fieldb = 123, fieldc = function(moo)}) Doesn't work: REMOVE Works: REMOVE FROM tablename...
  • 3 pages found