, October 02, 2006
3:38 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Advantages of
postgresql
Hello everybody,
So far I have only been working with MySQL. Today I was
talking to a friend and he was suggesting I migrated to postgreSQL, as it is
way better …
My question is … why?
I
Iulian Manea <[EMAIL PROTECTED]> schrieb:
>
>
> Hello everybody,
>
> So far I have only been working with MySQL. Today I was talking to a friend
> and
> he was suggesting I migrated to postgreSQL, as it is way better &
>
> My question is & why?
> I mean could someone pls tell me some advant
Hello everybody,
So far I have only been working with MySQL. Today I was
talking to a friend and he was suggesting I migrated to postgreSQL, as it is
way better …
My question is … why?
I mean could someone pls tell me some advantages and
disadvantages of working with postgresql?
To go slightly OT, I have the current displeasure of becomming
acquainted with Sybase which has ideas about being flexible with
standards (and sanity) much like MySQL.
The first of the two intentional "helpful" features I have come across
so far is that inserting (or updating) char/varchar columns
On Sat, 2006-25-03 at 10:11 -0800, Chris Travers wrote:
> Leif Jensen wrote:
>
> > Hello,
> >
> > I have with great interrest been following this thread. We have a
> >(small) flame war in house about this and I'm very happy about all the
> >arguments I have seen. I'm a long time user of Postgre
Chris Travers <[EMAIL PROTECTED]> writes:
> Out of curiosity, how hard would it be to change the default maximum
> length on the name type in PostgreSQL?
Change NAMEDATALEN in postgres_ext.h, recompile, re-initdb.
I'm not sure why we still define it in postgres_ext.h, because it hasn't
been part
Scott Marlowe wrote:
On Sun, 2006-03-26 at 16:00, Robert Treat wrote:
mysql's various user permissions / connection tables are often seen as being
more featurefull than postgresql pg_hba system, due to its closer likeness to
using sql, potentially simpler syntax, and ability to use remote
On Fri, 2006-03-24 at 17:08, Guy Fraser wrote:
> On Fri, 2006-24-03 at 14:53 -0600, Scott Marlowe wrote:
> ...snip...
> > Only my most recent personal experience, when I was explaining to the
> > guy from MySQL how frustrating it was that installing MySQL broke my
> > build of PHP and meant I had t
On Sun, 2006-03-26 at 16:00, Robert Treat wrote:
> mysql's various user permissions / connection tables are often seen as being
> more featurefull than postgresql pg_hba system, due to its closer likeness to
> using sql, potentially simpler syntax, and ability to use remote admin tools.
> That
On Saturday 25 March 2006 08:30, Leif Jensen wrote:
>Hello,
>
> I have with great interrest been following this thread. We have a
> (small) flame war in house about this and I'm very happy about all the
> arguments I have seen. I'm a long time user of PostgreSQL (which possibly
> makes me a b
Leif Jensen wrote:
Hello,
I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which possibly
makes me a bit biased ;-) ) and I think it's great. I'm
On Sat, Mar 25, 2006 at 14:30:54 +0100,
Leif Jensen <[EMAIL PROTECTED]> wrote:
>
> 1) I wonder that no one has mentioned anything about security issues in
> those two. I know that I'm a novice and that I didn't use MySql very much,
> but it seems to me that the PostgreSQL security is much better
Hello,
I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which possibly
makes me a bit biased ;-) ) and I think it's great. I'm not a big database
On Fri, 2006-24-03 at 14:53 -0600, Scott Marlowe wrote:
...snip...
> Only my most recent personal experience, when I was explaining to the
> guy from MySQL how frustrating it was that installing MySQL broke my
> build of PHP and meant I had to use the mysqli libs, not the mysql
> ones. The answer
On Fri, 2006-03-24 at 13:55, Jim C. Nasby wrote:
> On Fri, Mar 24, 2006 at 10:32:42AM -0600, Scott Marlowe wrote:
> > > > http://bugs.mysql.com/bug.php?id=13301
> > > >
> > >
> > > from the response:
> > >
> > > > Years ago, to help porting applications from other database brands to
> > > > M
On Fri, Mar 24, 2006 at 10:32:42AM -0600, Scott Marlowe wrote:
> > > http://bugs.mysql.com/bug.php?id=13301
> > >
> >
> > from the response:
> >
> > > Years ago, to help porting applications from other database brands to
> > > MySQL, MySQL was made to accept the syntax even though no real
> >
On Fri, 2006-03-24 at 02:51, Gábor Farkas wrote:
> Scott Marlowe wrote:
> > On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> >> On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> >>> Now, I shouldn't be able to insert anything in b that's not
> >>> referencing
> >>> an entry in a. and I used in
On Thu, Mar 23, 2006 at 12:24:18PM -0600, Scott Marlowe wrote:
> On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> > On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> > > Now, I shouldn't be able to insert anything in b that's not
> > > referencing
> > > an entry in a. and I used innodb tables.
Scott Marlowe wrote:
On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
Now, I shouldn't be able to insert anything in b that's not
referencing
an entry in a. and I used innodb tables. and I used ansi SQL, and I
got no errors. So how come my da
""Merlin Moncure"" <[EMAIL PROTECTED]> wrote
>
> In postgresql, queries executed over the parameterized/prepared C api
> are particularly fast...as much as a 70% speed reduction over vanilla
> PQexec.
Does it mean 70% time is spent on planning? I am a little bit interested in
this number. Can you
[EMAIL PROTECTED] (Scott Marlowe) writes:
> http://bugs.mysql.com/bug.php?id=13301
And as Heikki Tuuri is no longer with them, I'll bet that doesn't get
changed any time soon...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/finances.html
On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> > Now, I shouldn't be able to insert anything in b that's not
> > referencing
> > an entry in a. and I used innodb tables. and I used ansi SQL, and I
> > got no errors. So how come my data's in
On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
Now, I shouldn't be able to insert anything in b that's not
referencing
an entry in a. and I used innodb tables. and I used ansi SQL, and I
got no errors. So how come my data's incoherent three seconds after
creating the tables the way the s
>
> Hello there,
> I'm a freelance Oracle Developer by trade (can almost hear the boos now
> ;o)), and am looking into developing my own Snowboarding-related
> website over the next few years. Anyway, I'm making some decisions now
> about the site architecture, and the database I'm going to need is
>As I'm sure you've asked the same question of the MySQL folks, can you tell
>us what they've said about "us"? I guess it's not just idle curiosity (90%
>though), but it might give us some pointers about how to improve either our
>marketing, implementation or both.
Not yet asked them, but will pop
nal-
-->De: [EMAIL PROTECTED]
-->[mailto:[EMAIL PROTECTED] Em nome de Jimbo1
-->Enviada em: quarta-feira, 22 de março de 2006 08:06
-->Para: pgsql-general@postgresql.org
-->Assunto: [GENERAL] Advantages of PostgreSQL over MySQL 5.0
-->
-->
-->Hello there,
-->
-->I&
"Jimbo1" <[EMAIL PROTECTED]> writes:
> Not yet asked them, but will pop the question over the next week. ;o)
Careful about "popping the question"... While good marriages have
come from that, so also have been some bad ones :-).
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http:/
On Wed, 2006-03-22 at 16:36 -0500, Merlin Moncure wrote:
> Chis Browne wrote:
> > PostgreSQL is likely to be way slower if you submit streams of little
> > queries, each an independent transaction...
>
> When I get around to it I plan on debunking this ;). I recently did
> extensive internal benc
Chis Browne wrote:
> PostgreSQL is likely to be way slower if you submit streams of little
> queries, each an independent transaction...
When I get around to it I plan on debunking this ;). I recently did
extensive internal benchmarking of mysql 5.0 vs. postgresql 8.1 and
it's victories across th
I see a titanic advantage of PostgreSQL over MySQL: the license.
http://www.postgresql.org/about/licence
http://www.mysql.com/company/legal/licensing/commercial-license.html
Would you like to use the database for commercial purposes?
To my way of thinking, the Berkeley style license is the best
On Wed, 2006-03-22 at 05:06, Jimbo1 wrote:
> Hello there,
>
> I'm a freelance Oracle Developer by trade (can almost hear the boos now
> ;o)), and am looking into developing my own Snowboarding-related
> website over the next few years. Anyway, I'm making some decisions now
> about the site archite
On Wed, 2006-22-03 at 11:34 -0800, Benjamin Smith wrote:
> On Wednesday 22 March 2006 03:06, Jimbo1 wrote:
> > Hello there,
> >
> > I'm a freelance Oracle Developer by trade (can almost hear the boos now
> > ;o)), and am looking into developing my own Snowboarding-related
> > website over the next
Jimbo1 wrote:
> Hello there,
>
> Regarding MySQL
Hi Jimbo,
As I'm sure you've asked the same question of the MySQL folks, can you tell
us what they've said about "us"? I guess it's not just idle curiosity (90%
though), but it might give us some pointers about how to improve either our
marketing,
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
> Jimbo1 wrote:
>> Hello there,
>> I'm a freelance Oracle Developer by trade (can almost hear the boos
>> now
>> ;o)), and am looking into developing my own Snowboarding-related
>> website over the next few years. Anyway, I'm making some decisions now
>
...I can think of two really high
profile Postgresql installs that have recently been discussed:
1. The Wisconsin Court System, search the archives for a recent post
about this.
2. The entire .org and .info domains are stored in a Postgresql database.
I am sure there are many more.
Yup, Sony
On Wednesday 22 March 2006 03:06, Jimbo1 wrote:
> Hello there,
>
> I'm a freelance Oracle Developer by trade (can almost hear the boos now
> ;o)), and am looking into developing my own Snowboarding-related
> website over the next few years. Anyway, I'm making some decisions now
> about the site ar
Jimbo1 wrote:
Hello there,
I'm a freelance Oracle Developer by trade (can almost hear the boos now
;o)), and am looking into developing my own Snowboarding-related
website over the next few years. Anyway, I'm making some decisions now
about the site architecture, and the database I'm going to n
Jimbo1 wrote:
Hello there,
I'm a freelance Oracle Developer by trade (can almost hear the boos now
;o)), and am looking into developing my own Snowboarding-related
website over the next few years. Anyway, I'm making some decisions now
about the site architecture, and the database I'm going to ne
Tony Caduto wrote:
Jimbo1 wrote:
"With MySQL, customers across all industries are finding ...
If any PostgreSQL devotees on this group can comment on the above and
its accuracy/inaccuracy, I'd really appreciate it.
That's exactly what it is "propoganda", I can think of two really high
Jimbo1 wrote:
"With MySQL, customers across all industries are finding they can
easily handle nearly every type of database workload, with performance
and scalability outpacing every other open source rival. As Los Alamos
lab (who uses MySQL to manage their terabyte data warehouse) said, "We
cho
On Mar 22, 2006, at 6:06 AM, Jimbo1 wrote:
lab (who uses MySQL to manage their terabyte data warehouse) said, "We
chose MySQL over PostgreSQL primarily because it scales better and has
embedded replication.".".
The "one size fits all" style replication. What if it doesn't suit
your needs?
Hello there,
I'm a freelance Oracle Developer by trade (can almost hear the boos now
;o)), and am looking into developing my own Snowboarding-related
website over the next few years. Anyway, I'm making some decisions now
about the site architecture, and the database I'm going to need is
obviously
42 matches
Mail list logo
