DB Lib is a minimalistic database library for LiveCode that works on Desktop and Mobile and allows you to build database-savvy apps without writing SQL directly. For example consider the following code:
dbWhere "country", "Brazil"
put dbGet("contacts") into tDataA
set the dgdata of control "contacts" to tDataA
It picks all records from the contacts table that have the country field equals to Brazil and set a datagrid to it. It’s very easy to use. A more involved example:
on mouseUp
-- assemble array
put dbCardToArray("contacts") into tDataA
-- check if we're adding a new record
-- or updating an existing one.
--
-- this check depends on the record id being present.
if field "id" is empty then
get dbInsert("contacts", tDataA)
if it is not a number then
answer error it
else
answer "New Record Saved"
end if
go card "contact list"
else
dbWhere "id", field "id"
get dbUpdate("contacts", tDataA)
if it is not a number then
answer error it
else
answer "Record Updated"
end if
go card "contact list"
end if
end mouseUp
In this code first we pick the data from a card using dbCardToArray(), a function that magically picks data from fields, buttons and other controls, and assemble an array that is used to insert or update a given record depending on the presence of an id field.
This is just a quick glimpse of what you can do with DB Lib. It is basically a ORM for LiveCode.