473,898 Members | 2,914 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 12588
We are in the process of porting a logistics application to Postgres from a
Progress Software database. We have about 75 employees and will be putting
Postgres to work in a real time business situation where there are lots of
transactions. Once we are successful in this endeavor, how can we get stories
like that out to people who would care to know? I know this is a small
business project, but will it help to advertise that the "little" guys are in
the trenches doing this kind of thing?

On Tuesday 13 January 2004 11:32 am, Bob Powell wrote:
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


--
"Posterity -- you will never know how much it has cost my generation
to preserve your freedom. I hope you will make good use of it."

--John Quincy Adams

Work: 1-336-372-6812
Cell: 1-336-363-4719
email: te***@esc1.com

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

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

Nov 22 '05 #21
> 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

Nov 22 '05 #22
Terry Lee Tucker wrote:
We are in the process of porting a logistics application to Postgres from a
Progress Software database. We have about 75 employees and will be putting
Postgres to work in a real time business situation where there are lots of
transactions . Once we are successful in this endeavor, how can we get stories
like that out to people who would care to know? I know this is a small
business project, but will it help to advertise that the "little" guys are in
the trenches doing this kind of thing?
Absolutely. If you have a case study you can point over to pgsql-advocacy.

Sincerely,

Joshua D. Drake
On Tuesday 13 January 2004 11:32 am, Bob Powell wrote:

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


--
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 #23
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

Our doc search sucks. No question... there has been some work recently on it
but it doesn't seem to be that reliable. So you have us on that one.

Sincerely,

Joshua D. Drake
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

--
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 #24
Mensaje citado por Matt Davies <ma**@mattdavie s.net>:
Quoting "Joshua D. Drake" <jd@commandprom pt.com>:

MySQL has what 19 million in the bank?


I only point out what the userbase is feeling. I have never been attacked as
an
idiot when using MySQL - I have always had helpful responses instead of
"RTFM"
as I have seen and experienced here (and with qmail). To many people
starting
the decision making process one looks at the type of support and how the
group
makes you feel. You don't risk the company or project on potential
hostility.


Oh, please! I have never seen such a better community then this one (well, some
exceptions come to mind right now, but it's still within the best).

I have personally found GREAT replys from the developers (Tom Lane comes to
mind, saving me lots of time in some ocations), and users of this list.

Don't missunderstand me. Everyone (including me) some times makes responces in a
bit of a hard manner, but I think you have to see the whole picture, and not a
par of snapshots.

P.D.: BTW, RTFM is very good. You can learn alot from them. ;-)

--
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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #25
> >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 docsI could find exactly what I was looking for almost immediately. When I usethe postgres doc search feature I don't get the same experience. It is

Our doc search sucks. No question... there has been some work recently on

it but it doesn't seem to be that reliable. So you have us on that one.


Uh, I don't have one on you the mysql team does. I haven't used mysql in
over a year and don't intend to again (at least not for any app I write
myself at leaset). I assume that the mysql website is just using the mysql
full text search. Having used the mysql full text search it does not
surprise me that the search on their website search is so good. I always
asummed (read hoped) that the postgres full text search was just as good. I
hope the bad website search is not a reflection of the quality of the full
text search in postgres.

Does anyone have any experience with postgers full text search?

Perhaps someone could get two birds with one stone and make a good full text
search engine for postgres (how hard could it be if mysql has such a good
one :-) ) and use it to index the postgres docs.

Of course maybe mysql.com uses some other proprietery seach.
---------------------------(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 #26
Mensaje citado por "Joshua D. Drake" <jd@commandprom pt.com>:
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

Our doc search sucks. No question... there has been some work recently on it
but it doesn't seem to be that reliable. So you have us on that one.


I personally think that the search criterion is what's wrong here. The speed can
be fixed with optimization in the server.

--
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 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 #27

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.

J
Perhaps someone could get two birds with one stone and make a good full text
search engine for postgres (how hard could it be if mysql has such a good
one :-) ) and use it to index the postgres docs.

Of course maybe mysql.com uses some other proprietery seach.
---------------------------(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

--
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 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 22 '05 #28
Quoting Martin Marques <ma****@bugs.un l.edu.ar>:
Oh, please! I have never seen such a better community then this one (well,
some
exceptions come to mind right now, but it's still within the best).

I have personally found GREAT replys from the developers (Tom Lane comes to
mind, saving me lots of time in some ocations), and users of this list.

Don't missunderstand me. Everyone (including me) some times makes responces
in a
bit of a hard manner, but I think you have to see the whole picture, and not
a
par of snapshots.

P.D.: BTW, RTFM is very good. You can learn alot from them. ;-)


This thread is getting long and out in never-never land. I have RTFM. In fact,
many times. As a matter of practice I subscribe long before I post. I RTFM, I
google, attempted to search the docs and lists, ...

My comments come from my experiences and others. Yes, Tom Lane has wonderful
advice and help.

I do not mean to call the PG baby ugly (as I fear some people have taken it), I
only mean to point out some areas (as others have in this thread) that could be
improved upon that would greatly enhance PG.

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.

OK, I am done.


---------------------------(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 #29
> >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?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #30

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

Similar topics

1
2671
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
9993
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
9839
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
11256
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10481
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
9658
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
7187
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5877
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
6076
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3303
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.