Encrypted Database Generator



On occasion you may want an online database that only your customers or friends may access. You may be assuming that JavaScript is an open language, so anyone can look at the source code and figure out what is stored in the database.

However, once this searchable database is encrypted with your password or passwords, not even I can decrypt it. And no one can read data from your database online without knowing that password or passwords. Not even I can read your data online.

Why? Because this 4 bit encryption scheme is an open password protocol. You may be using single encryption with a password that may be anything from a single letter or character to a large number of words or characters or it may be a double encrypted database using a second password ranging from a single character to a large number of words or characters.

Only you and those who have the appropriate password or passwords can search your database.

This script engine takes the data straight from your spreadsheet (ClarisWorks®, AppleWorks®, Microsoft Excel® or other similar format) and converts it into a searchable JavaScript Database for your website. This is a super tool for the web developer offering his/her clients that little bit extra.

All you need to do is type in the column headings or titles below for each column that you wish included in the database. If any column contains URL's or paths to images you want displayed with results, simply click the appropriate radio button to indicate that is the case and search results will automatically make that column's data into a hyperreference displaying the contents of the column you indicate as linked to the URL as the title or display the image.

Finally, you mark and copy the columns from your spreadsheet (Claris Works®, AppleWorks® or Microsoft Excel® or other similar format) into the window below.

A click of the button and you will have a searchable database using your own data, ready to load online.

Note: You may not use the following characters in your spreadsheet: asterisk(*), accent grave(`), up caret(^) or pipe(|), since these are used as field and record separators in the resulting database.



Type the titles you desire displayed (if any) for each column of your spreadsheet when results of a search are displayed (You may change the order of results display by changing the contents of the column letter designations) If you leave a title blank, it will not be displayed in the search results accompanying the data (which will be displayed, of course) from that column.

Client's Website Title (optional)

Your Name (optional):

Your Copyright Info (optional):

Your Database Legend (optional):

Your First Password - from one character to 60 characters (Required):

Your Second Password - from one character to 60 characters (Optional):
Note: using second password will slow the access and retrieval time and may or may not provide additional security.

Mark your spreadsheet (Control-c or Apple-c), being careful to mark just the rows and columns you wish included in the final database. Important: Don't mark empty rows and columns. Then Paste it (Control-v or Apple-v) into the window below and click the "Prepare It" button.

After your script is returned, you may test it using the "Test It" button below the window.


© Copyright 2001 John H. Keyes