jeffreysbrother · November 8, 2016 19:38 · Nov 8, 2016 · Nov 4, 2016 · Nov 4, 2016 · Nov 3, 2016
diff --git a/Preferences.sublime-settings-2 b/Preferences.sublime-settings-2
@@ -0,0 +1,35 @@
+{
+	"always_show_minimap_viewport": true,
+	"color_scheme": "Packages/Boxy Theme/schemes/Boxy Tomorrow.tmTheme",
+	"font_face": "Fira Code",
+	"font_size": 11,
+	"hot_exit": false,
+	"ignored_packages":
+	[
+		"Vintage"
+	],
+	"indent_guide_options":
+	[
+		"draw_normal",
+		"draw_active"
+	],
+	"line_padding_bottom": 3,
+	"line_padding_top": 3,
+	"material_theme_accent_scrollbars": true,
+	"material_theme_arrow_folders": true,
+	"material_theme_big_fileicons": true,
+	"material_theme_bright_scrollbars": true,
+	"material_theme_bullet_tree_indicator": true,
+	"material_theme_compact_sidebar": true,
+	"material_theme_contrast_mode": true,
+	"material_theme_disable_folder_animation": true,
+	"material_theme_panel_separator": true,
+	"material_theme_small_statusbar": true,
+	"material_theme_small_tab": true,
+	"material_theme_tabs_separator": true,
+	"overlay_scroll_bars": "enabled",
+	"remember_open_files": false,
+	"theme": "Boxy Tomorrow.sublime-theme",
+	"use_simple_full_screen": true,
+	"word_wrap": "true"
+}
diff --git a/Preferences.sublime-settings b/Preferences.sublime-settings
@@ -1,8 +1,8 @@
 {
 	"always_show_minimap_viewport": true,
-	"color_scheme": "Packages/Colorsublime - Themes/Afterglow.tmTheme",
+	"color_scheme": "Packages/Colorsublime - Themes/Boron.tmTheme",
 	"font_face": "Fira Code",
-	"font_size": 15,
+	"font_size": 11,
 	"hot_exit": false,
 	"ignored_packages":
 	[

diff --git a/sublime.md b/sublime.md
@@ -7,6 +7,7 @@
 * Install PackageResourceViewer (with package control). I think this allows us to extract the source code of some installed package so that subsequent updates to the package will not override our customizations.
 * Install [AdvancedNewFile](https://github.com/skuroda/Sublime-AdvancedNewFile) using package control. Key bindings can be configured by going here: Preferences > Package Settings > AdvancedNewFile > Key Bindings -- User
 * Install a blade syntax highlighter
+* Install GitGutter (not sure if I like this yet)
 
 ###Sublime Text 3 Shortcuts
 

diff --git a/Preferences.sublime-settings b/Preferences.sublime-settings
@@ -1,16 +1,9 @@
 {
-	"color_scheme": "Packages/Colorsublime - Themes/Boron.tmTheme",
-	"theme": "Material-Theme.sublime-theme",
-	"font_face": "Fira Code",
-	"font_size": 12,
-	"line_padding_bottom": 3,
-	"line_padding_top": 3,
-	"word_wrap": "true",
 	"always_show_minimap_viewport": true,
+	"color_scheme": "Packages/Colorsublime - Themes/Afterglow.tmTheme",
+	"font_face": "Fira Code",
+	"font_size": 15,
 	"hot_exit": false,
-	"overlay_scroll_bars": "enabled",
-	"remember_open_files": false,
-	"use_simple_full_screen": true,
 	"ignored_packages":
 	[
 		"Vintage"
@@ -19,5 +12,12 @@
 	[
 		"draw_normal",
 		"draw_active"
-	]
+	],
+	"line_padding_bottom": 3,
+	"line_padding_top": 3,
+	"overlay_scroll_bars": "enabled",
+	"remember_open_files": false,
+	"theme": "Material-Theme.sublime-theme",
+	"use_simple_full_screen": true,
+	"word_wrap": "true"
 }
diff --git a/sublime.md b/sublime.md
@@ -2,10 +2,11 @@
 
 * install [package control](https://packagecontrol.io/installation) (by running the code in Sublime Text's console). This functionality can be accessed by typing ctrl+shift+p ... and by typing in "install", we will see an option that says "Package Control: Install Package". Selecting this option will give us the ability to install packages.
 * install [Material Theme](https://github.com/equinusocio/material-theme) using package control, then add the required and recommended JSON parameters to Sublime's user settings.
-* install ColorSublime package using package control. We can then use ColorSublime to install a theme, perhaps the Facebook theme by mbixby.
+* install ColorSublime package using package control. We can then use ColorSublime to install a colorscheme. So far I enjoy these themes the best: 1337, Acai, Facebook, Afterglow, and Boron. I have not tried *every* colorscheme.
 * download [Fira Code](https://github.com/tonsky/FiraCode) and update font_face in Sublime's user settings
 * Install PackageResourceViewer (with package control). I think this allows us to extract the source code of some installed package so that subsequent updates to the package will not override our customizations.
 * Install [AdvancedNewFile](https://github.com/skuroda/Sublime-AdvancedNewFile) using package control. Key bindings can be configured by going here: Preferences > Package Settings > AdvancedNewFile > Key Bindings -- User
+* Install a blade syntax highlighter
 
 ###Sublime Text 3 Shortcuts
 

diff --git a/Preferences.sublime-settings b/Preferences.sublime-settings
@@ -1,10 +1,16 @@
 {
-	"always_show_minimap_viewport": true,
-	// "bold_folder_labels": true,
 	"color_scheme": "Packages/Colorsublime - Themes/Boron.tmTheme",
+	"theme": "Material-Theme.sublime-theme",
 	"font_face": "Fira Code",
 	"font_size": 12,
+	"line_padding_bottom": 3,
+	"line_padding_top": 3,
+	"word_wrap": "true",
+	"always_show_minimap_viewport": true,
 	"hot_exit": false,
+	"overlay_scroll_bars": "enabled",
+	"remember_open_files": false,
+	"use_simple_full_screen": true,
 	"ignored_packages":
 	[
 		"Vintage"
@@ -13,11 +19,5 @@
 	[
 		"draw_normal",
 		"draw_active"
-	],
-	"line_padding_bottom": 3,
-	"line_padding_top": 3,
-	"overlay_scroll_bars": "enabled",
-	"remember_open_files": false,
-	"theme": "Material-Theme.sublime-theme",
-	"use_simple_full_screen": true
+	]
 }
diff --git a/sql.md b/sql.md
@@ -33,7 +33,7 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 ```php
 //when we are manually connecting to PDO, we want to wrap it in a try/catch block
 try {
- $pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>');
+	$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>');
 } catch (PDOException $e) {
 	die('Could not connect.');
 }

diff --git a/sql.md b/sql.md
@@ -30,10 +30,8 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 * we can start up a PHP server by typing `php -S localhost:4000` (any port)
 * we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
-  * `$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>')`;
-  * keep in mind that the username might be *root*
 ```php
-//actually, when we are manually connecting to PDO, we want to wrap it in a try/catch block
+//when we are manually connecting to PDO, we want to wrap it in a try/catch block
 try {
  $pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>');
 } catch (PDOException $e) {

diff --git a/sql.md b/sql.md
@@ -31,4 +31,12 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 * we can start up a PHP server by typing `php -S localhost:4000` (any port)
 * we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
   * `$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>')`;
-  * keep in mind that the username might be *root*
+  * keep in mind that the username might be *root*
+```php
+//actually, when we are manually connecting to PDO, we want to wrap it in a try/catch block
+try {
+ $pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>');
+} catch (PDOException $e) {
+	die('Could not connect.');
+}
+```
diff --git a/sql.md b/sql.md
@@ -30,4 +30,5 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 * we can start up a PHP server by typing `php -S localhost:4000` (any port)
 * we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
-  * `$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', 'root', '<password-here>');`
+  * `$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', '<username>', '<password>')`;
+  * keep in mind that the username might be *root*
diff --git a/sql.md b/sql.md
@@ -30,4 +30,4 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 * we can start up a PHP server by typing `php -S localhost:4000` (any port)
 * we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
-`$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', 'root', '<password-here>');`
+  * `$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', 'root', '<password-here>');`
diff --git a/sql.md b/sql.md
@@ -29,4 +29,5 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 ###PHP stuff that might be related to MySQL
 
 * we can start up a PHP server by typing `php -S localhost:4000` (any port)
-* we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
+* we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
+`$pdo = new PDO('mysql:host=127.0.0.1;dbname=<database-name>', 'root', '<password-here>');`
diff --git a/sql.md b/sql.md
@@ -24,4 +24,9 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `select * from <table-name> where id = 1;`
 
-> all of these things can be done from a GUI program such as Sequel Pro
+> all of these things can be done from a GUI program such as Sequel Pro
+
+###PHP stuff that might be related to MySQL
+
+* we can start up a PHP server by typing `php -S localhost:4000` (any port)
+* we can use an existing PHP class to fetch data from a MySQL database: PDO (PHP Data Objects)
diff --git a/Preferences.sublime-settings b/Preferences.sublime-settings
@@ -1,9 +1,10 @@
 {
 	"always_show_minimap_viewport": true,
-	"bold_folder_labels": true,
-	"color_scheme": "Packages/Colorsublime - Themes/Facebook.tmTheme",
-	"font_size": 12,
+	// "bold_folder_labels": true,
+	"color_scheme": "Packages/Colorsublime - Themes/Boron.tmTheme",
 	"font_face": "Fira Code",
+	"font_size": 12,
+	"hot_exit": false,
 	"ignored_packages":
 	[
 		"Vintage"
@@ -16,9 +17,7 @@
 	"line_padding_bottom": 3,
 	"line_padding_top": 3,
 	"overlay_scroll_bars": "enabled",
+	"remember_open_files": false,
 	"theme": "Material-Theme.sublime-theme",
-	"use_simple_full_screen": true,
-	//hot_exit and remember_open_files might not be necessary on a Mac. Had to add this to my work computer.
-	"hot_exit": false,
-	"remember_open_files": false
+	"use_simple_full_screen": true
 }
diff --git a/sql.md b/sql.md
@@ -20,6 +20,8 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `insert into <table-name> (<columnA>, <columnB>) values('Go to the store', false);`
 
-`select * from todos;`
+`select * from <table-name>;`
+
+`select * from <table-name> where id = 1;`
 
 > all of these things can be done from a GUI program such as Sequel Pro
diff --git a/sql.md b/sql.md
@@ -18,4 +18,8 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `drop table <table-name>;`
 
-`insert into <table-name> (<columnA>, <columnB>) values('Go to the store', false);`
+`insert into <table-name> (<columnA>, <columnB>) values('Go to the store', false);`
+
+`select * from todos;`
+
+> all of these things can be done from a GUI program such as Sequel Pro
diff --git a/sql.md b/sql.md
@@ -16,4 +16,6 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `describe <table-name>;`
 
-`drop table <table-name>;`
+`drop table <table-name>;`
+
+`insert into <table-name> (<columnA>, <columnB>) values('Go to the store', false);`
diff --git a/sql.md b/sql.md
@@ -6,9 +6,9 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `show databases;`
 
-`create datbase <database-name>;`
+`create database <database-name>;`
 
-`use <databse-name>;`
+`use <database-name>;`
 
 `show tables;`
 

diff --git a/sql.md b/sql.md
@@ -2,6 +2,8 @@
 
 log in as root user: `mysql -u root -p` (this will then prompt you for a password)
 
+> note: if running a command in the mysql prompt produces a **->** this probably means that we have failed to insert a semicolon at the end of the line.
+
 `show databases;`
 
 `create datbase <database-name>;`

diff --git a/sql.md b/sql.md
@@ -10,7 +10,7 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `show tables;`
 
-`create table <table-name> (id integer PRIMARY KEY AUTO_INCREMENT, description text NOT NULL, completed boolean NOT NULL);` (basic formatting here is **column name** **type** **modifiers**, **column name** **type** **modifiers**, etc)
+`create table <table-name> (id integer PRIMARY KEY AUTO_INCREMENT, description text NOT NULL, completed boolean NOT NULL);` (basic formatting here is **column_name** **type** **modifiers**, **column_name** **type** **modifiers**, etc)
 
 `describe <table-name>;`
 

diff --git a/sql.md b/sql.md
@@ -10,7 +10,8 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `show tables;`
 
-`create table <table-name> (description text, completed boolean);`
+`create table <table-name> (id integer PRIMARY KEY AUTO_INCREMENT, description text NOT NULL, completed boolean NOT NULL);` (basic formatting here is **column name** **type** **modifiers**, **column name** **type** **modifiers**, etc)
 
 `describe <table-name>;`
 
+`drop table <table-name>;`
diff --git a/sublime.md b/sublime.md
@@ -9,5 +9,6 @@
 
 ###Sublime Text 3 Shortcuts
 
+* **ctrl+shift+p** ... open command palette
 * **ctrl+p** ... browse files
 * **ctrl+r** ... go to symbol (this allows us to jump to class and function definitions)
diff --git a/sql.md b/sql.md
@@ -10,4 +10,7 @@ log in as root user: `mysql -u root -p` (this will then prompt you for a passwor
 
 `show tables;`
 
-`create table <table-name> (description text, completed boolean);`
+`create table <table-name> (description text, completed boolean);`
+
+`describe <table-name>;`
+
diff --git a/sql.md b/sql.md
@@ -1,5 +1,13 @@
 ###MySQL Stuff
 
-log in as root user: `mysql -u root -p`
-This will then prompt you for the password.
+log in as root user: `mysql -u root -p` (this will then prompt you for a password)
 
+`show databases;`
+
+`create datbase <database-name>;`
+
+`use <databse-name>;`
+
+`show tables;`
+
+`create table <table-name> (description text, completed boolean);`
diff --git a/sql.md b/sql.md
@@ -0,0 +1,5 @@
+###MySQL Stuff
+
+log in as root user: `mysql -u root -p`
+This will then prompt you for the password.
+
diff --git a/sublime.md b/sublime.md
@@ -5,6 +5,7 @@
 * install ColorSublime package using package control. We can then use ColorSublime to install a theme, perhaps the Facebook theme by mbixby.
 * download [Fira Code](https://github.com/tonsky/FiraCode) and update font_face in Sublime's user settings
 * Install PackageResourceViewer (with package control). I think this allows us to extract the source code of some installed package so that subsequent updates to the package will not override our customizations.
+* Install [AdvancedNewFile](https://github.com/skuroda/Sublime-AdvancedNewFile) using package control. Key bindings can be configured by going here: Preferences > Package Settings > AdvancedNewFile > Key Bindings -- User
 
 ###Sublime Text 3 Shortcuts
 

diff --git a/sublime.md b/sublime.md
@@ -9,4 +9,4 @@
 ###Sublime Text 3 Shortcuts
 
 * **ctrl+p** ... browse files
-* **ctrl+r** ... go to symbol (not sure how to use this, LOL)
+* **ctrl+r** ... go to symbol (this allows us to jump to class and function definitions)
diff --git a/sublime.md b/sublime.md
@@ -5,3 +5,8 @@
 * install ColorSublime package using package control. We can then use ColorSublime to install a theme, perhaps the Facebook theme by mbixby.
 * download [Fira Code](https://github.com/tonsky/FiraCode) and update font_face in Sublime's user settings
 * Install PackageResourceViewer (with package control). I think this allows us to extract the source code of some installed package so that subsequent updates to the package will not override our customizations.
+
+###Sublime Text 3 Shortcuts
+
+* **ctrl+p** ... browse files
+* **ctrl+r** ... go to symbol (not sure how to use this, LOL)
diff --git a/Preferences.sublime-settings b/Preferences.sublime-settings
@@ -18,6 +18,7 @@
 	"overlay_scroll_bars": "enabled",
 	"theme": "Material-Theme.sublime-theme",
 	"use_simple_full_screen": true,
+	//hot_exit and remember_open_files might not be necessary on a Mac. Had to add this to my work computer.
 	"hot_exit": false,
 	"remember_open_files": false
 }
No results found