PostreSQL建网站应该用哪个CMS，最新的WordPress能用吗 [英] Which CMS should be used to build web site using PostreSQL, can latest WordPress used

问题描述

我正在寻找一种方法来构建使用 PostreSQL 来存储网页并允许用户修改它们的网站.

I’m looking for a way to build web site which uses PostreSQL to store web pages and allow users to modify them.

管理员用户应该能够使用浏览器中的 html 编辑器创建和更改页面.站点使用 Apache 在 Debian Squeeze x64 VPS 中运行.这个 VPS 中已经运行了 Mono 2.8 和 PostreSQL 9.1 应用程序.

Admin user should able to create and changed pages using html editor from browser. Site runs in Debian Squeeze x64 VPS using Apache. There are already Mono 2.8 and PostreSQL 9.1 applications running in this VPS.

没有安装 PHP，但如果软件需要，它可能会安装.在同一台服务器上维护 MySql 和 PostreSQL 可能不合理，所以我正在寻找一种使用 Postgres 的方法.

There is no PHP installed but it can probably installed if software requires this. Maintaining MySql in addition to PostreSQL in same server may be not reasonable so I'm looking for a way to use Postgres.

CMS 应该为网站提供漂亮的深色主题，这样就不需要网页设计师了.

CMS should provide nice dark theme for web site so that web designer is not required for this.

WordPress PostreSQL 插件页面 http://wordpress.org/extend/plugins/postgresql-for-wordpress/声明这个插件与最新的 wordpress 不兼容.这个插件也有一段时间没有更新了.Joomla！不在 Postgres DBMS 中运行.Drupal 7 似乎支持它，但与 WordPress 相比 Drupal 使用量更小.

WordPress PostreSQL plugin page http://wordpress.org/extend/plugins/postgresql-for-wordpress/ states this this plugin is not compatible with latest wordpress. Also this plugin is not updated for a while. Joomla! does not run in Postgres DBMS. Drupal 7 seems to support it but comparing to WordPress Drupal usage is smaller.

此站点中运行着单声道 ASP.NET 应用程序，因此使用一些 ASP.NET CMS 似乎是最好的.最新的 Orchad 不能在 Mono 和 PostgreSQL 中运行.

There are mono ASP.NET applications running in this site so using some ASP.NET CMS seems best. Latest Orchad does not run in Mono and PostgreSQL.

如何在 PostreSQL 9.1 中使用最新的 WordPress?哪种 CMS 软件最适合 PostreSQL?

How to use latest WordPress with PostreSQL 9.1 ? Which CMS software is best for PostreSQL?

推荐答案

在同一台服务器上维护除PostgeSql之外的MySql可能不合理

Maintaining MySql in addition to PostgeSql in same server may be not reasonable

我不是专业的系统管理员，但我不确定这是不是真的.这是一个服务器故障问题，据称并行运行都可以正常工作:https://serverfault.com/questions/35934/installing-and-running-mysql-and-postgresql-8-4-side-by-side

I'm not a professional sysadmin, but I'm not sure that's true. Here is a Server Fault question where it is claimed that operating both in parallel works fine: https://serverfault.com/questions/35934/installing-and-running-mysql-and-postgresql-8-4-side-by-side

mySQL 是 PHP 世界中的准行业标准，因此最大的产品都使用它，而在 WP(和大多数其他产品)的情况下，它是唯一支持的数据库.将 Postgres 支持作为要求添加会严重限制您的选择，因此将 mySQL 与 Postgres 并排安装可能是一个好主意.

mySQL is the quasi industry standard in the PHP world, so the biggest products all use it, and in the case of WP (and most others), it's the only database suppored. Adding Postgres support as a requirement seriously limits your options, so installing mySQL side-by-side with Postgres may be a good idea.

也就是说，Drupal 是一个完美的、备受推崇的 CMS 框架，如果它的功能和架构适合您的目的，那么没有理由不选择它.

That said, Drupal is a perfectly fine, well-esteemed CMS framework and if its features and architecture work for your purposes, there is no reason not to choose it.

这篇关于PostreSQL建网站应该用哪个CMS，最新的WordPress能用吗的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！