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

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.