Skip to content

Instantly share code, notes, and snippets.

View Amadou02's full-sized avatar

Amadou CAMARA Amadou02

  • Saint Quentin, 02100
View GitHub Profile
@Amadou02
Amadou02 / capistrano_ubuntu.textile
Created February 27, 2020 17:04
Capistrano Install on Ubuntu

Deploy with Capistrano from Ubuntu

  1. Install RVM and Ruby
    • sudo apt-get install build-essential openssl libreadline6 libreadline6-dev curl git zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion git
    • curl -L https://get.rvm.io | bash -s stable --ruby
    • source ~/.rvm/scripts/rvm
  1. Install Capistrano gems
@Amadou02
Amadou02 / SQL Cheat Sheet.md
Created January 21, 2020 09:01 — forked from janikvonrotz/SQL Cheat Sheet.md
SQL Cheat Sheet#SQL#Markdown

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Datatypes

Text types