We have used postgresql since version 7.3 and have just installed a system on Solaris 10 with postgresql 8.2. Everything works very well. We use PGADMINIII as the DBA. Again everything works. When we first started developing this application on Linux we struggled with DB2, it size and lack of good documentation was enough to say quit. W e found out about postgresql and did the conversion in 1 weekend. Most of the table creation scripts worked without change. We never looked back. Very nice.
Rich,
Thanks for the comments. Isn't it amazing how small a postgres install is compared to any of the "big 3"?
I think postgres might be the most standards compliant also.
LewisC
I agree. It is like having an embedded database. Our application is Point of Sale, Inventory, etc and light weight CRM and as of yet there is not a need for the customer to have a DBA. BTW we have also integrated it with Sun's Java Application Server 8.1 and 8.2 and iReport. About to only issue we are not sure of is how well it works when we are using container managed transactions. Developing a good test and running it is time consuming.
Yeah, I've recently spent a lot of time testing various features and it seems like some very simple things can suck up entire days.
I haven't used Sun's app server. I've mostly worked with websphere and Oracle AS (with Oracle on the backend).
LewisC
The problem here is that PostgreSQL doesn't list "supported platforms" in an official manner, because there's no commercial entity to guarantee what's supported and what isn't. Compare http://www.mysql.com/support/
sup...enterprise.html with http://www.postgresql.org/docs/8...-
platforms.html
I would bet PostgreSQL works on more actual platforms, but you can't confirm that from the documentation.
Greg,
That's a good point. Now that the postgres project has that wiki going, I wonder if people would be willing to enter their hardware and os configurations? That way we would have a record of what exactly works.
Hmmm. Worth a thought I guess.
LewisC
There were some ideas tossed around recently related to listing the systems that participate in the build farm as a known compatible set. The developers are pretty serious about making sure all the buildfarm systems stay in good shape. That never went anywhere, but the idea might resurface.
We offers conversion from various file formats and media to other. With our extensive technical expertise in this area, we are almost certain to cater to any of your complex data
conversion requirements, be it in any format, file types or media.
My experience with postgres has been on popular distro's of Linux and Solaris 10. I would provide the details if that would help. Some were builds and some were from RPMS or .bins.
I really like postgreSQL with all of its features. But here in my company, they always asking me about the postgres capability comparing with any commercial database. I spent a lot of time just to search the details about commercial db feature that postgre has and doesn't on the net.
Does any one know where can i find it?
If you want to see comparisons to other databases, see my entry here: http://postgresqldbnews.blogspot...thing-
else.html
Hope that helps,
LewisC
Another place to look is in a book from O'Reilly, "SQL IN A NUTSHELL". It isn't so much a comparison as much as a quick reference on SQL and compares the differences in implementation for DB2, Oracle, postgresql, mysql and SQL Server.
Hi!
This is Nice Blog!
XML to send application data to browsers and to business applications. XML is well suited for the interchange of data, since XML documents are self-describing, easily parsed and can represent complex data structures. Also, there is a wide variety of high-quality, inexpensive tools for parsing and transforming xml conversion. When using XML for data interchange, ideally, the sending application will be able to export an XML document, and the receiving application will be able to import an XML document. Unfortunately, many legacy applications use flat files to import or export data. So, companies will need to convert flat files into XML documents when sending data to XML-capable applications. Likewise, companies will need to convert XML documents into flat files that can be imported into legacy applications.
Hi!
This is Nice Blog!
The Extensible Markup Language (XML) is a general-purpose specification for creating custom markup languages.Its primary purpose is to facilitate the sharing of structured data across different information systems, particularly via the Internet,and it is used both to encode documents and to serialize data. xml conversion is one of conversion methods.It is comparable with other text-based serialization languages such as JSON and YAML
Commenting by HaloScan
