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 PostgreSQL (which
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 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 to use
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
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 of
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 bit
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
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 than
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.
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
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. and I
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 innodb tables. and
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
constraints were
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
MySQL, MySQL was made to
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
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))
-
--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'm a freelance Oracle Developer by trade (can
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 the
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
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
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 incoherent
[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
Rules
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 specify
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
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?
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
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:
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
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
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
...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,
[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
about the
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 few
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
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
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 the
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
38 matches
Mail list logo