Access Standard SQL Databases

LiveCode includes full support for working with standard SQL databases. LiveCode supports MySQL, SQLite, PostgreSQL, Valentina and Oracle. We also include an ODBC connect to connect to other types of SQL databases such as Microsoft SQL Server. You can also access databases using web services.

Commands for working with databases include a command to directly execute SQL statements, work with binary data, count the number of columns, commit data, work with cursors, roll back the database, connect and disconnect and more.

datascreen

LiveCode’s Data Grid object has a number of features that make it easy to connect it to a database and use it as a window to access large data sets.

If you are working with databases in LiveCode you may also want to consider the SQLYoga Marketplace product, which allows you to manipulate data as LiveCode objects.

To get started with databases in LiveCode, take a look at the Connecting to a MySQL database lesson or search our Lesson’s portal for “database”. If you’re interested in working with SQLite, there is a sample project in the Resource Center.

See also the page on Text and Data Processing and Text and Data Display.

Next Multimedia Features