Difference between revisions of "FGdb"

From FreekiWiki
Jump to navigation Jump to search
 
(26 intermediate revisions by 8 users not shown)
Line 1: Line 1:
 
==Description==
 
==Description==
−
This is PHP code ( http://www.php.net/ ) that talks to a PostgreSQL database ( http://www.postgresql.org/ ). It is responsible for tracking all our gizmos and their statuses, all our volunteers and the hours they've worked, all our receipts for donations and sales, and more. Everything runs in a web browser.
+
FGdb is where lots of data about Free Geek is kept, including such things as volunteer names and hours, gizmo types and flow, dollar amounts of donations we've received, and much more. It is comprised of a [http://www.postgresql.org/ PostgreSQL] database and a [http://www.ruby-lang.org Ruby] front end.
  
−
==Project Status==
+
You can access it through a web browser, provided you're inside the Free Geek building (not including the wireless network.) Just type the word '''data''' in the address bar (you know, where you'd usually type a big long URL like http://www.example.com.)
−
This code is in a constant state of change. There's always work needed.
 
  
−
==Queue==
+
If you want to find information that isn't available through the web page, and are familiar with (or willing to learn) SQL, check out [[FGdb SQL queries]] for some suggestions.
−
The [[RT]] queue for this project is called FGdb.
 
  
−
==Sub-projects==
+
===Project Status===
−
* Contacts -- Anything relating to tracking volunteers, donors, customers, or other contact information for people '''or organizations''' in the database. -- Martin Chase is working on these related projects.
+
The new code is running live in [[Free_Geek|PDX]], [[Free_Geek_Vancouver|Vancouver]], and [[Free_Geek_Columbus|Columbus]].  Look at http://dev.freegeek.org/projects/fgdb.rb/timeline to see what we're working on.
−
** Volunteer tracking and volunteer hours maintenance
 
−
** Membership program tracking (people making regular cash contributions to Free Geek)
 
−
** Sales receipts (we sell stuff to customers)
 
−
** Donation receipts (donors give us stuff)
 
  
−
* Gizmos -- Anything relating to tracking gizmos in the database.
+
== Documentation ==
−
** new gizmo entry (at receiving)
+
[[FGdb Documentation]]
−
** editing existing gizmos
 
−
** cloning of several similar gizmos at the same time
 
  
−
* System checkout -- The process of tying a system's component gizmos to it, assigning an adopter to it, assigning an appropriate value and status to each gizmo, and attributing (in hours) the "value" of the system. This happens when a system is sent to the store, adopted, or granted out.
+
== Bugs ==
  
−
* Reports -- Anything that only requires read access to the database.
+
Problem with the database? Create a technocrats ticket in RT. Screenshots are helpful.
−
** volunteer reports -- who's in what program, who's waiting to get in, where are they in the process, etc. -- Douglas Howard is working on this.
 
−
** gizmo reports -- how many gizmos of which types were received, recycled, etc.
 
  
−
* Data Integrity and Cleaning -- Finding old problem in the data itself, removing them, and preventing their reoccurance. This is SQL intensive and less about PHP. -- David Jencks and Richard Seymour are working on this.
+
[[Category: Coders]][[Category: FGdb]]
−
 
 
−
==Unstarted sub-projects==
 

Latest revision as of 12:13, 15 April 2011

Description

FGdb is where lots of data about Free Geek is kept, including such things as volunteer names and hours, gizmo types and flow, dollar amounts of donations we've received, and much more. It is comprised of a PostgreSQL database and a Ruby front end.

You can access it through a web browser, provided you're inside the Free Geek building (not including the wireless network.) Just type the word data in the address bar (you know, where you'd usually type a big long URL like http://www.example.com.)

If you want to find information that isn't available through the web page, and are familiar with (or willing to learn) SQL, check out FGdb SQL queries for some suggestions.

Project Status

The new code is running live in PDX, Vancouver, and Columbus. Look at http://dev.freegeek.org/projects/fgdb.rb/timeline to see what we're working on.

Documentation

FGdb Documentation

Bugs

Problem with the database? Create a technocrats ticket in RT. Screenshots are helpful.

Retrieved from "http://wiki.freegeek.org/index.php?title=FGdb&oldid=56037"