473,889 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Postgress and MYSQL

To whom it may concern:

I find the recent articles in various trade publications a little
disturbing due to the lack of PostgrSQL mention. I continue to see
articles about how IBM may be considering MYSQL for development an
open_source web database.

Why isn't PostgreSQL being considered or talked about by major industry
giants? As a DBA I know that Postgres is far superior to MYSQL but if
the industry directs it's energies towards open-source database this
coming year I think somehow PostgreSQL needs to be represented better.
Bob Powell
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05
67 12583
That's good to hear. What is monogo and is it the problem here? Why don't
it use TSearch if it is better? Is it just a matter of someone taking the
time to set it up?

It is a little more complicated than that. Monogo or whatever it is
called is more
like a web spider that uses postgresql. Thus we can search the entire
postgresql
website. Tsearch is more about text search within PostgreSQL so we would
have
to load the books etc... into the database. That is not as easy as it
sounds.

Also if you are looking for something very cool... check out www.pgsql.ru

Sincerely,

Joshua D. Drake

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #31
> Imagine this: more users, more installations, more (selective) development
fingers. Not all users are rocket scientists, but the video game rule applies
to many: if I can't get it going in X (user preference) minutes then it isn't
worth the trouble. Should PG be limited to only those who are hard core DB
users? If so, I don't think PG will take off as fast.


We need a Postgres vs MySQL Mailing list :)

Honestly PG is easy to get up and running on several distributions. On
RH, service postgres start willgive you a running Postgres (it will do an
initdb if needed). Now just create a user and get going.

PG is only hard because people _think_ it's going to be hard. Or because
it used to be hard. However, it hasn't been hard for a long time.

I also don't think "how fast will this take off" is necesarily a good
design requirement.

Jon

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #32
Mensaje citado por Rick Gigger <ri**@alpinenet working.com>:
Does anyone have any experience with postgers full text search?

It works well but it is my understanding that our docs search doesn't
use PostgreSQL
and TSearch. It uses PostgreSQL monogo search or something like that.


That's good to hear. What is monogo and is it the problem here? Why don't
it use TSearch if it is better? Is it just a matter of someone taking the
time to set it up?


http://www.mnogosearch.com/

Aparently the problem is that this application is already written (I'm talking
about the presentation and buisness layers).

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués | Programador, DBA
Centro de Telemática | Administrador
Universidad Nacional
del Litoral
---------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 22 '05 #33

Personally I don't think it's installing/running the database server that
people have problems with. I used postgresql about 5 years ago and am now
switching back to it from sapdb. I have also used mysql and oracle.

The problems I have had with postgresql is the websites. The website does
very little to make an impression on new users, or to showcase the features
that are available to someone that doesn't know anything about postgresql.
It's difficult to find information, and too much information is outdated
which makes you question everything else. I still am not sure what
replication options are available because of all the conflicting information
that is posted on the various websites (gborg, pgsql.com, postgresql.org,
etc..).

Look I love postgresql, but reality is reality. The database itself is
great, the documentation is pretty good, but a lot of the other things about
postgresql (like the website) need a lot of work. Postgresql gives the
impression of being a second rate disorganized product if you were to just
go by the website alone. Now of course that is not true, but perception
governs people's actions and behavior. If people think postgresql is
difficult, guess what, for all intents and purposes it is. If that
perception leads them to use mysql instead of postgresql, then at some point
you have to face the fact that it's the perceptions that are really
important, regardless of the facts.

Chris

Honestly PG is easy to get up and running on several distributions. On
RH, service postgres start willgive you a running Postgres (it will do an
initdb if needed). Now just create a user and get going.

PG is only hard because people _think_ it's going to be hard. Or because
it used to be hard. However, it hasn't been hard for a long time.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #34
Quoting Rick Gigger <ri**@alpinenet working.com>:
On Wed, 14 Jan 2004, Joshua D. Drake wrote:
Not to mention that PostgreSQL.Org has some of the most complete
documentation
of any software out there.


Yes, I don't understand why people seem to keep complaining about
Postgres' documentation - it is by far the best reference documentation
I've ever come across.

Maybe it's that there isn't much tutorial content in the documentation -
for somebody trying to learn how to do SQL in the first place, it's not
going to hold your hand and I could see how that will turn off newbies.


I used to have that complaint until I got more aquainted with the docs.
When I used to use mysql I found that if I used search feature on their docs
I could find exactly what I was looking for almost immediately. When I use
the postgres doc search feature I don't get the same experience. It is
slow, sometimes doesn't work and rarely gives me what I am looking for.
Then I just started using google to search the docs and realized that just
looking at the TOC is usually good enough and that the postgres docs are
actually excellent. My bad experience with search, as well as the good
experience with mysql search (do other people feel this way) however led me
initially to conclude that the postgres docs were not as good.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match


That is something we can't seem to get across the new folks who think that they
can come from MySQL and move to PostgreSQL. I don't know why- I've heard people
say it because they are both open source, I heard (new) people say that they
should have to read the docs first, the reasons go on and on. What I do know is:

1) Comparing MySQL to PostgreSQL is not a valid technical discussion They're
different products.

2) Assuming the way MySQL does is correct is also invalid. What MySQL does for
MySQL works for them. Over time and with and open mind, I saw that even back
in the 6.x days that PostgreSQL was going to be a more robust product
and as such I had to not only learn PG but I also had to learn more about
relational theory and SQL. I was initially put off too (I remember all my
engineering buddies and I cracking jokes about those "database people") but
at the time, my DB experience was Dbase, Filemaker Pro and Foxpro. I mean
really... *laff*

3) Not being able to "find" something in via search BEFORE even reading the
documentation is somewhat backwards. You have to at least get a feel for
the docs before even know what to look for. That is not to say that the
search engine is not problematic but it is to say that I'm am more and more
convinced that knowing how to search more important than what is being
searched for.

4) As many people pointed out before, a product should not be technical
education it should product education. Some people take it as being rude
we some on-list says use google or check <some other site>. Granted
being told "this is not hand holding" is definitely a slap in the face its
been done to me and I'm sure there is a better way to put it but the
reality is that PG docs are very good. Get some paper and print
they out double-sided- they're an excellent reference. However, you have to
understand the basics first and that simply does not belong on the PG
site (save a link to some community recommendations ).
BTW, I've asked this before but where are the 7.4 docs in PS or PDF format? If
any one needs or wants them, I do have the 7.3.2-US books (admin, user,
programmer & reference) in PS with the duplexing code. They all fit nicely in a
3" ring binder and will compliment any bookshelf :)

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

_______________ _______________ ______
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 22 '05 #35
On Wed, 14 Jan 2004, Rick Gigger wrote:
Does anyone have any experience with postgers full text search?


I just put the docs on my apache server and hit them with htdig or
mnogosearch.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 22 '05 #36
Quoting "Joshua D. Drake" <jd@commandprom pt.com>:
That's good to hear. What is monogo and is it the problem here? Why don't
it use TSearch if it is better? Is it just a matter of someone taking the
time to set it up?

It is a little more complicated than that. Monogo or whatever it is
called is more
like a web spider that uses postgresql. Thus we can search the entire
postgresql
website. Tsearch is more about text search within PostgreSQL so we would
have
to load the books etc... into the database. That is not as easy as it
sounds.

Also if you are looking for something very cool... check out www.pgsql.ru

Sincerely,

Joshua D. Drake

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly


I thought Marc optimized the search last week when this same thread was being
discussed?

Marc?

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

_______________ _______________ ______
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 22 '05 #37

BTW, I've asked this before but where are the 7.4 docs in PS or PDF format? If


They are being worked on ;)
any one needs or wants them, I do have the 7.3.2-US books (admin, user,
programmer & reference) in PS with the duplexing code. They all fit nicely in a
3" ring binder and will compliment any bookshelf :)

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #38
Look I love postgresql, but reality is reality. The database itself is
great, the documentation is pretty good, but a lot of the other things about
postgresql (like the website) need a lot of work. Postgresql gives the
impression of being a second rate disorganized product if you were to just
go by the website alone.
Isn't that true of just about any OSS project? Heck, Linux doesn't even
have a website ;).
MySQL is not an OSS project, it is an OSS product with a commercial
company backing
it. There is a big difference.

Sincerely,

Joshua D. Drake

Now of course that is not true, but perception
governs people's actions and behavior. If people think postgresql is
difficult, guess what, for all intents and purposes it is. If that
perception leads them to use mysql instead of postgresql, then at some point
you have to face the fact that it's the perceptions that are really
important, regardless of the facts.

Chris


Honestly PG is easy to get up and running on several distributions. On
RH, service postgres start willgive you a running Postgres (it will do an
initdb if needed). Now just create a user and get going.

PG is only hard because people _think_ it's going to be hard. Or because
it used to be hard. However, it hasn't been hard for a long time.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #39
Martin Marques wrote:
Not really. I just tried to look in the docs for the explicit for of
a CAST (really trying to find the link to send someone), and I just
couldn't find it. I know it's somewhere there, as I have read it
before, but not even the search engine installed in the interactive
docs seem to find that doc.


If you want to find something in the documentation, there's an index at
the end of it. I realize now that there's no entry for CAST, which I
will fix. But if you find more terms that you would like to see in the
index, write to pgsql-docs.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #40

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2670
by: Liza | last post by:
Hi, I'm a novice to postgress and need to constract a simple tree. In my table I have: regionID int parentID int name char I need to do two functions: find all the children of XXX parent and find if an item is a child of an XXX parent.
0
9969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9810
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10794
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10896
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10443
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9612
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5830
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6029
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4650
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.