= Network Nodes Database =
== Existing Node Databases ==
* '''nodeDB''' (Funkfeuer new node database) [https://github.com/FFM/] | Documentation and design: [https://github.com/FFM/FFM/blob/master/doc/cwnos.txt design document and requirements analysis] [https://github.com/FFM/FFM/blob/master/doc/cwnos-architecture-overivew.pdf architecture diagram]
* '''Guifi.net''' (Wlan Espana) [http://gitorious.org/guifi Source code on Gitorious] | [http://gitorious.org/guifi/drupal-guifi/blobs/master/guifi.install Database Shema (Database addons for Drupal 6)] | [http://guifi.net/en/node/36672 HowTo add a new Node in Guifi.net] | [https://docs.google.com/document/d/1XYHOMaSkEe2mCj0_Va0pE2om-oHrWifkEInQ2NJ3W18/edit?hl=de Guifi.net business logic]
* '''Nodewatcher''' (wlan slovenija) [http://dev.wlan-si.net/wiki/GetSource Source code on Trac] | [[NodesDatabase/Schema/WlanSlovenija|Database Schema]]
* '''Freifunk Node Database''' (Freifunk Hannover) [http://github.com/knox/nodes Source code on Github!] | [[NodesDatabase/Schema/Freifunk|Database Schema]]
* '''Netmon''' (Freifunk Oldenburg) [http://trac.freifunk-ol.de/ Source code on Trac] | [[NodesDatabase/Schema/Netmon|Database Schema]]
* '''Redeemer''' (Funkfeuer Wien) [http://sourceforge.net/projects/redeemer/ Source code on Sourceforge] | [[NodesDatabase/Schema/FunkFeuer|Database Schema Wien]] | [[NodesDatabase/Schema/FunkFeuerGraz|Database Schema Graz]]
* '''WiND''' (Athens Wireless Metropolitan Network) [http://wind.cube.gr/ Source code on Trac] | [http://wind.cube.gr/browser/trunk/install/schema.sql|Database Schema] | [http://en.wikipedia.org/wiki/Wireless_Nodes_Database Wikipedia article] | [http://wind.cube.gr/ Development Area] | [https://docs.google.com/document/d/1qfOXNrLBrGwU8lKBHIQAShnqgNE3udPoSYEMOhKWoDI/edit?hl=en_US Business logic]
* '''NodeDB Augsburg''' (Freifunk Augsburg) [http://augsburg.freifunk.net/nodes.html Source code is missing]
* '''NodeDB Jena''' (Freifunk Jena) [http://www.freifunk-jena.de/NodeDB (Source code is missing)]
* '''IP Vergabe''' (Freifunk Berlin) [http://ip.berlin.freifunk.net/index.html (Source code is missing)]
* '''DDMesh Hotspots''' (Freifunk Dresden) [http://www.ddmesh.de/hotspots.html (Source Code is missing)]
* '''Nodeübersicht Bonn''' (Freifunk Bonn) [http://bonn.freifunk.net/tiki-index.php?page=Nodes%C3%BCbersicht (Tikiwiki, Source code?)]
* '''DB''' (Freifunk Leipzig) [https://db.leipzig.freifunk.net/ (Source code is missing)]
* '''Anomo''' (Freifunk Leipzig) [https://dev.leipzig.freifunk.net/trac/wiki/ANOMO Source code on Trac] | [https://dev.leipzig.freifunk.net/trac/browser/anomo/cgi-bin/definitions.sql Database Schema]
* old '''Funkfeuer redeemer DB''' (Austria) [https://marvin.funkfeuer.at/frontend_wien/ Node Database] | [http://map.funkfeuer.at Map]
* '''Mesh DB (mdb)''' (Arig, Israel) [http://taproot.org.il/project/mdb/mdb.xhtml Homepage] | [http://git.taproot.org.il/mdb?p=org.taproot.mdb;a=tree;h=refs/heads/development;hb=development Source code]

== Development of a Global Node Database ==
Amir and Aaron and Floh1111 are going to develop a schema for a global node database. Flo111 will participate  as his Google Summer of Code 2011 project. All discussions on this task will be made on the [https://lists.funkfeuer.at/mailman/listinfo/nodedb-interop Nodedb-Interop Mailinglist] and all developers are invited to participate in the diskussion and the process of development.

The Global Node Database for Freifunk Communities will be a Database that:
* unites all existing freifunk node databases in one common database schema so that development ressources can be saved and global applications depending on data from the database can be developed (every community will have its own database, but the data can be made available in a common format)
* has all features of the existing node databases
* defines a common API on top of the database so that applications can be written to work with this common API
* has an api which can be queried by applications on the nodes or other applications like a global map, whois server, user adressbook...
* has only a set of common features turned on but allows to turn on special features used only by a special community so that everyone has the features he needs. Think RFC MUST, SHOULD, MAY definitions.
* hast last but not least a view for every existing node database so that the data can be easily migrated or the exising node databases can uses the new common node database for storing data without completely migrating the code to the new database

The Database will be well documented and I hope it will become the first choice for all community wireless networks. All informations about the GSoC 2011 Project can be visited on the [http://www.google-melange.com/gsoc/project/google/gsoc2011/gsocfloh1111/11001 GSoC 2011 proposal page].
The code base for the common NodeDB is: https://github.com/aaronkaplan/commonNodeDB


=== Current development state of the Database Schema ===
Information about the development process can be visited on the [http://blog.freifunk-ol.de/category/gsoc2011/ blog of the project].

The current development state of the schema can be accessed on our [https://github.com/aaronkaplan/commonNodeDB Github Repository]