Skip to content

Instantly share code, notes, and snippets.

View omarsancas's full-sized avatar

Omar Sánchez omarsancas

View GitHub Profile
Enter the following command in the Terminal window.
ssh-keygen -t rsa
This starts the key generation process. When you execute this command, the ssh-keygen utility prompts you to indicate where to store the key.
Press the ENTER key to accept the default location. The ssh-keygen utility prompts you for a passphrase.
Type in a passphrase. You can also hit the ENTER key to accept the default (no passphrase). However, this is not recommended.
Warning! You will need to enter the passphrase a second time to continue.
select{
display: inline !important;
}
@omarsancas
omarsancas / northwind.markdown
Created October 31, 2019 21:30 — forked from nicolewhite/northwind.markdown
MySQL to Neo4j

From SQL to Neo4j: Northwind

SQL Model

Neo4j Model

Get the SQL Dump

The SQL dump was stolen from here and imported into MySQL.

@omarsancas
omarsancas / neo4j_cypher_cheatsheet.md
Created October 31, 2019 21:26 — forked from DaniSancas/neo4j_cypher_cheatsheet.md
Neo4j's Cypher queries cheatsheet

Neo4j Tutorial

Fundamentals

Store any kind of data using the following graph concepts:

  • Node: Graph data records
  • Relationship: Connect nodes (has direction and a type)
  • Property: Stores data in key-value pair in nodes and relationships
  • Label: Groups nodes and relationships (optional)
@omarsancas
omarsancas / GitCommitEmoji.md
Created June 13, 2019 15:46 — forked from parmentf/GitCommitEmoji.md
Git Commit message Emoji
xmllint --noout --schema http://import.awa.fm/music/1.0/meta_validate.rng meta.xml \;
for f in *.wav ; do ffmpeg -i "$f" -b:a 320k -acodec libmp3lame -q:a 2 "${f%.*}.mp3"; done
for f in *.wav ; do md5 "$f"; done
for f in *.wav ; do ffmpeg -i "$f" -af aformat=s16:44100 "${f%.*}.flac"; done
#New code for converting audio
for f in *.flac;do ffmpeg -i "$f" ;done
https://devopscube.com/monitor-linux-servers-prometheus-node-exporter/
https://devopscube.com/install-configure-prometheus-linux/
https://www.percona.com/blog/2016/02/29/graphing-mysql-performance-with-prometheus-and-grafana/
sftp -i ~/Downloads/merlin.ppk -oPort=2324 bqcoda@ftp.um-agency.com
sftp -oPort=### user@server.tld
put -r
@omarsancas
omarsancas / add_auto_increment_to_int_single_pk.sql
Created November 5, 2018 20:56 — forked from carlosrobles/add_auto_increment_to_int_single_pk.sql
Add auto_increment to all the single PRIMARY KEY of type int of a database
DROP TABLE if exists temp;
CREATE TABLE temp (
`table` varchar(250) DEFAULT NULL,
`colum` varchar(250) DEFAULT NULL,
`type` varchar(250) DEFAULT NULL,
`number_of_PK` tinyint(2) DEFAULT NULL,
`alter` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;