sokwedb
18 months agoProvide overview of how to use the make system
Karl O. Pinc [Thu, 28 Sep 2023 02:55:35 +0000 (21:55 -0500)]
Provide overview of how to use the make system

18 months agoAdd table of contents to the doc's readme
Karl O. Pinc [Thu, 28 Sep 2023 02:28:07 +0000 (21:28 -0500)]
Add table of contents to the doc's readme

18 months agoThere is no master shell script to make and configure databases
Karl O. Pinc [Wed, 27 Sep 2023 22:37:56 +0000 (17:37 -0500)]
There is no master shell script to make and configure databases

18 months agoReformat with black
Karl O. Pinc [Wed, 20 Sep 2023 16:16:42 +0000 (11:16 -0500)]
Reformat with black

18 months agoBuild triggers after views
Karl O. Pinc [Wed, 20 Sep 2023 15:59:14 +0000 (10:59 -0500)]
Build triggers after views

That way we can put triggers on views in the triggers directory.
We could have a separate "catagory" just for triggers on views,
but that introduces complication for no real benefit.

18 months agoMove generated doc files into sphinx-doc directory
Karl O. Pinc [Mon, 18 Sep 2023 22:08:08 +0000 (17:08 -0500)]
Move generated doc files into sphinx-doc directory

18 months agoSupport including view definitions into the documentation
Karl O. Pinc [Mon, 18 Sep 2023 21:37:29 +0000 (16:37 -0500)]
Support including view definitions into the documentation

18 months agoCombine 2 targets into one line
Karl O. Pinc [Mon, 18 Sep 2023 21:35:53 +0000 (16:35 -0500)]
Combine 2 targets into one line

18 months agoVariable for latex (pdf) prerequeistes
Karl O. Pinc [Mon, 18 Sep 2023 19:48:13 +0000 (14:48 -0500)]
Variable for latex (pdf) prerequeistes

18 months agoImprove cluster creation docs after review with Stevan
Karl O. Pinc [Sun, 17 Sep 2023 13:33:11 +0000 (08:33 -0500)]
Improve cluster creation docs after review with Stevan

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

18 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

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

18 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

18 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

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

18 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

18 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

18 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

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

18 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

18 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`.

18 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

18 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

18 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

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

18 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

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

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

18 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

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

18 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

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

18 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

18 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

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

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

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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

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

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

18 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

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

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

18 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

18 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

18 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

18 months 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

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

18 months 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

18 months 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

18 months 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

18 months 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

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

18 months 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.

18 months 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.

19 months 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

19 months 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

19 months 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

19 months 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

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

19 months 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

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

19 months 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

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

19 months 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

19 months 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

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

19 months 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

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

19 months 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

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

19 months 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`

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

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

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

20 months 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

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

22 months 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

22 months 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

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

22 months 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

22 months 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

22 months 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.

22 months 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

22 months 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

22 months 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

22 months 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

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

22 months 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

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

22 months 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

22 months 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.

22 months 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