If you are thinking web and growing for the future, then it's hard to beat PostgreSQL, which also comes with some nice web-admin tools for viewing the database, etc. MySQL - I hear - is equally nice, but I haven't used it.
You may just want to quickly test your work with SQLite3, which is near-identical to MySQL as far as query syntax goes, and if you think you like it, then migrate to using MySQL. I also recommend downloading Navcat Lite as a tool for viewing whatever database you decide to use. It's very handy. Jeff M. On Mon, Jul 25, 2011 at 4:07 PM, Keith (Gulf Breeze Ortho Lab) < ke...@gulfbreezeortholab.com> wrote: > Hi Jeff, > > The thing is is that the database will grow significantly over time. Also, > I might want to eventually move it online. Therefore, I need the best > solution to cover all bases for the present and the future... > > Thanks, > > - Boo > > ----- Original Message ----- From: "Jeff Massung" <mass...@gmail.com> > To: "How to use LiveCode" <use-livecode@lists.runrev.com**> > Sent: Monday, July 25, 2011 5:00 PM > Subject: Re: What is the fastest database? > > > That amount of data is ridiculously small. If you don't care about many >> thousands of concurrent connections and having to transform the data set >> periodically over time, then SQLite3 is probably the easiest to use, but >> really, for that tiny amount of data, *any* database application will >> work. >> I've used Access (from 10+ years ago) with > 1 GB data sets and never had >> a >> performance problem. You just to to make sure you setup the right indexes, >> foreign keys, and turn off uniqueness where they really don't matter. >> >> Jeff M. >> ______________________________**_________________ >> 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://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://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
