Databases
The Databases tab allows you to enable actions to interact with one or more database technologies. Enabling a checkbox will add the corresponding action categories to the Action Wizard, automatically add any necessary DLL files to your project when you build it, and include the (hidden) Lua script required to make those database actions available at run time.
See Database Actions for more information on how to use these databases in AutoPlay.
Enable support for MySQL databases. Selecting this option will automatically add the LuaSQL-MySQL module functionality to your project and make it available at run time. It will also add the MySQL, MySQLConnection, and MySQLCursor action categories to the Action Wizard.
Note that selecting this will cause 2 .dll files to be added to your Scripts folder at build time: libmysql.dll, and luasql\mysql.dll.
Enable support for SQLite3 databases. Selecting this option will automatically add the LuaSQL-SQLite3 module functionality to your project and make it available at run time. It will also add the SQLite3, SQLite3Connection, and SQLite3Cursor action categories to the Action Wizard.
Note that selecting this will cause 1 .dll file to be added to your Scripts folder at build time: luasql\sqlite3.dll.
Enable support for Oracle databases. Selecting this option will automatically add the LuaSQL-OCI8 module functionality to your project and make it available at run time. It will also add the Oracle, OracleConnection, and OracleCursor action categories to the Action Wizard.
Note that selecting this will cause 2 .dll files to be added to your Scripts folder at build time: oci.dll and luasql\oci8.dll.
Enable support for ODBC databases. Selecting this option will automatically add the LuaSQL-ODBC module functionality to your project and make it available at run time. It will also add the ODBC, ODBCConnection, and ODBCCursor action categories to the Action Wizard.
Note that selecting this will cause 1 .dll file to be added to your Scripts folder at build time: luasql\odbc.dll.
Enable support for PostgreSQL databases. Selecting this option will automatically add the LuaSQL-PostgreSQL module functionality to your project and make it available at run time. It will also add the PostgreSQL, PostgreSQLConnection, and PostgreSQLCursor action categories to the Action Wizard.
Note that selecting this will cause the following 10 .dll files to be added to your Scripts folder at build time:
luasql\postgre.dll
comerr32.dll
gssapi32.dll
k5sprt32.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-8.dll
libpq.dll
ssleay32.dll
The database functionality makes use of the LuaSQL library designed and implemented by the Kepler Project team.
Copyright © 2003-2007 The Kepler Project.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
PostgreSQL Data Base Management System
Portions Copyright (c) 1996-2009, PostgreSQL Global
Development Group
Portions Copyright (c) 1994-1996 Regents of the University of California
Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.