The Medical Cannabis Guide for the iPhone is NOW available at the iPhone App Store. Download it for free at:

itms://itunes.apple.com/us/app/istrainguide/id342548813?mt=8

The New Year is looking up!

Well it’s 2010. We’re still waiting for the iStrainGuide cannabis strain guide for iphone to be approved by Apple.  It was submitted to Apple on 11/24/09. It’s now January 2nd, 2010.  We’ll continue to wait. But in the mean time, check the app out:

Main Strain List – the strain database is updated weekly for free.

Detail View

I’m making available the MySql IP Geolocation Table we use in our projects. The cost will be $99.00. Anyone interested, contact me via this site.

My Three Stooges Sound Board App is available now on AppStore!! Coming soon is my ThumBeat Beat Box App for iPhone and iPod Touch – visit http://www.thumbeat.com for more info.

I submitted an iphone app to the App Store for the first time. The Three Stooges Sound Board, StoogeBoard, has been submitted. Hopefully they’ll approve it. I think kids will enjoy it.  Curly is showcased in this version. 15 sound clips are availble, from Nyuk Nyuk to all the other funniest clips.  Check out StoogeBoard.com for more info.

To offer a web site search facility, the pattern matching function [ select * from table where title like %news%] is often used, only for a lack of knowledge of Mysqls’ natural language query feature. Like Google.com, the optimum is to provide your users with a search feature whereby users type anything, a single word, or a natural language phrase [e.g. iphone 3gs available in san francisco].  Here’s how to set it up in Mysql.

1. create your table
create table as always – example fields:  title varchar(80), description longtext.

2. add the full text index via SQL or using a tool like navicat
alter table add fulltext(title,longtext)

3. A tip: keep in mind, you can’t just add a single record and run a test search.  Several records must be present in the table for the keyword matching facility to work.

For more information, check out mysql.com reference documentation.

If you’re looking for a hosting company, I’m here to say, while there are many offering low monthly fees, some of which I’ve used over the years, only one that I’ve found, is reliable, has a 99.99% availability, and is immediately customer support responsive.

Dream Host

The company?  DreamHost.com .  I’ve been with them almost a year. Never had a problem. If I have had a question, they responded with an hour or so. And for what I pay a year, I get unlimited bandwidth and disk space, and unlimited domains and sub-domains. It can’t be beat.

They offer great quick installs for many of the top php-applications, as well as a simple, and advanced install for wordpress.

I highly recommend this company.

Having a day off today. Jim and everyone coming for dinner. Have a good weekend everyone!

Saturday In The Park