index

Front Software

MJR: Software: SQL Journal

Version

1.3

Entered-date

2005-04-28

Description

A simple accounting journal

Keywords

scheme sql

Author

mjr AT dsl.pipex.com (MJ Ray)

Primary-site

http://mjr.towers.org.uk/comp/sqljournal/

Platforms

mzscheme apache linux postgresql

Copying-policy

GPL

FEATURES

  • Web-based accounting journal
  • Aims to be a simple recreation of an accounting journal book
  • Uses HTTP authentication and HTTP CGIs (not mod_whatever)
  • Uses PostgreSQL database backend
  • Written in PLT Scheme for rapid development
  • Installs easily on debian
  • A little bit incomplete still...

INSTALLATION

  1. Make sure that mzscheme and pg.ss are installed and working
  2. Create a user and database in postgres: createuser -PAD sqlj && createdb -Osqlj sqlj
  3. Customise schema.sql by adding other Asset, Liability, Expense or Sales codes and changing the username if needed
  4. Load the database structure: \i schema.sql in psql
  5. Configure the connection string in db.ss
  6. Configure apache with a string like ScriptAlias /journal/ /var/www/SqlJournal/sql-journal.scm
  7. Open http://localhost:80/journal/ or similar in a browser

DOWNLOAD

SQLJournal-1.3.tar.gz (13 Kb)

This website is copyright 2005 MJ Ray. All Rights Reserved. Please see the front page for terms.