Paul Myrick
Database Specialist & Website Developer
Welcome to Paul’s site featuring information about database and website development. The blog section also includes tips and techniques specifically for WordPress users in addition to information about PostgreSQL, SQL and reporting tools such as Tableau.
The Latest Blog Entries
PostgreSQL Database Time Zones and Timestamp Time Zone Conversion in SQL
PostgreSQL stores timestamps with time zones in Greenwich Mean Time (GMT); however, the database can be configured to return timestamps in a different time zone. To set the default time zone for a database, use the ALTER DATABASE command. For example, the following...
Resolving The Dreaded Facebook Malicious Link Warning
Facebook will occasionally decide to flag links to your website with a warning about malware, spam or other supposed problems when it is simply not true. On two occasions, for two separate websites I run, Facebook has flagged my links this way. In the first instance,...
WORKSHOP: How To Build Your Photography Website
On February 25, 2017, Robin Davis and Paul Myrick will host a three hour workshop featuring information and tips on building websites to showcase and sell photography online. In addition to technical aspects, there will be guidance on curation, design, color and...