PostgreSQL implements standard SQL as well as the features of an
enterprise DBMS. On that basis if you are changing it makes sense to
change to the fuller-featured product, one in the same class as Oracle
and DB2. In the short term Mysql could be as good as PostgreSQL.
Fanda Vacek wrote:
I'm not sure, if Postgres is better choice than MySQL. I have used both
of them to find out which is the better one. Both of them can do
almost anything. The choice is a matter of taste and person. We are
free to choose:)) I'm talking about MySQL 5 and PostgreSQL 8.1.
Sorry for writing this to SQLite mail-list.
Fanda
On Tue, 07 Feb 2006 22:35:09 +0100, John Stanton <[EMAIL PROTECTED]>
wrote:
Jim C. Nasby wrote:
On Mon, Feb 06, 2006 at 05:30:39PM +0100, Laurent Goussard wrote:
Hi there,
I use SQLite on my website for 2 years now. I do like SQLite a lot and
will use it for a lot of new web projects but, because I got more and
more traffic, I consider to move this one to MySQL in order to reduce
the over load of my computer (I host it @ home).
Do you know if there is a way to convert easily an SQLite database
into a MySQL one ?
(I'm especially thinking about the escapestring and other "create
table [myTable] {" issues...)
FWIW, I believe SQLite's syntax is closer to PostgreSQL's than it
is to
MySQL, so it might me easier to migrate that direction...
If you are migrating to an enterprise level DBMS, PostgreSQL is a
better choice than Mysql. It is fully featured with all the
qualities of DB2 and Oracle but without the expense.
Note that you will need considerably more machine resources to run a
"heavier" DBMS than Sqlite. For example on our 166MHz, 256MB RS/6000
PostgreSQL is sluggish but on our dual processor 1.2GHz, 2GB P-Series
it is lightning fast. Sqlite runs fast on the 166MHz machine.
