Author: timbo
Date: Tue Jul 17 07:25:36 2007
New Revision: 9752
Modified:
dbi/trunk/dbi.tiddlyspot.com.html
Log:
dbi.tiddlyspot.com FAQ update
Modified: dbi/trunk/dbi.tiddlyspot.com.html
==============================================================================
--- dbi/trunk/dbi.tiddlyspot.com.html (original)
+++ dbi/trunk/dbi.tiddlyspot.com.html Tue Jul 17 07:25:36 2007
@@ -546,22 +546,7 @@
}}}
</pre>
</div>
-<div title="DBI FAQ 1.2. Where can I get it from?" modifier="RobertHicks"
modified="200706221226" created="200706221200" tags="DBI" changecount="3">
-<pre>The Comprehensive Perl Archive Network resources should be used for
retrieving up-to-date versions of the DBI and drivers. CPAN may be accessed via
Tom Christiansen's splendid CPAN multiplexer program located at:
-
-{{{
- http://www.perl.com/CPAN/
-}}}
-
-For more specific version information and exact URLs of drivers, please see
the DBI drivers list and the DBI module pages which can be found on:
-
-{{{
- http://dbi.perl.org/
- http://www.symbolstone.org/technology/perl/DBI
-}}}
-This list is automatically generated on a nightly basis from CPAN and should
be up-to-date.</pre>
-</div>
-<div title="DBI FAQ 1.3. Where can I get more information?"
modifier="RobertHicks" modified="200706221226" created="200706221204"
tags="DBI" changecount="12">
+<div title="DBI FAQ 1.3. Where can I get more information?"
modifier="TimBunce" modified="200707171253" created="200706221204" tags="DBI"
changecount="13">
<pre>There are a few information sources on DBI.
//"Programming the Perl DBI"//
@@ -739,24 +724,6 @@
http://www.symbolstone.org/technology/perl/DBI
}}}
-''Mailing Lists''
-
-There are three mailing lists for DBI:
-
-{{{
- [EMAIL PROTECTED] -- for announcements, very low traffic
- [EMAIL PROTECTED] -- general user support
- [EMAIL PROTECTED] -- for driver developers (no user support)
-}}}
-
-For information on how to subscribe, set digest mode etc, and unsubscribe,
send an email message (the content will be ignored) to:
-
-{{{
- [EMAIL PROTECTED]
- [EMAIL PROTECTED]
- [EMAIL PROTECTED]
-}}}
-
''Mailing List Archives''
//US Mailing List Archives//
@@ -776,6 +743,15 @@
As per the US archive above.
</pre>
</div>
+<div title="DBI Mailing Lists" modifier="TimBunce" modified="200707171133"
created="200707171127" changecount="6">
+<pre>There are three DBI mailing lists:
[EMAIL PROTECTED]|http://lists.cpan.org/showlist.cgi?name=dbi-announce]]
+This is a very low traffic list (typically well under one email per week) just
for announcements of new releases and significant issues. All DBI users should
be subscribed to it.
[EMAIL PROTECTED]|http://lists.cpan.org/showlist.cgi?name=dbi-users]]
+This is the main DBI mailing list. Typically a few messages each day. This is
the place to ask for help
[[smartly|http://www.catb.org/~esr/faqs/smart-questions.html]].
[EMAIL PROTECTED]|http://lists.cpan.org/showlist.cgi?name=dbi-dev]]
+This list is for developers who work on the source code of the DBI and
drivers. Questions about installation issues or usage of the DBI or drivers
should be posted to dbi-users, //not// here. </pre>
+</div>
<div title="Database Drivers" modifier="TimBunce" modified="200706232203"
created="200706232149" changecount="9">
<pre>!Here's a list of drivers for the DBI
@@ -861,16 +837,28 @@
<div title="DefaultTiddlers" modifier="TimBunce" modified="200706232130"
created="200706221222" changecount="2">
<pre>[[Welcome to the DBI FAQ]]</pre>
</div>
-<div title="Edit This FAQ" modifier="TimBunce" modified="200706272115"
created="200706232129" changecount="3">
-<pre>You're welcome to edit this FAQ to add your own notes.
+<div title="Edit This FAQ" modifier="TimBunce" modified="200707171250"
created="200706232129" changecount="8">
+<pre>You're welcome to edit this FAQ to add your own notes. It uses
[[TiddlyWiki|http://www.tiddlywiki.com/]] so the FAQ runs in your browser using
JavaScript.
+
+To edit an entry (known as a 'tiddler') just click the 'edit' button to the
right of the title, make your changes, then click on 'done'. Simple.
+
+For help with formatting see http://tiddlyspot.com/twhelp/ especially the
Formatting Tiddlers section, and
http://nothickmanuals.info/doku.php/cheatsheets.
+
+To create new entries it's best to edit an existing one first, to add in a
link to your about-to-be-created entry. Click on 'done' and then click on your
new link. Please take a moment to think about good names for new entries and
good places to link from.
+
+Your changes only alter the local copy of the FAQ document in the memory of
your web browser. To save your changes you need to either upload it (see below)
or save the page to a local file (use 'Save As' in your browsers File menu, and
make sure the file has a .html extension).
-To share your DBI knowledge you'll need to upload your modified FAQ. For now
we're not giving out the password because there's little revision control and
there's a risk of concurrent edits being lost. So, after making your changes,
just "Save As" this page to a file and send it to RobertHicks or
myself TimBunce.
+To share your DBI knowledge, and avoid your changes getting out of sync,
you'll need to upload your modified FAQ. We're not giving out the direct upload
password widely for now because there's little revision control and there's a
risk of concurrent edits being lost. So, after making your changes, just
"Save As" this document to a file and send it to RobertHicks or
myself TimBunce.
-For help with formatting see http://tiddlyspot.com/twhelp/ especially the
Formatting Tiddlers section, and http://nothickmanuals.info/doku.php/cheatsheets
See also [[Welcome to Tiddlyspot]] and GettingStarted
</pre>
</div>
+<div title="Get More Help" modifier="TimBunce" modified="200707171108"
created="200707171106" changecount="2">
+<pre>The [[DBI Home Page|http://dbi.perl.org]] offers a general overview of
DBI related information, the [[Perl Monks|http://perlmonks.org]] web site is a
great place to learn more about perl and perl modules like DBI, but the [[DBI
Mailing Lists]] are the primary source of help for specific problems with the
DBI or drivers.
+
+Wherever you go to ask for more help, be sure to ask [[Smart
Questions|http://www.catb.org/~esr/faqs/smart-questions.html]].</pre>
+</div>
<div title="GettingStarted" modifier="RobertHicks" created="200706211226"
changecount="1">
<pre>To get started with this blank TiddlyWiki, you'll need to modify the
following tiddlers:
* SiteTitle & SiteSubtitle: The title and subtitle of the site, as shown
above (after saving, they will also appear in the browser title bar)
@@ -878,9 +866,6 @@
* DefaultTiddlers: Contains the names of the tiddlers that you want to appear
when the TiddlyWiki is opened
You'll also need to enter your username for signing your edits: <<option
txtUserName>></pre>
</div>
-<div title="Help save the world! Add to and edit this FAQ. It's quick and
simple and helps everyone. " modifier="TimBunce" created="200706192058"
changecount="1">
-<pre>a reusable non-linear personal web notebook</pre>
-</div>
<div title="How does one CONNECT to Oracle with DBD::Oracle?"
modifier="RobertHicks" modified="200706221237" created="200706221217"
tags="Oracle" changecount="4">
<pre>Look at these example code pieces. In this example, ORCL is the database
connect descriptor.
@@ -919,44 +904,38 @@
$dbh2->disconnect or warn "DB2 disconnection failed:
$DBI::errstr\n";
}}}</pre>
</div>
-<div title="Install DBI from CPAN" modifier="RobertHicks"
created="200706281232" changecount="2">
+<div title="Install DBI from CPAN" modifier="TimBunce" modified="200707171143"
created="200706281232" changecount="4">
<pre>If you are installing DBI on a UNIX like system you can do the following
to install the DBI module:
-
{{{
perl -MCPAN -e install DBI
}}}
-
Or from within the cpan shell started with "perl -MCPAN -e shell" or
"cpan" ^^[1]^^:
-
{{{
cpan> install DBI
}}}
-
-^^[1]^^ Starting with the 5.8 series, Perl has a shortcut to start cpan so you
don't have to use the "perl -MCPAN -e shell" command.</pre>
+^^[1]^^ Starting with the 5.8 series, Perl installs a "cpan" command
so you don't have to use the "perl -MCPAN -e shell" command.</pre>
</div>
-<div title="Install DBI from Source" modifier="RobertHicks"
modified="200706281342" created="200706281258" changecount="3">
-<pre>The DBI source can be downloaded from:
-
-[[DBI|http://search.cpan.org/~timb/DBI/DBI.pm]]
-
-Once you have staged that source then Build/test/install the DBI by doing:
+<div title="Install DBI from Source" modifier="TimBunce"
modified="200707171139" created="200706281258" changecount="6">
+<pre>The DBI source code can be downloaded as a gzipped tar file from
[[search.cpan.org|http://search.cpan.org/~timb/DBI]]
+Once you have downloaded the 'tar ball' then the typical command sequence on
unix-like systems would be:
{{{
+tar xfz DBI-1.XX.tar.gz
+cd DBI-1.XX
perl Makefile.PL
make
make test
make install
}}}
+Then delete the source directory tree since it's no longer needed.
-Then delete the source directory tree since it's no longer needed.</pre>
+If you're using Windows then you probably want to [[Install DBI using PPM]]
instead.</pre>
</div>
-<div title="Install DBI from Subversion" modifier="RobertHicks"
modified="200706281256" created="200706281251" changecount="3">
+<div title="Install DBI from Subversion" modifier="TimBunce"
modified="200707171142" created="200706281251" changecount="5">
<pre>The DBI source code is maintained using Subversion (see
http://subversion.tigris.org/). To access the source you'll need to install a
Subversion client. Then, to get the source code, do:
-
{{{
svn checkout http://svn.perl.org/modules/dbi/trunk
}}}
-
If it prompts for a //username// and //password// use your perl.org account if
you have one, else just 'guest' and 'guest'. The source code will be in a new
subdirectory called trunk.
@@TODO: describe how to install from the source@@
@@ -964,34 +943,28 @@
To keep informed about changes to the source you can send an empty email to
@@[EMAIL PROTECTED]@@ after which you'll get an email with the change log
message and diff of each change checked-in to the source.
After making your changes you can generate a patch file, but before you do,
make sure your source is still upto date using:
-
{{{
svn update
}}}
-
If you get any conflicts reported you'll need to fix them first. Then generate
the patch file from within the trunk directory using:
-
{{{
svn diff > foo.patch
}}}
+Read the patch file, as a sanity check, and then email it to @@[EMAIL
PROTECTED]@@.
-Read the patch file, as a sanity check, and then email it to @@[EMAIL
PROTECTED]@@.</pre>
+Thank you!</pre>
</div>
-<div title="Install DBI using PPM" modifier="RobertHicks"
created="200706281234" changecount="1">
-<pre>If you are using the ActiveState version of Perl then you can install the
DBI 2 ways:
+<div title="Install DBI using PPM" modifier="TimBunce" modified="200707171141"
created="200706281234" changecount="3">
+<pre>If you are using the ActiveState version of Perl then you can install the
DBI using the PPM utility:
From a command prompt:
-
{{{
ppm install DBI
}}}
-
-From the PPM shell ^^[1]^^ itself:
-
+Or start the PPM shell^^[1]^^ and enter the command:
{{{
install DBI
}}}
-
^^[1]^^ The latest version of PPM from Activestate includes a graphical user
interface to their ppm repository. If you use this gui then installing the DBI
is simple a matter of searching, selecting and installing the DBI module.</pre>
</div>
<div title="Installing DBI" modifier="RobertHicks" modified="200706281259"
created="200706272036" changecount="9">
@@ -1012,9 +985,6 @@
[[Get More Help]]
[[Edit This FAQ]]</pre>
</div>
-<div title="Perl DBI FAQ" modifier="TimBunce" created="200706192056"
changecount="1">
-<pre>My TiddlyWiki</pre>
-</div>
<div title="SiteSubtitle" modifier="TimBunce" modified="200706192113"
created="200706192111" changecount="4">
<pre>Gain DBI experience. Share DBI experience.</pre>
</div>
@@ -1091,18 +1061,18 @@
//}}}
</pre>
</div>
-<div title="UploadLog" modifier="RobertHicks" modified="200706281342"
created="200706192053">
+<div title="UploadLog" modifier="TimBunce" modified="200707171254"
created="200706192053">
<pre>| !date | !user | !location | !storeUrl | !uploadDir | !toFilename |
!backupdir | !origin |
-| 23/06/2007 23:03:20 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
-| 23/06/2007 23:10:14 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
-| 27/06/2007 09:31:04 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
-| 27/06/2007 21:40:17 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . | ok |
| 27/06/2007 22:16:26 | TimBunce |
[[/|http://dbi.tiddlyspot.com/#%5B%5BHelp%20save%20the%20world!%20Add%20to%20and%20edit%20this%20FAQ.%20It's%20quick%20and%20simple%20and%20helps%20everyone.%20%5D%5D]]
| [[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
| 28/06/2007 08:53:59 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
| 28/06/2007 09:02:09 | RobertHicks |
[[/|http://dbi.tiddlyspot.com/#%5B%5BInstalling%20DBI%5D%5D%20%5B%5BInstall%20DBI%20from%20Source%5D%5D%20%5B%5BInstall%20DBI%20from%20Subversion%5D%5D%20%5B%5BInstall%20DBI%20from%20CPAN%5D%5D%20%5B%5BWelcome%20to%20the%20DBI%20FAQ%5D%5D]]
| [[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
| 28/06/2007 09:03:24 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
| 28/06/2007 09:41:40 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
-| 28/06/2007 09:42:26 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |</pre>
+| 28/06/2007 09:42:26 | RobertHicks | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
+| 17/07/2007 11:51:31 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . | ok |
+| 17/07/2007 11:57:01 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . | ok |
+| 17/07/2007 12:47:12 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |
+| 17/07/2007 13:54:10 | TimBunce | [[/|http://dbi.tiddlyspot.com/]] |
[[store.cgi|http://dbi.tiddlyspot.com/store.cgi]] | . | [[index.html |
http://dbi.tiddlyspot.com/index.html]] | . |</pre>
</div>
<div title="UploadPlugin" modifier="YourName" modified="200706192051"
created="200706061221" tags="systemConfig">
<pre>/***
@@ -1737,6 +1707,11 @@
</pre>
</div>
+<div title="Using DBI" modifier="TimBunce" created="200707171146"
changecount="1">
+<pre>First you need to know about [[Getting Connected]], then you might want
to know about [[Selecting and Fetching Data]].
+
+You may also want help [[Using Transactions]].</pre>
+</div>
<div title="Welcome to the DBI FAQ" modifier="TimBunce"
modified="200706232205" created="200706232133" changecount="6">
<pre>!Got a DBI question?
