SQLite Refresher

In order to view databases that your Android app creates, please follow these steps.

1. Plug device into PC through USB data cable.
2. Fire up DOS prompt window.
3. adb devices (This will confirm that you are indeed connected)
4. adb shell (Gets you into Android Debug mode)
5. su (Need root access to the Linux file system)
6. cd data/data/[your package name] (For example, cd /data/data/ com.s33me.cashburn)
7. cd databases
8. ls (This will list the databases)
9. sqlite3 [database name] (For example, sqlite3 cashdb)
10. .tables (lists tables in the database)
11. Use SQL from this point on. (See Command Line Shell for SQLite)

This is probably more for me than for you, because I'll probably forget in the next 1/2 hour and start using DB2/SPUFI commands.

Cash and Burn

My latest Android app is one that I use daily to simply track cash withdrawals and debit card purchases. See CashBurn on Google Play.  This would be nice to have on a watch.

Android Cube - Work in Progress

A cube consists of 6 equal squares joined at right angles in a three dimensional space where X is the horizontal axis, Y is vertical and Z represents depth.

So in the diagram below where the side of each square is a length of 2, one would define vertices A, B and C in terms of (X, Y, Z) as follows:

A. (-1, +1, -1):
B. (-1, -1, -1);
C. (+1, -1, -1);

Note that every Z value on the front facing square will be -1; the Z values on the rear square will be +1.

ICE Cyber Crime Center Virus

Sony VAIO came into shop with the Windows Vista desktop blocked by a fraudulent screen requesting ransom. Here's what I did to the customer's satisfaction. 

•  Power on while tapping F8, but no back up to restore
•  Power on with F2 or F12 for BIOS set up
•  Change boot order: 1.CD, 2. USB, 3. HD
•  Power on with hiren boot USB. 
•  Copied bootmgr from D to C, but still locked out on restart.
•  Use hiren's Windows mini XP to back up user data.
•  Power on while tapping F10 and wipe C: to original factory.
• Advise user not to surf internet as administrator.

Stock Market and Options Trading App on Google Play

This site at finance.avafin.com would be a good feed into my market analysis app at Google Play

I'll get working on it. For now, maybe I'll just create a webview to make things simple.

Meanwhile, here is a link to all my financial apps at Google Play.

Android Integrated Development Environments

	Android Studio	Eclipse	AIDe
Installation:	Good on Linux	Good on Windows	Good on Tablet
Interface	Google style clean	Lots of tools	Good for tablet
Debugging	Better debug pane	Inconsistent and slow	LogCat on device
Compilation	Slow	Slow	Slow
Speed	Okay on Linux	Slow on Windows	Okay on tablet
Publishing	Fluid and keystore built in	Multi-step and awkward	Fluid and keystore built in

We Work Tech Meet Up in Hollywood

A fireside chat with Grindr's Lukas Sliwka covered the following:

• Scalability from PHP to Java and Ruby on Rails.
• Do not reinvent the wheel
• Sanitizing member profiles
• Approving user uploads
• User analytics to user preferences
• Pattern recognition and heuristics
• Shortened deliverable cycles.
• App ratings and client app crashes