l*****s 发帖数: 2109 | |
a*****i 发帖数: 4391 | 2 I am pretty good at it. What do you want to know about it?
【在 l*****s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 因为windows上不方便用?
|
s**********i 发帖数: 711 | 3 s/he wanted to know why it's not popular.
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : I am pretty good at it. What do you want to know about it?
|
a*****i 发帖数: 4391 | 4 Not so much publicity(most of the geeks who use mysql and brag about it can
not write a sql statement with more than two selects.:), but it is a very
solid, very good database. And the development has been very active.
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : s/he wanted to know why it's not popular.
|
s**********i 发帖数: 711 | 5
I don't think they can write one with more than one select in
an SQL statement... :)
what's better than MySQL besides you can write sub-select?
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Not so much publicity(most of the geeks who use mysql and brag about it can : not write a sql statement with more than two selects.:), but it is a very : solid, very good database. And the development has been very active.
|
a*****i 发帖数: 4391 | 6
I haven't used MySQL much. Tell me what you can do in mysql and I will see
if that can be done in pgsql. Functionality-wise, postgresql is very rich that
I dare say it can compete with Oracle. But speed-wise, it is hmm, a little
lacking. hehe... :)
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : I don't think they can write one with more than one select in : an SQL statement... :) : what's better than MySQL besides you can write sub-select?
|
b****e 发帖数: 1275 | 7 compete with oracle? hmm.. how about an equivalent for the connect by
prior? please don't tell me to RTFM
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : I haven't used MySQL much. Tell me what you can do in mysql and I will see : if that can be done in pgsql. Functionality-wise, postgresql is very rich that : I dare say it can compete with Oracle. But speed-wise, it is hmm, a little : lacking. hehe... :)
|
a*****i 发帖数: 4391 | 8 what does "connect by prior" do? @@
【在 b****e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : compete with oracle? hmm.. how about an equivalent for the connect by : prior? please don't tell me to RTFM
|
b****e 发帖数: 1275 | 9 haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : what does "connect by prior" do? @@
|
a*****i 发帖数: 4391 | 10 compete, compete, my friend, I never said it is NOT inferior. :)
Look at the price tag, and you will find why it can *compete* hehe...
【在 b****e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :) : but on what basis were you making the assertion that it's not inferior : to oracle feature wise.. : connect by prior gives you the hierarchical capabilities.. for example, : to find all children to a given node
|
|
|
b****e 发帖数: 1275 | 11 pricetag wise oracle is the worst.. it's a given. but your original
post says:
Functionality-wise, postgresql is very rich that
I dare say it can compete with Oracle
hehehe :)
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : compete, compete, my friend, I never said it is NOT inferior. :) : Look at the price tag, and you will find why it can *compete* hehe...
|
a*****i 发帖数: 4391 | 12 of course. subselect has been supported in pgsql for a long time.
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : I don't think they can write one with more than one select in : an SQL statement... :) : what's better than MySQL besides you can write sub-select?
|
b****e 发帖数: 1275 | 13 haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : what does "connect by prior" do? @@
|
q***e 发帖数: 90 | 14 Can PostgreSQL support embedded SELECT? In mysql,
the lastest version still does not support it even though
this is an ANSI feature. Not sure why it is not supported
by mySql, is it very difficult?
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Not so much publicity(most of the geeks who use mysql and brag about it can : not write a sql statement with more than two selects.:), but it is a very : solid, very good database. And the development has been very active.
|
s**********i 发帖数: 711 | 15 subselect? I think they didn't implement it for speed reasons.
but just a guess.
【在 q***e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Can PostgreSQL support embedded SELECT? In mysql, : the lastest version still does not support it even though : this is an ANSI feature. Not sure why it is not supported : by mySql, is it very difficult?
|
s**********i 发帖数: 711 | 16
found several comparison pages, like this one:
http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html
so even postgresql supports SQL better than MySQL,
there're still reasons MySQL is used more widely on
web servers. :)
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : of course. subselect has been supported in pgsql for a long time.
|
s**********i 发帖数: 711 | 17
forgot to say, I'm not going to post the content here
even some people are so lazy that they can't go to
any page and read themselves.
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : found several comparison pages, like this one: : http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html : so even postgresql supports SQL better than MySQL, : there're still reasons MySQL is used more widely on : web servers. :)
|
a*****i 发帖数: 4391 | 18 of course. subselect has been supported in pgsql for a long time.
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : subselect? I think they didn't implement it for speed reasons. : but just a guess.
|
a*****i 发帖数: 4391 | 19 FYI, the latest pgsql is 7.2 (stable).
And outer join has been supported since the day of 7.0
【在 s**********i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : forgot to say, I'm not going to post the content here : even some people are so lazy that they can't go to : any page and read themselves.
|
s**********i 发帖数: 711 | 20
and that's probably part of the reason that MySQL is faster
than PostgreSQL? :)
【在 a*****i 的大作中提到】![](/moin_static193/solenoid/img/up.png) : of course. subselect has been supported in pgsql for a long time.
|
l***s 发帖数: 126 | 21 功能太少了吧,比较mysql, sybase和oracle
hoho
【在 l*****s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 因为windows上不方便用?
|
s**********i 发帖数: 711 | 22
if you have read the comparisons, postgresql feature-wise
is much stronger than MySQL. it's comparable to Oracle
in many spects. however, it's not as much or stable as
MySQL.
【在 l***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 功能太少了吧,比较mysql, sybase和oracle : hoho
|