SiSU - SiSU information Structuring Universe - Manual [0.58],
Ralph Amissah

  1

What is SiSU?

  2

Markup Syntax History

  392

25. Postgresql

25. Postgresql

  1010

25.1 Name

  1011

SiSU - Structured information, Serialized Units - a document publishing system, postgresql dependency package

  1012

25.2 Description

  1013

Information related to using postgresql with sisu (and related to the sisu_postgresql dependency package, which is a dummy package to install dependencies needed for SiSU to populate a postgresql database, this being part of SiSU - man sisu).

  1014

25.3 Synopsis

  1015

sisu -D [instruction] [filename/wildcard if required]

  1016

sisu -D --pg --[instruction] [filename/wildcard if required]

  1017

25.4 Commands

  1018

Mappings to two databases are provided by default, postgresql and sqlite, the same commands are used within sisu to construct and populate databases however -d (lowercase) denotes sqlite and -D (uppercase) denotes postgresql, alternatively --sqlite or --pgsql may be used

  1019

-D or --pgsql may be used interchangeably.

  1020

25.4.1 create and destroy database

  1021

--pgsql --createall
initial step, creates required relations (tables, indexes) in existing (postgresql) database (a database should be created manually and given the same name as working directory, as requested) (rb.dbi)

  1022

sisu -D --createdb
creates database where no database existed before

  1023

sisu -D --create
creates database tables where no database tables existed before

  1024

sisu -D --Dropall
destroys database (including all its content)! kills data and drops tables, indexes and database associated with a given directory (and directories of the same name).

  1025

sisu -D --recreate
destroys existing database and builds a new empty database structure

  1026

25.4.2 import and remove documents

  1027

sisu -D --import -v [filename/wildcard]
populates database with the contents of the file. Imports documents(s) specified to a postgresql database (at an object level).

  1028

sisu -D --update -v [filename/wildcard]
updates file contents in database

  1029

sisu -D --remove -v [filename/wildcard]
removes specified document from postgresql database.

  1030

Output generated by SiSU 0.59.0 2007-09-23 (2007w38/0)
SiSU Copyright ^© Ralph Amissah 1997, current 2007. All Rights Reserved.
SiSU is software for document structuring, publishing and search,
www.jus.uio.no/sisu and www.sisudoc.org
w3 since October 3 1993 ralph@amissah.com

SiSU using:
Standard SiSU markup syntax,
Standard SiSU meta-markup syntax, and the
Standard SiSU object citation numbering and system, (object/text positioning system)
Copyright ^© Ralph Amissah 1997, current 2007. All Rights Reserved.

SiSU is released under GPLv3 or later, <http://www.gnu.org/licenses/gpl.html>

SiSU, developed using Ruby on Debian/Gnu/Linux software infrastructure, with the usual GPL (or OSS) suspects.
Better - "performance, reliability, scalability, security & total cost of ownership" [not to mention flexibility & choice] use of and adherence to open standards (where practical and fair) and it is software libre.
Get With the Future Way Better!