Showing posts with label remote. Show all posts
Showing posts with label remote. Show all posts

2014-01-29

Level Up - Android: How To Connected a Full-Sized Keyboard to Android Device?

In this post, I will walk you through connecting a computer keyboard to an Android phone or tablet, via WiFi (or USB cable).

Estimated time of completion: About five to ten minutes the first time, and less than minute after your first run through.

Why is this useful?
There are many great apps on smartphones, but some people find it much more comfortable to use a full-sized keyboard for typing, especially for long periods of time. After going through this post, you will be able to use your computer keyboard like an advanced user:
1. For text messages (SMS), WhatsApp, and any other app with an input field.
2. You will be able to copy&paste text.
3. Speeddial. You can set the function keys on keyboard to open any app on the phone.
and more..


You will need:
- A Telnet program, like PuTTY
- A app on your device, called "Remote Keyboard" created by Onyxbits.
- A WiFi connection


Step 1: Download app to your Android device
1.1. Link: https://play.google.com/store/apps/details?id=de.onyxbits.remotekeyboard
1.2. When you open the app, it should look something like the following. Note the host address on there, it will be different for you.
1.3. Click the "Select Keyboard" button on the Action Bar, at the top of the screen and choose "Remote Keyboard"
Remote Keyboard, Android app


Step 2: Download PuTTY to your computer
2.1. Link: http://www.putty.org/
2.2. When you open PuTTY, change your configurations in three different places: Host, Port, and Connection type. You will get the port number and host address from the Remote Keyboard app. The connection type should be set to Telnet.
2.3. Click Open.
How to set up a Telnet connection


Step 3: Connect to device via Telnet on the computer
3.1. You should now see a window that looks like the following. And, you when you type into this window, key presses will go straight to your device rather than showing up on this window. Just click on any input field on Android to have the key presses sent there.

A Telnet connection to an Android smartphone.


Notes:
- For step 3, if you only see a blank screen, then wait a little longer for the connection. Then, possibly try sending a few keystrokes into the window and the Enter key.
- Windows does have a Telnet client, but I didn't get it to work. Using PuTTY was much simpler.
- Telnet connections are not secure. Each input is sent unencrypted.
- To connect more securely over USB, here are some instructions.

~ Danial Goodwin ~



2013-03-20

Connect to Remote Database

Today, I tried three popular programs of connecting to a remote database. In this post I will compare the pros and cons of each of the methods. My motivation was to find a method to share access to a single database and not be able to see or access any other databases on my server. [My server (Bluehost), doesn't allow access to phpMyAdmin without going through CPanel.]

First, the summary:
 - I would use HeidiSQL for speed, responsiveness, and ease of use.
 - I would use phpMyAdmin if I wasn't on my own computer with HeidiSQL installed.
 - I wouldn't use MySQL Workbench at this time nor recommend for beginners.


HeidiSQL:
 - Very quick to learn
 - Shows exactly what I need to get started. (See lower-right window in the HeidiSQL screenshot below)
 - Very clean method of organizing everything.
 - Con: Must be downloaded first in order to work.

http://www.heidisql.com/


PhpMyAdmin:
 - Available with just about every server; on CPanel.
 - When setting up a remote login for team members, it took just 5 minutes. All I had to do was download the files from the site and upload it to my server. Then anybody can access the URL and see the login page.
 - Con: Seems a little show at times.

http://www.phpmyadmin.net/home_page/


MySQL Workbench:
 - Harder to begin with.
 - Couldn't easily show table data.
 - When first starting, user is presented with a flood of information which was a turn off for me.
 - The interface may seem a little cleaner at first, but that comes at a cost of not being able to find functionalities quickly and easily. In order to efficiently use this MySQL Workbench, user needs to spend time looking through all the menus and right-clicking everything. My first thought about the program was that it was missing basic functionalities like being able to show data from the tables. But, I eventually found the function.
 - The screenshot below show this program using null to describe the data in the first row. Having null values in each cell is different that not having any rows of data...

http://www.mysql.com/products/workbench/



I'd love to hear your comments, reviews, and comparisons of these and other programs.

~ Simply Advanced ~

Disclaimer: I only tested each of these programs for about 5-10 minutes before drawing a conclusion. So, this can be used as a judgement for learning curve.