wesley tanaka

java.lang.IllegalStateException: attempt to acquire a reference on a close SQLiteClosable

()

"java.lang.IllegalStateException: attempt to acquire a reference on a close SQLiteClosable" can occur in an Android program if you try to do an operation (like run a .query()) on a SQLiteDatabase object which has already been

Tantalus-Arboretum Trail

()

Emily, Ryan and I attempted to hike the Tantalus-Arboretum trail the other day.

Parking was easy, free, and nearby:

Regression testing sqlite database migrations in Android

()

One strategy to test Android sqlite database upgrades is to make a copy of your SQLiteOpenHelper class each time you create a new database version. That way, you can use the older revisions of SQLiteOpenHelper to create legacy versions of your database schema and make sure that when you open the database with newer versions, the upgrade works properly.

3D models from a single photo

()

Drop, modify, change or rename a column from a SQLite table in Android

()

SQLite only supports a limited subset of ALTER TABLE, so to modify an existing column, it's necessary to create a separate table. The SQLite documentation recommends doing two separate INSERT/SELECT operations using a temporary table, instead of doing an INSERT/SELECT followed by an ALTER TABLE RENAME TO.

Running a SQLite database transaction in Android

()

The idiom for SQLite transactions in Android is:

db.beginTransaction();
try {
  // Do database operations here ...
  db.setTransactionSuccessful();
} finally {
  db.endTransaction();
}

Responsive AdSense Leaderboard ad unit for Twitter Bootstrap 2.3.2

()

Twitter Bootstrap 2.3.2 sets its media query responsive layout breaks at 768px, 980px, (and 1200px), which are suitable for including a Mobile Banner (320 x 50), Leaderboard (728 x 90), or a  Large Leaderboard (970 x 90). It's possible to do this with the new beta Responsive ad unit AdSense ad size.

Lending Club Experiment

()

I've seen references to Lending Club in several different places, including an article in The Economist, news about Google's $125 million investment in the company, and the tritium lending club boat

Oneteen

()

ME: What's this? [draws 11]

RYAN: Eeleven

ME: What's this? [draws 12]

RYAN: mm mmm what's this?

ME: twelve

RYAN: twelve!

ME: What's this [draws 13]

RYAN: fourteen

ME: thirteen

RYAN: thirteen!

...

ME: What's this [draws 15]

RYAN: fiteen

EMILY: Try 13 again

ME: What's this [draws 13]

RYAN: mm mm thir...

EMILY: Yeah, that's right!  thirteen!

RYAN: Thirteen

ME: What's this [draws 17]

RYAN: Sedenteen

ME: What's this [draws 16]

Leave you alone for five seconds

. . . and you draw all over your face with crayon.

Syndicate content
by Wesley Tanaka