sokwedb
23 months agoMake doc indentation consistant
Karl O. Pinc [Sat, 16 Sep 2023 22:36:00 +0000 (17:36 -0500)]
Make doc indentation consistant

23 months agofix: ensure consistent db config file sorting
Stevan Earl [Sat, 16 Sep 2023 19:51:43 +0000 (12:51 -0700)]
fix: ensure consistent db config file sorting

23 months agofix: spacing
Stevan Earl [Sat, 16 Sep 2023 19:42:09 +0000 (12:42 -0700)]
fix: spacing

23 months agofix: configuration name default_transaction_isolation
Stevan Earl [Sat, 16 Sep 2023 19:17:00 +0000 (12:17 -0700)]
fix: configuration name default_transaction_isolation

23 months agoAdd comments to explain what's generated
Karl O. Pinc [Sat, 16 Sep 2023 18:00:45 +0000 (13:00 -0500)]
Add comments to explain what's generated

23 months agoFix line length
Karl O. Pinc [Sat, 16 Sep 2023 17:51:17 +0000 (12:51 -0500)]
Fix line length

23 months agoDo not alter the stored configurations on error
Karl O. Pinc [Fri, 15 Sep 2023 23:49:53 +0000 (18:49 -0500)]
Do not alter the stored configurations on error

23 months agoCommit the expected Azure server configs to revision control
Ubuntu [Fri, 15 Sep 2023 23:23:29 +0000 (23:23 +0000)]
Commit the expected Azure server configs to revision control

23 months agoNew targets for comparing Azure PG server configuration
Ubuntu [Fri, 15 Sep 2023 23:22:51 +0000 (23:22 +0000)]
New targets for comparing Azure PG server configuration

23 months agoImprove config diff docs
Ubuntu [Fri, 15 Sep 2023 21:55:48 +0000 (21:55 +0000)]
Improve config diff docs

23 months agoCommit expected PG Azure db settings to revision control
Ubuntu [Fri, 15 Sep 2023 21:17:23 +0000 (21:17 +0000)]
Commit expected PG Azure db settings to revision control

23 months agoFix compare-db-settings to work with Azure
Ubuntu [Fri, 15 Sep 2023 21:08:51 +0000 (21:08 +0000)]
Fix compare-db-settings to work with Azure

For some reason on Azure's Postgres flexible-server PGv15 the
SQL

SELECT name, setting, unit, pending_restart \
                     FROM pg_settings \
                     ORDER BY name;

Does not return a consistent ordering when run on different databases
on the same PG server.  So run the output through `sort`.

23 months agoAdd pending_restart column to compare-db-settings
Ubuntu [Fri, 15 Sep 2023 21:05:18 +0000 (21:05 +0000)]
Add pending_restart column to compare-db-settings

23 months agoFix use of psql_setup.sh
Ubuntu [Fri, 15 Sep 2023 20:31:44 +0000 (20:31 +0000)]
Fix use of psql_setup.sh

23 months agoNew targets for comparing db configurations
Karl O. Pinc [Fri, 15 Sep 2023 20:03:24 +0000 (15:03 -0500)]
New targets for comparing db configurations

23 months agoDocumentation formatting
Karl O. Pinc [Thu, 14 Sep 2023 19:29:31 +0000 (14:29 -0500)]
Documentation formatting

23 months agoAdd targets for building cluster hosts on Azure
Ubuntu [Thu, 14 Sep 2023 19:08:12 +0000 (19:08 +0000)]
Add targets for building cluster hosts on Azure

23 months agoFix footnote numbering
Karl O. Pinc [Thu, 14 Sep 2023 15:09:13 +0000 (10:09 -0500)]
Fix footnote numbering

23 months agoFix punctuation
Karl O. Pinc [Thu, 14 Sep 2023 15:04:42 +0000 (10:04 -0500)]
Fix punctuation

23 months agoSet the default transaction isolation to serializable
Karl O. Pinc [Thu, 14 Sep 2023 14:54:11 +0000 (09:54 -0500)]
Set the default transaction isolation to serializable

23 months agoAvoid hardcoding in Makefiles
Karl O. Pinc [Thu, 14 Sep 2023 13:32:11 +0000 (08:32 -0500)]
Avoid hardcoding in Makefiles

23 months agoSet default time zone in cluster setup
Karl O. Pinc [Wed, 13 Sep 2023 22:18:07 +0000 (17:18 -0500)]
Set default time zone in cluster setup

23 months agoBetter comment
Karl O. Pinc [Wed, 13 Sep 2023 20:35:24 +0000 (15:35 -0500)]
Better comment

23 months agoDrop the PUBLIC schema with a cluster initialization target
Karl O. Pinc [Wed, 13 Sep 2023 20:15:50 +0000 (15:15 -0500)]
Drop the PUBLIC schema with a cluster initialization target

23 months agoAdd comments to SokweDB group roles
Karl O. Pinc [Wed, 13 Sep 2023 15:11:01 +0000 (10:11 -0500)]
Add comments to SokweDB group roles

23 months agoBetter superuser docs
Karl O. Pinc [Wed, 13 Sep 2023 14:53:37 +0000 (09:53 -0500)]
Better superuser docs

23 months agoImprove docs
Karl O. Pinc [Wed, 13 Sep 2023 14:42:29 +0000 (09:42 -0500)]
Improve docs

23 months agoBetter docs for macro
Karl O. Pinc [Tue, 12 Sep 2023 23:44:43 +0000 (18:44 -0500)]
Better docs for macro

23 months agoAvoid spurious newlines in generated RST
Karl O. Pinc [Tue, 12 Sep 2023 23:43:41 +0000 (18:43 -0500)]
Avoid spurious newlines in generated RST

23 months agoRemove files used in attempt to match input lines with lines reported in pl/pgsql...
Karl O. Pinc [Tue, 12 Sep 2023 20:38:13 +0000 (15:38 -0500)]
Remove files used in attempt to match input lines with lines reported in pl/pgsql errors

23 months agoRequire new databases have a commnt
Karl O. Pinc [Tue, 12 Sep 2023 18:03:14 +0000 (13:03 -0500)]
Require new databases have a commnt

23 months agoMake all the group-ish roles during cluster setup
Karl O. Pinc [Tue, 12 Sep 2023 17:34:55 +0000 (12:34 -0500)]
Make all the group-ish roles during cluster setup

23 months agoAdjust permission system for Azure's lack of the SUPERUSER role property
Karl O. Pinc [Tue, 12 Sep 2023 17:16:38 +0000 (12:16 -0500)]
Adjust permission system for Azure's lack of the SUPERUSER role property

23 months agoKludge to work-around lack of SUPERUSER role properties when vacuuming
Karl O. Pinc [Mon, 11 Sep 2023 23:22:31 +0000 (18:22 -0500)]
Kludge to work-around lack of SUPERUSER role properties when vacuuming

23 months agoDocument date input and output formats
Karl O. Pinc [Mon, 11 Sep 2023 21:44:18 +0000 (16:44 -0500)]
Document date input and output formats

23 months agoGrant permissions to sequences
Karl O. Pinc [Mon, 11 Sep 2023 00:18:04 +0000 (19:18 -0500)]
Grant permissions to sequences

23 months agoRemove unused (macro) types
Karl O. Pinc [Mon, 11 Sep 2023 00:12:17 +0000 (19:12 -0500)]
Remove unused (macro) types

23 months agoThe unknown individual can't be deleted or altered by regular users
Karl O. Pinc [Mon, 11 Sep 2023 00:10:46 +0000 (19:10 -0500)]
The unknown individual can't be deleted or altered by regular users

23 months agoImprove description
Karl O. Pinc [Mon, 11 Sep 2023 00:09:08 +0000 (19:09 -0500)]
Improve description

23 months agoFix link anchors
Karl O. Pinc [Mon, 11 Sep 2023 00:08:39 +0000 (19:08 -0500)]
Fix link anchors

23 months agoGive macros dealing with speical values better names
Karl O. Pinc [Sun, 10 Sep 2023 19:32:26 +0000 (14:32 -0500)]
Give macros dealing with speical values better names

23 months agoFix connection db in hint
Karl O. Pinc [Sun, 10 Sep 2023 19:31:49 +0000 (14:31 -0500)]
Fix connection db in hint

23 months agoFix column name in error message
Karl O. Pinc [Sun, 10 Sep 2023 19:24:08 +0000 (14:24 -0500)]
Fix column name in error message

2 years agoAdd create-adminuser-root target to build system
Karl O. Pinc [Fri, 8 Sep 2023 22:06:52 +0000 (17:06 -0500)]
Add create-adminuser-root target to build system

2 years agoAdd set-password build target
Karl O. Pinc [Fri, 8 Sep 2023 21:46:50 +0000 (16:46 -0500)]
Add set-password build target

2 years agoBeginnings of a cluster initialization build setup
Karl O. Pinc [Fri, 8 Sep 2023 21:35:28 +0000 (16:35 -0500)]
Beginnings of a cluster initialization build setup

2 years agoChange variable name from SOKWEDB_DB to TARGET_DB
Karl O. Pinc [Fri, 8 Sep 2023 19:15:41 +0000 (14:15 -0500)]
Change variable name from SOKWEDB_DB to TARGET_DB

2 years agoQualify the login with a (short) hostname for azure
Ubuntu [Thu, 7 Sep 2023 22:24:31 +0000 (22:24 +0000)]
Qualify the login with a (short) hostname for azure

2 years agoNo reason to expand PSQL_ARGS_MINIMAL dynamically
Ubuntu [Thu, 7 Sep 2023 21:55:00 +0000 (21:55 +0000)]
No reason to expand PSQL_ARGS_MINIMAL dynamically

2 years agoFix spelling of azure pg host
Ubuntu [Thu, 7 Sep 2023 21:50:57 +0000 (21:50 +0000)]
Fix spelling of azure pg host

2 years agoTake $(ORDER) out of the dependencies
Ubuntu [Thu, 7 Sep 2023 21:42:06 +0000 (21:42 +0000)]
Take $(ORDER) out of the dependencies

No point.  Plus some schemas don't yet exist under revision control.

2 years agoInitial database construction
Karl O. Pinc [Thu, 7 Sep 2023 21:28:46 +0000 (16:28 -0500)]
Initial database construction

This includes creation of a build system as well as tables, triggers, etc.
that create some initial demographic database objects.  Also included
are some changes to the documentation which include additional database
validation rules.

2 years agoFiddle with m4 include path resolution
Karl O. Pinc [Tue, 5 Sep 2023 20:09:33 +0000 (15:09 -0500)]
Fiddle with m4 include path resolution

2 years agoUse $CMD_TARGETS instead of $TARGETS for uniqueness among include files
Karl O. Pinc [Mon, 4 Sep 2023 18:06:44 +0000 (13:06 -0500)]
Use $CMD_TARGETS instead of $TARGETS for uniqueness among include files

2 years agoExplain the use of PEOPLE.Active
Karl O. Pinc [Mon, 4 Sep 2023 18:03:49 +0000 (13:03 -0500)]
Explain the use of PEOPLE.Active

2 years agoAdd command installation to build system
Karl O. Pinc [Sun, 3 Sep 2023 20:58:22 +0000 (15:58 -0500)]
Add command installation to build system

2 years agoSupport creations and deletions
Karl O. Pinc [Sun, 3 Sep 2023 19:50:01 +0000 (14:50 -0500)]
Support creations and deletions

2 years agoScript to send email notifications of git push-s
Karl O. Pinc [Sun, 3 Sep 2023 16:49:55 +0000 (11:49 -0500)]
Script to send email notifications of git push-s

2 years agoDocument the PEOPLE.Active column
Karl O. Pinc [Fri, 1 Sep 2023 17:13:42 +0000 (12:13 -0500)]
Document the PEOPLE.Active column

2 years agoAdd replacement for the boolean data type
Karl O. Pinc [Fri, 1 Sep 2023 17:13:03 +0000 (12:13 -0500)]
Add replacement for the boolean data type

2 years agoProvide function descriptions
Karl O. Pinc [Fri, 1 Sep 2023 16:21:53 +0000 (11:21 -0500)]
Provide function descriptions

2 years agoUse the Sphinx replace directive for function link references
Karl O. Pinc [Thu, 31 Aug 2023 22:18:19 +0000 (17:18 -0500)]
Use the Sphinx replace directive for function link references

2 years agoWe're not using underscores before ID in column names
Karl O. Pinc [Thu, 31 Aug 2023 22:18:13 +0000 (17:18 -0500)]
We're not using underscores before ID in column names

2 years agoFix link text for DEPARTTYPES
Karl O. Pinc [Thu, 31 Aug 2023 14:04:03 +0000 (09:04 -0500)]
Fix link text for DEPARTTYPES

2 years agoAdd doc section for functions; julian() and julian_to() functions
Karl O. Pinc [Wed, 30 Aug 2023 17:54:17 +0000 (12:54 -0500)]
Add doc section for functions; julian() and julian_to() functions

2 years agoFix link anchor
Karl O. Pinc [Wed, 30 Aug 2023 17:52:16 +0000 (12:52 -0500)]
Fix link anchor

2 years agoFix so setting $LOCALHTML supports change of image format
Karl O. Pinc [Tue, 22 Aug 2023 07:47:23 +0000 (02:47 -0500)]
Fix so setting $LOCALHTML supports change of image format

2 years agoBreak overlong line
Karl O. Pinc [Tue, 22 Aug 2023 07:42:06 +0000 (02:42 -0500)]
Break overlong line

2 years agoFix so images build after `make clean`
Karl O. Pinc [Tue, 22 Aug 2023 07:17:26 +0000 (02:17 -0500)]
Fix so images build after `make clean`

2 years agoTypeo in comment
Karl O. Pinc [Tue, 22 Aug 2023 07:16:29 +0000 (02:16 -0500)]
Typeo in comment

2 years agoFix full copyright statement
Karl O. Pinc [Fri, 28 Jul 2023 21:59:34 +0000 (16:59 -0500)]
Fix full copyright statement

2 years agoChange macro prefix to sdb_
Karl O. Pinc [Fri, 28 Jul 2023 21:40:24 +0000 (16:40 -0500)]
Change macro prefix to sdb_

2 years agoMerge branch 'master' of ssh://sokwe.janegoodall.org/srv/repos/sokwedb
Karl O. Pinc [Thu, 27 Jul 2023 22:18:46 +0000 (17:18 -0500)]
Merge branch 'master' of ssh://sokwe.janegoodall.org/srv/repos/sokwedb

Merge Stephan's update of the sphinx requirements

2 years agofeat: update requirements
Stevan [Wed, 26 Jul 2023 22:29:40 +0000 (22:29 +0000)]
feat: update requirements

2 years agoMore docs on using help.mk
Karl O. Pinc [Sun, 4 Jun 2023 20:50:07 +0000 (15:50 -0500)]
More docs on using help.mk

2 years agoMore docs on the build process
Karl O. Pinc [Sat, 3 Jun 2023 23:57:26 +0000 (18:57 -0500)]
More docs on the build process

2 years agoTypo in comment
Karl O. Pinc [Sat, 3 Jun 2023 23:32:50 +0000 (18:32 -0500)]
Typo in comment

2 years agoDocument how to use help.mk
Karl O. Pinc [Sat, 3 Jun 2023 23:14:59 +0000 (18:14 -0500)]
Document how to use help.mk

2 years agoReorganize makefiles to distinguish doc from db building
Karl O. Pinc [Sat, 3 Jun 2023 23:14:43 +0000 (18:14 -0500)]
Reorganize makefiles to distinguish doc from db building

2 years agoBegin to document tables
Karl O. Pinc [Thu, 1 Jun 2023 23:04:00 +0000 (18:04 -0500)]
Begin to document tables

Improve the introduction sub-sections and special values.  Introduce
some code tables.  Document BIOGRAPHY, COMM_MEMBS, and COMM_MEMBS_LOG.

2 years agoThe key column of each support table is unique
Karl O. Pinc [Thu, 1 Jun 2023 18:26:39 +0000 (13:26 -0500)]
The key column of each support table is unique

2 years agoMore conventions used when writing docs
Karl O. Pinc [Thu, 1 Jun 2023 18:22:41 +0000 (13:22 -0500)]
More conventions used when writing docs

2 years agoStandardize on an RST section "underline" scheme
Karl O. Pinc [Wed, 31 May 2023 19:49:11 +0000 (14:49 -0500)]
Standardize on an RST section "underline" scheme

2 years agoMore documentation on the system's design and correct use
Karl O. Pinc [Tue, 30 May 2023 22:49:57 +0000 (17:49 -0500)]
More documentation on the system's design and correct use

2 years agoDatabase files use shared constants
Karl O. Pinc [Tue, 30 May 2023 22:19:32 +0000 (17:19 -0500)]
Database files use shared constants

2 years agoAdd to docs on introduction, architecture, and an appendix
Karl O. Pinc [Sun, 28 May 2023 22:21:39 +0000 (17:21 -0500)]
Add to docs on introduction, architecture, and an appendix

2 years agoHelper program for footnote numbering
Karl O. Pinc [Sun, 28 May 2023 19:21:40 +0000 (14:21 -0500)]
Helper program for footnote numbering

2 years agoRemove statement about unknown GPS coordinate system
Karl O. Pinc [Sun, 28 May 2023 18:08:43 +0000 (13:08 -0500)]
Remove statement about unknown GPS coordinate system

2 years agoAdd images to generated documentation
Karl O. Pinc [Sun, 21 May 2023 16:17:32 +0000 (11:17 -0500)]
Add images to generated documentation

Convert from dia to inkscape.  Drop a symlink to the image dir into
each of the sphinx source directories since sphinx urls are rooted
at the sphinx source directory.

2 years agoFiles used to develop the images on the wiki
Karl O. Pinc [Sun, 14 May 2023 19:40:11 +0000 (14:40 -0500)]
Files used to develop the images on the wiki

2 years agoAdd single-page html output
Karl O. Pinc [Wed, 10 May 2023 21:23:31 +0000 (16:23 -0500)]
Add single-page html output

2 years agoAdd README file
Karl O. Pinc [Wed, 10 May 2023 06:44:37 +0000 (01:44 -0500)]
Add README file

2 years agoAdd license file
Karl O. Pinc [Wed, 10 May 2023 06:42:51 +0000 (01:42 -0500)]
Add license file

2 years agoCreate the document root directory if necessary
Karl O. Pinc [Wed, 10 May 2023 06:04:06 +0000 (01:04 -0500)]
Create the document root directory if necessary

2 years agoUse a workable requirements.txt
Karl O. Pinc [Wed, 10 May 2023 05:50:54 +0000 (00:50 -0500)]
Use a workable requirements.txt

2 years agoWork-around a venv bug that breaks the generated requirements.txt
Karl O. Pinc [Wed, 10 May 2023 05:50:15 +0000 (00:50 -0500)]
Work-around a venv bug that breaks the generated requirements.txt

2 years agoChange URL paths for docs
Karl O. Pinc [Wed, 10 May 2023 03:34:25 +0000 (22:34 -0500)]
Change URL paths for docs

Have a separate dir for html within docs, as is required by the
process that copies the generated html because anything not generated
is removed.  And put the pdf documents in the doc directory.

2 years agoProduce both A4 and US-Letter pdfs
Karl O. Pinc [Wed, 10 May 2023 03:09:55 +0000 (22:09 -0500)]
Produce both A4 and US-Letter pdfs

2 years agoAdd support for different pdf paper size output
Karl O. Pinc [Wed, 10 May 2023 02:27:15 +0000 (21:27 -0500)]
Add support for different pdf paper size output

2 years agoMake pdf generation work
Karl O. Pinc [Wed, 10 May 2023 01:17:15 +0000 (20:17 -0500)]
Make pdf generation work