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
- Make sure that mzscheme and pg.ss are installed and working
- Create a user and database in postgres: createuser -PAD sqlj && createdb -Osqlj sqlj
- Customise schema.sql by adding other Asset, Liability, Expense or Sales codes and changing the username if needed
- Load the database structure: \i schema.sql in psql
- Configure the connection string in db.ss
- Configure apache with a string like ScriptAlias /journal/ /var/www/SqlJournal/sql-journal.scm
- Open http://localhost:80/journal/ or similar in a browser
DOWNLOAD
SQLJournal-1.3.tar.gz (13 Kb)