O'Reilly logo

LiveCode Mobile Development Cookbook by Dr. Edward Lavieri

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQLite

Databases are advanced data repositories known as relational database management systems. SQLite is an embedded database that can be used in your LiveCode mobile apps, giving you tremendous capability to store, retrieve, and manipulate data. Unlike MySQL databases, SQLite databases do not require a server. In this recipe, we will create a mobile app that uses five SQLite functions:

  1. Connect to a database.
  2. Add a table to the database.
  3. Add data to the database table.
  4. Retrieve data from the database.
  5. Close the database.

How to do it...

Use the following steps to create a mobile app that instantiates a SQLite database and add and retrieve information from it:

  1. Create a new main stack in LiveCode.
  2. Set the background color of the main card to black. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required