dcsimg
A Flash Developer Resource Site

Results 1 to 8 of 8

Thread: flash using a database

  1. #1
    Senior Member
    Join Date
    Jun 2001
    Posts
    343

    flash using a database

    I have a standalone app that is used by sales people to price out construction jobs. The problem is that they can't save the job after pricing it out.

    I need to save this info. I've done some research and it seems like flash studio pro v2 along with MySql is the way to go. I don't know much about databases and I would have to learn how to do it.

    My question: Is this the easiest and most pratical way to accomplish this? Any other suggestions?

    Thanks in advance.

  2. #2
    Tim (Super Moderator) Northcode's Avatar
    Join Date
    Dec 2000
    Location
    Whitehorse YT
    Posts
    3,766
    The easiest way to do this is to use local shared objects. You can save your data to a shared object and when someone comes back in from the field (or when they have access to the internet) they can send their data to a server for permanent storage.

  3. #3
    Senior Member
    Join Date
    Jun 2001
    Posts
    343

    Thanks

    I'll check that out.

    Thanks.

  4. #4
    Senior Member
    Join Date
    Jun 2001
    Posts
    343
    After researching the local shared objects it appears the saving locally is very limited. We want the user to be able to save hundreds of jobs on the laptop. Does flash+flash studio+MySQL seem like the way to go?

    Thanks.

  5. #5
    Tim (Super Moderator) Northcode's Avatar
    Join Date
    Dec 2000
    Location
    Whitehorse YT
    Posts
    3,766
    Yes, Flash Studio or any of the other third party tools will provide a database solution that you can use. Many of the tools listed below support some kinda of database access.

    SWF Studio http://www.northcode.com
    Flash Studio http://www.multidmedia.com
    Jugglor http://www.***********.com
    SWFKit http://www.swfkit.com
    SWiSH Studio http://www.swishzone.com
    FlashAnts http://www.flashants.com
    LPFlashEX http://www.logicplus.com.hk
    Flash 'N Pack http://www.flashnpack.com

    To decide whether a full blown database is overkill or not, you have to look at the amount of data you're collecting, how it will be organized into tables and what your retrieval needs are. Databases are very good when you have thousands of rows of data and where retrieval speed (searching) is important.

    If you are storing pricing info for a single job at a time then a database MAY be overkill for what you can easily store in XML format in Flash. All the benefits of hierarchically organized data without all the hassles of installing and licensing the database software (you need to license MySQL for commercial use) etc.

    So saving locally in SOL files is a bit limited but you can get around the limitations if you store your data in XML internally and then save the entire project as a serialized version of the XML object (using xml.toString). That means you just need one variable for an entire project. Saving and loading becomes very easy because your format on disk is the same as the format you use in memory (XML) and if you decide to move up to a database later, your data is already nicely organized and easy to store.

  6. #6
    Hi, download a free trial version of Flash Studio PRO v2 and you'll see how easily you can connect to an Access or mySQL database. There are also some examples and read-code available at http://www.multidmedia.com/software/...udio/downloads

    I hope this helps.

  7. #7
    Hi, I have been asked by the moderator to post a follow up to my last post which provides further information and help.

    If you are specifically considering Flash Studio PRO for your database connectivity, in addition to the open source examples mentioned above, you can also find Tutorials on Database connectivity at http://www.multidmedia.com/support/l...2/db_intro.htm

    Also, you mentioned that you don't have much experience with databases so if you would like some general help, please feel free to email me and I'll be happy to help.

    I would also recommend re-evaluating how much data you need to save as Northcodes solution to using either shared objects or XML is also viable. I hope this helps

  8. #8
    Senior Member
    Join Date
    Jun 2001
    Posts
    343
    Thanks MDM...I'm going to look into what you have given me. The forum is great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center