Differences between revisions 4 and 5
Revision 4 as of 2002-06-04 20:12:06
Size: 597
Editor: DonPark
Comment:
Revision 5 as of 2002-06-04 20:16:37
Size: 772
Editor: DonPark
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Database Databases
Line 11: Line 11:
  * Lat
  * Long
  * Type: GPS loc
Line 16: Line 15:
  * Type: Address
  * Type: Affiliated groups [n]
  * Type: User, Owner
  * Type: User, Maintainer
  *

* GPS Loc
  * float lat
  * float long
  * float altitude

Databases

  • User
    • First Name
    • Last Name
    • Wireless Community ID # (off the back of your wifi id card :)

    • Username (Key)
    • IM: ICQ
    • IM: Jabber ID
  • Node
    • Type: GPS loc
    • Antenna type
    • Antenna pointing direction
    • Power output
    • Type: Address
    • Type: Affiliated groups [n]
    • Type: User, Owner
    • Type: User, Maintainer

* GPS Loc

  • float lat
  • float long
  • float altitude

System for getting at the data

  • XML-RPC interface
  • xmlrpc.personaltelco.net:3322
  • inserts
  • updates
  • queries
    • Q: <nodequery sql="select * where name=\"PCHS\" " />

    • A: <node> <name>PCHS</name> </node> ...

Implementation

  • PHP page talking to a MySQL server


[CategoryDocumentation]

CommunityDatabase (last edited 2012-03-11 02:06:36 by RussellSenior)