Phosphorus Five Files

Phoenix release version 8.2

About this release

This release contains Hyper SQL, a web based and secure alternative to PHPMyAdmin and MySQL Workbench, that renders perfectly (responsive design) on your phone. Hyper SQL features AutoComplete for keywords, tables, and columns in your MySQL database, allows you to save and load snippets from your "SQL snippets library", and is also extremely slick on its bandwidth usage - Allowing for you to use it over "very bad internet connections". One feature I think is unique to Hyper SQL, is that it will allow you to automatically generate charts from your data, if it can semantically understand your data as the potentialdata source for a Pie Chart or a Column Chart. Below is a screenshot of Hyper SQL.

Below is a screenshot of an automatically generated Pie Chart.

Hyper SQL was conceptualised, implemented, and released in my "3 day coding challenge", as an example of how much work you can actually get done, in some few days, with a "5th generation programming language" such as Hyperlambda. I consider Hyper SQL to be extremely secure, stable, and mature - Although arguably not having all the features that PHPMyAdmin and MySQL Workbench has.

Using the Source Code version

IMPORTANT - Please download the Source-Complete-With-Submodules.zip file, which includes all submodules. If you get a blank page when debugging, this is highly likely your problem!

Visual Studio for Windows - Make sure you turn OFF the "Browser sync" features of Visual Studio before you start your debugging session.

Please make sure you have installed Visual Studio, Mono Develop, or Xamarin. In addition, you'll need to have access to a MySQL database, and edit your "/core/p5.webapp/web.config" file, such that your connection string points to your MySQL instance. If you don't have MySQL installed, Phosphorus Five will still function partially, such as Hyper IDE, and some of the other modules - But you will not get the full experience.

Installation process (for non-geeks)

1. Install Visual Studio Community Edition - You can skip this if you already have Visual Studio, Mono Develop or Xamarin installed.
2. Install MySQL Community Server - You can skip this if you have access to an (other) MySQL server somewhere
3. Download and unzip Phosphorus Five
4. Edit your "/core/p5.webapp/web.config" file from Visual Studio, and supply your MySQL password in the "MYSQL_GENERIC_CONNECTION_STRING" section. Below is an example of how your entire connection string setting should look like.
5. Turn OFF Browser Sync in Visual Studio if you are using the Windows version. This is a toolbar button, that looks like a "round arrow".
6. Start debugging by clicking "F5" or the "play" button in Visual Studio
7. Have fun :)

Example MySQL connection string setting from "web.config".

server=127.0.0.1;SslMode=none;User Id=root;Password=YOUR_MYSQL_PASSWORD_GOES_HERE;charset=utf8mb4;allowPublicKeyRetrieval=true;

Exchange the YOUR_MYSQL_PASSWORD_GOES_HERE parts above with your actual MySQL password, which you chose during installation of MySQL.

Notice - The above connection string allows retrieval of the public encryption key over a non-secure connection. This is probably what you want for your local source code and development machine - But you'd probably want to change this for your production website.

Installing binaries on a Linux/Ubuntu server

To install a new binary release on a Ubuntu server, type in the following to download the installation script in a terminal window. Make sure you don't have an old "install.sh" file in the same folder from before.

wget https://github.com/polterguy/phosphorusfive/releases/download/v8.2/install.sh

Then execute the following command to make your installation script become an executable.

chmod +x install.sh

Then start the installation process with the following.

sudo ./install.sh

The above "install.sh" script have only been tested on Ubuntu Server, version 16.04.4, but it might work on other versions. You can probably easily edit the actual script yourself, if you'd like to make it work with other Debian based systems.

Documentation

The system is largely literate, and contains its own documentation. However, for convenience purposes, I have included the PDF documentation as a separate file here. You can also generate this file yourself, from within the system.