Android SQLite tip - default datetime to now

Android SQLite FAQ: How do I default a SQLite datetime field to the current time, i.e., now?

Just use the SQLite "default current_timestamp" syntax, as shown in bold here:

create table projects (
  _id integer primary key autoincrement,
  name text not null,
  description text,
  date_created datetime default current_timestamp

If you create your table like that, then insert a sample record into the table like this:

Valley Programming, open for business in Colorado

It's February 1, 2012, and Valley Programming is now open for business in the Boulder, Colorado area. All of the legal business startup paperwork has been filed, and now I'll start getting all the other things together, including business cards, stationery, etc.

Hadoop programming services in Boulder, Colorado

I've been doing some Hadoop programming for the last couple of months, starting just before I arrived here in the Boulder, Colorado area, and I have to say, I love it.

Java String array syntax and examples

When working with a Java String array -- or any other type of Java array -- you follow these steps to work with the array:

  1. You declare the array.
  2. You specify the size of the array.
  3. You populate the array.

You can create a String array in these three explicit steps, or you can do them in two steps, or just one step.

Three steps to using a Java String array

In the three-step approach to creating and using a Java String array, Step 1 is to declare the array:

Boulder, Colorado yoga studios

If you know me, you know I like to practice yoga. Admittedly, I'm not very good at it, but I do like to try. So I was very happy when I just did a search for yoga in Boulder, Colorado, and found a wealth of yoga training facilities, including these:

Arduino programming near Boulder, Colorado

I'm a big Arduino programming fan, so I just got a big smile on my face when I saw that SparkFun Electronics is located here in Boulder, Colorado. They're one of the top sellers of Arduino products in the world, if not the top seller, so that's very cool.

Looking at the website, I don't see any specific Arduino meetups, but there is this Colorado Springs Embedded Programming Meetup.

KT's BBQ, Boulder, Colorado

Another quick note about Boulder, Colorado: A few nights ago I had to run some errands around Boulder, and I drove past a BBQ restaurant named KT's, which looks pretty interesting:

KT's BBQ, Boulder, Colorado

Boulder, Colorado Drupal news (meetups)

Boulder, Colorado Drupal news, December, 2011:

With a quick look at the calendar, the next Boulder, Colorado Drupal meetup is scheduled for December 14, 2011. John Fiala is scheduled to give a talk about the Drupal Services module.

A simple printable calendar

Ever wanted a simple, printable calendar you could print and then put up on your refrigerator (or elsewhere)? If so, you've come to the right place. I just created a simple, full-page, black and white, printable calendar.

You can access the first calendar page by clicking the image below. After that, just (1) navigate to the month you want to print, (2) select the print view, and (3) print it:

Our Boulder, Colorado Drupal programming and website services

Do you live and work in Colorado, and need a great, multi-user "social" website? If so, one of the technologies I've worked with a lot in the last three years is a website-building technology named Drupal. I've specifically worked with Drupal 6, and all my new websites are created with Drupal 7, which was released in January, 2011.


Subscribe to RSS - blogs