Hi, I want to add a content library module to a LiveCode-built project. It will enable users to store, tag, sort and retrieve their content. I've read various threads and articles about databases, but I have minimal database experience and I want to get it right the first time. So I'd appreciate answers to these questions and any other insights:
1) Is SQLite the best choice for local database file with a Livecode interface? (Each database record will need to hold a few sentences of Unicode text, 1 or 2 small arrays, the text contents of a few cprops, and a field for tags the user can apply to categorize the various records.) I doubt the number of records would ever exceed 10,000 with an average more like 2,000. 2) The content of some records may have associated images or audio files. I can store the paths to those, but paths break easily. How much does it bloat or burden a database to store jpgs, pngs, wavs or aifs files in records? 3) I see there are a few 3rd-party tools for database work with Livecode. (SQLyoga, SQLiteAdmin and SQLMagic). Are there others? Are these current with LC7? 4) Are there contract developers in the LC community that specialize in setting up databases with LC interfaces? Thanks! Tom B. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Choosing-a-database-and-LC-tools-tp4694777.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
