Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:
" Database Workbench 5.2 "
This release includes support for PostgreSQL and adds several other features.
Database Workbench 5 comes in multiple editions with
Dear all,
I want to convert some tables from Mysql database to Postgresql Database
in Linux Systems ( Ubuntu-10.4, CentOS ).
Can someone Please tell me tool for it that makes it easier.
I am able to done it through FW tools in Windows System but i want to
achieve it in Linux ( CentOS
2011/3/1 Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
I want to convert some tables from Mysql database to Postgresql Database in
Linux Systems ( Ubuntu-10.4, CentOS ).
[...]
invalid byte sequence for encoding UTF8: 0xe3ba27
HINT: This error can also happen if the byte sequence does
By default Postgresql database encoding in UTF8.
It seems to me by seeing error that database encoding in mysql is
different from it.
--
Cheers,
Dhaval Jaiswal
On 01/03/2011 3:57 PM, Adarsh Sharma wrote:
Dear all,
I want to convert some tables from Mysql database to Postgresql
Dear all,
Today I need to back up a mysql database and restore in Postgresql
database but I don't know how to achieve this accurately.
Can anyone kindly describe me the way to do this.
Thanks best Regards,
Adarsh Sharma
--
MySQL General Mailing List
For list archives: http
2011/2/22 Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
Today I need to back up a mysql database and restore in Postgresql database
but I don't know how to achieve this accurately.
Have a look at: mysqldump --compatible=postgresql command:
http://dev.mysql.com/doc/refman/5.1/en
no, i don't want to start a flame war, i just want some feedback on
a current list of mysql drawbacks WRT postgresql.
in the context of a fully open-source, java based ECM product, there
is a FAQ entry that summarizes why the developers would prefer their
users to use postgresql as opposed
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), Robert P. J. Day
rpj...@crashcourse.ca wrote:
no, i don't want to start a flame war, i just want some feedback on
a current list of mysql drawbacks WRT postgresql.
in the context of a fully open-source, java based ECM product, there
is a FAQ entry
Dear all,
Benetl, a free ETL tool for files using MySQL, is out in version 3.2.
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
Dear all,
Benetl, a free ETL tool for files using postgreSQL and MySQL, is out in
version 3.2.
You can freely download it at : www.benetl.net
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can learn more about ETL tools at:
http://en.wikipedia.org
Dear all,
Benetl, a free ETL tool for files using postgreSQL (and now MySQL), is
out in version 3.1.
A small correction has been done to Benetl 3.1.
This is now available online.
You can freely download it at : www.benetl.net
This new version brings the support of long as date.
Benetl
-.
- There won't be more than 86400 * 365 rows per table -one GPS position
every second along one year-.
- There won't be more than 10 simultaneously read-only queries.
The question is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
I think
. This is not
sophisticated box - about 3 yr old, 2Mbytes RAM.
- Miles
Date: Wed, 18 Mar 2009 12:53:45 -0700
Subject: Performance Spamassin PostgreSQL vs MySQL
From: mussa...@csz.com
To: mysql@lists.mysql.com
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend
.
The question is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
I think it depends on exactly what you want to do with the data. MySQL
has fairly poor support for spatial types but you can achieve a lot
just manipulating normal data types. Postgres (which
At 02:53 PM 3/18/2009, you wrote:
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend a lot of time 'vacumming' which of course
drives up disk load. The system admin has adjusted it so it only does
this at low load. I'm curious if anyone has
DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
Thanks in advance
Juan Karlos.
is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
Thanks in advance
Juan Karlos.
__
This email has been scanned by Netintelligence
http://www.netintelligence.com/email
--
MySQL General Mailing List
one year-.
- There won't be more than 10 simultaneously read-only queries.
The question is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
I think it depends on exactly what you want to do with the data. MySQL
has fairly poor support for spatial types
is the best for this kind of
application? PostgreSQL or MySQL?
I think it depends on exactly what you want to do with the data. MySQL
has fairly poor support for spatial types but you can achieve a lot
just manipulating normal data types. Postgres (which i know nothing
about) appears to have
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend a lot of time 'vacumming' which of course
drives up disk load. The system admin has adjusted it so it only does
this at low load. I'm curious if anyone has actually tested the
PostgreSQL vs
PostgreSQL Conference East is being held at historic Drexel University
on April 3rd through 5th 2009 . This is the second call for papers. The
call for papers ends Feb 23rd and speakers will be notified on the 27th.
You may submit your talk here: http://www.postgresqlconference.org . We
Hello,
The talk I gave at MySQCon on this topic is here:
http://www.commandprompt.com/blogs/joshua_drake/2008/04/what_mysql_and_really_sun_can_learn_from_postgresql/
It was an interesting experience. Thanks for the help you guys gave me
via this list and direct email to accomplish the task.
Hello,
I know this is a *little* off topic but it is about Open Source
databases :)
There are only three weeks left to register for the PostgreSQL
Community Conference: East!
The conference is scheduled on March 29th and 30th (a Saturday and
Sunday) at the University of Maryland. Come join us
Hi,
We are developing a Java EE 5 based system in which we run our system using
MySQL on our local test workstation machines. Each night our project is built
and deployed on our test server, which is using PostgreSQL, it's the database
we will be using in our production environment as well
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am an unabashed PostgreSQL user. However i am giving a talk on
MySQL/PostgreSQL shortly. I would like to know from a MySQL user
perspective what MySQL has over PostgreSQL, why is it good? Why would
use use MySQL versus PostgreSQL? Any
At 11:57 AM 1/15/2008, you wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am an unabashed PostgreSQL user. However i am giving a talk on
MySQL/PostgreSQL shortly. I would like to know from a MySQL user
perspective what MySQL has over PostgreSQL, why is it good? Why would
use use
is not going to help
you much, if your queries typically only touch one partition it will
help a lot.
I am a bit hesitant however to go with PostgreSQL because the partitioning
system seems a bit less easier to work with than MySQL (5.1's)
implementation; as I would need to maintain my own master
partitioning.
Cheers
- Andrew
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 July 2007 6:44 PM
To: mysql@lists.mysql.com
Subject: Re: Data Warehousing and MySQL vs PostgreSQL
On 7/26/07, Andrew Armstrong wrote:
* Table 1: 80,000,000 rows - 9.5 GB
On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote:
Hello,
I am seeking information on best practices with regards to Data Warehousing
and MySQL. I am considering moving to PostgreSQL.
* Table 1: 80,000,000 rows - 9.5 GB
* Table 2: 1,000,000,000 rows - 8.9 GB
Just
Hello,
I am seeking information on best practices with regards to Data Warehousing
and MySQL. I am considering moving to PostgreSQL.
I am currently using MySQL as the database of choice. I am now running into
performance issues with regards to large tables.
At the moment, I have
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
snip
Information is deleted from this DW as well, after every five minutes.
The data being recorded is time sensitive. As data ages, it may be deleted.
Groups of samples are aggregated into a summary/aggregation sample prior to
being deleted.
: Re: Data Warehousing and MySQL vs PostgreSQL
On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote:
Hello,
I am seeking information on best practices with regards to Data
Warehousing
and MySQL. I am considering moving to PostgreSQL.
* Table 1: 80,000,000 rows - 9.5 GB
Warehousing and MySQL vs PostgreSQL
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
snip
Information is deleted from this DW as well, after every five minutes.
The data being recorded is time sensitive. As data ages, it may be
deleted.
Groups of samples are aggregated into a summary
so much due
to the
large table size.
-Original Message-
From: Wallace Reis [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 July 2007 1:02 AM
To: Andrew Armstrong
Cc: mysql@lists.mysql.com
Subject: Re: Data Warehousing and MySQL vs PostgreSQL
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED
more concerned as to why inserts begin to slow down so much due to the
large table size.
-Original Message-
From: Wallace Reis [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 July 2007 1:02 AM
To: Andrew Armstrong
Cc: mysql@lists.mysql.com
Subject: Re: Data Warehousing and MySQL vs PostgreSQL
On 7/26/07, Andrew Armstrong [EMAIL PROTECTED] wrote:
Do you have a suggestion to how this should be implemented?
Data is aggregated over time and summary rows are created.
I think that you didnt design correctly your DW.
It should have just one very larger table (the fact table).
Data should
To: Andrew Armstrong
Cc: 'Wallace Reis'; mysql@lists.mysql.com
Subject: Re: Data Warehousing and MySQL vs PostgreSQL
Wallace is right, Data Warehousing shouldn't delete any data. MySQL
isn't as robust as say, Oracle, for partitioning so you need to fudge
things a little. I think partitioning
Rewriting PostgreSQL in another language - from C to SmartEiffel
PostgreSQL is very stable, mature and fully grown up and is in
spectacular shape.
But what will the developers do next ? Will they run out of work?
No!!
We can give them more work to do. We can keep them very busy for many
more
If you used TOAD in oracle, DBBrowser is similar to that.
Developers need a tool like DBBrowser to work with SQL database.
DBBrowser is excellent tool and is quite useful for developers.
DBBrowser is released under gnu/gpl license.
DBBrowser is quite impressive and in future it will find rapid
http://linux.inet.hr/poll_favorite_database.html
I don't think so. Do something!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
the package which
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer
Hello List:
I hope my question does not start war of the posts. This question is
genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS,
Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will
have all the software I we
World-Wide public announcement (every human animal on this planet
must read this announcement) :
The top RDBMS SQL systems are:
Number one: PostgreSQL
Number two: FireBird and MySQL.
Now, which are the top computer languages which you would use to
interface with these SQL servers??
You
PostgreSQL is becoming the World's Financial Capital !!
All the banks in the world are ordered to change their operations to
run on open-source databases like PostgreSQL, MySQL or FireBird.
It means all the banks in 200 countries in the world run on open
source db system.
The heart of the bank
is there other ways of doing this?
tia,
On Tuesday 02 August 2005 20:33, Gleb Paharenko wrote:
Hello.
Have a look here:
http://solutions.mysql.com/technology/technology/?item=425
SQLPorter supports Postgres according to this page.
JM [EMAIL PROTECTED] wrote:
hi all,
is
hi all,
is there a howto on this? or an application for this?
tia,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Have a look here:
http://solutions.mysql.com/technology/technology/?item=425
SQLPorter supports Postgres according to this page.
JM [EMAIL PROTECTED] wrote:
hi all,
is there a howto on this? or an application for this?
tia,
--
For technical support
My choice was based on the fact that web requires a high number of reads
and normally far fewer writes. The speed of MySQL in read is very fast
compared to PostgreSQL. Where it comes to accounting, high transactions
and such applications I will continue to use PostgreSQL till MySQLv5
becommes
Hi Stone,
if you ask me which is bettet your car or mine, i'll answer mine.
Your question can't be answered here because it's not technical but political.
Better close this thread.
Mathias
Selon stone.wang [EMAIL PROTECTED]:
How do you think about PostgreSQL and mysql? want to know which
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
FB
Hi Stony,
I didn't use PostgreSQL before, so couldn't comment. For MySQL, you
Félix Beltrán wrote:
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
It really depends on what you are using it for. Stability
As previously posted to this list.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
On 6/24/05, stone.wang [EMAIL PROTECTED] wrote:
How do you think about PostgreSQL and mysql? want to know which is good? How
to choose database for the web?
--
MySQL General
How do you think about PostgreSQL and mysql? want to know which is good? How to
choose database for the web?
Hi Stony,
I didn't use PostgreSQL before, so couldn't comment. For MySQL, you have
to beware of the following:
- Store procedure, views, triggers is supported only in version 5, which
is still in development phase.
- clustering / failover feature is only out for about 9 months, so
Hi,
What do you think about MySQL vs PostgreSQL ?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
March 2005 8:20 PM
To: mysql@lists.mysql.com
Subject: MySQL vs PostgreSQL
Hi,
What do you think about MySQL vs PostgreSQL ?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing
On Tue, 15 Mar 2005 18:49:38 +0900
ninjajs [EMAIL PROTECTED] wrote:
What do you think about MySQL vs PostgreSQL ?
Both are great products and have their ups and downs. On a MySQL list
you will not get an un-biases answer to this question.
If you really want to know what people on the MySQL
At 05:45 PM 2/24/2005, you wrote:
hi,
just want to know the main benefits of mysql over postgresql.
thanks,
Payam Shabanian
Payam,
The differences between the products are narrowing, especially
with MySQL 5.0 which is still in beta. If I could sum it up in 1 sentence
then MySQL
On Fri, 25 Feb 2005 11:21:26 -0600, mos wrote:
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html
There is a reason this page was removed from the MySQL site: some of
it was never correct in the first place, and the rest was severly
outdated.
Don't you
On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten [EMAIL PROTECTED]
wrote:
Don't you think it is childish to link to documentation from 2003?
I've never seen a child do anything like you describe.
-Rich
--
Rich Lafferty
Hello.
You should search in archives for such questions. For example see
threads at:
http://lists.mysql.com/mysql/160972
http://lists.mysql.com/mysql/170673
shabanip [EMAIL PROTECTED] wrote:
hi,
just want to know the main benefits of mysql over postgresql.
thanks,
Payam
hi,
just want to know the main benefits of mysql over postgresql.
thanks,
Payam Shabanian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:24 +0800, Patrick Hsieh wrote:
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this?
pg_dump
First dump the schema, edit that until you have something MySQL
understands. Then dump the data using the -d option so you
now I managed to dump table schema with pg_dump. However,
is there any schema converting tool available? I don't want to edit
each table schema to make it mysql-compliant.
Download yourself a trial of Database Workbench
at www.upscene.com
It has a Schema Migrator tool that allows you to
Hello list,
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this? Any infomation is
highly appreciated!
---
Patrick Hsieh() [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED] | ICQ: 97133580
Skype: pahud_at_pahud.net | YIM: pahudnet
On Mon, 18 Oct 2004 18:08:24 +0800, Patrick Hsieh wrote:
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this?
pg_dump
First dump the schema, edit that until you have something MySQL
understands. Then dump the data using
:
I am planing to transfer data from postgresql to
mysql. Is there any
useful tools, scripts or utilities to achieve
this?
pg_dump
First dump the schema, edit that until you have
something MySQL
understands. Then dump the data using the -d option
so you have full
inserts instead
mysqldump --no-data --all-databases
SNIP
Eamon Daly
Yeap Eamon, as mentioned MyRun is not the only utility on earth with the
functionality. The difference between mysqldump and MyRun is that while MyRun
includes all the mysqldump
Great, MyCon produces SQL statements ready to recreate just your schema and/or all
data as well, now did I miss something, or does MyCon actually write the SQL one
needs to create and populate a set of system tables for the schema?
PB
.
Nope Peter, you didn't miss a beat ;)
Just to be
SciBit MySQL Team [EMAIL PROTECTED] wrote:
select * from accounts; -- as an example
but because you can customize the source sql script for MyRun, you can go like:
select * from accounts where AccountDateYEAR(CURDATE()); --
i.e. limit the inserts you going to get to that which is really
-w, --where=nameDump only selected records; QUOTES mandatory!
:)
The more options the merrier for MySQL and the end-users :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-gnu (i686)
Same behaviour in :
mysql Ver 12.22 Distrib 4.0.20, for pc-linux-gnu (i386)
Same query in PostgreSQL return IMHO good value,
NULLs in second record are everywhere except table Lokal .
1 Lokal1 2122004-10-10 1 2004-10-10 2Kontrahent2
2 Lokal2 NULL NULL NULL NULL
On Tue, 10 Aug 2004 23:40:39 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Well, since you admitted to being a newbie, I would suggest that
you learn with MySQL. It supports several types of data storage
On Tue, 10 Aug 2004 23:34:49 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
One area where MySQL beat Postgres is in Windows installation.
Installing postgres on Windohs is like pulling your fingernails
off slowly.
It is more
On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote:
On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote:
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
MySQL's command line interface and programming API also are nicer
for newer users. Why in the world do I need to
remembering: I prefer to remember just one standard,
instead of the idiosyncracies of each product.
Yes, a queryable (sp?) set of dictionary tables/views would be nice for doing this.
The MySQL set of SHOW commands is pretty painful for any serious development.
Does PostgreSQL have a set
development.
Does PostgreSQL have a set of information schema tables to query against like Oracle
does (e.g. SELECT table_name FROM user_tables)?
It does have a system that is pretty comparable to what is in the the
SQL standard. There is a pg_catalog schema that contains the base
tables (information
SHOW TABLES does not make sense. How are you going to join the
output of SHOW TABLES against the output of SHOW COLUMNS and
SHOW INDEXES?
In MySQL, by parsing the output of SHOW CREATE TABLE.
It would be a boon if someone were to write a utility, in an OS-independent
language, which does that
In MySQL, by parsing the output of SHOW CREATE TABLE.
It would be a boon if someone were to write a utility, in an OS-independent
language, which does that parsing for all tables in a MySQL database and
returns SQL output that's suitable for creating a set of system tables.
Obviously bits
, August 11, 2004 4:34 PM
Subject: RE: Re: [OT] PostgreSQL / MySQL Data Dictionary
In MySQL, by parsing the output of SHOW CREATE TABLE.
It would be a boon if someone were to write a utility, in an
OS-independent
language, which does that parsing for all tables in a MySQL database
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
EWAGW wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
No need for flames. I think the two are converging.
PostgreSQL started out
consideration, go with PostgreSQL: ColdFusion MX is
Java based and PostgreSQL has a stable release with Unicode support.
But I am sure that in an answer you will give us many more
requirements which may or may not change my recommendation :)
Jochem
--
MySQL General Mailing List
For list archives: http
3:45 PM
Subject: Re: Difference between PostgreSQL and MySQL
EWAGW wrote:
Hi all, mr.super newbie here, what is the best for cold fusion
development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
No need
that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, 10 Aug 2004 16:45:29 -0400
Brad Tilley [EMAIL PROTECTED] wrote:
No need for flames. I think the two are converging.
One area where MySQL beat Postgres is in Windows installation. Installing postgres on
Windohs is like pulling your fingernails off slowly. I hear they are close to full
Subject: Re: Difference between PostgreSQL and MySQL
Well, since you admitted to being a newbie, I would suggest that you learn
with MySQL. It supports several types of data storage (memory only, ISAM,
full-relational) and both transacted and non-transacted execution models.
Ehm
No need for flames. I think the two are converging.
One area where MySQL beat Postgres is in Windows installation. Installing
postgres on Windohs is like pulling your fingernails off slowly. I hear
they are close to full Windows support though in the 8.x branch.
FYI:
Thanks a lot Shawn, Josh and Brad for your great advice. The command line
interface you talk about is that in MySQL administrator?
MySQL's command line interface and programming API also are nicer for newer
users. Why in the world do I need to remember to type \d to show my
tables?
That
Thank Jochem as well interesting reply got me thinking
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 3:51 PM
Subject: Re: Difference between PostgreSQL and MySQL
On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW [EMAIL
.
I hear they are close to full Windows support though in the 8.x branch.
The current BETA offers identical features on Windows and Linux. But
don't use beta software in production (neither PostgreSQL nor MySQL).
MySQL's command line interface and programming API also are nicer for newer users
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Well, since you admitted to being a newbie, I would suggest that you learn
with MySQL. It supports several types of data storage (memory only, ISAM,
full-relational) and both transacted and non-transacted execution
Thanks Emmett and Martijn!!
- Original Message -
From: EWAGW [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 4:31 PM
Subject: Re: Difference between PostgreSQL and MySQL
Thank Jochem as well interesting reply got me thinking
- Original Message
At 03:35 PM 8/10/2004, you wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
One thing that wasn't mentioned is MySQL requires a license
Foundation or a lawyer as appropriate.
Lachlan
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11 August 2004 7:58 AM
To: [EMAIL PROTECTED]
Subject: Re: Difference between PostgreSQL and MySQL
At 03:35 PM 8/10/2004, you wrote:
Hi all, mr.super newbie here, what
Hi All,
Does anyone have any experience of running MySQL and PostgreSQL on the
same hardware?
At the moment we have several reasonable fast servers (dual Xeon GHz,
1GB ram, 15,000rpm scsi disk) running MySQL in a replicated environment
with high volumes of queries (high read:write ratio) and I
a
month.
Kevin Cowley
RD
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 10:47
To: [EMAIL PROTECTED]
Subject: Running MySQL and PostgreSQL on the same
10:53
To: Andrew Braithwaite; [EMAIL PROTECTED]
Subject: RE: Running MySQL and PostgreSQL on the same hardware
Andrew
I've done it but only in a test environment. I actually had 3 different
versions of Mysql running plus Postgres.
Each of the Mysql's and Postgress were installed to
/opt/database
1 - 100 of 224 matches
Mail list logo