DB or C++

[willbr]

I keep a log book of things I do to my car like checking air in the tires,
getting gas... What I would like to do is put this stuff in a DB. The
format I have been using on paper is:

Date - Mileage - Category - Description
Jan.8, 2005 - 12345.1 - FUEL - 20.123 gal @ $1.509 (35mpg) [480trip]
Jan.9, 2005 - 12350.5 - TIRE - RF:Flat. Put on spare.
Jan.15, 2005 - 12355.4 - TIRE - LF:35, LR:32, RF:34,RR:32. All>35

First is that each category potentially has a different set of fields from
others. Most would be just a text description, but others like the FUEL, I
would like to enter the Gallons, the Trip & the Price per gallon & have the
DB calculate the miles per gallon.

Another problem comes from for example the TIRE category where most of the
time I put in the pressure before adding air & then what I aired them up
to, as in that Jan.15 entry above, but when I buy new tires or have a flat
the format for that category will need to change.

Can this reasonably be done with a MySQL DB or should I write a C++
program to do it?

Thanks,
Bill

[Aggro]

Re: DB or C++

willbr wrote:
[color=blue]
> Can this reasonably be done with a MySQL DB or should I write a C++
> program to do it?[/color]

Is there a reason why you wouldn't want to use Excell or OpenOffice Calc
for that job? Because it sounds like a perfect job for it since both
can do the simple math your system requires.

Of course you could do a better solution with MySQL or C++ or both
combined, but that would require more work from you.

[willbr]

Re: DB or C++

On Sun, 06 Feb 2005 19:22:06 +0000, Aggro wrote:
[color=blue]
> willbr wrote:
>[color=green]
>> Can this reasonably be done with a MySQL DB or should I write a C++
>> program to do it?[/color]
>
> Is there a reason why you wouldn't want to use Excell or OpenOffice Calc
> for that job? Because it sounds like a perfect job for it since both
> can do the simple math your system requires.
>
> Of course you could do a better solution with MySQL or C++ or both
> combined, but that would require more work from you.[/color]
gnumeric is what I am using now. I would like to automate some of the
input & also have a better search. Plus with MySQL I can use PHP to manke
it platform independent.

Thanks,
Bill

[Aggro]

Re: DB or C++

willbr wrote:
[color=blue]
> gnumeric is what I am using now. I would like to automate some of the
> input & also have a better search. Plus with MySQL I can use PHP to manke
> it platform independent.[/color]

Well PHP + MySQL is pretty simple and fast to implement, if you got the
skills. So that would be my second suggestion. I don't think you would
gain anythin extra by using C++ if you already got a webserver + PHP.

[willbr]

Re: DB or C++

On Mon, 07 Feb 2005 15:45:17 +0000, Aggro wrote:
[color=blue]
> willbr wrote:
>[color=green]
>> gnumeric is what I am using now. I would like to automate some of the
>> input & also have a better search. Plus with MySQL I can use PHP to
>> manke it platform independent.[/color]
>
> Well PHP + MySQL is pretty simple and fast to implement, if you got the
> skills. So that would be my second suggestion. I don't think you would
> gain anythin extra by using C++ if you already got a webserver + PHP.[/color]
I can do PHP & MySQL.

[Bill Karwin]

Re: DB or C++

willbr wrote:[color=blue]
> I can do PHP & MySQL.[/color]

I just came across the following tool. Perhaps it does what you need
already, or else it can get you started and you can modify it to do what
you want.

http://phpmyedit.org/home.php

Regards,
Bill K.