Differences between revisions 1 and 9 (spanning 8 versions)
← Revision 1 as of 2002-06-03 20:05:12 →
Size: 68
Editor: DonPark
Comment:
← Revision 9 as of 2002-06-06 08:23:08 →
Size: 1453
Editor: user-uini6a1
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Database
 User
 Node
 Statistics
DonPark and AdamShand are thinking about ways to create a SQL/LDAP/XML/something schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that we're going to want to store in it (yes we know we're doomed to failure :-).

 Don, it occurred to me that it might be worth checking out the NoCatAuth SQL schema (etc/nocat.schema in the tarball), they had originally planned for it to be more then just the auth server. -- Adam.

Databases
 * User
  * String username (Key)
  * String first_name
  * String last_name
  * String wireless_community_id (off the back of your wifi id card :)
  * Type ICQ, icq_id
  * Type Jabber, jabber_id
  * Type Address, mailing
  * Type Login, last_login

 * Node
  * String id (Key)
  * Type: GPS, gps_loc
  * Type: Antenna, antenna_type
  * Type: Direction antenna_pointing_direction
  * int power_output
  * Type: Address, Antenna
  * Type: Affiliated group [n]
  * Type: User, Owner [n]
  * Type: User, Maintainer [n]

 * GPS Loc
  * float lat
  * float long
  * float altitude
Line 6: Line 33:
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
Line 8: Line 47:
[CategoryUnknown] [CategoryDocumentation]

DonPark and AdamShand are thinking about ways to create a SQL/LDAP/XML/something schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that we're going to want to store in it (yes we know we're doomed to failure :-).

  • Don, it occurred to me that it might be worth checking out the NoCatAuth SQL schema (etc/nocat.schema in the tarball), they had originally planned for it to be more then just the auth server. -- Adam.

Databases

  • User
    • String username (Key)
    • String first_name
    • String last_name
    • String wireless_community_id (off the back of your wifi id card :)

    • Type ICQ, icq_id
    • Type Jabber, jabber_id
    • Type Address, mailing
    • Type Login, last_login
  • Node
    • String id (Key)
    • Type: GPS, gps_loc
    • Type: Antenna, antenna_type
    • Type: Direction antenna_pointing_direction
    • int power_output
    • Type: Address, Antenna
    • Type: Affiliated group [n]
    • Type: User, Owner [n]
    • Type: User, Maintainer [n]
  • 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)