sokwedb
23 months agoRedo the table name arrow
Karl O. Pinc [Fri, 3 Nov 2023 22:08:02 +0000 (17:08 -0500)]
Redo the table name arrow

For reasons not understood, the arrow glyph at the end of the
old arrow was rotated 90 degrees when displayed on the web page.

23 months agoConfigure Sphinx theme and RST figures to display SVG full-screen width
Karl O. Pinc [Mon, 30 Oct 2023 21:25:10 +0000 (16:25 -0500)]
Configure Sphinx theme and RST figures to display SVG full-screen width

23 months agoThe demography er diagram
Karl O. Pinc [Fri, 27 Oct 2023 22:39:26 +0000 (17:39 -0500)]
The demography er diagram

2 years agoMove system-level commands into the sokwe_server repo
Karl O. Pinc kop@karlpinc.com [Fri, 20 Oct 2023 21:11:18 +0000 (21:11 +0000)]
Move system-level commands into the sokwe_server repo

2 years agoDocument hardcoding of cluster init and provide related control variables
Karl O. Pinc [Sun, 15 Oct 2023 17:48:47 +0000 (12:48 -0500)]
Document hardcoding of cluster init and provide related control variables

2 years agoFix copyright/author contact info
Karl O. Pinc [Fri, 13 Oct 2023 15:33:40 +0000 (10:33 -0500)]
Fix copyright/author contact info

2 years agoNew command to support VPN for port forwarding to pg server
Karl O. Pinc kop@karlpinc.com [Fri, 13 Oct 2023 16:24:10 +0000 (16:24 +0000)]
New command to support VPN for port forwarding to pg server

2 years agodocs: added url to wikipage on build system
Stevan Earl [Thu, 12 Oct 2023 18:00:30 +0000 (11:00 -0700)]
docs: added url to wikipage on build system

Providing richer resources for working with the build system that are
beyond the scope of the Make documentation.

2 years agoTransaction isolation is now configured to be serializable
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 03:00:13 +0000 (03:00 +0000)]
Transaction isolation is now configured to be serializable

There are also new settings for PG 15, but it's too much of a hassle
to break these into a separate commit.  Especially since there's
no production data yet.

2 years agoNew az server settings removed "anon" from available shared libraries
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 02:54:42 +0000 (02:54 +0000)]
New az server settings removed "anon" from available shared libraries

2 years agoNo need to end db comments with a newline
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 02:00:36 +0000 (02:00 +0000)]
No need to end db comments with a newline

2 years agoOnly look for db comments in *.rst files
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 01:52:47 +0000 (01:52 +0000)]
Only look for db comments in *.rst files

2 years agoImprove cluster creation docs
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 01:37:30 +0000 (01:37 +0000)]
Improve cluster creation docs

2 years agoMust be able to assume the role to create an object owned by the role
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 01:34:42 +0000 (01:34 +0000)]
Must be able to assume the role to create an object owned by the role

Unless of course you're a superuser.

2 years agoImprove error message when group is wrong
Karl O. Pinc kop@karlpinc.com [Mon, 9 Oct 2023 00:55:27 +0000 (00:55 +0000)]
Improve error message when group is wrong

2 years agoFix latex doc builds
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 02:13:20 +0000 (02:13 +0000)]
Fix latex doc builds

2 years agoAccount for empty db/schemas/*/create/ directories
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 01:18:03 +0000 (01:18 +0000)]
Account for empty db/schemas/*/create/ directories

2 years agoThere is nothing in the upload directory; temporarly comment out
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 01:15:34 +0000 (01:15 +0000)]
There is nothing in the upload directory; temporarly comment out

2 years agoProperly pass the schema to gen_func_comment_tmpl()
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 00:58:26 +0000 (00:58 +0000)]
Properly pass the schema to gen_func_comment_tmpl()

2 years agoAvoid a stack trace when raising DuplicateError
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 00:40:24 +0000 (00:40 +0000)]
Avoid a stack trace when raising DuplicateError

2 years agoAdd an informative error message for when comment SQL can't be made
Karl O. Pinc kop@karlpinc.com [Sat, 7 Oct 2023 00:21:26 +0000 (00:21 +0000)]
Add an informative error message for when comment SQL can't be made

2 years agoAdd caution about installing db components in a piece-wise fashion
Karl O. Pinc kop@karlpinc.com [Fri, 6 Oct 2023 23:23:46 +0000 (23:23 +0000)]
Add caution about installing db components in a piece-wise fashion

2 years agoEnsure function installation into the db is before comment generation
Karl O. Pinc kop@karlpinc.com [Fri, 6 Oct 2023 23:15:50 +0000 (23:15 +0000)]
Ensure function installation into the db is before comment generation

Function signatures cannot be obtained until after functions are
put into the database.  This means that comment SQL cannot be generated
before functions go in.  Alter the big install/re-install targets to
be sure that things happen in the right order.

The user can still invoke the "installcomments" target without having
all the functions installed.  In this case comment installation fails.
It is up to the user to install things in the proper order, as with
tables and views, when invoking targets that install piecemeal.

2 years agoBe consistent with PSQL_DEPENDS dependency placement
Karl O. Pinc kop@karlpinc.com [Fri, 6 Oct 2023 23:11:13 +0000 (23:11 +0000)]
Be consistent with PSQL_DEPENDS dependency placement

2 years agoFix install target docs
Karl O. Pinc kop@karlpinc.com [Fri, 6 Oct 2023 19:53:35 +0000 (19:53 +0000)]
Fix install target docs

2 years agoRemove <schema>/comments/ with clean-db
Karl O. Pinc kop@karlpinc.com [Fri, 6 Oct 2023 19:43:40 +0000 (19:43 +0000)]
Remove <schema>/comments/ with clean-db

2 years agoDocument default pg host
Karl O. Pinc [Fri, 6 Oct 2023 19:27:23 +0000 (14:27 -0500)]
Document default pg host

2 years agoImprove DATABASE TARGETS docs
Karl O. Pinc [Fri, 6 Oct 2023 19:16:46 +0000 (14:16 -0500)]
Improve DATABASE TARGETS docs

2 years agoName the devloper's database "sokwedb_dev", not "sokwedb_copy"
Karl O. Pinc [Fri, 6 Oct 2023 19:15:05 +0000 (14:15 -0500)]
Name the devloper's database "sokwedb_dev", not "sokwedb_copy"

2 years agoAdd user management commands: sokwedb-user-add, sokwedb-user-delete
Karl O. Pinc [Fri, 6 Oct 2023 19:06:39 +0000 (14:06 -0500)]
Add user management commands: sokwedb-user-add, sokwedb-user-delete

2 years agoRemove unnecessary program
Karl O. Pinc [Thu, 5 Oct 2023 14:46:01 +0000 (09:46 -0500)]
Remove unnecessary program

2 years agoMuch improve the build system's performance
Karl O. Pinc [Thu, 5 Oct 2023 02:19:22 +0000 (21:19 -0500)]
Much improve the build system's performance

Have make cache the creation of targets that:
  Put things in the database.
    No point in connecting to the db all the time when
    we don't need to.
  Create directories.
    There are separate targets for directory creation dependencies
    so that adding to/deleting from directories themselves don't
    change the dependent timestamp.
  Create complex targets.
    Some targets build things that are too complex to easily
    test, in a later make run, that the target has been successfully
    completed.

In all the above cases the build system used to go ahead and do the
extra work. But now, gen_comments.py takes a long time to run
and it's really annoying to wait all the time.

2 years agoFix to cleanup comment sql
Karl O. Pinc [Thu, 5 Oct 2023 02:14:58 +0000 (21:14 -0500)]
Fix to cleanup comment sql

2 years agoFix indentation
Karl O. Pinc [Wed, 4 Oct 2023 16:51:07 +0000 (11:51 -0500)]
Fix indentation

2 years agoRun comments taken from the docs through Sphinx to make the in-db text
Karl O. Pinc [Wed, 4 Oct 2023 03:00:30 +0000 (22:00 -0500)]
Run comments taken from the docs through Sphinx to make the in-db text

2 years agoFix trigger RETURN statements
Karl O. Pinc [Wed, 4 Oct 2023 02:58:09 +0000 (21:58 -0500)]
Fix trigger RETURN statements

2 years agoBetter sentence
Karl O. Pinc [Wed, 4 Oct 2023 02:47:45 +0000 (21:47 -0500)]
Better sentence

2 years agoAll non-html formats have the same epilog
Karl O. Pinc [Tue, 3 Oct 2023 01:02:51 +0000 (20:02 -0500)]
All non-html formats have the same epilog

2 years agoFix to capture comments at the end of a file
Karl O. Pinc [Sun, 1 Oct 2023 22:18:40 +0000 (17:18 -0500)]
Fix to capture comments at the end of a file

Technically, this shouldn't be necessary because the convention is to
declare the comment and then use it.  So no comment replacment text
should be at the end of the file.  But having a function makes
the code more clear and no harm in having code that always works.

2 years agoEmpty lines do not end indent blocks
Karl O. Pinc [Sun, 1 Oct 2023 21:56:21 +0000 (16:56 -0500)]
Empty lines do not end indent blocks

2 years agoTrigger functions must RETURN
Karl O. Pinc [Sun, 1 Oct 2023 21:35:46 +0000 (16:35 -0500)]
Trigger functions must RETURN

2 years agoSimplify logic
Karl O. Pinc [Sun, 1 Oct 2023 21:29:51 +0000 (16:29 -0500)]
Simplify logic

2 years agoReformat with black
Karl O. Pinc [Sun, 1 Oct 2023 21:23:39 +0000 (16:23 -0500)]
Reformat with black

2 years agoMove make documentation above make db
Karl O. Pinc [Sun, 1 Oct 2023 21:16:49 +0000 (16:16 -0500)]
Move make documentation above make db

This is necessary or making the db comments won't work, they depend
on $(HTML_RST_FILES) being defined when the comments are collected.

2 years agoDirectories must exist before the RST can
Karl O. Pinc [Sun, 1 Oct 2023 21:16:34 +0000 (16:16 -0500)]
Directories must exist before the RST can

2 years agoPut dependencies in the right order
Karl O. Pinc [Sun, 1 Oct 2023 21:03:11 +0000 (16:03 -0500)]
Put dependencies in the right order

2 years agoMove secondexpansion make code into it's own file
Karl O. Pinc [Sun, 1 Oct 2023 20:48:06 +0000 (15:48 -0500)]
Move secondexpansion make code into it's own file

2 years agoPut cluster creation stuff in it's own file
Karl O. Pinc [Sun, 1 Oct 2023 20:44:12 +0000 (15:44 -0500)]
Put cluster creation stuff in it's own file

2 years agoGive the database connection variables their own doc heading
Karl O. Pinc [Sun, 1 Oct 2023 20:37:59 +0000 (15:37 -0500)]
Give the database connection variables their own doc heading

2 years agoAdd dependencies everywhere psql is called
Karl O. Pinc [Sun, 1 Oct 2023 20:22:58 +0000 (15:22 -0500)]
Add dependencies everywhere psql is called

2 years agoAdd db comments for columns
Karl O. Pinc [Sun, 1 Oct 2023 19:59:29 +0000 (14:59 -0500)]
Add db comments for columns

2 years agoColumn names should not contain underscores
Karl O. Pinc [Sun, 1 Oct 2023 19:57:19 +0000 (14:57 -0500)]
Column names should not contain underscores

2 years agoBasics of putting comments into the db
Karl O. Pinc [Sun, 1 Oct 2023 19:13:43 +0000 (14:13 -0500)]
Basics of putting comments into the db

2 years agoPut julian_to() into it's own file
Karl O. Pinc [Sun, 1 Oct 2023 19:06:43 +0000 (14:06 -0500)]
Put julian_to() into it's own file

The db commenting build system requires a file per function name.

2 years agoUse make function instead of shell function
Karl O. Pinc [Thu, 28 Sep 2023 13:01:10 +0000 (08:01 -0500)]
Use make function instead of shell function

2 years agoFix removal of leading empty lines
Karl O. Pinc [Thu, 28 Sep 2023 04:10:23 +0000 (23:10 -0500)]
Fix removal of leading empty lines

2 years agoBetter function documentation
Karl O. Pinc [Thu, 28 Sep 2023 04:09:46 +0000 (23:09 -0500)]
Better function documentation

2 years 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

2 years 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

2 years 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

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

2 years 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.

2 years 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

2 years 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

2 years 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

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

2 years 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

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

2 years 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

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

2 years 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

2 years 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

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

2 years 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

2 years 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

2 years 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

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

2 years 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

2 years 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`.

2 years 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

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

2 years 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

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

2 years 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

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

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

2 years 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

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

2 years 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

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

2 years 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

2 years 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

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

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

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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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