Yeah, me too. This blog is typo, but to be honest, I’m not a big fan.

Here’s the problem.. I don’t really want a “rails application” at all - what I want is to be able to add blog features to my current applications.

With the need for mongrels et all, what I really think we need is either:

1) An application that you can point multiple domains to, e.g. blog.domain1.com, blog.domain2.com etc. that can be a single install / application with a single environment that is multi-purpose.

2) A blog plugin, that works off a single controller for admin, and a single controller for view that can be thrown into any rails application.

I’ve been working on 2, and it’s turning out pretty well, but at this point it’s too application specific to throw out to the open source community. The focus is on simple simple simple and seo seo seo.

What started off as a standalone project, has now been integrated into Billabill here.

Features include:

• SEO: Independent control of stub, title, H1 and tags
• SEO: Blog title displayed as H1 or H2 depending on context
• SEO: Blog summary used as full article teaser reused as meta description
• Full page caching with a very simple cache clearing mechanism
• Routing setup so that categories become root directory for posting
• Category stored with a post - no separate table. There’s really no need

It can do more than you can see at Billabill, but I’m not using everything, e.g. the ability for any post to be tagged as a header, footer or sidebar menu item.. Again, features on the front without any extra complexity.

What it would need to be great though is:

• Simple THREADED comments with subscription.. why are blog comments linear!
• RSS - 10 minute job, but I haven’t done it yet
• A parsing engine to allow you to easily include links to other internal pages
• A parsing engine to include flickr content etc.

Anyhoo. If I get a chance I’ll try to bundle this up and turn it into a plugin because I really think that is the answer.. just like you can add a WordPress blog to any php site, you should be able to add a rails blog alongside any rails app.

No offense, but I’m tired of Navicat and Emerald not playing well together. I used to be a big fan, I have a paid license, and I think the feature set is unequal, but if a tool I need every day doesn’t work every day, then I have to move on.

Why use a GUI Mysql tool?

In every other way I’m a command line junky. The idea of finding / creating / updating things in a mysql table using the mysql command line does not appeal to me AT ALL though. No way, in this scenario visibility is king.

GUI Mysql Tools like mysqlcc and navicat vs myphpadmin

Myphpadmin is a very popular tool for managing mysql settings and data. The difference between it and tools like mysqlcc and navicat are that mysqladmin is a php application that sits on the server.

The advantage of this is that by default, your mysql database will allow connections from “localhost” so you can throw mysqladmin up there and login. Locally installed tools however need an extra step, that you may or may not want to take, and that is that you have to tell mysql to ALLOW access to certain IP addresses. If you always work from the same place, and your IP address is fairly static, then that’s not a big deal. If you roam the earth though, you may have to open up ANY IP address and that’s a bad idea.

Allowing those IPs can be done through the nomal control panels like plesk or cpanel or using the mysql command line ( as root ).. Google it.

Why mysqlcc?

After giving up on Navicat, I looked around alot and eventually found mysqlcc. It’s OOOOLD but it’s great. In many ways not as good as Navicat, but in some even better - like the way a view has a mysql header at the top that you can modify to filter down results.. nice.

It’s very easy to install in Ubuntu ( tested under 32 and 64 bits from 7.04 to 8.04 ) even though it’s an old project, and not in the repositories.

The steps are basically:

1) Get the rpm install file 2) Convert it to a deb using alien 3) Install

The RPM

Download the appropriate RPM from here here. Select the 386 or amd64 version depending on your install.

Convert it to a .deb file

In a terminal,

sudo apt-get install alien

cd [directory where the rpm file is]

alien mysql*.rpm

sudo dpkg -i mysqlcc*.deb

You’re done. To launch type “mysqlcc” in a terminal or create an icon. If you think it looks old and clunky, well you’re right - but just go to Options > Themes and select “Plastik” and you have a very modern looking look and feel that will match your install very well.

I’m not yer “Have laptop, am good to go” kind of guy so I have multiple systems, of which one is a laptop for travel.

How did I afford that attitude when I was a windows user, or how much would switching to a Mac cost me? Lots! As a business owner I never used pirated software and had a license for every instance of every install I had. Because of that I was an early adoptor of things like Open Office, even on the PC, because I wasn’t going to shell out for more than one instance of Office.

I have 5 systems.

• Primary home office Dual monitor Ubuntu Desktop
• Primary outside office Dual monitor Ubuntu Desktop
• Ubuntu box in the home theatre room
• Ubuntu Laptop
• Old G4 to sync my iPhone to

Total software costs in the last 2 years? I bought a sync tool for my Mac to do two way sync between the iPhone and Google Calendar - and if I wanted my USB webcam to work with iChat I’d have to spend some more - but that’s another story.

Focusing on the systems that I use day in, day out - nothing is what I pay, with no compromises. Kick ass, hardcore business systems with interface features I couldn’t get anywhere else. Wow.

How do you like them apples?

Easy online time, cost and mileage tracking

Billabill springs to life. Billabill is all about time tracking but also allows you to track costs / expenses and mileage.

Full featured project time tracking and more

• Track projects for multiple clients and yourself
• Track time
• Track costs / expenses
• Track milesage
• Provide clients with “view only” login to their projects ( coming in beta )
• Group time and cost information together for reporting and as invoice evidence
• Send invoices! ( coming in Beta )

Dual purpose admin allows you to view your projects, and vendors projects in the same place

Once you get used to using Billabill to track your projects you’ll wish people doing work for you would use it too! An easy invitation option will allow your vendors to setup an account, and give you view-only access to the projects they are doing for you.

Planned iPhone and mobile interface to allow data entry on-the-go

What is the point of a tool that tracks your progress if you don’t update it regularily? Well that is much easier if you can enter your data from your phone or other mobile device

A flexible tool with a million uses

• Time tracking for client projects or your own needs
• Internal company time tracking - Billabill has everything you need
• Expense tracking / expense reports
• Mileage tracking for IRS compliance or project related travel

100% Free to get up and running

You have nothing to loose in trying Billabill. Signup is quick, easy, and free. Your free account will allow you to setup up to five projects with no feature restrictions. If you like what you see, and find that Billabill is right for you, then unlocking for limited projects costs only $7.95 / month.

Why Billabill?

Go and check out the options. You’ll find Project Management tools (with time tracking bolted on as an afterthought ), Invoicing tools ( with time tracking bolted on as an afterthought), and accounting systems (with time tracking bolted on as an afterthought ). You’ll find PC / Mac installable software ( that can only be accessed locally ), you’ll find mileage tracking products and expense report products that are geared towards more corporate customers.

What you WON’T find, is something like Billabill that has been developed from day one with the attitude that if you don’t use it every day, it’s worthless. That’s why Billabill is fun and easy to use. That’s why it’s focused on doing the simple tasks really well. It’s not trying to replace your accountant, or your accounting software. It’s not trying to manage your projects - it’s just trying to make sure that when you spend money, drive miles, or spend time on a project, that gets logged.

Try it. We think you’ll like it.

Billabill.com