Database Services
1. First, create a group that will be used for read only access: create group readonly; 2. Revoke default create rights in the public schema: revoke c...
Fri, 12 Mar, 2021 at 10:16 AM
Database backups are useful for restoring data and are required for satisfying HIPAA/NIST CSF disaster recovery requirements. The Healthcare Blocks managed ...
Wed, 11 May, 2022 at 12:46 PM
Setting up an SSH tunnel allows you to use applications and tools on your local development machine while being connected to the remote server hosting your ...
Wed, 26 Jun, 2019 at 10:24 PM
If your application is communicating with a non-local database service and is transmitting protected health information, then HIPAA requires that the connec...
Thu, 12 May, 2022 at 8:12 AM
If you are migrating your database from another service or environment or restoring a database backup, the following steps describe how to load your databa...
Wed, 11 May, 2022 at 11:49 AM
Expensive queries can impact overall performance. By adding an index to a column being used in a query, it can significantly improve overall query times. He...
Mon, 21 May, 2018 at 3:09 PM
To enable logging of slow queries, do this with the mysql shell: set global slow_query_log = 1;
set global long_query_time = 0.05; // logs queries slower t...
Tue, 5 Jun, 2018 at 7:49 AM
To perform this command your user must be part of the database administrator role. Run command via psql: psql -c "CREATE EXTENSION hstore" To s...
Tue, 23 Apr, 2019 at 7:58 AM
To identify queries requiring more than 2 seconds to run (change this value as needed), run the following command via psql: SELECT now() - query_start as &...
Wed, 11 May, 2022 at 11:50 AM