Ed Chipman Programs

Code Bank is a code snippit manager with support for a local database as well as a shared database¹. Code Bank also has syntax highlighting for multiple languges including C++, ActionScript, Flex, HTML and SQL to name a few. Code Bank also has a simple revision history with a compare viewer so you can see the changes side-by-side between two revisions.

Desktop Client Installation

Use the install button on the left to download and install Code Bank, Adobe AIR 2.5 required.

Serverside Information

(Serverside is not required, Code Bank has built in support for local storage)

With the serverside application you can share a code snippit library between multiple users. If you would like to use the serverside application you may download it here. It only requires PHP 5.2.x (or greater) and MySQL 5.x (or greater).

Installation:

1. Make sure that the config folder is writable by PHP
2. Make sure that temp exists and is writable by PHP
3. Make sure that install.css, install.php, install.sql, and update.php are also writable by PHP
4. Create a database for Code Bank to use in MySQL, you will need this during the installer
5. Hit install.php in your browser and fill out the required information.
6. If the installer completes successfully you will now be able to use the remote server in Code Bank's desktop client. Just set the server path to be http://{your domain}/{path to root of code bank server folder}
7. Ensure the installer removed all install files (install.php, install.css, install.sql and update.php) before using your server again

MySQL User Privileges

Make sure the MySQL user you are using for Code Bank's serverside has atleast the following permissions.

• SELECT
• INSERT
• UPDATE
• DELETE
• CREATE
• ALTER
• INDEX
• DROP

Upgrading to 2.1.0 or 2.1.1 (Server side)

If you have MySQL 5.0.x on your web server you must use root (or a user with the SUPER privilege) for Code Bank's Serverside ensure you change your database.php to use a super user (typically root) to perform the upgrade, I'm dropping the trigger's introduced in 2.0.0. After the update you may switch back to using the user you were. If you cannot use a super user on your web host see here for manual upgrade instructions.

Upgrading to new versions:

1. Visit http://programs.edchipman.ca/applications/code-bank/ and download the latest version of the server
2. Extract all files in the archieve over your existing server install
3. Make sure that the config folder is writable by PHP
4. Make sure that temp exists and is writable by PHP
5. Make sure that install.css, install.php, install.sql, and update.php are also writable by PHP
6. Backup your code bank server database
7. Hit update.php in your browser this will automatically upgrade the server database if needed
8. Ensure the updater removed all install files (install.php, install.css, install.sql and update.php) before using your server again

Localizations

If you want to help localize Code Bank into your language I welcome the help, please use the contact page to ask about how you can help me with this. Once a translation has been made available it will be listed here with the language and your name/handle (if you wish) as the maintainer of the translation.

(Right Click and Save As)

Change Log

I've started publishing the change log, if you're interested in this see the change log here.

1.   Shared database requires the optional serverside. See that section above for more information