sokwedb
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

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

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

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

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

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

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

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

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

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

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

22 months agoKeep sphinx venv under revision control
Karl O. Pinc [Wed, 10 May 2023 00:55:27 +0000 (19:55 -0500)]
Keep sphinx venv under revision control

22 months agoImprove comments
Karl O. Pinc [Tue, 9 May 2023 23:57:19 +0000 (18:57 -0500)]
Improve comments

22 months agoDisplay page generation time in UTC
Karl O. Pinc [Tue, 9 May 2023 23:39:20 +0000 (18:39 -0500)]
Display page generation time in UTC

22 months agoSeparate target dirs for local and non-local html
Karl O. Pinc [Tue, 9 May 2023 22:11:20 +0000 (17:11 -0500)]
Separate target dirs for local and non-local html

Since local html now uses a html builder but non-local html uses
dirhtml, sharing a target directory results is "extra stuff"
leftover from the other kind of build.  We don't want that.

22 months agoBetter comment
Karl O. Pinc [Tue, 9 May 2023 21:58:04 +0000 (16:58 -0500)]
Better comment

22 months agoNo need for recursive expansion as source files are not dynamic
Karl O. Pinc [Tue, 9 May 2023 21:57:47 +0000 (16:57 -0500)]
No need for recursive expansion as source files are not dynamic

22 months agoBetter comment
Karl O. Pinc [Tue, 9 May 2023 21:54:11 +0000 (16:54 -0500)]
Better comment

22 months agoBetter variable names and comments
Karl O. Pinc [Tue, 9 May 2023 21:44:57 +0000 (16:44 -0500)]
Better variable names and comments

22 months agoGet rid of extra variable
Karl O. Pinc [Tue, 9 May 2023 21:43:36 +0000 (16:43 -0500)]
Get rid of extra variable

22 months agoBetter comments
Karl O. Pinc [Tue, 9 May 2023 21:31:42 +0000 (16:31 -0500)]
Better comments

22 months agoMove generated RST epilog files into doc/sphinx-doc/.
Karl O. Pinc [Tue, 9 May 2023 20:56:23 +0000 (15:56 -0500)]
Move generated RST epilog files into doc/sphinx-doc/.

22 months agoBuild system for text docs -- images not yet supported
Karl O. Pinc [Tue, 9 May 2023 16:49:33 +0000 (11:49 -0500)]
Build system for text docs -- images not yet supported