On Mon, Jul 25, 2011 at 7:49 PM, Bob Sneidar <b...@twft.com> wrote: > 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ยข >
what he said! > > 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 > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ 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
