If you plan on moving this to an external server, then you should not allow direct access to your SQL server (although I do so myself in development using On-Rev). You will probably want to access it through a web based script of some sort to firewall your SQL data. This will prevent things like SQL injection attacks and such.
If this is your eventual goal, I would advise developing your application using this methodology right from the start. my 2ยข Bob On Jul 25, 2011, at 2:51 PM, Keith (Gulf Breeze Ortho Lab) wrote: > Hello, > > I have approximately 25 MB of data (plain text) that consists of > approximately 140,000 different entries (one per line--pipe delimited). I am > working on an application to quickly search through the data not unlike the > LiveCode Dictionary application. However, it will be necessary for my users > to be able to edit any entry at will. > > For a desktop application, what database would you recommend for the job? I > can use a flat file database, but the problem is that all 25 MB of data must > be loaded into memory... What about SQLite? Valencia? Speed is of the essence. > > FYI: In the past I used an Access database, but it was too sluggish for my > purposes. > > Any recommendations/feedback is most welcome. Thanks. > > LiveCode is awesome! > > Sincerely, > > - Boo > _______________________________________________ > 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 _______________________________________________ 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
