On 12/1/05, Robert Hicks <[EMAIL PROTECTED]> wrote: > "... if i only needed MySQL, i'd use SQL Lite." > > Really? I think that would be a poor choice and I like SQLite. ; ) > > Robert
I'll elaborate. PostgreSQL is already installed. It's what I "grew up with" I've very comfortable with it and I find it easy to use. So if I'm starting an application of any reasonable size I grab Pgsql cause it's "right there". Alot of our customers are very small mom and pop shops, selling crafts, advertising their business mostly read only. As well these users can only be really expected to see a few hundred vists a month, and probably less than 100 unique visitors. We deal with the truly "small guys" quite often. For those folks SQL lite is more then enough. An example is we have one guy that takes bookings for Opening/Closing swimming pools when the seasons change. So for a year the most bookings he'd have is 365 x 2, 2 appointments per day. SQL lite is perfect for this stuff. Myself and a few of the guys were going into this topic in more depth in the IRC channel [irc.perl.org #cgiapp]. We we talking more about the "right answer" to the original posting, not so much which is best RDBMS. IMHO, the right answer is none of them are best. Choose one. Start using it. See if it does what you want, and in a timly fashion. Use it for a year then evaluate if you need more of if it works. By then you'll have had more experience to develop your own opinions. If you are just starting in this type of application etc, chances are that most of your choices or at least the 2 big free ones will be adequate. You can haggle over details later. Why did I start with PostgreSQL ? I was good friends with Marc Fournier at the time, and he pushed it on me :) Had I have been in another part of the country, maybe I might have chosen MySQL. I'm comfortable with it, it suits my needs and puts food on the table. Jeff.
