PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

SweetRice is a open source website management system[CMS],it support PostgreSQL and Mysql,Sqlite.

We think,PostgreSQL is a excelent database for website,if your web hosting support PostgreSQL,you can build your own site use SweetRice and PostgreSQL now:

1. Download SweetRice from download.html
2. Unzip the package to your website folder,eg:sweetrice
3. Visit the folder via web browser,eg http://yourdomain.com/sweetrice/
4. Choose database PostgreSQL when install SweetRice ,input PostgreSQL database information,server name,server port,username,password,database name etc.
5. When all thing done,you will get your PostgreSQL website.

Good news!

you can checkout SweetRice from Google code hosting now:

svn checkout http://sweetrice.googlecode.com/svn/trunk/

SweetRice project home at google code hosting:http://code.google.com/p/sweetrice/

SweetRice V0.6.4 release - support TinyMCE with upload management plugin

time to upgrade your blog/cms program.

Change log

======================================
Change log V0.6.4 4/27/2010

Upgrade Dashboard
- support TinyMCE with file management plugin,re-write post add/modify page.

Key Features:

• Support database:Mysql,Sqlite,PostgreSql
• Support comments,track user agent .
• 1 click eligible for changing theme,and easily edit it.
• easy to backup database.
• easy to converter database.
• Support custom plugin and ease to install.
• Support website database time line,you can take your site to every version.
• Support sitemap,link,tags,and rssfeed auto create.
• Support post entries with attachment and track download times.
• Support SEO
• support cache option,you can save more time when query database.
• support custom template
• support TinyMCE [new]

SweetRice upgrade to 0.6.1 at 2010-3-13,some upgrade notice is here

Upgrade Dashborad

• - add database optimizer - this feature is for database optimize,you can via it clean and optimize database,for Mysql,that is execute "Optimize table " ,for Postgresql :"vacuum analyze ",Sqlite :"vacuum",i think it can help you when database query slow.
• - upgrade dashboard style

Fix : if get_magic_quotes_gpc = ON,data insert error.

* Important :when php setting get_magic_quotes_gpc = ON,php automatic escape string and add backslash before single-quote and  double quote,but SweetRice [since 0.6.0 ]  custom function for escape string,so must filter the backslash,if your php setting get_magic_quotes_gpc = ON ,you may need upgrade SweetRice 0.6.1 version.

If you have any question,please submit comment via form below.

If your web hosting provider support PostgreSql,you can easy converter database from Mysql to PostgreSql use SweetRice,many people likes Mysql ,me too,but in same time,mysql's user more then postgresql's user on web server,so connect to mysql server slower then connect to postgresql.

Now SweetRice allow you ease converter your database to postgresql from mysql,you can test which one fastest and use it.

Download and enjoy SweetRice now

If you find any bug of SweetRice,please submit it here,thanks.

Change log V0.5.5.5 1/23/2010

Upgrade Dashborad
- add Database converter .
- update plugin list
- update database backup.
- update search form.

Change log V0.5.5.4 1/13/2010

Upgrade Dashborad
- add tiny head mode.
- add quick link of plugin list.

Change log V0.5.5.3 12/22/2009

Upgrade Dashborad - view chart

Change log V0.5.5 12/8/2009

• Change SweetRice core.
• Upgrade theme.
• Support AJAX.
• Upgrade core for Sqlite.
  

Change log V0.5.4 2009/11/29

• Fix some minor bug.
• Upgrade classic theme.

Change log V0.5.3 11/13/2009

• Upgrade theme.

Change log V0.5.2 11/3/2009

• Support database PostgreSql
• fix bug:tag list error
• fix bug:attachment link in non-rewrite mode error 11/2/2009
• fix some minor bug.
• add database time line,your web site can go back to every history.

Change log V0.5.1 2009-11-1

• Support database PostgreSql
• fix bug:tag list error

Change log V0.5.0 10/15/2009

• Fix bug:comment form include postss url.
• Change attachment url non-absolute for diffrent domain.
• Add database Sqlite ,user can select Sqlite for SweetRice
• Add 404 page for "Page not found"
• SweetRice plugin add support Sqlite ,for develop SweetRice plugin,you can see Subscriber document,which include _plugin/subscriber.

Change log V0.4.4 2009-8-28

• Support php short tag => off
• more easy to use as old version
• change user track ,you can enable it in dashborad [default is disable]
• User track data use SQLite3 ,fast and reliable.

Change log V0.4.2 2009-7-21

• Add support for dashboard directory custom
• Fix bug:view post in non-rewrite mode.
• Change category link auto creat by time() as post sys-name;

Change log V0.4.1 2009-7-16

• Change .htaccess RewriteBase output
• php short_tag ON auto set

Change log V0.4.0 2009-6-24

• support password recovery.
• Change sitemap.xml output[include true time of post]

Change log V0.3.1 2009-5-19

• change database table posts and category
• support parent category.

Notice:for update your SweetRice database table,please open the link http://yourdomain/upgrade_db.php?sql=upgrade_0.3.0-0.3.1.sql
when you update your database,please remove the script upgrade_db.php and upgrade_0.3.0-0.3.1.sql from your root directory.

Change log V0.3.0 2009-5-12

• add plugin support,user can creat own plugin for SweetRice
• add example plugin emaillist:allow user subscribe.
• fix bug sitting => change mysql server.

Change log V0.2.1 2009-4-15

• add theme allrp which basic-cms.org used.
• update dashborad style design
• modify comment form,add url.

Change log V0.2.0 2009-4-12

• add attachment download times track.
• add more language pack.
• add SweetRice update check.
• modify plugin fckeditor php4 config same to php5
• fix bug sitting => site close bug.
   

Sweetrice new logo:

Sweetrice old logo:

When SweetRice upgrade to 0.5.5,we want upgrade the logo too,new version of SweetRice more easy,more simple.

If you have any suggestions, ideas, comments please let us know.^_^
 

Since v0.4.2 ,SweetRice allows user change dashboard directory from the default "as" to any directory,this means you can custom remote login link for dashborad:

When you change "as" to other directory,only you can login to the dashboard,so your SweetRice becomes more secure,maybe can  reduce attack from other people,this is very important but very easy.

SweetRice is a most simple program for website management.Perfect support web standards,easy to setup and use.best value is SEO.Support 3 kinds of database:Mysql,Sqlite,PostgreSql,support database time line..

Key Features:

Easy to be installed and used.

1. Support database:Mysql,Sqlite,PostgreSql
2. Support user post comments,and track user agent .
3. 1 click eligible for changing theme,and easily edit it.
4. 1 click backup database.
5. Support custom plugin and ease to install.
6. Support website database time line,you can take your site to every version.
7. Support sitemap,link,tags,and rssfeed .
8. Support post entries with attachment and track download times.
9. Support easy SEO:including url rewrite,keywords,description,title edit in post form.

This is our goal