Quick Start | MySQL | Document | Layouts | Searches | Browse | Sharing





Sharing
You can share the connection to your database and layouts with other people as e.g. clients, employees and friends over the internet (your web site). As well as you publish an HTML page on your web site, you can upload the SQLTouch document to a public area of your FTP then let the users access this document from their iPhone using a bookmark from within the app SQLTouch. The concept is similar to the RSS one, here extended to the database. The RSS is a static news delivering system. SQLTouch is an interactive database delivering system. This means that you share the database connection and layouts with other people and let them interact with your database.

Since you are going to publish the SQLTouch document on the internet, you must be sure to never leave precious access informations in it.
• Public Read Only Database

If you are going to publish a database for everybody, (e.g. a World-Wide Restaurants directory or a World-Wide Phone-Book directory), where everybody can search for records but nobody can modify, add or delete records, you should create a user called e.g. "clients" on your server and grant it the

"SELECT" & "CREATE TEMPORARY TABLES"

permission on your MySQL table. This way your clients will be able to read the database, perform searches and find the records, but will not be able to update, delete, insert and edit the records. In this case you could include username and password in the SQLTouch document. And if one day you would deny access to this user you can remove it from your server so no one will be longer able to access the database. Also you can just change his permissions on your server and database.


On the "Open" tab, click on the blue arrow to edit your SQLTouch document.

Then edit your connection parameters.

Then publish the document to your FTP clicking on the button "Publish to FTP" at the bottom of the same panel.

The FTP parameters you enter here will never be included within the SQLTouch document you upload. These parameters (but not the password) will be written on the preferences file of your iPhone until you delete this SQLTouch document. The password will never be stored anywhere.




• Private Writable Database

As opposite, if you are going to publish an internal private database for the employees of your company you should create one or more users on your server then grant to the database these privileges:

SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES

depending on your needs. In this case, since you don't want to publish on the internet a document containing username and password of your private database, delete username and password from the connection parameters then save the document.




Then they have to fill with a bookmark name and with the URL of the SQLTouch document you have provided them.
If you sent them the URL on an email, they can get the email on the iPhone, copy the URL and paste it in the URL field here below.



So, whenever they tap on the bookmark button, since the document doesn't contain the username and password, the employees will have to enter them in order to login and access to the database. This procedure should end as annoying to do every time, so we gave the user the opportunity to store the login parameters (username and password) to "his own" phone, and automatically login at any launch of the db. To do that just switch on the Remember Me option when logging in. In case the employee loses his phone, no panic, just remove the user from your server and he will not longer be able to access the db. Also you can remotely delete the whole contents of his iPhone using the iPhone Wipe option.


If you really are afraid to publish your SQLTouch document on the internet, even if it doesn't contain username and password, you can always use some tool to copy the SQLTouch document file from your iPhone to your employees' iPhones. We don't know which tool.

SqlTouch ©2011 - All rights reserved - Web site: http://www.sqltouch.com