2.0.13

Features:

Initial postgresql support (#374)

This PR contains code to support Postgresql alongside SQLite and MS SQL Server as a data store for the application.

Specifically, it contains:

• modifications to the build.gradle file to support local development using postgresql (and incorporate recent sqlite bug fixes)
• modifications to database migrations to allow all existing tables, normal indexes (by which I mean not full-text indexes) and constraints to be created correctly in a postgresql database
• new mssql2pg.pl script to transform insertBaseData.sql for postgresql consumption, with modifications to insertBaseData.sql to make it easier to process (and some needed updates to the sqlite equivalent script)
• modifications to all DAOs to support the casing conventions of postgresql using existing database migrations, together with the script that performed (most of) those modifications
• modifications to the Searcher code to allow postgresql to use the same searchers as sqlite, since they are largely compatible (this will presumably change when full-text search is implemented)
• a tweak to DAOs to allow sqlite to behave as if it supported window functions
• a few bug fixes for sqlite
• sundry refactorings to support the above changes.
• a tweak to the initial data load to make reports (though not other entries) avoid using microsecond precision, so that the data is more realistic for testing purposes

It does not contain:

• full text search support for postgresql
• a fix for the fact that sqlite (and now, postgresql) use case-sensitive search, and hence fail some search-based tests
• a fix for some other things that don't currently work in sqlite, though they probably could be made to.

Enhancements:

#454: Change placeholder text (#460)

#445: Allow only admins to create new super users (#456)

ANET 2.0.2 release (#317)

Release 2.0.1 (#310)

GH-414 Add reports with sensitive info to dashboard (#463)

#265: Show a warning on the home page if the user has no (active) position (#462)

#443: Show appropriate warning for no (active) position (#461)

#95: Re-label "atmosphere (details)" to "atmospherics (details)" (#457)

Bug fixes:

Fix use of wrong setting for organizations (#458)

Implements #448

#416: Fix cursor behaviour in person firstname field (#455)

The issue was that whenever something was typed in the firstname field,
the cursor would go immediately to the end of the input. This was
happening because the event target value was being changed by the JS
code in order to remove the eventual comma added through the lastname
field. I fixed this by changing the way the comma is removed.

#323: No longer display default filter in adv search (#444)

Framework improvements:

Initial support for PostgreSQL (#439)

PR is based on #374 with some minor modifications.

Fix string formatting in logging resource (#465)

Avoid transaction and locking issues in postgresql and sqlite (#447)

Resubmitting #466 as native PR to avoid build issues

Add server-side logging of client errors (#464)

Implements #419