jhas3c

Add Git Branch Name to Terminal Prompt (Mac)

Open ~/.bash_profile in your favorite editor and add the following content to the bottom.

# Git branch in prompt.

parse_git_branch() {

jhas3c

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

jhas3c

class ImageUpload extends Component {
  constructor(props) {
    super(props);
    this.state = {
      file: '',
      imagePreviewUrl: ''
    };
    this._handleImageChange = this._handleImageChange.bind(this);
    this._handleSubmit = this._handleSubmit.bind(this);
  }

jhas3c

-- start mysql daemon
mysql.server start

-- connect as root
mysql -u root -p

-- create a new limited user
-- [field] = placeholder for your situation
CREATE USER '[username]'@'localhost' IDENTIFIED BY '[password]';
GRANT SELECT, INSERT, UPDATE, ALTER ON *.* TO '[username]'@'localhost';

jhas3c

{"lastUpload":"2021-07-15T12:31:41.248Z","extensionVersion":"v3.4.3"}

jhas3c

https://en.wikipedia.org/wiki/Wikipedia:Database_download
https://archive.org/details/stackexchange
http://www.imdb.com/interfaces
https://dmoztools.net/docs/en/rdf.html
https://www.cia.gov/library/publications/the-world-factbook/
https://www.rfc-editor.org/retrieve/
http://download.geonames.org/export/
https://www.census.gov/main/www/cen2000.html
https://www.census.gov/population/www/cen2000/briefs/
http://ucdata.berkeley.edu/index.php

jhas3c

Setting up github and bitbucket on the same computer

Github will be the main account and bitbucket the secondary.

Create SSH Keys

ssh-keygen -t rsa -C "github email"

Enter passphrase when prompted. If you see an option to save the passphrase in your keychain, do it for an easier life.

jhas3c

# MySQL.  Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
#   gem install mysql2
#
# And be sure to use new-style password hashing:
#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
  adapter: mysql2
  encoding: utf8