Task Timer Portable 1.11
|
Date Added: |
Mar 31, 2011 01:35 AM |
Publisher's Description: |
Timer.pl is written in perl and logs work hours to a MySQL or to a PostgreSQL database (there are 2 versions of the script, 1 for each type of database). You should know that PostgreSQL is free. MySQL costs somewhere around $600 for embedded use the last time I checked I think, but it was difficult getting numbers out of them (timer.pl is an embedded database program). You will need ActivePerl for Windows or Mac or some kind of Perl language installed, and Tk and DBD-mysql or DBD-PgPP packages to run the script. They may both be built in, or you may have to install Perl/Tk.
This is a multi-user client program, but only to a point. Where it stops being multiuser is where the user must hit a button to query the db for the most up-to-date task number (program increments it). The code should really be eliminating this field from the user interface altogether, although it is a good indication of whether the input is a good match or not. Actually, an even better idea is keeping it there for the user to use, but eliminating the global variable tied to it from being used in the INSERT queries. The INSERT query should be wrapped in a transaction, since it will have a new "(SELECT 1+MAX($dbschema.work.tasknum))" for a value for tasknum in the INSERT. I think I can fix this in the next version. Should be simple.
The cool thing about the perl database program is that you can use it to write other database clients that have a GUI. However, if you are planning on company-wide distribution, consider these facts:
ActiveState Perl for Windows has an OEM license that gives redistribution rights. If you are corporate, you will probably need some sort of corporate license.
Perl usually comes built-into Linux and all UNIX.
you need to run ppm, the perl package manager, to install more packages. from it, you can see which packages you have, install new packages, remove packages, and install packages. I think if you install, it essentially upgrades.
These programs are under GPL3 license.
|
Screenshot: |
|
Documentation: |
http://jesusnjim.com/code/windows/tasktimer.html |
Last Download: |
Apr 23, 2024 05:56 PM
|
Downloads: |
364 |
OS: |
Windows |
Rating: |
|
|
|