" mysql Archives - LuxSci FYI Blog: Learn about HIPAA email encryption, secure email encryption, and more
LUXSCI

Posts Tagged ‘mysql’

SecureForm: API and Auditing Updates for Database Storage

Tuesday, June 16th, 2015

Your web and/or PDF forms can securely delivery data to you in many ways using LuxSci SecureForm.  One of these ways, saving all of your form post data to a hosted database, is now even more useful:

  • Data can be downloaded and/or deleted using LuxSci’s API
  • Row-level Audit trails are now explicitly maintained for access to database-stored data

Form Database Access using the LuxSci API

LuxSci’s API enables SecureForm customers to manage form posts stored to hosted MySQL databases.  In particular, this makes audited access to stored (and encrypted) data simple, does not require any SQL knowledge, and permits you to determine if access is read only or read and delete.

Read the rest of this post »

Can your web and PDF forms save to an Encrypted Database?

Monday, April 20th, 2015

Many web form processing systems allow you to save the form posts in a database.  However, for security and compliance reasons, that is not really very secure.  Of course, if your form processing and the database are in a secure, compliant environment (e.g. a HIPAA-compliant dedicated server), then the situation is better and it may be OK to have your form data saved unencrypted in your database.

However, as the person doing your compliance risk analysis will tell you, it is always better to have data encrypted at rest if you have a choice.  That greatly reduces your risk of breach / compromise.  The problem is: these web form processing systems and plugins will not encrypt your data for you and it is not easy to get a database that is itself fully encrypted.

So — what can you do to lock down your data?

Read the rest of this post »

Encryption and Auditing for MySQL Databases under HIPAA

Monday, July 21st, 2014

We get a number of questions every week regarding MySQL databases and HIPAA web site compliance. These range from confusion over auditing of access to stored ePHI to what HIPAA’s data encryption requirements actually are to how HIPAA applies to MySQL databases. Here, we will attempt to address some of these subtle questions for you.

Read the rest of this post »

Import CSV files into your MySQL database tables

Wednesday, April 30th, 2014

LuxSci’s MySQL database hosting console now enables you to import data into MySQL database tables directly from a CSV (Comma Separated Variables) file, e.g. a simple and universal form that spreadsheets can be saved or exported to.

Why would you want to import data from CSV?  Well, you could do the same thing by writing SQL code and importing this to your database or by connecting remotely to your database and issuing commands.  But both of those methods take some time and expertise to set up.  If you have a spreadsheet of data or a CSV of data created from some other system (e.g. customer information, contact lists, inventories, etc.), you can simply upload this file and populate your database with its new contents in a matter of seconds.

Read the rest of this post »

Video: Watch how SecureForm Makes Form Processing Easy and Secure

Wednesday, February 5th, 2014


LuxSci SecureForm is an easy way to add or enhance security and functionality to online forms you use to collect important information.

With a few clicks and a change of only 1-2 lines of your forms, you can receive the form data via secure email in a wide range of formats, save it to a LuxSci Documents WebAide (encryption optional) for future access, upload it to your own FTP or SFTP site, and/or send it directly to a MySQL database. You can even receive notifications via email or text message when new submissions arrive!  SecureForm has many other great features such as Ink Signatures for contract signing and Spam blocking.

Find out how it works in just a few minutes:

Watch Video: SecureForm Overview


LUXSCI