peterdee

Remove MySQL completely

1. Open the Terminal

2. Use mysqldump to backup your databases

3. Check for MySQL processes with: ps -ax | grep mysql

4. Stop and kill any MySQL processes

5. Analyze MySQL on HomeBrew:

brew remove mysql

peterdee

axios({
  url: 'http://localhost:5000/static/example.pdf',
  method: 'GET',
  responseType: 'blob', // important
}).then((response) => {
  const url = window.URL.createObjectURL(new Blob([response.data]));
  const link = document.createElement('a');
  link.href = url;
  link.setAttribute('download', 'file.pdf');
  document.body.appendChild(link);

peterdee

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

1. brew doctor
2. brew update

peterdee

[
{"group":"US (Common)",
"zones":[
{"value":"America/Puerto_Rico","name":"Puerto Rico (Atlantic)"},
{"value":"America/New_York","name":"New York (Eastern)"},
{"value":"America/Chicago","name":"Chicago (Central)"},
{"value":"America/Denver","name":"Denver (Mountain)"},
{"value":"America/Phoenix","name":"Phoenix (MST)"},
{"value":"America/Los_Angeles","name":"Los Angeles (Pacific)"},
{"value":"America/Anchorage","name":"Anchorage (Alaska)"},

peterdee

function camel(object) {
    const keys = Object.keys(object);
    return keys.reduce((o, k) => {
        if (k.includes('_')) {
            const words = k.split('_');
            const capitalized = words.map((word, i) => {
                if (word.length > 0) {
                    const capital = i > 0 ? `${word[0].toUpperCase()}${word.substr(1)}` : word;
 return capital; 

peterdee

function* iterate(length) {
    for (let i = 1; i <= length; i += 1) yield i;
}

function* pow2(array) {
    for (let i in array) yield array[i] ** 2;
}

const res = [...pow2([...iterate(10)])]; // (10) [1, 4, 9, 16, 25, 36, 49, 64, 81, 100]

peterdee

function createPromises(length) {
    const promises = [];
    for (let i = 0; i < length; i += 1) {
        const value = Math.random();
        promises.push(new Promise((resolve, reject) => setTimeout(() => {
            if (value < 0.1) reject('exception');
            resolve(value);
        }, value * 1000)));
 }

peterdee

1. Change your database RDS instance security group to allow your machine to access it.
   • Add your ip to the security group to acces the instance via Postgres.
2. Make a copy of the database using pg_dump
   • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
   • you will be asked for postgressql password.
   • a dump file(.sql) will be created
3. Restore that dump file to your local database.
   • but you might need to drop the database and create it first
   • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

• the database is restored

peterdee

{
  "Africa/Abidjan": 0,
  "Africa/Accra": 0,
  "Africa/Addis_Ababa": -180,
  "Africa/Algiers": -60,
  "Africa/Asmara": -180,
  "Africa/Asmera": -180,
  "Africa/Bamako": 0,
  "Africa/Bangui": -60,

peterdee

module.exports = {
  up: function (queryInterface, Sequelize) {
    return [
      queryInterface.addColumn('User', 'name', {
        type: Sequelize.STRING
      }),
      queryInterface.addColumn('User', 'nickname', {
        type: Sequelize.STRING,
      })
    ];