CR Post to Ping.fm not working – resolved.

Last couple of months I was having a tough time getting the plugins in my wordpress to work with the ping.fm service.  This is the only service that I rely on to post my blogs. So, basically I was left with no mechanism to publish my new posts 🙁

Now thanks to this post I am able to use the plugin again and thus update my status at multiple places again.

using wordpress CLI to post to wordpress

There is a very nice post here: How to post content to a WordPress blog from the command line

I tried this in Fedora 14 and here is the way to get this working in Fedora

  <td>
    <div class="text codecolorer">
      su -<br /> <br /> cpan<br /> <br /> install WordPress::CLI WordPress::Post
    </div>
  </td>
</tr>

Now, once the above completes make sure that the path /usr/local/bin is in you path.

Performance issues resolved with my blog.

For last 2-3 weeks there were quite a lot of performance issues with my website. I was looking at the same but could not get enough time to have all of them resolved together. Finally I have spent time on my web hosting and wordpress installation to resolve these issues.

I have taken this opportunity to optimize the blog also. Now the page loading time should be much lesser and you should not be seeing any issues with respect to the site performance or un-availability. If you do see some issues, leave me a comment or contact me through contact me page.

Using SQLite to maintain your monthly bills.

I was looking for a small application to maintain my every month bills. The application had to be small and script-able. I basically wanted to keep track of the bills that have been generated and pending payment and the bills that have been paid.

First we will create the <a class="zem_slink" title="Database" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database">database schema with the following command:

  <td>
    <div class="text codecolorer">
      CREATE TABLE bills(name varchar(20), due_dt text, p_dt text, amount integer);
    </div>
  </td>
</tr>

So, I built on the knowledge gathered on <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite. And here is a small script that I wrote:

SQLite – simple use in scripts

Today we will look a the most simple use&#8217;s in the scripts and how to use them.

echo &#8221;insert into bills values (&#8221;$name&#8221;,$date_now, $date_now,$1)&#8221;|sqlite bills

or the other way to do this is

<a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">sqlite3 bills &#8221;insert into bills values (&#8221;$name&#8221;,$date_now, $date_now,$1)&#8221;

OK, now in the next post we will see a simple application that I am currently developing or planning.<h6 class="zemanta-related-title" style="font-size: 1em;">Related articles by Zemanta <ul class="zemanta-article-ul"> <li class="zemanta-article-ul-li"><a href="http://tobu.lightbird.net/">Tobu Tutorial (tobu.lightbird.net) <li class="zemanta-article-ul-li"><a href="http://go.theregister.com/feed/www.theregister.co.uk/2010/07/02/openoffice_adopts_gstreamer/">OpenOffice gets Ubuntu-media friendly (go.theregister.com) <li class="zemanta-article-ul-li"><a href="http://elegantcode.com/2010/07/02/using-transactionscope-with-sqlite/">Using TransactionScope with SQLite (elegantcode.com) <li class="zemanta-article-ul-li"><a href="http://www.slideshare.net/aikisteve/flash-and-the-city-2010">Flash And The City 2010 (slideshare.net) <div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Enhanced by Zemanta" href="http://www.zemanta.com/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://img.zemanta.com/zemified_e.png?x-id=7b7c893c-d92b-44bc-8923-d7c6fddc8b42" alt="Enhanced by Zemanta" /><span class="zem-script more-related pretty-attribution">