<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Helvetica, Arial, sans-serif">Hi all,<br>
<br>
<font face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif"><font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif"><font face="Helvetica, Arial,
sans-serif"><font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif">when we
started to refactor the code of nodeshot<font
face="Helvetica, Arial, sans-serif"></font></font>
<font face="Helvetica, Arial, sans-serif">I <font
face="Helvetica, Arial, sans-serif">would have
liked to be able to support any kind of
database<font face="Helvetica, Arial,
sans-serif"> supported by Django. Now after
quite many months </font></font>of work I
am <font face="Helvetica, Arial, sans-serif">slowly
starting to und<font face="Helvetica, Arial,
sans-serif">erstand that PostgreSQL has a
few killer <font face="Helvetica, Arial,
sans-serif">funct<font face="Helvetica,
Arial, sans-serif">ionalit<font
face="Helvetica, Arial, sans-serif">ies</font>
that <font face="Helvetica, Arial,
sans-serif">make perfect sense for <font
face="Helvetica, Arial, sans-serif">us.<br>
<br>
<font face="Helvetica, Arial,
sans-serif">The functionalities
i'm mostly talking about are <font
face="Helvetica, Arial,
sans-serif">2 in particular:<br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
<ol>
<li><font face="Helvetica, Arial, sans-serif">inet <font
face="Helvetica, Arial, sans-serif">type: support for ip <font
face="Helvetica, Arial, sans-serif">(v4 and v6) address
storage, subnet info, and mac address<br>
<br>
<font face="Helvetica, Arial, sans-serif">this DB type
makes it possible to check whether an ip+subnet that is
being entered in the DB</font></font></font></font>
doesn't conflict with another ip+subnet in the network which is
something that can easily happen in a decentralized wireless
network where usually anybody can choose an IP<br>
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<a
href="http://www.postgresql.org/docs/9.1/static/datatype-net-types.html">http://www.postgresql.org/docs/9.1/static/datatype-net-types.html</a><br>
<br>
</li>
<li>PostGIS:
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<a href="http://postgis.refractions.net/">http://postgis.refractions.net/</a><br>
this should make it easier to retrieve other nodes in a certain
distance range from a node from the database, and some other
useful spatial information.. I don't know if it's really worth
it for the switch, has anybody else worked with it before?<br>
</li>
</ol>
<font face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif"><font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif"><font face="Helvetica, Arial,
sans-serif"><font face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"><font
face="Helvetica, Arial, sans-serif"></font></font></font><br>
This would come at the disa<font face="Helvetica,
Arial, sans-serif">vantage that a<font
face="Helvetica, Arial, sans-serif">nybody th<font
face="Helvetica, Arial, sans-serif">at would
want to try nodeshot2 would have to have a PGSQL
in<font face="Helvetica, Arial, sans-serif">stance
<font face="Helvetica, Arial, sans-serif">up
and running; <font face="Helvetica, Arial,
sans-serif">plus <font face="Helvetica,
Arial, sans-serif">any<font
face="Helvetica, Arial, sans-serif">body
who uses MySQL would have <font
face="Helvetica, Arial, sans-serif">to
switch and convert their DB.<br>
<br>
<font face="Helvetica, Arial,
sans-serif">I'm no<font
face="Helvetica, Arial,
sans-serif">t a big <font
face="Helvetica, Arial,
sans-serif">fan of MySQL, as
far <font face="Helvetica,
Arial, sans-serif">as i'm
concerned for usual low to
medium traffic web
application<font
face="Helvetica, Arial,
sans-serif">s there's no
much difference<font
face="Helvetica, Arial,
sans-serif"> between <font
face="Helvetica,
Arial, sans-serif">the
two<font
face="Helvetica,
Arial, sans-serif"></font></font></font></font></font></font></font></font>.<br>
<br>
<font face="Helvetica, Arial,
sans-serif">I'd like to think <font
face="Helvetica, Arial,
sans-serif">if anybody in this
list has <font face="Helvetica,
Arial, sans-serif">some<font
face="Helvetica, Arial,
sans-serif">thing
interesting to say about <font
face="Helvetica, Arial,
sans-serif">this.<br>
<br>
<font face="Helvetica,
Arial, sans-serif">Federico</font><br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
</body>
</html>