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
