It takes suspiciously long to load the page...

Unfortunately sometimes certain browsers get confused even when loading an otherwise valid page. You can try to reload the page, or use the Refresh button of your browser, which usually solves the problem.

User guide Dictionary Description System Content Repository Test Suite Licence User guide
User guide

Table of contents
1 Introduction
1.1 What is hu.dwim.rdbms
1.2 Why not something else?
2 Supported Platforms
2.1 Operating Systems
2.2 Common Lisp Implementations
3 Instal Guide
4 Connect to Database
4.1 Postgresql
4.2 Oracle
5 Tutorial
6 TODO
6.1 with-database-connection
7 Concepts
7.1 Database
7.2 Transaction
Introduction

What is hu.dwim.rdbms

Why not something else?

Supported Platforms

Operating Systems

Common Lisp Implementations

Instal Guide

Connect to Database

Postgresql

To create a 'test' database with a 'test' user: su - postgres createdb test createuser -d -r -l -P test
Oracle

dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb rlwrap sqlplus / as sysdba When reinstalling an "rm /etc/default/oracle-xe" may ease things a lot.
Tutorial

TODO

The create/alter/drop table AST should really be structured like (create (table :name ... :columns ...)) and (alter (table ...)) where the (table ...) part is a shared table description. then a new format sub-protocols should be started for create and alter that works from the shared (table ...) ast node. same applies to sql-create-index, sql-drop-index, sql-create-sequence, sql-drop-sequence introduce a named-sql-syntax-node, add a print-object method for it. :null should be converted back to cl:nil in the query results, except for boolean columns (the columns of the result contain the type information necessary for this). this needs changes in hu.dwim.perec.
with-database-connection

hu.dwim.rdbms is missing a WITH-DATABASE-CONNECTION abstraction that could wrap several WITH-TRANSACTION blocks and also make (execute "DROP DATABASE foo") and prepare the path for connection pooling.
Concepts

Database

Transaction

Refresh