Revision [187]
Last edited on 2005-06-29 04:10:39 by KogAdmin [added last-edit and info about dev copy]Additions:
{{lastedit show="3"}}
Project is in beta! [[http://pgfoundry.org/projects/trackerdb/ on PGFoundry]]
~- Development copy - {{colour hex="#444444" text="Email me please, this is case-by-case"}}
Project is in beta! [[http://pgfoundry.org/projects/trackerdb/ on PGFoundry]]
~- Development copy - {{colour hex="#444444" text="Email me please, this is case-by-case"}}
Deletions:
Additions:
==== TrackerDB Project Page ====
== History ==
TrackerDB was originally a class project from SOS2003-2004 DBMS component. Judith Cushing, the instructor, had a set of requirements for a project and I chose to write software to assist my father and Stan Reynolds of [[www.onbalance.biz On Balance Inc.]] by providing a system with better extensibility than their MS Access DB. It turned out that Access was better for them due to not needing a host and having RAD properties that allowed my father to tweak the software as needed. I guess this project is for more tech savvy people, or at lease people with simple operations.
I contemplated writing a .NET client, or Java perhaps (even though JDBC is sloooow). I don't even have time to fully develop the PHP site heh.
== History ==
TrackerDB was originally a class project from SOS2003-2004 DBMS component. Judith Cushing, the instructor, had a set of requirements for a project and I chose to write software to assist my father and Stan Reynolds of [[www.onbalance.biz On Balance Inc.]] by providing a system with better extensibility than their MS Access DB. It turned out that Access was better for them due to not needing a host and having RAD properties that allowed my father to tweak the software as needed. I guess this project is for more tech savvy people, or at lease people with simple operations.
I contemplated writing a .NET client, or Java perhaps (even though JDBC is sloooow). I don't even have time to fully develop the PHP site heh.
Deletions:
Additions:
[[TrackerDB]] is a project to provide work order tracking for computer repair shops. Tracker is written for PHP5/PostgreSQL (developed on 8.0). There is no plan whatsoever to use MySQL.
Tracker is developed under the BSD license so as not to hinder small companies from getting their free (read: beer and liberty), quality software. I do request, however, that you send an email to kog =at= epiphanic =dot= org (yeah, = are for antispam) and let me know what you use it for, how you heard about it and whatever sort of updates I can make to it. Like other authors, I'm curious what people do with my work.
I really think this project has some potential, which is why out of all of my projects I plan on devoting the most attention to this one. Now that I've got my degree, I'm getting my life in order and dragging out the code for this - it's going to need some significant rewrites and some work, but it's getting there. I wrote the original source base when I was fairly new to both programming and database design.
== Project Status ==
Project is in beta! Going to put up a copy, and release an RC [[http://pgfoundry.org/projects/trackerdb/ on PGFoundry]]
== Links ==
~- [[TrackerDBScreenShots Screen shots]]
~- [[TrackerDBDownloads Download information]]
~- [[TrackerDBLicensing License information]]
~- [[TrackerDBInstallation Installation information]]
~- [[TrackerDBHelp Help]]
~- [[TrackerDBDevelopment Development Information]]
~- [[TrackerDBBugs Bug Tracking]]
~- [[TrackerDBFeatures Feature Requests]]
Tracker is developed under the BSD license so as not to hinder small companies from getting their free (read: beer and liberty), quality software. I do request, however, that you send an email to kog =at= epiphanic =dot= org (yeah, = are for antispam) and let me know what you use it for, how you heard about it and whatever sort of updates I can make to it. Like other authors, I'm curious what people do with my work.
I really think this project has some potential, which is why out of all of my projects I plan on devoting the most attention to this one. Now that I've got my degree, I'm getting my life in order and dragging out the code for this - it's going to need some significant rewrites and some work, but it's getting there. I wrote the original source base when I was fairly new to both programming and database design.
== Project Status ==
Project is in beta! Going to put up a copy, and release an RC [[http://pgfoundry.org/projects/trackerdb/ on PGFoundry]]
== Links ==
~- [[TrackerDBScreenShots Screen shots]]
~- [[TrackerDBDownloads Download information]]
~- [[TrackerDBLicensing License information]]
~- [[TrackerDBInstallation Installation information]]
~- [[TrackerDBHelp Help]]
~- [[TrackerDBDevelopment Development Information]]
~- [[TrackerDBBugs Bug Tracking]]
~- [[TrackerDBFeatures Feature Requests]]
Deletions:
Tracker is developed under the BSD license so as not to hinder small companies from getting their free (read: beer and liberty), quality software. I do request, however, that you send an email to kog =at= epiphanic =dot= org (yeah, = are for antispam) and let me know what you use it for, how you heard about it and whatever sort of updates I can make to it.
The only copy in use was EVO Gaming before they defaulted and ceased existing. Eventually a report module will be built and you can modify all kinds of report stuff for printing. Why? In some states it's a legal requirement to have a specific form. Hopefully I can integrate PDF creation of some sort too. As you can see this is a really long term project and gets worked on as I have time (which is fewer and far between these days...).
==== PGFoundry ====
PGFoundry was kind enough to agree to host my project which can be found [[http://pgfoundry.org/projects/trackerdb/ on PGFoundry]]. All releases will go through them as per my agreement.
==== PostgreSQL ====
Why PSQL? MySQL 4.0 was beta at the time of the original development, and does not provide any sort of referential integrity, triggers, decent constraints, views, procedures or anything else really. I figure that the system will be small enough such that the performance hit that PSQL supposedly has will be minimal.
== Installing PSQL ==
TO ADD
== Setting up PGSQL ==
remember to rehash....
==== History ====
TrackerDB was originally a class project from SOS2003-2004 DBMS component. Judith Cushing, the instructor, had a set of requirements for a project and I chose to write software to assist my father and Stan Reynolds of [[www.onbalance.biz On Balance Incorporated]] by providing a system with better extensibility than their MS Access DB. It turned out that Access was better for them due to not needing a host and having RAD properties that allowed my father to tweak the software as needed. I guess this project is for more tech savvy people, or at lease people with simple operations.
I contemplated writing a .NET client, or Java perhaps (even though JDBC is sloooow). I don't even have time to fully develop the PHP site heh.