Re: SQL varieties

2009-01-22 Thread Luis
Hiya, I'd opt for PostgreSQL mainly due to the Licence for commercial use (unless that's changed). For OS X PostgreSQL go here: http://www.postgresqlformac.com OpenBase is another option, I believe it's still free for 10 connections (you mentioned no heavy usage, I'm assuming connections

RE: SQL varieties

2009-01-22 Thread Lynn Fredricks
Hi Sara, My system is going to be a relatively small database and not subject to heavy usage, if that makes any difference to the recommendations. How small is small? For just a few thousand records, often it really doesn't matter what you use - a performance based query isn't going to

Re: SQL varieties

2009-01-22 Thread Sarah Reichelt
Thanks to all who responded. Pierre: MySQL (3.2.3) use to be a very unsecure solution. More, it was unable to serve more than 10-15 connections/second. At that time, PostgreSQL (6.5) had become a very serious alternative to Oracle or Sybase rdbms. Since it will be completely LAN-based and

RE: SQL varieties

2009-01-22 Thread Lynn Fredricks
Lynn: How small is small? Very small - about 8 tables with the biggest having maybe 500 entries. Only 6 - 7 users and no intensive usage. Mouse nugget size :-) Postgre has free going for it, without a lot of concerns that come up with the free of MySQL. It also has the advantage

Re: SQL varieties

2009-01-22 Thread Kay C Lan
On Fri, Jan 23, 2009 at 5:55 AM, Sarah Reichelt sarah.reich...@gmail.comwrote: Hmmm, MySQL comes with it's own admin tools. For my limited use I don't want to have to buy another tool. You might consider the free: http://www.pgadmin.org/ HTH ___

Re: SQL varieties

2009-01-22 Thread Sarah Reichelt
Hmmm, MySQL comes with it's own admin tools. For my limited use I don't want to have to buy another tool. You might consider the free: http://www.pgadmin.org/ I certainly will. Thanks very much :-) Sarah ___ use-revolution mailing list

SQL varieties

2009-01-21 Thread Sarah Reichelt
Hi All, I'm working on a system that will end up using a multi-user database served from a central system. While testing I am using SQLite which is great as I can test all my SQL commands without having to worry about the additional complication of server connections. When that all works I will

Re: SQL varieties

2009-01-21 Thread Kay C Lan
On Thu, Jan 22, 2009 at 7:02 AM, Sarah Reichelt sarah.reich...@gmail.comwrote: 3. How do you say PostgreSQL :-) Sorry, can't help with the other questions, I found MySQL so easy to install and use I never got around to installing PostgreSQL. As far as how to pronounce it goes it looks like

Re: SQL varieties

2009-01-21 Thread Pierre Sahores
Hi Sarah, MySQL (3.2.3) use to be a very unsecure solution. More, it was unable to serve more than 10-15 connections/second. At that time, PostgreSQL (6.5) had become a very serious alternative to Oracle or Sybase rdbms. Today, PostgreSQL is still a very suitable solution (more ACID-

Re: SQL varieties

2009-01-21 Thread Mark Schonewille
Hi Sarah, I can't say much about the difference between PostGreSQL and MySQL. I have been using MySQL 4 and 5 and have been particularly happy with release 5. I just can't think of a reason to switch to PostGreSQL. I have also noticed that most, if not all, web providers provide MySQL,