Loading Twitter updates Loading...
Follow me on Twitter
Main | Next day (Oct 17, 2005) »
20051016 Sunday October 16, 2005

Roller gets some respect From A Baggins Under the Hill (nice looking theme BTW):

There's a surprising (or perhaps not so surprising) number of PHP programs, intricate ones at that, that have developers who didn't bother to abstract away the database layer, and wrote DB-vendor-dependent queries. That's a pretty horrible thing to do, since it ties you quite firmly down to one DB (in many cases MySQL). The SQL code is often very tightly integrate with the display code; it's bad enough in the business layer, but the view layer as well? Good gods.
...
Roller, on the other hand, uses things like Hibernate to abstract away queries from the underlying DB implementations, and Velocity to separate out the display logic from the business logic. And blogging software does have business logic, or a model; blog entries and categories and tags and authentication and the manipulation thereof are not simple. As a result, I see features being added to Roller that I'm surprised to see happening so quickly.

As far as solving the issue with Tomcat 5.5, that's just a matter of updating your $CATALINA_HOME/conf/Catalina/localhost/roller.xml file. Here's what I use for Roller on PostgreSQL:

<Context path="/roller" docBase="roller" debug="99" reloadable="false"
    antiJARLocking="true" antiResourceLocking="false">

    <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="org.postgresql.Driver"
       connectionURL="jdbc:postgresql://localhost/roller"
      connectionName="postgres" connectionPassword="postgres"
           userTable="rolleruser" userNameCol="username" userCredCol="passphrase"
       userRoleTable="userrole" roleNameCol="rolename" />

    <Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource"
              maxActive="20" maxIdle="10" maxWait="100"
              driverClassName="org.postgresql.Driver"
              username="postgres" password="postgres"
              url="jdbc:postgresql://localhost/roller"/>

    <Resource name="mail/Session" auth="Container" type="javax.mail.Session"
              mail.smtp.host="localhost" />
</Context>

Posted in Roller at Oct 16 2005, 01:03:54 PM MDT Add a Comment