DBD-TreeData
view release on metacpan or search on metacpan
README.html view on Meta::CPAN
],</pre>
<p>Would create the following tables:</p>
<pre> <main_table>
address_component_groups
address_components
type_groups
types</pre>
<p>In this case, <code>address_components</code> has most of the columns and data, but it also has a tie to an ID of <code>address_component_groups</code>.</p>
<p>Since <code>types</code> points to an array, it will have its own dedicated table. That table would have data like:</p>
<pre> type_id │ type
════════╪════════════════
1 │ street_number
2 │ establishment
3 │ route
4 │ locality
5 │ political
... │ ...</pre>
<p>Most of the <code>type_groups</code> table would be a 1:1 match. However, the last component entry has more than one value in the <code>types</code> array, so the <code>type_group_id</code> associated to that component would have multiple entries ...
<h1><a class='u'
name="CAVEATS"
>CAVEATS</a></h1>
<h2><a class='u'
name="DBI_/_DBD::AnyData_Conflict"
>DBI / DBD::AnyData Conflict</a></h2>
<p>As of the time of this writing, the latest version of <a href="http://search.cpan.org/perldoc?DBI" class="podlinkpod"
>DBI</a> (1.623) and the latest version of <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> (0.110) do not work together. Since TreeData relies on <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> for table creation, you will need to downgrade to <a href="http://search.cpan.org/perldoc?DBI" class="podlinkpod"
>DBI</a> 1.622 to use this driver, until a new version of <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> comes out.</p>
<h1><a class='u'
name="AVAILABILITY"
>AVAILABILITY</a></h1>
<p>The project homepage is <a href="https://github.com/SineSwiper/DBD-TreeData/wiki" class="podlinkurl"
>https://github.com/SineSwiper/DBD-TreeData/wiki</a>.</p>
<p>The latest version of this module is available from the Comprehensive Perl Archive Network (CPAN). Visit <a href="http://www.perl.com/CPAN/" class="podlinkurl"
>http://www.perl.com/CPAN/</a> to find a CPAN site near you, or see <a href="https://metacpan.org/module/DBD::TreeData/" class="podlinkurl"
>https://metacpan.org/module/DBD::TreeData/</a>.</p>
<h1><a class='u'
name="SUPPORT"
>SUPPORT</a></h1>
<h2><a class='u'
name="Internet_Relay_Chat"
>Internet Relay Chat</a></h2>
<p>You can get live help by using IRC ( Internet Relay Chat ). If you don't know what IRC is, please read this excellent guide: <a href="http://en.wikipedia.org/wiki/Internet_Relay_Chat" class="podlinkurl"
>http://en.wikipedia.org/wiki/Internet_Relay_Chat</a>. Please be courteous and patient when talking to us, as we might be busy or sleeping! You can join those networks/channels and get help:</p>
<ul>
<li>irc.perl.org
<p>You can connect to the server at 'irc.perl.org' and join this channel: #dbi then talk to this person for help: SineSwiper.</p>
</li>
</ul>
<h2><a class='u'
name="Bugs_/_Feature_Requests"
>Bugs / Feature Requests</a></h2>
<p>Please report any bugs or feature requests via <a href="http://search.cpan.org/perldoc?GitHub" class="podlinkpod"
><a href="https://github.com/SineSwiper/DBD-TreeData/issues" class="podlinkurl"
>https://github.com/SineSwiper/DBD-TreeData/issues</a></a>.</p>
<h1><a class='u'
name="AUTHOR"
>AUTHOR</a></h1>
<p>Brendan Byrd <BBYRD@CPAN.org></p>
<h1><a class='u'
name="COPYRIGHT_AND_LICENSE"
>COPYRIGHT AND LICENSE</a></h1>
<p>This software is Copyright (c) 2013 by Brendan Byrd.</p>
<p>This is free software, licensed under:</p>
<pre> The Artistic License 2.0 (GPL Compatible)</pre>
<!-- end doc -->
</body></html>
( run in 1.155 second using v1.01-cache-2.11-cpan-39bf76dae61 )