Rankings of Customer Support

Here is an ordered ranking of the customer support experience at different companies that I am either a personal or business customer of. Being a user of customer support, it makes it even clearer how important it is for your business.

A few things that strike me about companies that work really well as opposed to experiences that are rather miserable:

  • Quick response time
  • Clear and friendly
  • Good follow through on resolving issues

If someone is a customer and you keep dropping the ball on their issues, that is not a good thing.

(If you are a student/teacher/customer of CodeHS and there is something we can do better, please let me know at jkeesh@codehs.com).

The List

(Positive)

  1. Simple
  2. Zenpayroll
  3. Zenefits
  4. New Relic
  5. Customer.io
  6. Stripe
  7. (Neutral)
  8. PipeDrive
  9. Segment.io
  10. UserVoice
  11. Google
  12. RecruiterBox
  13. Asana
  14. Uber
  15. (Negative)
  16. Digital Ocean
  17. Linode
  18. Getaround

How to Buy Dogecoin


Dogecoin is the fun new cryptocurrency on the block, and you should get some! It’s not quite that easy yet, so here is a step by step guide.

Step 1: Buy Bitcoin on Coinbase

The first thing to do is go to Coinbase and create an account. This is an online bitcoin wallet, or an easy place to buy and sell bitcoins. It takes a bit of time to verify your account, and add in the payment info, but this is so far the most user-friendly way I have found to buy bitcoin using US dollars. So you can use your bank account and get yourself some bitcoin.

Step 2: Send the Bitcoin to Cryptsy

I believe there may be a way to get Dogecoin using USD on Vault of Satoshi, but I haven’t yet personally used that site. So in any case, say you have your bitcoin on Coinbase. The next thing you’ll want to do is create an account on Cryptsy, a site to trade cryptocurrencies. So after you log in click Balances at the top.


Then hover over bitcoin and click the “Deposit/Autosell BTC” link.

 

 

Then you’ll see a pop up show up with a long string of numbers and letters. This is the address. You want to copy this address.

 

 

Now go back into coinbase, and send the bitcoin to this address.

It may take some time to get the bitcoin into your cryptsy account because bitcoin is a bit slow.

Step 3: Trade Bitcoin for Dogecoin

Now click the Trade link at the top, scroll to the DOGE/BTC section and click. Now you’ll be at a page like this.

 

 

Then you can buy as much dogecoin as you like with your bitcoin.

Step 4: Send that Dogecoin to a Wallet

Now you have that dogecoin in crypsty, but you probably want it somewhere else so you can easily send it around. I have tried online wallets at DogeVault and DogeAPI and they both work. Online wallets are less secure, so you could also download the dogecoin client, but that is a bit of a hassle.

So now you do the same thing to send your dogecoin to a wallet. On the crypsy balances bage, hover over dogecoin and click Withdraw. Then you can send it to the address (string of numbers and letters) for you online dogecoin wallet ( this is the address you get from DogeVault or wherever your dogecoin wallet is).

 

 

There you have it! That’s how you can get dogecoin. If you don’t have any but want to get involved, send me a tweet @jkeesh and I can send you a tip.

Connecting to a RDS Server from a Local Computer Using SSH Tunneling on a Mac


That was the google query I searched and it took me a long time to find an answer so I’m going to contribute it back to the internet.

Most helpful resources:

http://stackoverflow.com/questions/9119497/i-can-connect-to-db-through-sequel-pro-but-not-through-command-line

http://www.sequelpro.com/docs/Connecting_to_a_MySQL_Server_on_a_Remote_Host

(almost helpful: http://it.blog.adclick.pt/linux/amazon-rds-tunnel-access-from-your-desktop/ )

Problem

I wanted to connect to a remote RDS instance from my mac computer. You normally would connect through an ec2 instance so do things differently, but if you want to connect from your local computer, the permissions make this a bit challenging. You might think you just connect by saying

mysql -u user -p -h your.rds.host

but that won’t work.

Solution

If you scour the internet there appear to two main solutions.

  1. Add your IP address to a whitelist on rds, but could be problematic since your IP address will probably change.
  2. Connect to the RDS instance using SSH tunneling.

I had not set up SSH tunneling before and for some reason had a hard time tracking it down. I use sequl pro to inspect our database sometimes, and I realize I was able to connect using SSH tunneling via their gui interface.

So, what is the solution?

There are two steps:

  1. Set up the SSH Tunnel
ssh -N -L 3306:your.rds.endpoint.rds.amazonaws.com:3306 sshuser@yourserver.com
 -N   
only set up the tunnel
 -L   
set up the forwarding
 3306
that first number is the port on your local machine
your.rds.endpoint.amazonaws.com
The name of the rds endpoing
3306
the port on the remote computer
sshuser@yourserver.com
how you log in to your ec2 instance

2. Use the SSH Tunnel

mysql -u dbuser -p -h 127.0.0.1

This lets you connect to the remote rds instance. Note that you have to use the host here 127.0.0.1 explicitly and that it is not the host you set up earlier. This is because it is now forwarding all of the requests. That’s all.

To be clear on how the ports work, here is another example

ssh -N -L 1234:your.rds.endpoint.rds.amazonaws.com:3306 sshuser@yourserver.com
mysql -u dbuser -p -h 127.0.0.1 -P 1234

This says forward from port 1234 on my computer to port 3306 on the remote instance. I just used 3306 in both as the defaults.

Trackpad Not Working on Macbook Pro

I had an old macbook pro that had been sitting around for maybe 6 or more months, and I tried to turn it on to use it, and the first thing I noticed was that 1) it was mostly frozen, and 2) the trackpad was not clicking. This made it hard to use, but with a little keyboard navigation I was able to google.

I googled around and found some suggestions—mainly that it was probably from a bad battery (which was probably the case), but also a fix which worked for me.

The fix was to push down hard on the trackpad evenly and hold down for about 10 seconds.

After this it pretty much started working again.

Just wanted to add my data point back to the internet.

Donate Bitcoins