All good stuff. SQLite is great for prototyping applications and in production use for single user applications, but it will have problems dealing with networked file access and/or a high volume of multi-user updating activity (due to locking issues).
Pete On Mon, Jul 25, 2011 at 3:13 PM, Jeff Massung <mass...@gmail.com> wrote: > 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 > _______________________________________________ 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
