sokwedb
2024-01-31 Karl O. PincRaise an exception if we don't find the view code
2024-01-31 Karl O. PincAutomatically generate statements to drop views
2024-01-30 Karl O. PincRequire that the CREATE VIEW explicitly list column...
2024-01-30 Karl O. PincAutomatically generate statements to drop views
2024-01-30 Karl O. PincFix (typos in) review target
2024-01-29 Karl O. PincChange BIOGRAPHY table name to BIOGRAPHY_DATA
2024-01-29 Karl O. PincReflect change of lookup schema to "codes" in conversio...
2024-01-29 Karl O. PincChange the name of the lookup schema to "codes"
2024-01-29 Karl O. PincImprove code formatting
2024-01-29 Karl O. PincCleanup after moving triggers into db/schemas/lib/
2024-01-29 Karl O. PincFix and imprprove error message
2024-01-29 Karl O. PincImprove docs on clean targets
2024-01-29 Karl O. PincAdd clean-commands target for scripts
2024-01-24 Karl O. Pinc... default_transaction_deferrable=on, backslash_quote=off
2024-01-24 Karl O. Pinc... The php-fpm interpreter is not deprecated
2024-01-24 Karl O. Pinc... Convert BIOGRAPHY_LOG
2024-01-24 Karl O. Pinc... Clean up "biography_update_log.made by" column to remov...
2024-01-24 Karl O. Pinc... Make a PEOPLE table in the "clean" schema to support...
2024-01-24 Karl O. Pinc... Index biography_log and comm_memb_log
2024-01-24 Karl O. Pinc... Add LIMIT to SELECT INTO, and ORDER BY for consistant...
2024-01-24 Karl O. Pinc... Fix AnimID column docs, must not be null, plus other...
2024-01-24 Karl O. Pinc... Create BIOGRAPHY_LOG and update docs with actual constr...
2024-01-24 Karl O. Pinc... Document BIOGRAPHY_LOG
2024-01-24 Karl O. Pinc... Remove empty trailing line
2024-01-24 Karl O. Pinc... Move DadID, DadIDPub, and DadPrelim relationships into...
2024-01-24 Karl O. Pinc... Mention both column names in the iff NULL docs
2024-01-24 Karl O. Pinc... Note what the special quotes are
2024-01-24 Karl O. Pinc... Add BIOGRAPHY.DadPrelim substitution refrence
2024-01-19 Karl O. PincIn diagram, change name BIOGRAPHY->BIOGRAPHY_DATA and...
2024-01-19 Karl O. Pinc... Reduce the HTML sidebar table of contents level to 2
2024-01-19 Karl O. PincBetter docs for DATA_FILE conversion variable
2024-01-19 Karl O. PincRemove more code which worked around invalid primary...
2024-01-19 Karl O. Pinc... New limits ("final" for the ones that exist now) based...
2024-01-19 Karl O. Pinc... Update based on initial data conversion
2024-01-19 Karl O. Pinc... Enforce rule that EntryDate <= DepartDate
2024-01-19 Karl O. Pinc... Align community code max length with that of the code...
2024-01-19 Karl O. Pinc... Testing for contiguous membership requires membership...
2024-01-19 Karl O. Pinc... Fix syntax error
2024-01-19 Karl O. Pinc... Load DadIDPrelim; adjust DadID and DadIDPub accordingly
2024-01-19 Karl O. Pinc... Remove trailing newlines from file
2024-01-19 Karl O. Pinc... Do not limit AnimID length, to match BIOGRAPHY
2024-01-19 Karl O. Pinc... Add missing FROM clauses
2024-01-19 Karl O. Pinc... Fix minimum age of parent at time of birth calculation
2024-01-18 Karl O. Pinc... Cleanup data required to tidy data types, fixes problem #10
2024-01-18 Karl O. Pinc... Improve description of file
2024-01-18 Karl O. Pinc... These cleanups were done in the upstream data
2024-01-18 Karl O. Pinc... Explain why permissions are set only on raw
2024-01-18 Karl O. Pinc... Have BIOGRAPHY.DadIDPub follow the same NULL rules...
2024-01-18 Karl O. Pinc... Add BIOGRAPHY.DadID_Prelim column
2024-01-18 Karl O. Pinc... New macro for if and only if NULL values
2024-01-18 Karl O. Pinc... Better BIOGRAPHY.DadID description
2024-01-18 Karl O. Pinc... Note where BIOGRAPHY.AnimIDs come from
2024-01-18 Karl O. Pinc... Reword the standard "empty text" phrasings
2024-01-17 Karl O. Pinc... Revert all code that changes the FOLLOW_MAP_TIME DDL...
2024-01-17 Karl O. Pinc... Do not change the FOLLOW_MAP_TIME DDL statement at all
2024-01-17 Karl O. Pinc... Properly pick up variables from the environment
2024-01-17 Karl O. Pinc... Improve docs for create-schema target
2023-11-30 Karl O. PincProgress towards moving demography data into a producti...
2023-11-30 Karl O. PincFix max lifespan constraint
2023-11-30 Karl O. PincChange BIOGRAPHY.AnimIDNum to allow NULL, and fix const...
2023-11-30 Karl O. PincFix column indexed
2023-11-28 Karl O. PincAllow spaces in Name column; align code with docs
2023-11-28 Karl O. PincFix permissions
2023-11-28 Karl O. PincFix comments
2023-11-28 Karl O. PincConvert data from the tidy to the easy schema
2023-11-28 Karl O. PincFix to use command line argument
2023-11-28 Karl O. PincRequire COMM_IDS.Name be unique
2023-11-26 Karl O. PincImprove hint; SokweDB has "admin"s and no real superusers
2023-11-26 Karl O. PincDocument the "lib" schema
2023-11-26 Karl O. PincFix typo
2023-11-26 Karl O. PincMove triggers and functions the user need not see into...
2023-11-19 Karl O. PincDo not need to remove primary key declaration, the...
2023-11-12 Karl O. PincConvert data into the tidy schema
2023-11-09 Karl O. PincSeparate psql setup vars for different schemas
2023-11-09 Karl O. PincStop if there's an error loading the db
2023-11-09 Karl O. PincMake executable
2023-11-09 Karl O. PincChange default conversion schema to "raw"
2023-11-09 Karl O. PincSeparate file for db speed settings
2023-11-09 Karl O. PincMake "old" the default db for converting
2023-11-09 Karl O. PincSystem to load MS Access dump into Postgres
2023-11-07 Karl O. PincUse variable instead of hardcoding
2023-11-03 Karl O. PincRedo the table name arrow
2023-10-30 Karl O. PincConfigure Sphinx theme and RST figures to display SVG...
2023-10-27 Karl O. PincThe demography er diagram
2023-10-20 Karl O. Pinc... Move system-level commands into the sokwe_server repo
2023-10-15 Karl O. PincDocument hardcoding of cluster init and provide related...
2023-10-13 Karl O. PincFix copyright/author contact info
2023-10-13 Karl O. Pinc... New command to support VPN for port forwarding to pg...
2023-10-12 Stevan Earldocs: added url to wikipage on build system
2023-10-09 Karl O. Pinc... Transaction isolation is now configured to be serializable
2023-10-09 Karl O. Pinc... New az server settings removed "anon" from available...
2023-10-09 Karl O. Pinc... No need to end db comments with a newline
2023-10-09 Karl O. Pinc... Only look for db comments in *.rst files
2023-10-09 Karl O. Pinc... Improve cluster creation docs
2023-10-09 Karl O. Pinc... Must be able to assume the role to create an object...
2023-10-09 Karl O. Pinc... Improve error message when group is wrong
2023-10-07 Karl O. Pinc... Fix latex doc builds
2023-10-07 Karl O. Pinc... Account for empty db/schemas/*/create/ directories
2023-10-07 Karl O. Pinc... There is nothing in the upload directory; temporarly...
2023-10-07 Karl O. Pinc... Properly pass the schema to gen_func_comment_tmpl()
next