Wordpress First Steps

This article introduce WordPress, and give a quick summary on  installation and rapid site setup with some useful plugins. At the end there is a list of sites for themes review.

Introduction

WordPress (WP) is an Open Source Content Management System (CMS), powered by PHP and MySQL. It was Born as a Weblog (blog) publishing system, but is evolved in a complete CMS application; IMHO is the most fast and intuitive available.

Actually (jan 2011) is the most used CMS for building web sites.

Installation

Quick version of installation instructions:

  1. Download and install WordPress
  2. Create a DB for wordpress
  3. Rename wp-config-sample.php to wp-config.php; then fill it with your database details
  4. Place WordPress files in desired location on your Web Server
  5. Run the WordPress installation script accessing wp-admin/install.php

Complete page about installing:

Plugins

WordPress community makes available a lot of plugins. Those are useful for me.

Themes Review

Reviewing themes is a vaste topic, so i leave only a list of links, with most interesting themes.

HSQLDB Intro

This article introduce HSQLDB, and give a summary,launching ad some usage examples.

Introduction

HSQLDB (HyperSQL Database) is a relational DB engine written in Java. It offers a fast, small Database engine which offers both in-memory and disk-based tables. Additionally, it include tools like a minimal web server HSQLDB is currently being used as database and persistence engine in many open source software projects (see).

Local copies of official documentation ( v.2.0 )

Launching – Running the server

You can start the server in different ways: as HSQL Server, as HTTP Server as HTTP Servlet or from Java Program.

The preferred way of running the DB Server (and the fastest one) is to launch the HSQL Server from command prompt

java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb

The above example launch HSQL Server ( org.hsqldb.server.Server ) with one database, named “xdb” ; backed on files named mydb.* ( in current prompt directory ). To launch the HTTP Server, replace the main class for the server with

org.hsqldb.server.WebServer

The server can also be launched as HTTP Servlet. this method also use the HTTP protocolit is used when a separated servlet engine (or application server) provides the access to the DB.

As we said the server can be launched from Java Program. The code below make an example of launch and execute statements.

Server hServer;
try{
  hServer = new Server( );
  hServer.setLogWriter( null );
  hServer.setSilent( true );

  // database name and set file storage
  hServer.setDatabaseName( 0, "xdb" );
  hServer.setDatabasePath( 0, "file:testdb" );

  // starts the database
  hServer.start();

  // now connect to the db
  Connecction conn = null;
  //
  try{
    Class.forName("org.hsqldb.jdbcDriver");
    // connect
    conn = DriverManager.getConnection(
      "jdbc:hsqldb:hsql://localhost/xdb", "sa", "");
    // execute statement
    conn.prepareStatement("drop table testtable;")
      .execute();
    conn.prepareStatement(
      "create table testtable ( id INTEGER, name VARCHAR ) ;" )
      .execute();

  } finally {
    // closing connection
    if( connection != null ) {
      conn.close();
    }
  }
} finally {
  // closing server
  if( hServer != null ){
    hServer.stop();
  }
}

For more detais see

Conclusions

This article explained rapidly how to use HSQLDB for common purposes. For whose needs clarification, follow references: main site: http://hsqldb.org/

Eclipse Conferences 2010

This document is a resume of some Eclipse conferences i’ve been partecipated

  • Eclipse Banking Day – Copenhagen: co-organized by IBM and Eclipse Foundation, directed to senior technical developers, architects and managers in the finance industry.
    • main topics: eclipse as platform for application development; leveraging Eclipse modeling technology for data exchange; collaboration with the open source community.
    • presentations on: tecnhologies, demos, applications and success stories.
    • language: English
    • interesting technologies: BIRT, RCP, RAP
    • link: http://wiki.eclipse.org/Eclipse_Banking_Day_Copenhagen
  • Eclipse SOA Day – Rome: co-organized by Engineering Group and Eclipse Foundation, focusing on the enterprise adoption of Eclipse-based solutions.
    • main topics: SOA (service oriented architectures), integration and interoperability domains
    • presentations: technologies, demos, concrete applications.
    • languages: English and Italian
    • interesting technologies: Workflows on Eclipse SOA, SwordFish, RCP integration
    • link: http://www.spagoworld.org/xwiki/bin/view/openevents/Agenda
  • Eclipse Enterprise Modeling Day – Zurich: co-organized by UBS and Eclipse Foundation; directed to IT architects and IT strategists
    • main topics: model driven development approach for enterprise application development
    • presentations: technologies, demos, concrete applications.
    • languages: English and Deutsch
    • most interesting: EMF, Xtext, Graphiti
    • link: http://wiki.eclipse.org/Eclipse_MDD_Day