Announcement

Collapse
No announcement yet.

SQLite

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite

    What Versions of SQLite does AMS 8 support?

  • #2
    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
    Plugins or Sources MokoX
    BunnyHop 2021 Here

    Comment


    • #3
      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?

      Comment


      • #4
        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

        Comment


        • #5
          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 ?
          Plugins or Sources MokoX
          BunnyHop 2021 Here

          Comment


          • #6
            If I am reading the website correctly, Version 3.8.0

            Comment


            • #7
              Originally posted by David REMD View Post
              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.
              Plugins or Sources MokoX
              BunnyHop 2021 Here

              Comment


              • #8
                Where can I find the Plugin?

                Comment


                • #9
                  Originally posted by David REMD View Post
                  Where can I find the Plugin?
                  In Ulrich's post or HERE
                  Last edited by kingzooly; 02-09-2016, 11:58 AM. Reason: Boobed on a name
                  Plugins or Sources MokoX
                  BunnyHop 2021 Here

                  Comment


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

                    Comment


                    • #11
                      Please see main menu: Project > Databases.

                      Ulrich

                      Comment


                      • #12
                        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
                        Plugins or Sources MokoX
                        BunnyHop 2021 Here

                        Comment

                        Working...
                        X