Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
PostgreSQL Guide Feedback
View unanswered posts
View posts from last 24 hours

Goto page Previous  1, 2  
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
zeek
Guru
Guru


Joined: 16 Nov 2002
Posts: 478
Location: Bantayan Island

PostPosted: Sat May 26, 2007 6:24 am    Post subject: Reply with quote

Mad Merlin wrote:
Foreign keys have been supported in MySQL for InnoDB tables since version 3.23. Some things that were added in MySQL 5 were views, stored procedures and triggers.

You're free to bash MySQL if you want to, but please get your facts straight. See here: http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-keys.html


Its been over 1 year and this still hasn't been addressed?

Stuff like this is one of the reasons I think Postgres isn't taking off. Pg zealots seem to be fixated on ancient problems with mysql and wont acknowledge that they've been addressed. The result is people think "raving lunatic" when they think about Postgres.

The cheap shot about mysql and foreign keys only being supported started with mysql 5 needs to be removed from the guide. Its completely bogus. The bogus sentence is (engrish alert):
Quote:
Most of the standard features such as FOREIGN KEY was only just added in MySQL 5.
Back to top
View user's profile Send private message
tSp
Apprentice
Apprentice


Joined: 19 Jan 2004
Posts: 214
Location: Maysville, KY

PostPosted: Sun Jun 03, 2007 4:34 pm    Post subject: Reply with quote

Joseph_sys wrote:
Maybe somebody can help me here.
After upgrading several perl scripts yesterda, when I try to log-in to sql-ledger I get an error:
apache log:
Code:
/usr/local/sql-ledger/login.pl: symbol lookup error: /usr/lib/perl5/vendor_perl/5.8.8/i686-linux/auto/DBD/Pg/Pg.so: undefined symbol: PQserverVersion
[client 127.0.0.1] Premature end of script headers: login.pl

Can anybody point me in the right direction?


end of script headers problem is here - http://www.maysville-linux-users-group.org/ftopict-30.html Different distro, but same fix
_________________
tSp
http://www.rhpstudios.com
http://www.xtremewebhosts.com
http://www.maysville-linux-users-group.org
http://www.edwiget.name

Registered Linux User #162711
Back to top
View user's profile Send private message
ucntcme
n00b
n00b


Joined: 11 Oct 2004
Posts: 32

PostPosted: Thu Nov 29, 2007 6:40 pm    Post subject: Reply with quote

zeek wrote:
Mad Merlin wrote:
Foreign keys have been supported in MySQL for InnoDB tables since version 3.23. Some things that were added in MySQL 5 were views, stored procedures and triggers.

You're free to bash MySQL if you want to, but please get your facts straight. See here: http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-keys.html


Its been over 1 year and this still hasn't been addressed?

Stuff like this is one of the reasons I think Postgres isn't taking off. Pg zealots seem to be fixated on ancient problems with mysql and wont acknowledge that they've been addressed. The result is people think "raving lunatic" when they think about Postgres.

The cheap shot about mysql and foreign keys only being supported started with mysql 5 needs to be removed from the guide. Its completely bogus. The bogus sentence is (engrish alert):
Quote:
Most of the standard features such as FOREIGN KEY was only just added in MySQL 5.


While I would remove any comparison of MySQL and PostgreSQL in a user guide to either of them neither your statement nor the one in the aforementioned doc is properly accurate. By default, last I knew, InnoDB was not default (i.e. standard) storage engine, and as that is the only place foreign keys were supported (every else it just silently ignores which IMO is the worst failing of MySQL - it's tendency to not tell you things like that). As such IF I were force to include the reference I would make it clear that while MyISAM will accept the FOREIGN KEY declaration it will silently ignore it and that you need to use InnoDB if you need actual support. I know of many people that got bit by taking statements like yours as MySQL supporting transaction and doing their code that way without realizing that others may not have their DB set to use InnoDB and then encounter user problems because the install of the application was on an MySQL server that was not using InnoDB. IMO to say that pre-5 MySQL support foreign keys is like saying PostgreSQL supports replication. Neither of them were/are standard, nor meet the expectations of saying they are (like foreign keys on temp tables not working in MySQL, and significant deviation for the SQL standard re: foreign keys on MySQL).

But like I said, comparisons do not belong in virtually any user guide.

Things like is one of the reasons PostgreSQL *is* becoming increasingly popular as people get bit by MySQL "choices" (especially at the large corps and financial firms I deal with). This is just one item among many. PG has it's issues (can you say DB upgrades?) but I'd prefer to have them then data getting silently changed under my feet because the DB assumes your first time stamp field on a table is something it should update to the current time every time it modifies that entry.

As far as zealotry, I see far, far more of that from MySQL users. I've never gotten a glare from a PostgreSQL proponent by suggesting MySQL. A raised eyebrow or two, sure. But never a glare or a glare followed by a lecture about how MySQL is "soo much faster" (again not true they are pretty close to the same), or outright hostility. I can't say the reverse however.

So how do we get the opening bits of this doc fixed (or anything else that needs updated). If it's been a year between these comments, whatever method was tried before has not worked.
Back to top
View user's profile Send private message
zeek
Guru
Guru


Joined: 16 Nov 2002
Posts: 478
Location: Bantayan Island

PostPosted: Sat Dec 01, 2007 6:20 am    Post subject: Reply with quote

ucntcme wrote:
While I would remove any comparison of MySQL and PostgreSQL in a user guide to either of them neither your statement nor the one in the aforementioned doc is properly accurate. By default, last I knew, InnoDB was not default (i.e. standard) storage engine...


It seems another Postgres Zealot looks past the truth ... Lets review the original again shall we?

PostgreSQL Guide Feedback wrote:
Most of the standard features such as FOREIGN KEY was only just added in MySQL 5.


There is no claim to what the "default storage engine" is, only to the support of the feature.
Back to top
View user's profile Send private message
uprooter
n00b
n00b


Joined: 06 Mar 2005
Posts: 70

PostPosted: Thu Jan 10, 2008 8:33 pm    Post subject: Reply with quote

One word !
Thanks.
Back to top
View user's profile Send private message
pactoo
Guru
Guru


Joined: 18 Jul 2004
Posts: 549

PostPosted: Mon Jan 21, 2008 11:54 am    Post subject: Reply with quote

Maybe you could say a word to i18n and creating a database with a certain encoding or locale and its effects and consequences. I currently do not understand this myself, but in case somebody answers my question, you may might want to add this information

http://forums.gentoo.org/viewtopic-t-649259.html
Back to top
View user's profile Send private message
Eckos
Apprentice
Apprentice


Joined: 25 Jan 2008
Posts: 197
Location: Houston, Texas, USA

PostPosted: Sun Feb 17, 2008 11:54 am    Post subject: Reply with quote

Thank you so very much. Too bad we can't get alot of users to switch to postgres from mysql :lol:
_________________
AMD Athlon 64 X2 3800+ | 2GB DDR2 533MHz RAM | GCC-4.3.2 | Gentoo x86_64 | KDE 4.1.2
Back to top
View user's profile Send private message
salmonix
Guru
Guru


Joined: 16 Jul 2006
Posts: 410

PostPosted: Mon Nov 30, 2009 1:45 pm    Post subject: Reply with quote

Helpful, indeed.
However, I would drop the PostgreSQL SQL intro - the PostgreSQL manual online - http://www.postgresql.org/docs/8.0/interactive/ddl.html - covers the topic a bit more in details.
It would however be more interesting to call attention to the scripting possibilities of Pg, the inheritance, special datatypes and some notes on tweaking and probably schemas.
Also the external projects are interesting - as I recall there is a GPS related extension around.

IMHO, 'course.
_________________
Quis custodiet ipsos, custodes?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum