SQLite

[David REMD]

What Versions of SQLite does AMS 8 support?

[kingzooly]

SQLite is an action plugin that makes use of the SQLite Embeddable SQL Database Engine to add high-performance database functionality to your application.

Note: The SQLite database engine is not a client used to connect to a big database server. It is the server. The SQLite database engine reads and writes directly to and from database files on disk.

Highlights of the SQLite Database Engine:

Implements most of SQL92. (Features not supported)
Each complete database (with multiple tables and indices) is stored in a single disk file.
Atomic commit and rollback protect data integrity.
Database files can be freely shared between machines with different byte orders.
Supports databases up to 2 terabytes (2^41 bytes) in size.
Two times faster than PostgreSQL and MySQL for many common operations.
Self-contained: no external dependencies!
For more information on the SQLite database engine, see the SQLite website at www.sqlite.org.


So I guess SQL92

Fucntions not userd here

http://www.sqlite.org/omitted.html

[David REMD]

Thank you, Kingzooly. Here is my problem. I exported a database I created in AMS to a .sql file. I imported the .sql file into the most current SQLite browser (http://sqlitebrowser.org/). I wrote and executed a query within the latest browser and it executed perfectly. I saved the database to my project and placed a SQLite.QueryToTable query on a button. No records were returned. Why is this?

[Ulrich]

You need to check which format this tool generates. The official plugin supports SQLite 2.x databases, but third party plugins exist for SQLite 3.x files. You can also use SQLite 3 databases with the LuaSQL module.

Ulrich

[kingzooly]

Very sorry I forgot the 2.x and 3.x problem, Ulrichs plugin would me a nice option, Ulrich does yours have the same omitted functions ?

[David REMD]

If I am reading the website correctly, Version 3.8.0

[kingzooly]

If I am reading the website correctly, Version 3.8.0

Ya I think you will need the plugin that supports the 3.x format.

[David REMD]

Where can I find the Plugin?

[kingzooly]

Where can I find the Plugin?

In Ulrich's post or HERE

[David REMD]

What is the LuaSQL module, and where do I get it?

[Ulrich]

Please see main menu: Project > Databases.

Ulrich

[kingzooly]

There is also a version 3 of the SQLite by another user on here, he's a good programmer, HERE

SQLite3 Action Plugin for AutoPlay Media Studio 8
This is A Lua module that Orginally written for Lua
This module is ported to an AMS Action plugin by www.amsplugins.com
plugin uses a statically linked SQLite 3.7.2 library