DB Lib Goes Open Source with GPL

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.

RunRevLive.11

During RunRevLive.11 I gave a talk about web stuff with LiveCode (then called Runtime Revolution, aka RunRev). I spoke about Social Network integration.

Memories from the event

For many years I’ve operated my own URL shortening website called fon.nu. I’ve stopped using it many years ago but for many many years it was alive and used by thousands of people. I’ve found a mail message from the day before the conference detailing the creation of the service. The service was originally created to add short urls to my slides. I’ve used it all the way into the Firefox OS and Mozilla era of my life and the original URLs for my books footnotes all used it. The service was even used as an example of good feature set to be implemented in other competing services. Proud of my little tool. Its source is available from sourcehut.

RunRevLive.08

During RunRevLive.08 I gave four talks about all sorts of Web stuff:

Brace Yourself for the 7 Super Secrets of Rev CGI

Put a star right now next to this one!

We guarantee this session will change the way you think of Rev from now on. Once you see how great Rev GGI’s work on web servers, and how simple they are to create, you’ll want to start using them on all sorts of websites. And with the included world premiere latest versions of RevOnRockets and Rockets Editor, we expect you’ll begin writing your own CGI’s the very same day!

Why bother with MySQL, when all you need is a store locator database, or a website catalog? In fact, there are numerous easy to setup, high performance Rev CGI’s which enable you to quickly and easily add dynamic website capabilities without having to learn SQL or php, or configure database server technologies. While a small portion of this talk will focus on setting up Rev CGI’s on servers, most of the session focuses on how to create Rev CGI’s and will go over workflow and architecture techniques. Plenty of examples will be given out, along with the latest free release of RevOnRockets and the first-time free release of the new “Rev CGI Missing Link” workflow enhancement tool, Rockets Editor.

This was co-hosted by Chipp Walters.

Other sessions

Unfortunately the wayback machine didn’t cache the data from the other sessions but I believe the last one, Internet Kitchen, was a kind of workshop/unconference.

  • Internet Applications II: XML, SOAP, RPC
  • Exchanging Data Over the Internet
  • Internet Kitchen

RevCon West 2006

Gave a talk to present to users a set of libraries and tools to aid Revolution Developers building Web Applications. The objective is to empower the developer to create web applications from inside the comfort of Revolution IDE and using stacks. Participants will learn CGI basics, FastCGI basics and how to benefit from Model-view-controller approach. Each participant will receive a powerful suite of tools including all libraries, docs and new plugins and palettes for RunRev.

Mentions