|
Sponsored Links
Resources
Enterprise Java
Research Library
Get Java white papers, product information, case studies and webcasts
|
|
Message #310657
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
 |
Re: PostgreSQL 8.4 now available
Great progress!
Btw: does anyone use a reliable multi-master cluster solution for postgresql?
|
|
|
Message #310662
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
At least one advantage PostgreSQL has over 'Commercial Open Source' databases: Nobody can buy PostgreSQL.
|
|
|
Message #310663
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
Great progress!
Btw: does anyone use a reliable multi-master cluster solution for postgresql?
Not really.
Having tried sequoia and ha-jdbc but never felt comfortable with neither of them due to some problems found.
Currently i am using the PITR way to warm-standby replicate my DB. Although a real cluster would be nice.
Looking forward to see if anyone knows any other reliable, production ready multimaster replication; of course, open source ;-)
Regards
|
|
|
Message #310674
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
I am not a database expert, so I would like to ask:
How does Postgres stand in comparison to the market in terms of performance and features? Specilly incomparison to oracle and mysql.
|
|
|
Message #310678
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Great news
looking forward to test the new version out in the next prod environment I setup. Excellent that postgresql works well together with jopr.
|
|
|
Message #310684
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
I am not a database expert, so I would like to ask:
How does Postgres stand in comparison to the market in terms of performance and features? Specilly incomparison to oracle and mysql.
PostgreSQL is way more stable than MySQL. Also, PostgreSQL has good support for stored procedures and custom functions while SPs in MySQL are a joke. Query language in PostgreSQL is also much more rich. MySQL might be faster for simple operations, but PostgreSQL completely demolishes it in complex queries.
And Oracle... Well, it's hard to find anything which has more features than Oracle :)
The only major missing piece in PostgreSQL is synchronous replication...
|
|
|
Message #310685
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
The only major missing piece in PostgreSQL is synchronous replication...
Some other major pieces are missing, like true table partitioning and the ability to execute a single query in parallel using multiple cpus and core.
Nevertheless, PG is truly an awesome database and the relatively low market share is something that continues to surprise me.
|
|
|
Message #310686
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
MySQL is great for simple read only and/or simple query transaction processing, but it chokes in high throughput environment when complex transactions are involved.
We build a high transaction application on top of MySQL and had to really wonder why when it actually went in production and the throughput increased. We've previously worked with Postgres in a relatively complex application and it performed without a hickup. Any performance issues we ever found had to do with application CPU or IO bottlenecks, Postgres executed hundreds of queries per transaction in about .003 percent of the transaction time. This of course doesn't say much, since it's application specific. It also doesn't discount MySQL as a viable alternative, since it can be tuned for high scalability requirements and is used by some of the most high traffic sites out there. I due wonder if majority of mysql transactions in those environments are read only.
For highly scalable read/write scenarios, I think relational databases in general (at least their current implementations) are not scalable without a huge hardware investment and even then you're at the mercy of being able to scale up. That's where partitioning/sharding and even different data models are used. You can't possibly scale a highly read/write database up and the only current way to really scale horizontally is through partitioning. I wish these features where more available through some database features, vs. having to roll your own each time.
Also, in memory stores, like Terracota and GigaSpaces that provide data partitioning and replication functionality can be used in conjunction with the ACID data storage, which can be used for eventual consistency.
Ilya
|
|
|
Message #310758
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Re: PostgreSQL 8.4 now available
I am really looking forward to trying out the common table expressions (CTEs, "WITH" clause), and windowing functions.
These are features I rely on frequently in Oracle, and it's great to see PostgreSQL support for them.
I am surprised to see that "WITH" is not explained in many SQL books. I use it every day, and find that it is a very important feature for many non-trivial queries.
John Hurst
Wellington, New Zealand
|
|
|
| New content on TheServerSide.comNew content on TheServerSide.comNew content on TheServerSide.com |
|
|
Now that Oracle is absorbing Sun Microsystems, there mixed views on what should come of the Java Community Process (JCP). While some say Oracle should become the new steward of Java and keep the JCP much as it was, others argue that it may be time to open-source this widespread language.
(November 24, Article)
Reza Rahman explores the features of the proposed JSR 299, Contexts and Dependency Injection for Java EE (CDI). When approved, it promises to be a key feature of Java EE 6.
(November 2, Article)
SAML is an XML-based standard for exchanging authentication and authorization data between security domains. The single most important problem that SAML was created to solve is the Web browser Single Sign-On problem. Many organizations are debating whether to stay with version 1.1 or move to 2.0. This article makes observations about both options.
(September 28, Article)
Joe Ottinger takes a look at how people learn, and applies it to the practice of programming. He notes that understanding how people learn is an essential part of working in a programming team.
(September 22, Article)
Stephen Maryka gave us an article about the Asynchronous Web and posed a number of questions that get examined like an approach to delivering Asynchronous Web capabilities through extensions to existing Java EE technologies.
(July 14, Article)
JavaServer Faces Flex goal is to provide users capability in creating standard Flex components, part of flexSDK which is open sourced through MPL license, as normal JSF components. This article by Ji Hoon Kim will provide an overview of creating a simple multilingual JSF page consisting of JSF Flex tags.
(June 29, Article)
In this session Jeff explores the key characteristics of successful SOA projects. He covers some of the patterns, and anti-patterns, tool sets, and strategies that he himself learned the hard way. Last, he provides a strategy and blueprint for achieving a high likelihood of success in your SOA project.
(June 23, Tech Talk)
Ari Zilka, CTO of Terracotta, Inc., talks about the new features in Terracotta 3.1, announced during JavaOne and available now.
(June 15, Tech Talk)
In this Tech Talk, Josh Long explores an integration challenge using Spring Integration and walks through the implementation, employing and expanding on the basic patterns of Enterprise Application Integration to tie together components into a function integration solution, and then demonstrates how Spring Integration helps address the integration requirements.
(June 15, Tech Talk)
In this Tech Talk, David Geary teaches you: The basics of Google Web Toolkit; How to implement Ajax-enabled applications in Java; Internationalization; Hooking into the browser history mechanism; Remote procedure calls.
(June 4, Tech Talk)
Jon Kern discusses the best architecture/technical solutions and ensure that they are repeated by all developers. By tackling the architecture up-front in a serial manner, subsequent parallel development will be much more manageable and predictable.
(May 28, Tech Talk)
This keynote describes the frustrations of modern knowledge workers in their quest to actually get some work done, and solutions for how to guard yourself against all those distractions. Neal Ford talks about environments, coding, acceleration, automation, and avoiding repetition as ways to defeat the misguided attempts to sap your ability to produce good work.
(May 26, Tech Talk)
Gil demonstrates how new, aggressive uses of already abundant compute capacity by common applications offer competitive value for application designers.
(May 21, Tech Talk)
Chris Keene introduces WaveMaker as a new way to automate the ability to generate Hibernate classes in order to more quickly bring OR mapping into an application.
(May 19, Article)
Mastering EJB was one of the original and most influential EJB books in the industry. Mastering EJB III now returns with two new expert co-authors, updated for EJB 2.1 and 30% new chapters including security, integration, best practices, open source, and more.
(Book PDF Download)
The Application Server Matrix is a detailed listing of J2EE vendors and their application server products, with information on latest version numbers, J2EE spec support and licensing, pricing, platform support, and links to product downloads and reviews.
(Application Server Comparison Matrix)
|
|
