AT&T Data Plan Changes
I’m sure everyone has heard by now, but starting next week AT&T will now have two data plans to choose from for their smartphones: * $15 for 200MB per month* $25 for 2GB per month I checked my usage and I’ve been below 200MB for my 3G data usage in 5 out of the last 6 months. The one month I went over 200MB (only to about 480MB) was when I was traveling to Florida. I like the...
Read MoreSQLite Naming Standards
Everyone who writes code has their own naming standard, but it’s also important to have database naming standards. Here is what I use when working with SQLite. Tables First, all my tables are named in singular using mixed case. So a table containing all the teams in my kids Little League would be called Team. Whether you specify it or not, SQLite assigns a rowid column to every table you...
Read MoreSQLite Studio Now Available
Many years ago, one of the first products that we started selling was called SQLVue. It was a database IDE for working with a variety of database engines. It was pretty popular, but we eventually stopped selling it for a variety of reasons. In the years since, we’ve been working with SQLite a lot. Most of our consulting work is creating database applications. And a great many use SQLite...
Read MoreBook Recommendations
A few books I recently finished that I highly recommend: Getting Real Rework Both of these are by 37Signals. I had previously read Getting Real (you can read it free online). I liked its premise and decided I need a hard-copy to keep on my bookshelf. Rework is very similar to Getting Real (some of the short essays are almost exactly the same). But Rework is more focused on business topics and...
Read MoreSQLite Migrator 1.3.0 Now Available
Quick and easily migrate your data from any database to SQLite. Press Release SQLite Migrator Web Site
Read More2009 Year End Awards
A little late, but here are my 2nd annual “Best of the Year” awards. Best Movie: Star Trek I only saw two movies in the theatre in 2009: Star Trek and Transformers 2 (both in IMAX because I only see IMAX movies in the theatre nowadays). But I did watch lots of movies on DVD (I have Netflix). Out of all of these, my favorite movie of 2009 was Star Trek. I’ve always been a Star...
Read More