up one level
Using phpLiteAdmin as a Daily Task Tracker and a Work Activity Log
Using phpLiteAdmin as a daily task tracker and a work activity log
On my shared web hosting, both
UsingSugarCRM CE as a task tracker and UsingCollabPress as a task tracker were taking thousands of
milliseconds to load the page after each server-refresh-mouse-click.
Now I use phpLiteAdmin which is much quicker. The whole solution is comprised of a tasks table and a notes table.
Here are the table creation schemas:
CREATE TABLE "btc_tasks" (‘date’ DATETIME DEFAULT
CURRENT_DATE, ‘task’ TEXT)
CREATE TABLE "btc_notes" (‘date_time’ DATETIME DEFAULT
CURRENT_TIMESTAMP, ‘note’ TEXT)
On both the tasks and notes tables, I set the date (or date+time) field to use phpLiteAdmin’s date stamp or time stamp functionality.
Here is my work flow:
– Into the tasks table, insert a new task with due date.
– I use the due date to order the tasks– if its an important task I put the date today and if its a secondary task I put it tomorrow or later.
– Screenshot here of the tasks ordered by date ascending:
– From the list of tasks with today’s date I pick the one most important task and work on it.
– To break from a task or to punt it to later, I update the date — either individually or with this SQL query: UPDATE â€œtasks” SET “date” = ‘2014-10-26’ WHERE “date” = ‘2014-10-25’
– In the notes table along with date+time I insert a note of a task’s progress.
– Screenshot here of the insert note form:
– When I complete a task I delete the task.
– At the end of the week I look at the list of notes. It’s become a report my week’s accomplishments.
– Screenshot here of the notes table ordered by date_time descending:
I use phpLiteAdmin as a daily task tracker and a work activity log. On the same shared hosting it is much faster than were either the CollabPress or the SugarCRM CE installations.
*2015-01-21 edit: previously published at http://w̶i̶e̶l̶d̶l̶i̶n̶u̶x̶.̶c̶o̶m̶/2014-12-09-phpliteadmin-as-task-manager.html
*2015-06-04 edit: edited to fix broken links and clean up white space.
[2020 edit: Moved to: https://investorworker.com/2014/... .html.]