public inbox for [email protected]
help / color / mirror / Atom feedFrom: Josh Kupershmidt <[email protected]>
To: Joshua Berkus <[email protected]>
Cc: w^3 <[email protected]>
Subject: Re: Advantages page out of date
Date: Fri, 18 May 2012 16:17:58 -0700
Message-ID: <CAK3UJRFdBT8m3yh_0m84rGdw5b-GqYn7_kHL0eBAKuvhxNqUYg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAK3UJRGOyQ7ukXGH7Bdv7Gq1csvkdH8LMd+HErHaBBYnjGaBMw@mail.gmail.com>
<[email protected]>
On 5/18/12, Joshua Berkus <[email protected]> wrote:
> No question. It's not remotely the only page which is horribly out of date,
> either.
>
> Think you could write up replacement text for the page?
Sure. A quick fix (patch: advantages_quickfix.diff) would be to remove
just that line, and leave Hot stand-by covered by the entry for
'Replication'.
I think a better solution (patch: advantages_link_matrix.diff) would
be to simply link the user to the Feature Matrix, instead of trying to
summarize some arbitrary subset of those features under Technical
Features.
If we did want to keep something like the Technical Features section
around, I think its scope should be narrowed down to features which
are rare, nonexistent, or limited in our competitors. Support for
Unicode, sub-selects, views, etc. may have been cutting-edge features
back when that page was written, but is not such a draw these days.
Things like SP-GiST, KNN, per-transaction durability control, SSI,
SE-Postgres, transactional DDL, JSON and Range types, etc. along with
a summary of why they're better than our competitor implementations
would make for an interesting read IMO. But this kind of prose seems
like it'd be better suited for the wiki anyway... there's not already
a page like that, other than the comparisons against MySQL, is there?
I'd be happy to help start a page like that.
Josh
Attachments:
[text/x-patch] advantages_quickfix.diff (1.3K, 2-advantages_quickfix.diff)
download | inline diff:
diff --git a/templates/pages/about/advantages.html b/templates/pages/about/advantages.html
new file mode 100644
index 30d32a6..1ba31c6
*** a/templates/pages/about/advantages.html
--- b/templates/pages/about/advantages.html
***************
*** 49,55 ****
<li>Fully ACID compliant.</li>
<li>ANSI SQL compliant.</li>
<li>Referential Integrity.</li>
! <li>Replication (non-commercial and commercial solutions) allowing the duplication of the master database to multiple slave machines.</li>
<li>Native interfaces for ODBC, JDBC, .Net, C, C++, PHP, Perl, TCL, ECPG, Python, and Ruby.</li>
<li>Rules.</li>
<li>Views.</li>
--- 49,55 ----
<li>Fully ACID compliant.</li>
<li>ANSI SQL compliant.</li>
<li>Referential Integrity.</li>
! <li>Replication (built-in and third-party solutions) allowing the duplication of the master database to multiple slave machines.</li>
<li>Native interfaces for ODBC, JDBC, .Net, C, C++, PHP, Perl, TCL, ECPG, Python, and Ruby.</li>
<li>Rules.</li>
<li>Views.</li>
***************
*** 63,69 ****
<li>Stored Procedures.</li>
<li>Native SSL support.</li>
<li>Procedural languages.</li>
- <li>Hot stand-by (commercial solutions).</li>
<li>Better than row-level locking.</li>
<li>Functional and Partial indexes.</li>
<li>Native Kerberos authentication.</li>
--- 63,68 ----
[text/x-patch] advantages_link_matrix.diff (1.8K, 3-advantages_link_matrix.diff)
download | inline diff:
diff --git a/templates/pages/about/advantages.html b/templates/pages/about/advantages.html
new file mode 100644
index 30d32a6..18b28a8
*** a/templates/pages/about/advantages.html
--- b/templates/pages/about/advantages.html
***************
*** 45,77 ****
<a name="features"></a>
<h2>Technical Features</h2>
! <ul>
! <li>Fully ACID compliant.</li>
! <li>ANSI SQL compliant.</li>
! <li>Referential Integrity.</li>
! <li>Replication (non-commercial and commercial solutions) allowing the duplication of the master database to multiple slave machines.</li>
! <li>Native interfaces for ODBC, JDBC, .Net, C, C++, PHP, Perl, TCL, ECPG, Python, and Ruby.</li>
! <li>Rules.</li>
! <li>Views.</li>
! <li>Triggers.</li>
! <li>Unicode.</li>
! <li>Sequences.</li>
! <li>Inheritance.</li>
! <li>Outer Joins.</li>
! <li>Sub-selects.</li>
! <li>An open API.</li>
! <li>Stored Procedures.</li>
! <li>Native SSL support.</li>
! <li>Procedural languages.</li>
! <li>Hot stand-by (commercial solutions).</li>
! <li>Better than row-level locking.</li>
! <li>Functional and Partial indexes.</li>
! <li>Native Kerberos authentication.</li>
! <li>Support for UNION, UNION ALL and EXCEPT queries.</li>
! <li>Loadable extensions offering SHA1, MD5, XML, and other functionality.</li>
! <li>Tools for generating portable SQL to share with other SQL-compliant systems.</li>
! <li>Extensible data type system providing for custom, user-defined datatypes and rapid development of new datatypes.</li>
! <li>Cross-database compatibility functions for easing the transition from other, less SQL-compliant RDBMS.</li>
! </ul>
{%endblock%}
--- 45,52 ----
<a name="features"></a>
<h2>Technical Features</h2>
! <p>Please see the <a href="/about/featurematrix/">Feature Matrix</a> for a summary of PostgreSQL's features.
! </p>
!
{%endblock%}
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Advantages page out of date
In-Reply-To: <CAK3UJRFdBT8m3yh_0m84rGdw5b-GqYn7_kHL0eBAKuvhxNqUYg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox