Skip to content

Instantly share code, notes, and snippets.

@jdonson
Created November 21, 2014 14:40
Show Gist options
  • Save jdonson/4ffaa7746eb3cfe0f6fd to your computer and use it in GitHub Desktop.
Save jdonson/4ffaa7746eb3cfe0f6fd to your computer and use it in GitHub Desktop.
our first gist
mysql> CREATE SCHEMA schems_2014
CHARACTER SET utf8
COLLATE utf8_general;
mysql> use schems_2014
mysql> CREATE TABLE inventory (
inv_id ...
);
mysql> CREATE TABLE io_obs (
obs_id ...
);
mysql> INSERT INTO io_stats VALUES ( ... );
mysql> CREATE TABLE io_stats (
stats_id ...
);
mysql> CREATE TABLE projects (
project_id ...
);
@jdonson
Copy link
Author

jdonson commented Nov 21, 2014

It is good timing that I explain gcc tools + hello world + databases + web servers....

Linux is at the ground floor of the LAMP stack, and all depends upon linux:

  1. Linux and other local and network file systems, as you are quickly learning.
  2. MySQL, which is a relational database management service
  3. Apache, which is the web page server (listens for urls from browsers)
  4. PHP = Server-side dev language

With this hands-on grasp of the LAMP stack, git will make WAY more sense! :)

In order to help you make $$ with logical and physical relational database technology:
0. ensure gcc tools are installed in OS X

  1. mysqld database service installation and configs
  2. mysql client connects and secures database
  3. mysql db root account creates logical database schema
  4. mysql db root account creates dbadmin + dbadmin_ro + dbdev accounts
  5. mysql db root account confers all privs
    to dbadmin on schema(s) with grant options.
  6. schema dbadmin connects and creates tables and keys
  7. developer provides sample data and some structural changes
  8. schema dbadmin makes structural changes + loads sample data
  9. data sources and logic inputs reviewed
  10. custom stored functions and procedures can reduce amount of dev code
  11. CASE Tools aid in connecting actual code with diagrams that finalize system specs.
  12. Environments --< Networks --< Systems --< Services

EXAMPLES OF SOFTWARE SPEC DIAGRAMS =>

  1. ERD = Database Model = Entity Relational Diagrams (tables and keys)
  2. DFD = Data Flow Diagrams = Process Flows for Devs
  3. UI Prototyping = Focus on front end responsive templates and user experience.

TESTS ARE THE CONNECTIVE TISSUE THAT HELP THESE THREE LAYERS CONVERGE!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment