Login  Sign up

Database Services

Database backups are useful in disaster recovery scenarios and can help organizations comply with state-specific data retention laws. HIPAA does not have a ...
Fri, 25 Aug, 2017 at 6:53 AM
How to import a database
If you are migrating your database from another service or environment or restoring a database backup, the following steps describe how to load your datab...
Mon, 4 Dec, 2017 at 7:57 AM
PostgreSQL (Docker)
By running PostgreSQL inside a Docker container, it is easier to isolate system dependencies, test new versions, and apply upgrades without affecting the ...
Thu, 18 Aug, 2016 at 11:25 PM
PostgreSQL - installing an extension
To perform this command your user must be part of the database administrator role. Run command via psql: psql -c "CREATE EXTENSION hstore&quo...
Wed, 17 Aug, 2016 at 11:12 PM
Postgres - Tuning Tips
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 &...
Thu, 11 Jan, 2018 at 8:45 AM
Using SSH tunnels to connect remotely
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 ...
Thu, 8 Jun, 2017 at 11:10 AM
MySQL SSL Connections
To satisfy HIPAA requirements, protected health information (PHI) should be encrypted in transmission. The Healthcare Blocks MySQL Database Service is confi...
Thu, 11 May, 2017 at 11:44 PM
MongoDB - Connecting via Mongo Shell
Your application server comes with the mongo shell pre-installed. Connecting with SSL: Per HIPAA requirements, you should use a TLS (SSL) connection when ...
Sat, 29 Apr, 2017 at 12:25 PM