My wife Kim is the successful editor behind At Home with Kim Vallee. She uses the WordPress platform.

With success and a popular platform, problems with comment and contact form spam becomes quickly a pain to manage. That’s why you need a good toolset to keep your sanity intact. Good WordPress plugins to protect against spamming and keep your installation secure include:

• Akismet – protects against spam
• Login LockDown – adds extra security to your login form
• WP Security Scan – security
• WP-SpamFree – extra spam protection

WP-SpamFree is quite invaluable against robots and contact form spam. However, it came to our attention that some people would see the following message instead of the contact form:

Your location has been identified as part of a reported spam network. Contact form has been disabled to prevent spam.

See the message when it would appear instead of Kim’s contact form:

This was really annoying. People were telling Kim they couldn’t send comments.

By chance, one PC at our office had this bug. The unique IP address assigned to our network by Videotron seemed clean. So I dug further and looked at the plugin code to understand and debug what’s happening. It seems some browsers in some configurations (in our case a particular Firefox installation on Windows XP) do not transmit the HTTP_ACCEPT_LANGUAGE variable to servers. There is a check in the WP-SpamFree plugin that identifies the visitor as a spammer if this variable is empty.

Once the problem identified, the fix is easy: simply disable this verification. The quick fix to the plugin is to modify the wp-spamfree.php file in the plugin directory to put this condition in comment. See my changes in red:

/*
            $user_http_accept_language = trim($_SERVER['HTTP_ACCEPT_LANGUAGE']);
            if ( !$user_http_accept_language ) {
                $contact_form_blacklist_status = '2';
                $spamfree_error_code .= ' CF-HAL1001';
                }
*/
            // Add blacklist check - IP's only though.

            if ( $contact_form_blacklist_status ) {
                $spamfree_contact_form_content = '<strong>Your location has been identified as part of a reported spam network. Contact form has been disabled to prevent spam.</strong>';
                }
            $content_new = str_replace('<!--spamfree-contact-->', $spamfree_contact_form_content, $content);

That’s it. No more false positives for Kim’s visitors!

I’ll send this issues to the WP-SpamFree devs.

Yesterday Steve Jobs announced his latest creation, the Apple iPad.

The Emperor has spoken and it’s very telling. Apple’s present and future is no longer about a fine-tuned combination of hardware and software. It’s also about being the content gatekeeper.

The announcement

We finally know what kind of tablet computer the Apple folks were cooking! Basically, it’s a blend of an oversized iPod Touch and iPhone. At the same time, it’s really a computer; the chip looks much more powerful. It’s supposedly very fast. Like any first generation Apple product, it has a lot going for it while missing a few things. No real surprises except maybe the starting price and very surprised about seeing a touch version of iWorks.

What’s more telling about Steve’s strategy is the lack of support for Adobe Flash. Not that I am very fond of Flash, but it is very telling.

It’s all about control

It’s no secret Steve Jobs is a control freak. It has worked well for him. Since the first Apple computer, Apple has had an aversion for clones. Apple wants to control the whole experience starting from hardware. Forget about having an Orange, a Pear or a Peach. Like Eve, all you need is to get a bite out of the Apple and you’re hooked. (Their logo is really telling). By controlling hardware and software combined with their sense of design and controlled user experience they’ve been able to do what most tech giants still dream of.

But today, controlling the user experience is also all about controlling content distribution.

They’ve done a really good job with iTunes out of distributing songs for people to buy. Then, Apple added an App Store to iTunes to distribute and install software. It made sense: it is more user-friendly and practical. What a success it has been!

Now enters the iPad which uses exactly the same model than the iPhone or iPod Touch. To download and install and application you still need to go through the Apple store. Oh, and you can download books now.

The excuse for the lack of Flash support on the iPhone Safari browser was that it was using too much CPU. It would deter the user experience. It wasn’t a bad excuse. Heck! Flash is known to bring underpowered computers to a crawl. But that excuse doesn’t fly well with the iPad. Those who got to try the device were all raving on how fast it is with its new Apple designed chip.

I do not care that much about the lack of Flash on Web sites. It is usually more a pain than a gain.

On the other hand, Adobe is prepping Flash CS5 which allows to build iPod Touch, iPhone and iPad applications. Who needs Flash support? Adobe is building it in some way! Who needs Adobe Air support on the iPad computer? Here’s a solution!

The thing is these Flash applications will have to be distributed by the App Store and approved and censored by Apple. There is no other way to do it unless you want to break Apple’s terms of use.

That’s why I don’t see Flash being supported natively in the browser on the iPad or the iPhone. It would be a way for developers to distribute software in a Web page without going through the content distribution gatekeeper Apple has become. Do pass go, but we’ll charge a fee on your 200$!

What’s next?

Apple’s announcement of the iWorks software suite for the iPad was quite a surprise to me. Digesting this announcement means Apple does not see the iPad as just an oversized iPhone. It’s also a computer where you can get some sort of work done. With the new screen estate, I can see a lot of exciting business applications being built for this new toy. But again, all these will have to pass through the gatekeeper.

To conclude, I predict we will see App Store support for Mac applications in the near future. It would make perfect sense when you think of it. Users get to download everything in a single place. Invoices are easy to find. You are dealing with a single company you trust. Why download and install something from somewhere else? That’s really too hard and too risky!

I wouldn’t be surprised to someday see a new computer from Apple which will make everything even easier for the computer illiterate. It will support a mouse and keyboard when touch is not yet as efficient. You will be able to get some real work done with it. It will use a blend of the Mac OS and the iPad OS to offer a seamless experience from hardware to content consumption. We almost have this device with the iPad but it’s just a start. In a future near you, your Adobe PhotoShop or Microsoft Office installations for a Mac will probably be downloaded from Apple.

Image source: Bite me in the rain by *sherryetal

Update:

Some interesting articles popped-up on the subject after I wrote this:

• Alex Payne: “On the iPad”.
• Free Software Foundation: “iPad is iBad for freedom”.
• Dave Winer: “Attn Joe: Should we trust iPad?”.
• Adobe Blog: “Apple's iPad -- a broken link?”.
• Fortune Brainstorm Tech: “Behind the Adobe-Apple cold war”.

I’ve been quite busy with work during the holidays. I had a huge mandate to complete for January 4th. This doesn’t mean I’m always at the office. I’m always looking for new way to make my office more mobile.

This is why I’ve been using an IP Telephony service (from Ubity in Montreal) for a year now. With such a service, you can plug your phones anywhere there’s an Ethernet jack.

Location, location

The location where I’m at doesn’t matter. I could be in Mexico, in Europe, wherever and when I use my phone, it’s my office phone calling locally from Montreal.

So, I have a phone plugged in at my office, I have one at home and I have another one at my cottage. When the phone rings these 3 phones will all ring at the same time and I can answer like I was at the office. When I call someone, I always look as if I was at the office. I can be at my cottage and answer as if I was at the office after a day of skiing.

Not only that, I also have software phone support. So, when travelling, I can use my laptop at the hotel to make calls: I just plug in my iPhone headphones (which as a microphone) and I still appear as being in the office when returning calls from clients!

I’ve also installed a VoIP application on my iPhone called iSip. Unfortunately, it does not allow to make calls over the 3G network yet. It only supports Wi-Fi. The cool thing is I can be having a glass of port and smoking a cigar on my terrace and use the phone to call back clients or partners while still looking as if I’m at the office!

The day I’ll move my office, I just need to plug the phone somewhere else and I’m instantly ready to make and answer calls.

Features

This kind of service has all the usual telephony and corporate voicemail features for an affordable price. Calls in North America are free (1000 minutes per months) and calls to countries the other side of the Ocean are ridiculously cheap. On top of that I have features such as “find me” where in my corporate voicemail, people can press a button in my inbox to find me. They get to speak their names while the service calls my cell phone. Then, when receiving the call on my cell phone, after listening to who’s calling, I can press a button to accept or ignore the call.

The downside is I’m extremely reachable. But I often need to be.

The upside is that I can enjoy the pleasures of life a bit more and work where it’s more practical and enjoyable while looking like I’m never leaving my office and even sleeping there!

So, I decided to join the bandwagon and give my predictions for 2010 in technology and social media.

1. We’ll see a new breed of social media curating

As we are more than ever overloaded with information, implicit filtering becomes a must. Are you able to keep up with your RSS feed? I can’t! Do you feel like you’re missing on a lot of interesting conversations shared across your networks? I sure do!
We’ve already seen a bunch of aggregators in the social media landscape as destination sites. The next wave, which will happen this year, will focus on personalized our social media streams based on our social interactions and preferences. We’ll see a lot of innovation in this space.

2. Telcos start adopting a single Android platform

Google’s upcoming Nexus One Android phone proves that Google can’t afford to have a platform where it does not better control the experience in its fight against Apple’s iPhone. I predict we will see many telcos start adopting a unified Android which will be a packaged version of the Nexus One and thelcos will start dropping other Android implementations.

3. It will be the year of BuddyPress

As more and more bloggers become media empires and as different brands want to embrace social media, we’ll see an impressive number of mainstream sites adopt BuddyPress to build their own communities.

4. Bing will integrate social shopping features

As innovation in e-commerce is stagnating outside of Amazon, social shopping will continue to boom. We’ll see major players such as Google, Microsoft and even Apple jump into social shopping. Bing, which already has some focus on shopping, will integrate social features in its search engine.

5. There will be at least one high profile lawsuit against Apple

Losers love their lawyers and success breads jealousy. A major company will have a major lawsuit against Apple. Easy prediction. There probably will be more than one high profile lawsuit against Apple. As a bonus, Apple will fend these off.

6. 2010: the year of the tablet

Another easy prediction. Everyone’s making it. I had to.

The real questions are: Will Windows 7 stand of the crowd with its multi-touch features? Will Android be majorly used? Will Apple’s tablet be great enough? As a side prediction it is sure that Apple fans will drink to cool-aid.

7. More anti-trust investigations against Google

The American Department of Justice and the European Union will open both new probes and investigations into Google’s activities. At least another high profile acquisition will be blocked. It a rite a passage Microsoft had to go through and its Google turn.

8. Facebook to become the next Paypal

In 2010, Facebook will finally launch a payment platform that can be used as a virtual currency. Eventually, users can exchange credits.

9. Facebook e-commerce applications

We will see adoption of Facebook’s payment platform outside of social gaming and we will see it adopted on Facebook Connect sites too. Want to make a donation through Facebook?

10. We’ll see innovation in e-commerce outside of Amazon

I had to make this prediction because I feel e-commerce is still at the 1.0 stage. It’s a matter of time before we begin to see innovation outside of Amazon. I’m making this prediction because you’ll have to stay tuned to Shwowp a new startup from Tara Hunt and yours truly. If others don’t start to innovate, at least there will be us! In any case, it will become true if #9 becomes true.

Image copyright: http://commons.wikimedia.org/wiki/File:Glaskugel_CrystalBall.jpg

Notre amie Renée nous a quitté hier. Difficile encore de le croire et encore plus de l’accepter.

De Renée Wathelet une bonne amie, je retiens joie, bonheur et extrème bonté.

J’ai discuté avec elle via Skype il y a seulement quelques jours. Nous parlions de notre visite éventuelle, Kim et moi-même, à Isla Mujeres, l’Ile qu’elle avait récemment adoptée pour de bon. Son dernier billet reflète bien pourquoi elle avait décidé de s’y installer en permanence. D’ailleurs, voici sa dernière photo Flickr, prise encore hier matin :

Parlant d’adoption… Renée adorait les chats. Que ce soit à Montréal ou Mexique, elle partageait son domicile avec ses chats. Elle était dévouée à aider le docteur Delfino Guevara et sa clinique vétérinaire Clinica de Chipie sur son île d’Isla Mujeres. Un autre blogue de Renée, Petits minous et gatitos en fait foi :

Être un chat au Mexique n’est pas toujours chose facile. Nous, les chats de l’Isla Mujeres, sommes privilégiés: depuis quelques années, le Dr. Delfino Guevara s’occupe de nous tous à sa Clinica de Chipie, que nous ayons ou non une famille. Bien sûr, il soigne aussi les chiens et les autres animaux de l’île!

Ce n’est pas facile pour les chats parce que plusieurs sont abandonnés ou maltraités pour causes d’ignorance ou de bêtise humaine. Les chats ne sont généralement pas vaccinés et opérés, ce qui exacerbe le problème. Heureusement, Dr. Delfino fait de son mieux pour essayer d’aider les chats abandonnés, les vacciner et les opérer. Idéalement, il faut leur trouver une famille d’adoption. Une page Facebook est aussi dédiée aux chats de l’île.

Tout ça pour dire que depuis près d’un an, je suis l’heureux propriétaire adoptif de Leeloo, un chat rescapé du Mexique. C’est Renée qui s’est chargé, avec son amie Line, de faire immigrer Leeloo à Montréal. Même chose pour notre bon ami commun, Philippe Martin, qui a adopté Coba avec qui il était tombé en amour lorsqu’il avait visité Renée sur son île mexicaine.

Voici Leeloo et Coba à l’aéroport YUL lorsque Renée, Kim et moi-même étions allé accueillir Line et nos deux nouveaux résidents félins (Kim, Renée et Line sur la photo) :

Voici Leeloo qui découvrait son nouveau maître:

Pour terminer, en essayant de vivre notre deuil, je ne peux qu’avoir des pensées pour sa famille et ses enfants que je ne connais pas vraiment. Ce que je sais, c’est que ses enfants ont eu une mère qui personnifie la joie de vivre et la bonté. Je leur offre mes plus sincères condoléances.

My cats just love their MTV!

Posted via email from Jerome's posterous

 

TweetDeck finally announced a new version that includes an easy way to sync groups. At the same time, a TweetDeck iPhone application is now available for download in the iTunes App store.

You can forget my old clunky way of syncing TweetDeck groups and install the latest TweetDeck desktop beta.

Once the new version is installed, you will be asked to sign in or create a TweetDeck account. This TweetDeck account will be used to keep your groups up-to-date in the cloud. Use the same TweetDeck account on other computers and your groups will be automagically synchronized.

If you have an iPhone, you can download the TweetDeck application. Once again, you can sign in your TweetDeck account to have access to your groups on your iPhone.

The main reason I use TweetDeck is because of the groups feature. In the new version, I noticed some welcomed improvements in its speed, specially when editing groups. However, I feel that mass editing groups is still clunky at best. Hopefully, in the future, they will build a Web interface (or better TweetDeck interface) that makes it easy to browse through people you follow on Twitter and assign them to different groups in one page step.

A little while ago, Facebook recognized the need to manage lists of friends. All friends are not equal. I feel that it’s the kind of feature Twitter (and any social network) needs in their API. I’m glad the TweetDeck folks recognize this need, but I would love to be able to bring my lists in any other third party applications.

My friend Michelle, the most famous blogger in Quebec, recently re-opened the Pandora box (text in French) about content piracy. Her case is simple: as an avid Lost fan, she simply has no legal means to watch the first 4 episodes of this season to catch up to her recorded episodes.

Another friend, Philippe Martin, tweeted about an article from France that talks about the 3 strikes law they are looking to adopt in France. In France, some suggested an amendment that propose to intervene only when the downloaded content is already available on the Internet. Interesting idea. In another tweet, Philippe points me to “Quebecor Opens Door to Canadian Three Strikes Policy”.

With the CRTC currently investigating net neutrality and being lobbied by companies such as Quebecor for a law similarly abusive than what a few countries like France want, I decided to play the role of a legislator and ask myself:

What would be the perfect anti-piracy law?

I don’t know if it’s perfect, but I think I came up with a damn good one.

Please note that to simplify the language I loosely use the term content owner. I am targeting the music and movie industry when referring to content owners.

Here’s the draft of my perfect anti-piracy law:

• An individual can download and share digital content from any source unless:
• the content has already been made available for download by the content owner
• the content was never released for personal listening or viewing by the content owner
• the content made available by the content owner is not copy protected

I haven’t talked about any coercive measures. That wasn’t the point. I wouldn’t wish for ISPs to spy on individuals. The point is that if you make content available for download through purchase (or freely with advertising), you are answering the needs of the consumer. You wouldn’t have any excuse to pirate and it would be easier to go against real pirates (those who profit from piracy).

Such a law would be progressive because it forces the music and movie industry to rethink their business model.

For example, no more region locking. If Hollywood wouldn’t make a movie available for download in Canada but would in the USA, it would be fare game for Canadians to download and share freely. It would force them to review global licensing issues.

It would also incite Canadian content owners to offer their content for download across the globe. I think it would benefit artists and everyone involved. I am confident artists would increase their royalties through increased sales.

It’s also important to allow individuals to be able to play the content the way they want to play it. To simplify things for consumers, content should not be copy protected. If I want to play my purchased movie through an iPod, the computer, an XBox, whatever, I should be able to. If I want to play a digital movie I purchased on the TV screen instead of the computer, I should be able to. Hollywood is just realizing, though the Hulu/Boxee saga that digital content can be played on the TV and want to control how users play Hulu’s content. It’s laughable since it is technologically easy to have a browser control play content on any screen, including the TV.

I also think we should force download availability as a prerequisite of content availability. Streaming-only technology put limits on the way we can play content (we need an Internet link). So, if a content is only made available through streaming, downloadable copies should be fare game to individuals.

What do you think?

What would be your perfect anti-piracy law?

UPDATE: TweetDeck finally added sync support.

I use multiple PCs. I have a Windows Vista laptop at work, a desktop Windows XP computer always on at home and a MacBook for work and pleasure. I also love using TweetDeck and it's groups feature is invaluable when you follow a lot of people. I needed a solution to sync group definitions and settings so that when I add someone to a group, the change follows me on my 3 computers.

Here's my solution.

Sign up for Live Mesh and add your computers

I find Live Mesh very useful to sync folders between computers and now has support for Mac OS X. It is free and I thought it would be the perfect answer to my problem. To set up your computer with Live Mesh:

• First visit the Live Mesh Web site and sign up.
• On each computer, click the "Add Device" button and install the Live Mesh software on your computer

Adding TweetDeck's data folder to Live Mesh using Windows

Start with the computer that has the TweetDeck data you want to keep.
You first need to find your TweetDeck folder. On Windows Vista it will be located here:

C:\Users\[Your Username]\AppData\Roaming\TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1\Local Store

On Windows XP, the path would be something like:

C:\Documents and Settings\[Your UserName]\Application Data\TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1\Local Store

The TweetDeck folder name begins with "TweetDeckFast.F" and is followed by a bunch of numbers. Inside this folder is the "Local Store" folder which contains the settings for your TweetDeck installation. It contains two files and a folder:

• An XML file with your TweetDeck settings (mine is named: preferences_JeromeParadis.xml)
• A database files that contain your TweetDeckdata (mine is named: td_26_JeromeParadis.db)
• A folder named "#ApplicationUpdater" which contains information about your latest TweetDeck version

Our strategy is that we don't want to synchronize the "#ApplicationUpdater" folder. It is used by TweetDeck updating process. When we' update TweetDeck we don’t want other PCs to think TweetDeck is updated. We cannot simply sync the hole "Local Store" and Live Mesh syncs all the content of a folder, including subfolders. So what do we do? Well, Live Mesh will not sync an hidden Windows folder.
To add the folder to your Live Mesh, here's what you need to do on Windows:

1. Right-click the "#ApplicationUpdater" folder inside the "Local Store" folder
2. Select "Properties" in the menu
3. In the "Attributes" section, check the "Hidden" option
4. Right-click the "Local Store" folder
5. Select the "Add folder to Live Mesh..." menu option
6. Give it a name you will remember like "TweetDeck Local Store"
7. After a moment, Live Mesh should begin uploading your xml and db files to Live Mesh

Syncing other TweetDeck instances under Windows

On a Windows computer, here's what you need to do to sync a second (or more) computer:

1. Make sure TweekDeck is closed
2. Locate your "Local Store" folder
3. Make a backup copy of the db and xml files inside the "Local Store" folder, just in case you mess up
4. Delete the db and xml files
5. Mark the exiting "#ApplicationUpdater" folder as "Hidden"
6. Open the "TweetDeck Local Store" shortcut that Live Mesh will have added to your Desktop
7. Live Mesh will ask you to enter a destination folder. Be sure that this path points to TweetDeck's existing "Local Store" folder
8. Answer Yes when warned that your folder will be merged with the Live Mesh folder
9. You should see the Live Mesh icon in your task bar flash which means it is active downloading.

How to selectively sync under Mac OS X

Remember that we don't want to sync the "#ApplicationUpdater" folder. We need a strategy to ignore this folder from the Live Mesh synchronization. Since I don't know the equivalent of hiding a file from Live Mesh under Mac OS X, here's a summary of what we should do:

1. Instead of directly syncing TweetDeck Data Store folder, we will sync with a second folder, say "TweetDeck Data Store"
2. We will make hard links between the xml and db files in TweetDeck's actual folder and the "TweetDeck Data Store" folder. Making an alias using the Finder won't work. We need to open a bash console using the Terminal utility and use the command line. If you have no idea what I'm talking about, I recommend you to stop reading now or that you proceed with care.
3. Then, we use the "TweedDeck Data Store" folder to sync with Live Mesh. The "#ApplicationUpdater" will therefore not be present in that new folder and not synced with Live Mesh.

Adding TweetDeck's data folder to Live Mesh using Mac OS X

If your computer containing your groups and settings to keep is Mac, you will want to first add your TweekDeck folder in Live Mesh from this computer. Here's how to proceed:

1. Locate your TweekDeck Local Store directory using the Finder by opening your hard drive icon. It should be something like [Your User Name]/Library/TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1/Local Store
2. Make a backup copy of the xml and db files in the "Local Store" folder in case something goes wrong. Note their names.
3. Add a folder named "TweetDeck Local Store" in your Documents folder
4. Open the Terminal application (in Applications/Utilities).
5. In the command prompt, navigate your new "TweetDeck Local Store" folder:
   1. cd /Volumes/Macintosh HD/Users/[Your User Name]/Documents/TweetDeck Local Store
6. Create hard links from your xml and db files to you "TweetDeck Local Store" folder:
   1. ln "../../Library/Preferences/TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1/Local Store/preferences_[TwitterName].xml" ./preferences_[TwitterName].xml
   2. ln "../../Library/Preferences/TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1/Local Store/td_26[YourUserName].db" ./td_26_[TwitterName].db
7. Then, add the "TweetDeck Local Store" folder to Live Mesh.
8. It should soon begin syncing your files to Live Mesh.

Syncing other TweetDeck instances under Mac OS X

To sync TweetDeck settings already on Live Mesh from Mac OS X, you follow these steps:

1. Using the Live Mesh application, add your existing "TweetDeck Local Store" Live Mesh folder to your Mac. Create the Mac folder in "Documents/TweetDeck Local Store".
2. Wait that Live Mesh has finished syncronizing the folder.
3. Locate TweetDeck's "Local Store" folder.
4. Make a backup copy of the xml and db files in TweetDeck's "Local Store" folder in case something goes wrong. Note their names. Delete them.
5. Open the Terminal applications and make hard links from your Live Mesh xml anbd db files in the "TweetDeck Local Store" folder to TweetDeck's "Local Store" folder:

cd /Volumes/Macintosh HD/Users/[Your User Name]/Documents/TweetDeck Local Store

ln ./preferences_[TwitterName].xml "../../Library/Preferences/TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1/Local Store/preferences_[TwitterName].xml"

ln ./td_26_[TwitterName].db "../../Library/Preferences/TweetDeckFast.FXXXXXXXXXXXXXXXXXXXX.1/Local Store/td_26_[TwitterName].db"

Caveat

When syncing with Live Mesh, the downside is that files should not be in use for syncing to proceed.
This means that to sync your TweetDeck settings, to other computers, you will need to close TweetDeck for the Live Mesh syncing to proceed. When using another computer, if it was shut down, you will need for the Live Mesh sync to finish before using TweetDeck. In my case, it means that:

• When using my desktop at home, I leave TweetDeck open. When going to work, I close TweetDeck. My upload connection is slow; this takes about 15 minutes.
• When arriving at work and boot up my Windows Vista laptop, I wait for the Live Mesh syncing to finish before opening TweetDeck. It takes a few minutes. 15 minutes before leaving work, I close TweetDeck for the syncing to start and finish.
• It's the same when using my MacBook: I also wait for the syncing to end before opening TweetDeck and before shutting it down, I close TweetDeck and wait for the syncing to end.

Note that my TweetDeck db file is quite large. It is 45 MB. I've looked at its content and it is due to the fact that TweetDeck used to store messages locally. I have a bunch of old tweets stored in it. TweetDeck never cleaned up nor compressed my database. If you started using TweetDeck recently, it shouldn't be a problem for you.

Compacting the TweetDeck database

If you've been a long-time TweetDeck user, your database is big enough that it's an inconvenient to sync. To compact the database, you need to clean up stored tweets that take too much space and compact the database. Follow these steps:

• Download the SQLite command-line tool at http://www.sqlite.org/download.html
• Make a backup copy of your db file.
• Execute the tool with your database as a parameter:
  • sqlite3.exe "[path to your db file]"
• In the command-line utility, delete the tweets, compact the database and quit:
  • delete from tweets;
  • vacuum;
  • .quit

That's it. Doing this my database shrank from 45MB to 1MB. Doing this, my upload syncs went from about 15 minutes to less than a minute!

I recently went for a week to Los Angeles. I did some geeky stuff like going to the BSGCast Frak party. Plus, at the same time there was an auction for Battlestar Galactica props. So, I had to tweet and make my Facebook friends salivate and stay in touch.

The iPhone is the perfect companion for such events, but you need to be careful with the data usage.

For example, the default data roaming fee for Rogers in the United States is 6$ per MB. Since I use maybe a MB or two per day (or even more), it can add up really fast. I was glad to learn Rogers has a new data roaming plan for the iPhone which costs:

• 10$ per month
• 1$ per MB

As far as I could see, this plan is not yet advertised on Roger’s Web site. When I called Rogers a week ago, I was told this data roaming plan was just recently added.

This means if you think you will be using more than 2MB during a stay in the United States, the plan begins to make sense. You can remove the plan when you come back so you don’t pay 10$ each month.

During my trip I must have used about near 25MB of data. With the 10$ monthly fee and data usage fees, this amounts to 35$ of data roaming fees. It does not come cheap, but it would have cost me 150$ without the plan.

To further monitor and control your data roaming usage, here are must-follow tips for your next trip in the United States.

1. Don’t forget to call Rogers about voice roaming packages if you plan to make or receive many phone calls
2. Call Rogers to enable the iPhone United States data roaming plan
3. Before the plane takes off from Canada, when asked to shut down cell phones, you can activate Airplane mode in Settings
   
   
4. To minimize unforeseen bandwidth usage while abroad, go in Settings/Fetch New Data and set Push to “Off” then Fetch to “Manually”. This way, you will only download new emails when going to look at your emails.
   
   
5. In Settings/General/Network, set Data Roaming to “Off”. If you plan to use only Wi-Fi you would leave that there always when abroad. However, even if you plan to use data roaming, it’s a good idea to disable it before arriving at your destination.
6. Clear your usage statistics. Go in Settings/General/Usage and press the “Reset Statistics” button. You need to scroll down the Usage page to see this button. This will clear your Cellular Network data usage.
   
   
7. When arriving at destination, leave the Airplane mode and put back data roaming to “On”.
8. During your stay, you can monitor your usage statistics to keep track of how much you will be paying for your stay.
9. When coming back to Canada, put back your Data Roaming to “Off” to be sure it’s off if you ever go to Europe or another country where data roaming rates would cost you a pension.
10. Don’t forget to call Rogers again to remove your data roaming plan from your account.
11. Remember that browsing Web sites can consume a lot of data. Refrain from visiting too many graphics-heavy Web sites. Try to browse iPhone optimized Web pages or use specialized applications. You will consume a lot less data and it will reduce the extra fees that will appear on your invoice.

EDIT 2009-01-22 23:34

1. Funny thing! A few hours after my post, my wife, Kim Vallée, independently posted on the same subject here. We didn't even knew about each of our similar posts! Of course, we had extensively discussed the subject, which explains the eerie similarity of our posts. :)
   
2. Highlighted some key words and the title after some tweets. Seems the new US data roaming plan is news to some.