Babase 5.0 was released on May 3, 2022. In this update, all tables (except for those related to warnings) became "temporal" tables. All changes to the data from this date onward will be recorded, in case earlier versions need to be recalled.
Major changes to Babase 5.0 include:
Creation of the babase_history schema and its "history" tables
Addition of a Sys_Period column to every table
Installation of "versioning" triggers to record old versions of data in the "history" tables
For information about how to use this new system, see Temporal Tables and babase_history.
Babase 5.1 was released on June 2, 2022. In this update, three new columns were added to RANKS to assist users with making decisions about the accuracy of rank data, similar to the way "confidence" columns are employed in other tables. New functions were also added to automate the population of these new columns.
Major changes in Babase 5.1 include:
Addition of the Ags_Density, Ags_Reversals, and Ags_Expected columns to the RANKS table
Creation of the rebuild_ranks(), rebuild_ranks_grp_rnktype(), and rebuild_all_ranks() functions to populate the new columns
In Babase 5.1.1 — released on June 16, 2022 — most of the validation for the CYCGAPS table was rewritten. For the most part, the actual rules did not change (exceptions discussed below) but the timing did, such that most of the CYCGAPS rules are now validated on transaction commit. Because of this change, rules that were in place to allow adding/removing/modifying gaps by doing odd things — e.g. "insert a 'start' row with the same date as an 'end' row to remove both" — are no longer needed and were removed.
Babase 5.2 was released on August 9, 2022. In this update, the contents of the PCSKINS table were added to the SEXSKINS table, and PCSKINS was removed. The PCSKINS_SORTED view was likewise removed. To facilitate this change, the Color column was added to SEXSKINS.
In Babase 5.2.1 — released on August 15, 2022 — the REPRO_NOTES table was added, as well as the SEXSKINS_REPRO_NOTES view.
In Babase 5.2.2 — released on September 7, 2022 — the Comments column was added to the WBC_COUNTS table.
In Babase 5.2.3 — released on September 8, 2022
— the HYBRIDGENE_SCORES table was
altered to allow Lower_Conf and Upper_Conf to be NULL.
Babase 5.3 was released on June 21, 2023. In this update, the residency system was revamped. Details of the new system are explained in the residency rules, but in general:
Individuals no longer need to be present in a group for 29 days before their residency begins. Instead, their residency begins on the first day that they were continually present in the group of residency.
When an individual begins to transition out of their resident group, their residency no longer ends at the beginning of that transition period (their first absence). Instead, residency lasts until the end of that transition period (the last day of the last "present" 29-day window).
Residency assignments are no longer limited to study groups. Individuals can be residents of any group (except 9.0 and 10.0), and it is possible to remain resident in a low-frequency (probably non-study) group through lengthy periods of nonobservation.
The system no longer attempts to assign residency in all of an individual's MEMBERS rows. Instead, the system only considers dates between the individual's Entrydate and Statdate, inclusive.
Other changes in Babase 5.3:
A new column added to ENTRYTYPES, telling the system when to use an alternate rule set for assigning residency on and shortly after an individual's Entrydate.
A new column added to STATUSES, telling the system when to use an alternate rule set for assigning residency on and shortly before an individual's Statdate.
A new table, RESIDENCIES, which condenses each individual's day-by-day residency information in MEMBERS into discrete "bouts".
In Babase 5.3.1, released on 17 July 2023, the FLOW_CYTOMETRY table was added.
In Babase 5.3.2, released on 02 November 2023, the Collection_Date_Status column was added to TISSUE_DATA and several related views.
In Babase 5.3.3, released on 09 November 2023, the VAGINAL_PHS table and the related VAGINAL_PH_STATS view were added.
Babase 5.4 was released on November 28, 2023. In this update, the WEATHERHAWK table was renamed to DIGITAL_WEATHER, the Lightning_Strikes column was added to DIGITAL_WEATHER, and the WEATHERHAWK_SOFTWARES table was renamed to WEATHER_SOFTWARES.