8 Replies Latest reply on Aug 31, 2006 12:08 AM by AntiTRUST�

    Best Xtra for MSAccess Databases

    AntiTRUST� Level 1
      Hi,
      I am just going to use database in my project, but before starting i would like to know what this community says about the best Xtra for Database usage in Director.

      I will be using MS Access as my database.
      Any suggestions will be highly appreciated.

      Regards,
      Amir
        • 1. Re: Best Xtra for MSAccess Databases
          Lukewig Level 1
          Hi,

          The answer depends on three things (1) does it really need to be a database, or is a director list or perhaps XML better suited? (2) do you need direct access to a local database; or (3) do you want to access a database server?

          The answer to question 1 will depend on how many records and what kind of searching and filtering you want. If you have less than, say, 1000 records, and only need to execute fairly simple searches, then you can use Director's native list format (saving you data to external files such as using an Xtra like PropSave (free) / BuddyFile / vList

          If you do really need a database, then your options (for local databases) include V12 and VizionDB from http://www.inm.com/ (I have used V12 a fair bit - its very easy to use but is a proprietary format and perhaps slower than other options), Arca from http://xtras.tabuleiro.com which is based on SQLite 3 (I've not had much experience with it - but tabuleiro.com are great people to deal with), Valentina from http://www.paradigmasoft.com/ I've not had much experience with it - but apparently its very fast) and the free SQLite Xtra from the amazingly prolific Valentin Schmidt ( http://dasdeck.de/staff/valentin/xtras/).

          In all these cases, you'll need to export your data from MS Access and import it into a native format. There are some other Windows-only Xtras that might let you work directly with the MS Access database - check out http://www.updatestage.com/products_table.html#Database

          -- Luke
          • 2. Re: Best Xtra for MSAccess Databases
            AntiTRUST� Level 1
            Hi Lukewig,
            Thanks a lot for such information, basically i have already created by project, and which contains a lot of project files and cast members. And also i have to make updates on to these files frequently, and in order to update i have to go back into the cast and have to reload them again and again.

            To get rid of this, i am planning to switch over database, so i will onyl put paths of my files over database and then get these values through cast, so director will always get the current and upto date contents.

            Also, one more feature for my project which i want to develop that is the UPDATER, which will update my project files from internet, so in database i will add a "version" column which will basically diferentiate between the old and new contents.

            And also, by adding an Administrative console into my application (IN FUTURE), all of the administrators or anybody who has the authority to change contents/update Project's contents can change and update without using Director.


            So, I think i must switch into database.


            Need comments,
            Amir
            • 3. Re: Best Xtra for MSAccess Databases
              Ex Malterra Level 1
              if you are commited to using access, check out the vbscriptxtra from xtramania.com. i've found it to be invaluable, as it provides script access to most of the ms product line. however, access (or any other ms product you are going to access) must be installed on the client machine.
              • 4. Re: Best Xtra for MSAccess Databases
                AntiTRUST� Level 1
                quote:

                access (or any other ms product you are going to access) must be installed on the client machine


                Hi,
                If this is the case then i think using this xtra will not be a good step. There should be no dependency on client's machine.
                Are those other xtras named above also requires the Installation of MsAccess on clients machine ??

                Amir
                • 5. Re: Best Xtra for MSAccess Databases
                  Lukewig Level 1
                  Hi,

                  An alternative to using a database (which doesn't seem like its definitely required) is simply download an xml file of what files are on the server and what version they are, and then download the files. The XML could even be created dynamically by the server. Have a look at http://www.lingoworkshop.com/Articles/downloading_files.php and http://www.lingoworkshop.com/Articles/imageslider/Loading_Remote_Images.php (this second link is an example of getting a dynamically generated list of files from a server, and then downloading and importing them).

                  -- Luke

                  • 6. Re: Best Xtra for MSAccess Databases
                    AntiTRUST� Level 1
                    Hi Luke,
                    What is the difference between MS Access Database and this XML ??
                    I never worked with this XML. But i have heard a lot.

                    Any strong key features between them ??


                    Amir
                    • 7. Re: Best Xtra for MSAccess Databases
                      Lukewig Level 1
                      Hi,

                      MS Access is a database application that stores data in its own special 'file format' in a way that is optimized for sorting and searching (and doing all the things databases are good at)

                      XML is a general-purpose markup language used for describing data. Typically, and XML files is a simple text file which structures information like this

                      <?xml version="1.0"?>
                      <updatelist>
                      <item>Some content</item>
                      <item>Some content</item>
                      </updatelist>

                      XML seems to be a popular general purpose language for describing data - but it is can lead to overly complex, bloated markup.

                      The reason you might consider using XML is that you need some language the Webserver and Director can both speak.

                      -- Luke
                      • 8. Re: Best Xtra for MSAccess Databases
                        AntiTRUST� Level 1
                        Hi,
                        Well, any best tutorial guide on building this XML ??


                        Amir