This Is Your Brain On Informatics: User Interfaces - Revision history

Tikenn at 02:33, 19 March 2014

2014-03-19T02:33:48Z

← Older revision		Revision as of 21:33, 18 March 2014
Line 113:		Line 113:

	phpMyAdmin should now be able to be accessed by typing in ''yourservername/phpMyAdmin'' into the browser.		phpMyAdmin should now be able to be accessed by typing in ''yourservername/phpMyAdmin'' into the browser.


	{{Template:This Is Your Brain On Informatics}}		{{Template:This Is Your Brain On Informatics}}

	[[Category:This Is Your Brain On Informatics]]		[[Category:This Is Your Brain On Informatics]]

Tikenn at 02:33, 19 March 2014

2014-03-19T02:33:33Z

← Older revision		Revision as of 21:33, 18 March 2014
Line 1:		Line 1:
	==Introduction==		== Introduction ==
	~~<p>~~
	While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, [[#SQL Buddy\|SQLbuddy]] and [[#phpMyAdmin\|phpMyAdmin]]; however, there are several others.		While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, [[#SQL Buddy\|SQLbuddy]] and [[#phpMyAdmin\|phpMyAdmin]]; however, there are several others.
	~~</p>~~

	==SQL Buddy==		== SQL Buddy ==

	===Overview===		=== Overview ===
	~~<p>~~
	SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin\|phpMyAdmin]], which means it is more secure due to being a smaller profile target. However, these advantages bring the disadvantage of SQLbuddy not having a heavy user interface including its lack of syntax highlighting for SQL queries.		SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin\|phpMyAdmin]], which means it is more secure due to being a smaller profile target. However, these advantages bring the disadvantage of SQLbuddy not having a heavy user interface including its lack of syntax highlighting for SQL queries.
	~~</p>~~

	===Installation===		=== Installation ===

	~~<p>~~
	SQLbuddy can be acquired from http://sqlbuddy.com/. This site will allow the user to download a zip file of the user interface. Move this file to the server using an ftp client (such as filezilla) and then use [[This Is Your Brain On Informatics: Linux\|mv]] to move the zip file to the directory shown below. Remain there for the rest of installation.		SQLbuddy can be acquired from http://sqlbuddy.com/. This site will allow the user to download a zip file of the user interface. Move this file to the server using an ftp client (such as filezilla) and then use [[This Is Your Brain On Informatics: Linux\|mv]] to move the zip file to the directory shown below. Remain there for the rest of installation.

Line 43:		Line 37:

	If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.		If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.
	~~</p>~~
	~~<p>~~
	<div id="index.php">		<div id="index.php">
	Now, a configuration must be done in the ''www'' file so that the index.php will be recognized as the primary site. Go to the file shown below using [[This Is Your Brain On Informatics: Pico\|pico]] (or any other text editor of your choice).		Now, a configuration must be done in the ''www'' file so that the index.php will be recognized as the primary site. Go to the file shown below using [[This Is Your Brain On Informatics: Pico\|pico]] (or any other text editor of your choice).
Line 72:		Line 65:
	Sqlbuddy should now be able to be accessed by typing in ''yourservername/sqlbuddy'' into the browser.		Sqlbuddy should now be able to be accessed by typing in ''yourservername/sqlbuddy'' into the browser.

	~~</p>~~		=== Troubleshooting ===
			There are still some quirks that may need to be worked out at this point.

	~~===Troubleshooting===~~		==== Firefox ====
	~~<p>~~
	~~There are still some quirks that may need to be worked out at this point.~~
	~~</p>~~
	====Firefox====
	~~<p>~~
	Firefox is excellent at tracking history; however, because of this, anything that was done incorrectly during the setup of sqlbuddy, mariadb, or even php will be remembered by the browser. If firefox is your browser of choice, it will be necessary to clear any history, after doing any major troubleshooting in order to allow those changes to take effect in firefox.		Firefox is excellent at tracking history; however, because of this, anything that was done incorrectly during the setup of sqlbuddy, mariadb, or even php will be remembered by the browser. If firefox is your browser of choice, it will be necessary to clear any history, after doing any major troubleshooting in order to allow those changes to take effect in firefox.
	~~</p>~~

	==phpMyAdmin==		== phpMyAdmin ==

	===Overview===		=== Overview ===

	~~<p>~~
	The interface phpMyAdmin is actually one of the most popular web server database interface tools. Unfortunately, this comes with the downside of being the most common target for hackers, making it a much larger security vulnerability than SQLbuddy. Also, it is not quite as lightweight, meaning it is slightly slower (not really noticeably with small queries though). But what it lacks in those departments, it makes up in sheer user friendliness. It is very easy to use this interface to manipulate a database without even really knowing any SQL (something that should NOT be indulged in by someone writing code, but it still makes manipulations easy). If SQL is the way to go for you, the SQL editor will highlight the syntax intelligibly to make it easier to read and spot errors. The choice really depends on your needs: quick and nimble without unneeded bells and whistles or slightly slower with heavy user interface.		The interface phpMyAdmin is actually one of the most popular web server database interface tools. Unfortunately, this comes with the downside of being the most common target for hackers, making it a much larger security vulnerability than SQLbuddy. Also, it is not quite as lightweight, meaning it is slightly slower (not really noticeably with small queries though). But what it lacks in those departments, it makes up in sheer user friendliness. It is very easy to use this interface to manipulate a database without even really knowing any SQL (something that should NOT be indulged in by someone writing code, but it still makes manipulations easy). If SQL is the way to go for you, the SQL editor will highlight the syntax intelligibly to make it easier to read and spot errors. The choice really depends on your needs: quick and nimble without unneeded bells and whistles or slightly slower with heavy user interface.
	~~</p>~~

	===Installation===		=== Installation ===

	~~<p>~~
	This is pretty much a repeat from above, so this time we'll use a slightly different method to show how it works. Go to http://www.phpmyadmin.net/ and right click on ''Download''. Then click on the selection that will copy the link to the clipboard (''copy link address'' for Google Chrome). Now go to the following location in the server and remain there for the rest of the installation:		This is pretty much a repeat from above, so this time we'll use a slightly different method to show how it works. Go to http://www.phpmyadmin.net/ and right click on ''Download''. Then click on the selection that will copy the link to the clipboard (''copy link address'' for Google Chrome). Now go to the following location in the server and remain there for the rest of the installation:

Line 131:		Line 114:
	phpMyAdmin should now be able to be accessed by typing in ''yourservername/phpMyAdmin'' into the browser.		phpMyAdmin should now be able to be accessed by typing in ''yourservername/phpMyAdmin'' into the browser.

	~~</p>~~		{{Template:This Is Your Brain On Informatics}}


	~~{{Template~~:This Is Your Brain On Informatics}}		[[Category:This Is Your Brain On Informatics]]

Tikenn at 01:49, 28 January 2014

2014-01-28T01:49:07Z

← Older revision		Revision as of 20:49, 27 January 2014
Line 1:		Line 1:
	==Introduction==		==Introduction==
	<p>		<p>
	While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, SQLbuddy and phpMyAdmin; however, there are several others.		While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, [[#SQL Buddy\|SQLbuddy]] and [[#phpMyAdmin\|phpMyAdmin]]; however, there are several others.
	</p>		</p>

Tikenn at 01:48, 28 January 2014

2014-01-28T01:48:14Z

← Older revision		Revision as of 20:48, 27 January 2014
Line 1:		Line 1:
			==Introduction==
			<p>
			While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, SQLbuddy and phpMyAdmin; however, there are several others.
			</p>

	==SQL Buddy==		==SQL Buddy==

Tikenn: /* Overview */

2014-01-22T22:41:59Z

Overview

← Older revision		Revision as of 17:41, 22 January 2014
Line 83:		Line 83:

	<p>		<p>
	The interface phpMyAdmin is actually one of the most popular web server database interface tools. Unfortunately, this comes with the downside of being the most common target for hackers making it a much larger security vulnerability than SQLbuddy. Also, it is not quite as lightweight, meaning it is slightly slower (not really noticeably with small queries though). But what it lacks in those departments, it makes up in sheer user friendliness. It is very easy to use this interface to manipulate a database without even really knowing any SQL (something that should NOT be indulged in by someone writing code, but it still makes manipulations easy). If SQL is the way to go for you, the SQL editor will highlight the syntax intelligibly to make it easier to read and spot errors. The choice really depends on your needs: quick and nimble without unneeded bells and whistles or slightly slower with heavy user interface.		The interface phpMyAdmin is actually one of the most popular web server database interface tools. Unfortunately, this comes with the downside of being the most common target for hackers, making it a much larger security vulnerability than SQLbuddy. Also, it is not quite as lightweight, meaning it is slightly slower (not really noticeably with small queries though). But what it lacks in those departments, it makes up in sheer user friendliness. It is very easy to use this interface to manipulate a database without even really knowing any SQL (something that should NOT be indulged in by someone writing code, but it still makes manipulations easy). If SQL is the way to go for you, the SQL editor will highlight the syntax intelligibly to make it easier to read and spot errors. The choice really depends on your needs: quick and nimble without unneeded bells and whistles or slightly slower with heavy user interface.
	</p>		</p>

Tikenn: /* Installation */

2014-01-22T22:40:47Z

Installation

← Older revision		Revision as of 17:40, 22 January 2014
Line 50:		Line 50:
	</div>		</div>

	Finally, the ''www'' file needs a location for SQLbuddy. ~~Type:~~		Finally, the ''www'' file needs a location for SQLbuddy. While still in the ''www'' file, add this block of code below the current locations to set up a new location on the server for SQLbuddy:

	~~<pre>cd /etc/nginx/sites-available</pre>~~

	~~and open~~ the ''www'' file.

	~~Then~~, add this block of code below the current locations to set up a new location on the server for SQLbuddy:

	<pre>		<pre>

Tikenn: /* Installation */

2014-01-22T22:39:39Z

Installation

← Older revision		Revision as of 17:39, 22 January 2014
Line 45:		Line 45:
	<pre>/etc/nginx/sites-available/www</pre>		<pre>/etc/nginx/sites-available/www</pre>

	In this file add ''index.php'' to the line shown below (shown with ''index.php'' added already).		In this file, add ''index.php'' to the line shown below (shown with ''index.php'' added already).

	<pre>index index.html index.htm index.php</pre>		<pre>index index.html index.htm index.php</pre>

Tikenn: /* Installation */

2014-01-22T22:39:01Z

Installation

← Older revision		Revision as of 17:39, 22 January 2014
Line 32:		Line 32:
	If there is a single directory listed named ''src'' then the files, which are embedded in ''sqlbuddy/src'' need to be moved to ''sqlbuddy''. Do this by typing:		If there is a single directory listed named ''src'' then the files, which are embedded in ''sqlbuddy/src'' need to be moved to ''sqlbuddy''. Do this by typing:

	<pre>mv sqlbuddy/src/* sqlbuddy</pre>		<pre>
			mv sqlbuddy/src/* sqlbuddy
			rm -rf sqlbuddy/src/
			</pre>

	If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.		If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.

Tikenn: /* Overview */

2014-01-22T22:37:21Z

Overview

← Older revision		Revision as of 17:37, 22 January 2014
Line 3:		Line 3:
	===Overview===		===Overview===
	<p>		<p>
	SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin\|phpMyAdmin]], which means it is more secure due to being a smaller profile target. A disadvantage ~~is that it will~~ not ~~highlight SQL~~ syntax for ~~easy viewing when writing a query~~.		SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin\|phpMyAdmin]], which means it is more secure due to being a smaller profile target. However, these advantages bring the disadvantage of SQLbuddy not having a heavy user interface including its lack of syntax highlighting for SQL queries.
	</p>		</p>

Tikenn at 01:22, 18 January 2014

2014-01-18T01:22:48Z

← Older revision		Revision as of 20:22, 17 January 2014
Line 130:		Line 130:

	</p>		</p>


			{{Template:This Is Your Brain On Informatics}}