The SQLite Connector is 100% embeddable and stand-alone, so there is no need
for a server in the middle. However, my SQLite implentation is compatible with any other SQLite tool, including PHP. You embedd a small (<250kb) C exe inside your Flash exe that does all the DB stuff. You communicate with it via an AS2 Class. However you need a third-party wrapper for your swf. The AS Class that comes with the Connector is ready to go with SWF Studio V3. If you buy SWF Studio via my Page you get 10% off, so the SQLite Conenctor is in-fact "free" ;) You can check out a demo project (compiled exe incl. sources) at www.Software-and-Solutions.de hth, André -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Wade Arnold Gesendet: Samstag, 25. Februar 2006 20:50 An: Flashcoders mailing list <flashcoders@chattyfig.figleaf.com> Betreff: Re: AW: [Flashcoders] Flash connecting to a database - allrunning on aDVD-ROM Would using SQLite or Berkley DB work on the server for development and then just copy the database.db file to your cd? I have not ever connected flash to either of these without php/jsp in the center and I don't know if it is possible. I have thought about this problem for a long time and have resorted to a file structure for "tables" and xml files for instances of components. I am excited to test INM. Wade On 2/25/06 12:42 PM, "André Goliath" <[EMAIL PROTECTED]> wrote: > Hi List, > > XML and CSV is fine for small data, and I would even prefer it about a > Database such as SQLite for rather small data or if you only need to search > for one key/index. > > But if you need to do complex lookups or need to search for different > criteria I would strongly recommend SQlite or comparable,as a DB is hard to > beat if it comes to speed and flexibility. Using my SQlite Connector the > speed you gain is even faster then mySQL, and far better than XML. SQLite > imports/writes CSV files too, btw. > > However, it´s really a design choice and what you're going to do with your > data. > > hth > > André Goliath > > > > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Michael > Bedar > Gesendet: Samstag, 25. Februar 2006 19:31 > An: Flashcoders mailing list > Betreff: Re: [Flashcoders] Flash connecting to a database - all running on > aDVD-ROM > > As long as your dataset is relatively small, XML is fine, but at some > point a real database is going to be needed. I'm not sure how v12 > with flash is going to work, but I have used Valentina with Director, > and when you have 10's of thousands of records, you can't afford the > disk space or speed penalty of xml files on a CD > > > > On Feb 25, 2006, at 12:37 PM, Danny wrote: > >> I've programmed many databases both in Director and Flash, and find >> it much more code it myself than use an xtra like V12. >> For your example, I would assign each module an ID number, then in >> Excel or FileMaker, what ever data base you want to use, match the >> ID number up with the paths to the content and description >> ID, path, description >> 23498, moduleOne\myPDF.pdf, descriptionHere >> 23498, moduleOne\myPres.ppt, descriptionHere >> 99999, moduleTwo\myPDF.pdf, descriptionHere >> 99999, moduleTwo\myDoc.doc, descriptionHere >> >> etc. >> >> Save the data as a CSV file, and use Amber CSV Converter (http:// >> www.processtext.com/abccsv.html) to convert it to XML. This >> creates a very easily readable XML file without a lot of extra crap >> like you get if you convert directly from Filemaker. >> >> There are plenty of examples of how to load the XML into Flash and >> save it in an Array. >> >> Assign the ID numbers to the proper nodes in the tree using the >> data parameter. When a user chooses a node, search your array for >> all the matches to the ID number and display the descriptions. >> _______________________________________________ >> Flashcoders@chattyfig.figleaf.com >> To change your subscription options or search the archive: >> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders >> >> Brought to you by Fig Leaf Software >> Premier Authorized Adobe Consulting and Training >> http://www.figleaf.com >> http://training.figleaf.com > > > > > _______________________________________________ > Flashcoders@chattyfig.figleaf.com > To change your subscription options or search the archive: > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > > Brought to you by Fig Leaf Software > Premier Authorized Adobe Consulting and Training > http://www.figleaf.com > http://training.figleaf.com > > _______________________________________________ > Flashcoders@chattyfig.figleaf.com > To change your subscription options or search the archive: > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > > Brought to you by Fig Leaf Software > Premier Authorized Adobe Consulting and Training > http://www.figleaf.com > http://training.figleaf.com _______________________________________________ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com _______________________________________________ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
