forked from perl5-dbi/dbi
/
dbi.tiddlyspot.com.html
10132 lines (9200 loc) · 324 KB
/
dbi.tiddlyspot.com.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<script type="text/javascript">
//<![CDATA[
var version = {title: "TiddlyWiki", major: 2, minor: 2, revision: 4, date: new Date("Jun 19, 2007"), extensions: {}};
//]]>
</script>
<!--
TiddlyWiki created by Jeremy Ruston, (jeremy [at] osmosoft [dot] com)
Copyright (c) UnaMesa Association 2004-2007
Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:
Redistributions of source code must retain the above copyright notice, this
list of conditions and the following disclaimer.
Redistributions in binary form must reproduce the above copyright notice, this
list of conditions and the following disclaimer in the documentation and/or other
materials provided with the distribution.
Neither the name of the UnaMesa Association nor the names of its contributors may be
used to endorse or promote products derived from this software without specific
prior written permission.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT
SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH
DAMAGE.
-->
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<!--PRE-HEAD-START-->
<!--{{{-->
<link rel='alternate' type='application/rss+xml' title='RSS' href='index.xml'/>
<!--}}}-->
<!--PRE-HEAD-END-->
<title> Perl DBI FAQ - Gain DBI experience. Share DBI experience. </title>
<style type="text/css">
#saveTest {display:none;}
#messageArea {display:none;}
#copyright {display:none;}
#storeArea {display:none;}
#storeArea div {padding:0.5em; margin:1em 0em 0em 0em; border-color:#fff #666 #444 #ddd; border-style:solid; border-width:2px; overflow:auto;}
#shadowArea {display:none;}
#javascriptWarning {width:100%; text-align:center; font-weight:bold; background-color:#dd1100; color:#fff; padding:1em 0em;}
</style>
<!--POST-HEAD-START-->
<!--POST-HEAD-END-->
</head>
<body onload="main();" onunload="if(window.checkUnsavedChanges) checkUnsavedChanges(); if(window.scrubNodes) scrubNodes(document.body);">
<!--PRE-BODY-START-->
<!--PRE-BODY-END-->
<div id="copyright">
Welcome to TiddlyWiki created by Jeremy Ruston, Copyright © 2007 UnaMesa Association
</div>
<noscript>
<div id="javascriptWarning">This page requires JavaScript to function properly.<br /><br />If you are using Microsoft Internet Explorer you may need to click on the yellow bar above and select 'Allow Blocked Content'. You must then click 'Yes' on the following security warning.</div>
</noscript>
<div id="saveTest"></div>
<div id="backstageCloak"></div>
<div id="backstageButton"></div>
<div id="backstageArea"><div id="backstageToolbar"></div></div>
<div id="backstage">
<div id="backstagePanel"></div>
</div>
<div id="contentWrapper"></div>
<div id="contentStash"></div>
<div id="shadowArea">
<div title="ColorPalette">
<pre>Background: #fff
Foreground: #000
PrimaryPale: #8cf
PrimaryLight: #18f
PrimaryMid: #04b
PrimaryDark: #014
SecondaryPale: #ffc
SecondaryLight: #fe8
SecondaryMid: #db4
SecondaryDark: #841
TertiaryPale: #eee
TertiaryLight: #ccc
TertiaryMid: #999
TertiaryDark: #666
Error: #f88</pre>
</div>
<div title="StyleSheetColors">
<pre>/*{{{*/
body {background:[[ColorPalette::Background]]; color:[[ColorPalette::Foreground]];}
a {color:[[ColorPalette::PrimaryMid]];}
a:hover {background-color:[[ColorPalette::PrimaryMid]]; color:[[ColorPalette::Background]];}
a img {border:0;}
h1,h2,h3,h4,h5,h6 {color:[[ColorPalette::SecondaryDark]]; background:transparent;}
h1 {border-bottom:2px solid [[ColorPalette::TertiaryLight]];}
h2,h3 {border-bottom:1px solid [[ColorPalette::TertiaryLight]];}
.button {color:[[ColorPalette::PrimaryDark]]; border:1px solid [[ColorPalette::Background]];}
.button:hover {color:[[ColorPalette::PrimaryDark]]; background:[[ColorPalette::SecondaryLight]]; border-color:[[ColorPalette::SecondaryMid]];}
.button:active {color:[[ColorPalette::Background]]; background:[[ColorPalette::SecondaryMid]]; border:1px solid [[ColorPalette::SecondaryDark]];}
.header {background:[[ColorPalette::PrimaryMid]];}
.headerShadow {color:[[ColorPalette::Foreground]];}
.headerShadow a {font-weight:normal; color:[[ColorPalette::Foreground]];}
.headerForeground {color:[[ColorPalette::Background]];}
.headerForeground a {font-weight:normal; color:[[ColorPalette::PrimaryPale]];}
.tabSelected{color:[[ColorPalette::PrimaryDark]];
background:[[ColorPalette::TertiaryPale]];
border-left:1px solid [[ColorPalette::TertiaryLight]];
border-top:1px solid [[ColorPalette::TertiaryLight]];
border-right:1px solid [[ColorPalette::TertiaryLight]];
}
.tabUnselected {color:[[ColorPalette::Background]]; background:[[ColorPalette::TertiaryMid]];}
.tabContents {color:[[ColorPalette::PrimaryDark]]; background:[[ColorPalette::TertiaryPale]]; border:1px solid [[ColorPalette::TertiaryLight]];}
.tabContents .button {border:0;}
#sidebar {}
#sidebarOptions input {border:1px solid [[ColorPalette::PrimaryMid]];}
#sidebarOptions .sliderPanel {background:[[ColorPalette::PrimaryPale]];}
#sidebarOptions .sliderPanel a {border:none;color:[[ColorPalette::PrimaryMid]];}
#sidebarOptions .sliderPanel a:hover {color:[[ColorPalette::Background]]; background:[[ColorPalette::PrimaryMid]];}
#sidebarOptions .sliderPanel a:active {color:[[ColorPalette::PrimaryMid]]; background:[[ColorPalette::Background]];}
.wizard {background:[[ColorPalette::PrimaryPale]]; border:1px solid [[ColorPalette::PrimaryMid]];}
.wizard h1 {color:[[ColorPalette::PrimaryDark]]; border:none;}
.wizard h2 {color:[[ColorPalette::Foreground]]; border:none;}
.wizardStep {background:[[ColorPalette::Background]]; color:[[ColorPalette::Foreground]];
border:1px solid [[ColorPalette::PrimaryMid]];}
.wizardStep.wizardStepDone {background::[[ColorPalette::TertiaryLight]];}
.wizardFooter {background:[[ColorPalette::PrimaryPale]];}
.wizardFooter .status {background:[[ColorPalette::PrimaryDark]]; color:[[ColorPalette::Background]];}
.wizard .button {color:[[ColorPalette::Foreground]]; background:[[ColorPalette::SecondaryLight]]; border: 1px solid;
border-color:[[ColorPalette::SecondaryPale]] [[ColorPalette::SecondaryDark]] [[ColorPalette::SecondaryDark]] [[ColorPalette::SecondaryPale]];}
.wizard .button:hover {color:[[ColorPalette::Foreground]]; background:[[ColorPalette::Background]];}
.wizard .button:active {color:[[ColorPalette::Background]]; background:[[ColorPalette::Foreground]]; border: 1px solid;
border-color:[[ColorPalette::PrimaryDark]] [[ColorPalette::PrimaryPale]] [[ColorPalette::PrimaryPale]] [[ColorPalette::PrimaryDark]];}
#messageArea {border:1px solid [[ColorPalette::SecondaryMid]]; background:[[ColorPalette::SecondaryLight]]; color:[[ColorPalette::Foreground]];}
#messageArea .button {color:[[ColorPalette::PrimaryMid]]; background:[[ColorPalette::SecondaryPale]]; border:none;}
.popupTiddler {background:[[ColorPalette::TertiaryPale]]; border:2px solid [[ColorPalette::TertiaryMid]];}
.popup {background:[[ColorPalette::TertiaryPale]]; color:[[ColorPalette::TertiaryDark]]; border-left:1px solid [[ColorPalette::TertiaryMid]]; border-top:1px solid [[ColorPalette::TertiaryMid]]; border-right:2px solid [[ColorPalette::TertiaryDark]]; border-bottom:2px solid [[ColorPalette::TertiaryDark]];}
.popup hr {color:[[ColorPalette::PrimaryDark]]; background:[[ColorPalette::PrimaryDark]]; border-bottom:1px;}
.popup li.disabled {color:[[ColorPalette::TertiaryMid]];}
.popup li a, .popup li a:visited {color:[[ColorPalette::Foreground]]; border: none;}
.popup li a:hover {background:[[ColorPalette::SecondaryLight]]; color:[[ColorPalette::Foreground]]; border: none;}
.popup li a:active {background:[[ColorPalette::SecondaryPale]]; color:[[ColorPalette::Foreground]]; border: none;}
.popupHighlight {background:[[ColorPalette::Background]]; color:[[ColorPalette::Foreground]];}
.listBreak div {border-bottom:1px solid [[ColorPalette::TertiaryDark]];}
.tiddler .defaultCommand {font-weight:bold;}
.shadow .title {color:[[ColorPalette::TertiaryDark]];}
.title {color:[[ColorPalette::SecondaryDark]];}
.subtitle {color:[[ColorPalette::TertiaryDark]];}
.toolbar {color:[[ColorPalette::PrimaryMid]];}
.toolbar a {color:[[ColorPalette::TertiaryLight]];}
.selected .toolbar a {color:[[ColorPalette::TertiaryMid]];}
.selected .toolbar a:hover {color:[[ColorPalette::Foreground]];}
.tagging, .tagged {border:1px solid [[ColorPalette::TertiaryPale]]; background-color:[[ColorPalette::TertiaryPale]];}
.selected .tagging, .selected .tagged {background-color:[[ColorPalette::TertiaryLight]]; border:1px solid [[ColorPalette::TertiaryMid]];}
.tagging .listTitle, .tagged .listTitle {color:[[ColorPalette::PrimaryDark]];}
.tagging .button, .tagged .button {border:none;}
.footer {color:[[ColorPalette::TertiaryLight]];}
.selected .footer {color:[[ColorPalette::TertiaryMid]];}
.sparkline {background:[[ColorPalette::PrimaryPale]]; border:0;}
.sparktick {background:[[ColorPalette::PrimaryDark]];}
.error, .errorButton {color:[[ColorPalette::Foreground]]; background:[[ColorPalette::Error]];}
.warning {color:[[ColorPalette::Foreground]]; background:[[ColorPalette::SecondaryPale]];}
.lowlight {background:[[ColorPalette::TertiaryLight]];}
.zoomer {background:none; color:[[ColorPalette::TertiaryMid]]; border:3px solid [[ColorPalette::TertiaryMid]];}
.imageLink, #displayArea .imageLink {background:transparent;}
.annotation {background:[[ColorPalette::SecondaryLight]]; color:[[ColorPalette::Foreground]]; border:2px solid [[ColorPalette::SecondaryMid]];}
.viewer .listTitle {list-style-type:none; margin-left:-2em;}
.viewer .button {border:1px solid [[ColorPalette::SecondaryMid]];}
.viewer blockquote {border-left:3px solid [[ColorPalette::TertiaryDark]];}
.viewer table, table.twtable {border:2px solid [[ColorPalette::TertiaryDark]];}
.viewer th, .viewer thead td, .twtable th, .twtable thead td {background:[[ColorPalette::SecondaryMid]]; border:1px solid [[ColorPalette::TertiaryDark]]; color:[[ColorPalette::Background]];}
.viewer td, .viewer tr, .twtable td, .twtable tr {border:1px solid [[ColorPalette::TertiaryDark]];}
.viewer pre {border:1px solid [[ColorPalette::SecondaryLight]]; background:[[ColorPalette::SecondaryPale]];}
.viewer code {color:[[ColorPalette::SecondaryDark]];}
.viewer hr {border:0; border-top:dashed 1px [[ColorPalette::TertiaryDark]]; color:[[ColorPalette::TertiaryDark]];}
.highlight, .marked {background:[[ColorPalette::SecondaryLight]];}
.editor input {border:1px solid [[ColorPalette::PrimaryMid]];}
.editor textarea {border:1px solid [[ColorPalette::PrimaryMid]]; width:100%;}
.editorFooter {color:[[ColorPalette::TertiaryMid]];}
#backstageArea {background:[[ColorPalette::Foreground]]; color:[[ColorPalette::TertiaryMid]];}
#backstageArea a {background:[[ColorPalette::Foreground]]; color:[[ColorPalette::Background]]; border:none;}
#backstageArea a:hover {background:[[ColorPalette::SecondaryLight]]; color:[[ColorPalette::Foreground]]; }
#backstageArea a.backstageSelTab {background:[[ColorPalette::Background]]; color:[[ColorPalette::Foreground]];}
#backstageButton a {background:none; color:[[ColorPalette::Background]]; border:none;}
#backstageButton a:hover {background:[[ColorPalette::Foreground]]; color:[[ColorPalette::Background]]; border:none;}
#backstagePanel {background:[[ColorPalette::Background]]; border-color: [[ColorPalette::Background]] [[ColorPalette::TertiaryDark]] [[ColorPalette::TertiaryDark]] [[ColorPalette::TertiaryDark]];}
.backstagePanelFooter .button {border:none; color:[[ColorPalette::Background]];}
.backstagePanelFooter .button:hover {color:[[ColorPalette::Foreground]];}
#backstageCloak {background:[[ColorPalette::Foreground]]; opacity:0.6; filter:'alpha(opacity:60)';}
/*}}}*/</pre>
</div>
<div title="StyleSheetLayout">
<pre>/*{{{*/
* html .tiddler {height:1%;}
body {font-size:.75em; font-family:arial,helvetica; margin:0; padding:0;}
h1,h2,h3,h4,h5,h6 {font-weight:bold; text-decoration:none;}
h1,h2,h3 {padding-bottom:1px; margin-top:1.2em;margin-bottom:0.3em;}
h4,h5,h6 {margin-top:1em;}
h1 {font-size:1.35em;}
h2 {font-size:1.25em;}
h3 {font-size:1.1em;}
h4 {font-size:1em;}
h5 {font-size:.9em;}
hr {height:1px;}
a {text-decoration:none;}
dt {font-weight:bold;}
ol {list-style-type:decimal;}
ol ol {list-style-type:lower-alpha;}
ol ol ol {list-style-type:lower-roman;}
ol ol ol ol {list-style-type:decimal;}
ol ol ol ol ol {list-style-type:lower-alpha;}
ol ol ol ol ol ol {list-style-type:lower-roman;}
ol ol ol ol ol ol ol {list-style-type:decimal;}
.txtOptionInput {width:11em;}
#contentWrapper .chkOptionInput {border:0;}
.externalLink {text-decoration:underline;}
.indent {margin-left:3em;}
.outdent {margin-left:3em; text-indent:-3em;}
code.escaped {white-space:nowrap;}
.tiddlyLinkExisting {font-weight:bold;}
.tiddlyLinkNonExisting {font-style:italic;}
/* the 'a' is required for IE, otherwise it renders the whole tiddler in bold */
a.tiddlyLinkNonExisting.shadow {font-weight:bold;}
#mainMenu .tiddlyLinkExisting,
#mainMenu .tiddlyLinkNonExisting,
#sidebarTabs .tiddlyLinkNonExisting {font-weight:normal; font-style:normal;}
#sidebarTabs .tiddlyLinkExisting {font-weight:bold; font-style:normal;}
.header {position:relative;}
.header a:hover {background:transparent;}
.headerShadow {position:relative; padding:4.5em 0em 1em 1em; left:-1px; top:-1px;}
.headerForeground {position:absolute; padding:4.5em 0em 1em 1em; left:0px; top:0px;}
.siteTitle {font-size:3em;}
.siteSubtitle {font-size:1.2em;}
#mainMenu {position:absolute; left:0; width:10em; text-align:right; line-height:1.6em; padding:1.5em 0.5em 0.5em 0.5em; font-size:1.1em;}
#sidebar {position:absolute; right:3px; width:16em; font-size:.9em;}
#sidebarOptions {padding-top:0.3em;}
#sidebarOptions a {margin:0em 0.2em; padding:0.2em 0.3em; display:block;}
#sidebarOptions input {margin:0.4em 0.5em;}
#sidebarOptions .sliderPanel {margin-left:1em; padding:0.5em; font-size:.85em;}
#sidebarOptions .sliderPanel a {font-weight:bold; display:inline; padding:0;}
#sidebarOptions .sliderPanel input {margin:0 0 .3em 0;}
#sidebarTabs .tabContents {width:15em; overflow:hidden;}
.wizard {padding:0.1em 1em 0em 2em;}
.wizard h1 {font-size:2em; font-weight:bold; background:none; padding:0em 0em 0em 0em; margin:0.4em 0em 0.2em 0em;}
.wizard h2 {font-size:1.2em; font-weight:bold; background:none; padding:0em 0em 0em 0em; margin:0.4em 0em 0.2em 0em;}
.wizardStep {padding:1em 1em 1em 1em;}
.wizard .button {margin:0.5em 0em 0em 0em; font-size:1.2em;}
.wizardFooter {padding:0.8em 0.4em 0.8em 0em;}
.wizardFooter .status {padding:0em 0.4em 0em 0.4em; margin-left:1em;}
.wizard .button {padding:0.1em 0.2em 0.1em 0.2em;}
#messageArea {position:fixed; top:2em; right:0em; margin:0.5em; padding:0.5em; z-index:2000; _position:absolute;}
.messageToolbar {display:block; text-align:right; padding:0.2em 0.2em 0.2em 0.2em;}
#messageArea a {text-decoration:underline;}
.tiddlerPopupButton {padding:0.2em 0.2em 0.2em 0.2em;}
.popupTiddler {position: absolute; z-index:300; padding:1em 1em 1em 1em; margin:0;}
.popup {position:absolute; z-index:300; font-size:.9em; padding:0; list-style:none; margin:0;}
.popup .popupMessage {padding:0.4em;}
.popup hr {display:block; height:1px; width:auto; padding:0; margin:0.2em 0em;}
.popup li.disabled {padding:0.4em;}
.popup li a {display:block; padding:0.4em; font-weight:normal; cursor:pointer;}
.listBreak {font-size:1px; line-height:1px;}
.listBreak div {margin:2px 0;}
.tabset {padding:1em 0em 0em 0.5em;}
.tab {margin:0em 0em 0em 0.25em; padding:2px;}
.tabContents {padding:0.5em;}
.tabContents ul, .tabContents ol {margin:0; padding:0;}
.txtMainTab .tabContents li {list-style:none;}
.tabContents li.listLink { margin-left:.75em;}
#contentWrapper {display:block;}
#splashScreen {display:none;}
#displayArea {margin:1em 17em 0em 14em;}
.toolbar {text-align:right; font-size:.9em;}
.tiddler {padding:1em 1em 0em 1em;}
.missing .viewer,.missing .title {font-style:italic;}
.title {font-size:1.6em; font-weight:bold;}
.missing .subtitle {display:none;}
.subtitle {font-size:1.1em;}
.tiddler .button {padding:0.2em 0.4em;}
.tagging {margin:0.5em 0.5em 0.5em 0; float:left; display:none;}
.isTag .tagging {display:block;}
.tagged {margin:0.5em; float:right;}
.tagging, .tagged {font-size:0.9em; padding:0.25em;}
.tagging ul, .tagged ul {list-style:none; margin:0.25em; padding:0;}
.tagClear {clear:both;}
.footer {font-size:.9em;}
.footer li {display:inline;}
.annotation {padding:0.5em; margin:0.5em;}
* html .viewer pre {width:99%; padding:0 0 1em 0;}
.viewer {line-height:1.4em; padding-top:0.5em;}
.viewer .button {margin:0em 0.25em; padding:0em 0.25em;}
.viewer blockquote {line-height:1.5em; padding-left:0.8em;margin-left:2.5em;}
.viewer ul, .viewer ol {margin-left:0.5em; padding-left:1.5em;}
.viewer table, table.twtable {border-collapse:collapse; margin:0.8em 1.0em;}
.viewer th, .viewer td, .viewer tr,.viewer caption,.twtable th, .twtable td, .twtable tr,.twtable caption {padding:3px;}
table.listView {font-size:0.85em; margin:0.8em 1.0em;}
table.listView th, table.listView td, table.listView tr {padding:0px 3px 0px 3px;}
.viewer pre {padding:0.5em; margin-left:0.5em; font-size:1.2em; line-height:1.4em; overflow:auto;}
.viewer code {font-size:1.2em; line-height:1.4em;}
.editor {font-size:1.1em;}
.editor input, .editor textarea {display:block; width:100%; font:inherit;}
.editorFooter {padding:0.25em 0em; font-size:.9em;}
.editorFooter .button {padding-top:0px; padding-bottom:0px;}
.fieldsetFix {border:0; padding:0; margin:1px 0px 1px 0px;}
.sparkline {line-height:1em;}
.sparktick {outline:0;}
.zoomer {font-size:1.1em; position:absolute; overflow:hidden;}
.zoomer div {padding:1em;}
* html #backstage {width:99%;}
* html #backstageArea {width:99%;}
#backstageArea {display:none; position:relative; overflow: hidden; z-index:150; padding:0.3em 0.5em 0.3em 0.5em;}
#backstageToolbar {position:relative;}
#backstageArea a {font-weight:bold; margin-left:0.5em; padding:0.3em 0.5em 0.3em 0.5em;}
#backstageButton {display:none; position:absolute; z-index:175; top:0em; right:0em;}
#backstageButton a {padding:0.1em 0.4em 0.1em 0.4em; margin:0.1em 0.1em 0.1em 0.1em;}
#backstage {position:relative; width:100%; z-index:50;}
#backstagePanel {display:none; z-index:100; position:absolute; margin:0em 3em 0em 3em; padding:1em 1em 1em 1em;}
.backstagePanelFooter {padding-top:0.2em; float:right;}
.backstagePanelFooter a {padding:0.2em 0.4em 0.2em 0.4em;}
#backstageCloak {display:none; z-index:20; position:absolute; width:100%; height:100px;}
.whenBackstage {display:none;}
.backstageVisible .whenBackstage {display:block;}
/*}}}*/</pre>
</div>
<div title="StyleSheetLocale">
<pre>/***
StyleSheet for use when a translation requires any css style changes.
This StyleSheet can be used directly by languages such as Chinese, Japanese and Korean which use a logographic writing system and need larger font sizes.
***/
/*{{{*/
body {font-size:0.8em;}
#sidebarOptions {font-size:1.05em;}
#sidebarOptions a {font-style:normal;}
#sidebarOptions .sliderPanel {font-size:0.95em;}
.subtitle {font-size:0.8em;}
.viewer table.listView {font-size:0.95em;}
.htmlarea .toolbarHA table {border:1px solid ButtonFace; margin:0em 0em;}
/*}}}*/</pre>
</div>
<div title="StyleSheetPrint">
<pre>/*{{{*/
@media print {
#mainMenu, #sidebar, #messageArea, .toolbar, #backstageButton {display: none ! important;}
#displayArea {margin: 1em 1em 0em 1em;}
/* Fixes a feature in Firefox 1.5.0.2 where print preview displays the noscript content */
noscript {display:none;}
}
/*}}}*/</pre>
</div>
<div title="PageTemplate">
<pre><!--{{{-->
<div class='header' macro='gradient vert [[ColorPalette::PrimaryLight]] [[ColorPalette::PrimaryMid]]'>
<div class='headerShadow'>
<span class='siteTitle' refresh='content' tiddler='SiteTitle'></span>&nbsp;
<span class='siteSubtitle' refresh='content' tiddler='SiteSubtitle'></span>
</div>
<div class='headerForeground'>
<span class='siteTitle' refresh='content' tiddler='SiteTitle'></span>&nbsp;
<span class='siteSubtitle' refresh='content' tiddler='SiteSubtitle'></span>
</div>
</div>
<div id='mainMenu' refresh='content' tiddler='MainMenu'></div>
<div id='sidebar'>
<div id='sidebarOptions' refresh='content' tiddler='SideBarOptions'></div>
<div id='sidebarTabs' refresh='content' force='true' tiddler='SideBarTabs'></div>
</div>
<div id='displayArea'>
<div id='messageArea'></div>
<div id='tiddlerDisplay'></div>
</div>
<!--}}}--></pre>
</div>
<div title="ViewTemplate">
<pre><!--{{{-->
<div class='toolbar' macro='toolbar closeTiddler closeOthers +editTiddler > fields syncing permalink references jump'></div>
<div class='title' macro='view title'></div>
<div class='subtitle'><span macro='view modifier link'></span>, <span macro='view modified date'></span> (<span macro='message views.wikified.createdPrompt'></span> <span macro='view created date'></span>)</div>
<div class='tagging' macro='tagging'></div>
<div class='tagged' macro='tags'></div>
<div class='viewer' macro='view text wikified'></div>
<div class='tagClear'></div>
<!--}}}--></pre>
</div>
<div title="EditTemplate">
<pre><!--{{{-->
<div class='toolbar' macro='toolbar +saveTiddler -cancelTiddler deleteTiddler'></div>
<div class='title' macro='view title'></div>
<div class='editor' macro='edit title'></div>
<div macro='annotations'></div>
<div class='editor' macro='edit text'></div>
<div class='editor' macro='edit tags'></div><div class='editorFooter'><span macro='message views.editor.tagPrompt'></span><span macro='tagChooser'></span></div>
<!--}}}--></pre>
</div>
<div title="GettingStarted">
<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)
* MainMenu: The menu (usually on the left)
* 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="OptionsPanel">
<pre>These InterfaceOptions for customising TiddlyWiki are saved in your browser
Your username for signing your edits. Write it as a WikiWord (eg JoeBloggs)
<<option txtUserName>>
<<option chkSaveBackups>> SaveBackups
<<option chkAutoSave>> AutoSave
<<option chkRegExpSearch>> RegExpSearch
<<option chkCaseSensitiveSearch>> CaseSensitiveSearch
<<option chkAnimate>> EnableAnimations
----
Also see AdvancedOptions</pre>
</div>
</div>
<!--POST-SHADOWAREA-->
<div id="storeArea">
<div title="Contributing" modifier="TimBunce" modified="200707181223" created="200707181150" changecount="10">
<pre>Many people have contributed to the DBI and its database drivers in many ways over many years.
Perhaps you'd like to find a way contribute yourself...
*Contribute help on the [[DBI Mailing Lists]].
*Contribute your experience to the community by [[Editing This FAQ]].
*Contributing fixes and enhancements by [[Patching the Source]].
*Or perhaps you're interested in [[Implementing a Driver]].
See also http://dbi.perl.org/contributing
</pre>
</div>
<div title="DBD::ODBC" modifier="RobertHicks" created="200708201159" changecount="1">
<pre>[[DBD::ODBC for MySQL V 5 under MS Windows]]</pre>
</div>
<div title="DBD::ODBC for MySQL V 5 under MS Windows" modifier="RobertHicks" modified="200708201202" created="200708201200" changecount="7">
<pre>These notes refer to ~MySQL V 5.0.45 and ~MySQL Connector ODBC V 3.51.19.
When installing ~MySQL, a dialog asks for a password. The user corresponding to this password is 'root'. Assume the value of this password is 'serverpassword'. Make a note of this username/password pair. Also: All single quotes herein are just for clarity. Don't type them in.
After installing the Connector, use Start/Settings/Control Panel/Administrative Tools/Data Sources (ODBC) to define a Data Source Name (DSN). The menu sequence just given is for ~WinXP. Other versions of Windows will be slightly different.
Choose System DSN rather than User DSN when creating a new DSN. System ~DSNs are visible to all users. A User DSN will only be visible to the user defining the DSN. This means, for instance, that if a web server running under a special user runs a CGI script, that CGI script will not have access to User ~DSNs other than those defined by that special user.
For your new DSN, create one of type ~MySQL (this is just a sample for testing):
* Call the DSN 'my-dsn', say
* There is no default server, so specify 'localhost'
* There is no default database, so specify 'mysql'
* The default username is 'root1'. Enter 'root'
* The default password is empty. Enter 'serverpassword'
* There is no default character set, so try 'latin1'
* Test the connection by clicking the button. Presumably it works...
* Save the DSN and test it from Perl, but be warned. The username and password in the Perl code to generate a database handle, , are discarded (sic) by ~MySQL Connector. That's why they need to be explicitly specified as below:
{{{
$dbh = DBI->connect('dbi:ODBC:my-dsn', $username, $password)
}}}
Once you can connect from Perl, you can run mysql.exe to create new databases and (~MySQL) users. Let's create a database called 'modules', for the username/password combination 'a.username'/'a.password', all of which will be used later in a new DSN:
From the command line:
{{{
mysql -uroot -p mysql
(Enter 'serverpassword' when prompted)
mysql> create database modules;
mysql> grant all privileges on *.* to 'a.username'@'localhost' identified by 'a.password' with grant option;
mysql> \q
}}}
Now you can return to define a corresponding DSN, and to delete that sample DSN my-dsn.</pre>
</div>
<div title="DBI FAQ 1.1 What is DBI, DBperl, Oraperl and *perl?" modifier="RobertHicks" modified="200707172221" created="200706211220" changecount="6">
<pre>To quote Tim Bunce, the architect and author of DBI:
{{{
"DBI is a database access Application Programming Interface (API)
for the Perl Language. The DBI API Specification defines a set of
functions, variables and conventions that provide a consistent
database interface independant of the actual database being used."
}}}
In simple language, the DBI interface allows users to access multiple database types transparently. So, if you connecting to an Oracle, Informix, mSQL, Sybase or whatever database, you don't need to know the underlying mechanics of the 3GL layer. The API defined by DBI will work on all these database types.
A similar benefit is gained by the ability to connect to two different databases of different vendor within the one perl script, ie, I want to read data from an Oracle database and insert it back into an Informix database all within one program. The DBI layer allows you to do this simply and powerfully.
~DBperl is the old name for the interface specification. It's usually now used to denote perl4 modules on database interfacing, such as, oraperl, isqlperl, ingperl and so on. These interfaces didn't have a standard API and are generally not supported.
Here's a list of ~DBperl modules, their corresponding DBI counterparts and support information. Please note, the author's listed here generally do not maintain the DBI module for the same database. These email addresses are unverified and should only be used for queries concerning the perl4 modules listed below. DBI driver queries should be directed to the dbi-users mailing list.
| !Module Name | !Database Required | !Author | !DBI |
|Sybperl|Sybase |Michael Peppler <mpeppler@itf.ch> |DBD::Sybase|
|Oraperl|Oracle 6 & 7 |Kevin Stock <dbi-users@perl.org>|DBD::Oracle|
|Ingperl|Ingres|Tim Bunce & Ted Lemon <dbi-users@perl.org>|DBD::Ingres|
|Interperl|Interbase|Buzz Moschetti <buzz@bear.com>|DBD::Interbase|
|Uniperl|Unify 5.0|Rick Wargo <rickers@coe.drexel.edu>|None|
|Pgperl|Postgres|Igor Metz <metz@iam.unibe.ch>|DBD::Pg|
|Btreeperl|NDBM|John Conover <john@johncon.com>|SDBM?|
|Ctreeperl|~C-Tree|John Conover <john@johncon.com>|None|
|Cisamperl|Informix ~C-ISAM|Mathias Koerber mathias@unicorn.swi.com.sg>|None|
|Duaperl|X.500 Directory User Agent|Eric Douglas|None|
However, some DBI modules have DBperl emulation layers, so, DBD::Oracle comes with an Oraperl emulation layer, which allows you to run legacy oraperl scripts without modification. The emulation layer translates the oraperl API calls into DBI calls and executes them through the DBI switch.
Here's a table of emulation layer information:
| !Module | !Emulation Layer | !Status |
|DBD::Oracle|Oraperl|Complete|
|DBD::Informix|Isqlperl|Under development|
|DBD::Ingres|Ingperl|Complete?|
|DBD::Sybase|Sybperl|Working? ( Needs verification )|
|DBD::mSQL|Msqlperl|Experimentally released with DBD::mSQL-0.61|
The Msqlperl emulation is a special case. Msqlperl is a perl5 driver for mSQL databases, but does not conform to the DBI Specification. It's use is being deprecated in favour of DBD::mSQL. Msqlperl may be downloaded from CPAN via:
{{{
http://www.perl.com/cgi-bin/cpan_mod?module=Msqlperl
}}}
</pre>
</div>
<div title="DBI FAQ 1.3. Where can I get more information?" modifier="RobertHicks" modified="200707172222" created="200706221204" changecount="14">
<pre>There are a few information sources on DBI.
//"Programming the Perl DBI"//
"Programming the Perl DBI" is the official book on the DBI written by Alligator Descartes and Tim Bunce and published by O'Reilly & Associates. The book was released on February 9th, 2000.
{{{
The table of contents is:
Preface
1. Introduction
From Mainframes to Workstations
Perl
DBI in the Real World
A Historical Interlude and Standing Stones
2. Basic Non-DBI Databases
Storage Managers and Layers
Query Languages and Data Functions
Standing Stones and the Sample Database
Flat-File Databases
Putting Complex Data into Flat Files
Concurrent Database Access and Locking
DBM Files and the Berkeley Database Manager
The MLDBM Module
Summary
3. SQL and Relational Databases
The Relational Database Methodology
Datatypes and NULL Values
Querying Data
Modifying Data Within Tables
Creating and Destroying Tables
4. Programming with the DBI
DBI Architecture
Handles
Data Source Names
Connection and Disconnection
Error Handling
Utility Methods and Functions
5. Interacting with the Database
Issuing Simple Queries
Executing Non-SELECT Statements
Binding Parameters to Statements
Binding Output Columns
do() Versus prepare()
Atomic and Batch Fetching
6. Advanced DBI
Handle Attributes and Metadata
Handling LONG/LOB Data
Transactions, Locking, and Isolation
7. ODBC and the DBI
ODBC -- Embraced and Extended
DBI -- Thrashed and Mutated
The Nuts and Bolts of ODBC
ODBC from Perl
The Marriage of DBI and ODBC
Questions and Choices
Moving Between Win32::ODBC and the DBI
And What About ADO?
8. DBI Shell and Database Proxying
dbish -- The DBI Shell
Database Proxying
A. DBI Specification
B. Driver and Database Characteristics
C. ASLaN Sacred Site Charter
Index
}}}
The book should be available from all good bookshops and can be ordered online either via O'Reilly & Associates
{{{
http://www.oreilly.com/catalog/perldbi
}}}
or Amazon
{{{
http://www.amazon.com/exec/obidos/ASIN/1565926994/dbi
}}}
//POD documentation//
~PODs are chunks of documentation usually embedded within perl programs that document the code //in place//, providing a useful resource for programmers and users of modules. POD for DBI and drivers is beginning to become more commonplace, and documentation for these modules can be read with the perldoc program included with Perl.
''The DBI Specification''
The POD for the DBI Specification can be read with the:
{{{
perldoc DBI
}}}
command. The Specification also forms Appendix A of "Programming the Perl DBI".
''Oraperl''
Users of the Oraperl emulation layer bundled with DBD::Oracle, may read up on how to program with the Oraperl interface by typing:
{{{
perldoc Oraperl
}}}
This will produce an updated copy of the original oraperl man page written by Kevin Stock for perl4. The oraperl API is fully listed and described there.
''Drivers''
Users of the DBD modules may read about some of the private functions and quirks of that driver by typing:
{{{
perldoc <driver>
}}}
For example, the DBD::mSQL driver is bundled with driver-specific documentation that can be accessed by typing
{{{
perldoc DBD::mSQL
}}}
''Frequently Asked Questions''
This document, the Frequently Asked Questions is also available as POD documentation! You can read this on your own system by typing:
{{{
perldoc DBI::FAQ
}}}
This may be more convenient to persons not permanently, or conveniently, connected to the Internet. The DBI::FAQ module should be downloaded and installed for the more up-to-date version.
The version of DBI::FAQ shipped with the DBI module may be slightly out of date.
''POD in general''
Information on writing POD, and on the philosophy of POD in general, can be read by typing:
{{{
perldoc perlpod
}}}
Users with the Tk module installed may be interested to learn there is a Tk-based POD reader available called tkpod, which formats POD in a convenient and readable way. This is available via CPAN as the module called Tk::POD and is highly recommended.
''Driver and Database Characteristics''
The driver summaries that were produced for Appendix B of "Programming the Perl DBI" are available online at:
{{{
http://dbi.perl.org/
http://www.symbolstone.org/technology/perl/DBI
}}}
in the driver information table. These summaries contain standardised information on each driver and database which should aid you in selecting a database to use. It will also inform you quickly of any issues within drivers or whether a driver is not fully compliant with the DBI Specification.
''Rambles, Tidbits and Observations''
{{{
http://dbi.perl.org/tidbits
http://www.symbolstone.org/technology/perl/DBI/tidbits
}}}
There are a series of occasional rambles from various people on the DBI mailing lists who, in an attempt to clear up a simple point, end up drafting fairly comprehensive documents. These are quite often varying in quality, but do provide some insights into the workings of the interfaces.
''Articles''
A list of articles discussing the DBI can be found on the DBI WWW page at:
{{{
http://dbi.perl.org/
http://www.symbolstone.org/technology/perl/DBI
}}}
These articles are of varying quality and age, from the original Perl Journal article written by Alligator and Tim, to more recent debacles published online from about.com.
README files
The README files included with each driver occasionally contains some useful information ( no, really! ) that may be pertinent to the user. Please read them. It makes our worthless existences more bearable. These can all be read from the main DBI WWW page at:
{{{
http://dbi.perl.org/
http://www.symbolstone.org/technology/perl/DBI
}}}
''Mailing List Archives''
//US Mailing List Archives//
{{{
http://outside.organic.com/mail-archives/dbi-users/
}}}
Searchable hypermail archives of the three mailing lists, and some of the much older traffic have been set up for users to browse.
//European Mailing List Archives//
{{{
http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest
}}}
As per the US archive above.
</pre>
</div>
<div title="DBI Mailing Lists" modifier="TimBunce" modified="200707181157" created="200707171127" changecount="8">
<pre>There are three DBI mailing lists:
![[dbi-announce@perl.org|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.
![[dbi-users@perl.org|http://lists.cpan.org/showlist.cgi?name=dbi-users]]
This mailing list is the heart of the DBI user community. There are typically over two thousand users subscribed, ranging from novices to experienced users and driver developers. Typically there are just a few messages each day. Messages are on-topic and the list is widely regarded as being of very high quality. It's a great way to learn about the DBI and, as you learn from the list and your own experience, you can help others along their path.
This is the place to ask for help [[smartly|http://www.catb.org/~esr/faqs/smart-questions.html]].
![[dbi-dev@perl.org|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="RobertHicks" modified="200707172218" created="200706232149" changecount="10">
<pre>!Here's a list of drivers for the DBI
Names not in bold don't have any entries in this FAQ yet - perhaps you could add some. (Just click on a link and a new entry 'tiddler' will appear. Click edit and enter your experience. See [[Edit This FAQ]] for how to share your experience with others.)
For more information about a driver see http://search.cpan.org
If that doesn't shed enough light on your question then see [[Get More Help]].
[[DBD::Adabas]]
[[DBD::ADO]]
[[DBD::Amazon]]
[[DBD::AnyData]]
[[DBD::ASAny]]
[[DBD::Chart]]
[[DBD::CSV]]
[[DBD::DB2]]
[[DBD::DBMaker]]
[[DBD::DBM]]
[[DBD::EmpressNet]]
[[DBD::Empress]]
[[DBD::ExampleP]]
[[DBD::Excel]]
[[DBD::File]]
[[DBD::Fulcrum]]
[[DBD::Gofer]]
[[DBD::Google]]
[[DBD::Illustra]]
[[DBD::Informix4]]
[[DBD::Informix]]
[[DBD::Ingres]]
[[DBD::InterBase]]
[[DBD::iPod]]
[[DBD::JDBC]]
[[DBD::LDAP]]
[[DBD::Log]]
[[DBD::MaxDB]]
[[DBD::Mimer]]
[[DBD::Mock]]
[[DBD::monetdb]]
[[DBD::mSQL]]
[[DBD::Multiplex]]
[[DBD::Multi]]
[[DBD::mysqlPP]]
[[DBD::mysql]]
[[DBD::NullP]]
[[DBD::ODBC]]
[[DBD::Oracle]]
[[DBD::Ovrimos]]
[[DBD::PgLite]]
[[DBD::PgPP]]
[[DBD::PgSPI]]
[[DBD::Pg]]
[[DBD::pNET]]
[[DBD::PrimeBase]]
[[DBD::Proxy]]
[[DBD::QBase]]
[[DBD::RAM]]
[[DBD::RDFStore]]
[[DBD::Recall]]
[[DBD::Redbase]]
[[DBD::Salesforce]]
[[DBD::SearchServer]]
[[DBD::Solid]]
[[DBD::Sponge]]
[[DBD::Sprite]]
[[DBD::Sqlflex]]
[[DBD::SQLite2]]
[[DBD::SQLite]]
[[DBD::Sybase]]
[[DBD::TemplateSS]]
[[DBD::Template]]
[[DBD::Teradata]]
[[DBD::TimesTen]]
[[DBD::TSM]]
[[DBD::Unify]]
[[DBD::WMI]]
[[DBD::WTSprite]]
[[DBD::XBase]]
[[DBD::Yaswi]]
If you want to implement your own driver [[Implementing a Driver]] should help you out.
</pre>
</div>
<div title="DefaultTiddlers" modifier="TimBunce" modified="200706232130" created="200706221222" changecount="2">
<pre>[[Welcome to the DBI FAQ]]</pre>
</div>
<div title="Editing This FAQ" modifier="TimBunce" modified="200707181202" created="200706232129" changecount="1">
<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.
Before your first edit, click on 'options>' on the right and give yourself a username that'll be used to sign your edits.
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, 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.
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)
* MainMenu: The menu (usually on the left)
* 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="How does one CONNECT to Oracle with DBD::Oracle?" modifier="RobertHicks" modified="200707172222" created="200706221217" changecount="5">
<pre>Look at these example code pieces. In this example, ORCL is the database connect descriptor.
{{{
use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:orcl','scott','tiger',)
|| die "Database connection not made: $DBI::errstr";
$dbh->disconnect;
}}}
... or with additional connect options:
{{{
use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:orcl','scott','tiger',
{
RaiseError => 1,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect;
}}}
This example connects to two databases simultaneously:
{{{
my $dbh1 = DBI->connect( "dbi:Oracle:ORCL1", "scott", "tiger" )
or die "Can't connect to 1st Oracle database: $DBI::errstr\n";
my $dbh2 = DBI->connect( "dbi:Oracle:ORCL2", "scott", "tiger" )
or die "Can't connect to 2nd Oracle database: $DBI::errstr\n";
$dbh1->disconnect or warn "DB1 disconnection failed: $DBI::errstr\n";
$dbh2->disconnect or warn "DB2 disconnection failed: $DBI::errstr\n";
}}}</pre>
</div>
<div title="Implementing a Driver" modifier="RobertHicks" modified="200707182139" created="200707172217" changecount="8">
<pre> Some wisdom of this dark art has been distilled into: [[ DBD Driver Voodoo|http://search.cpan.org/perldoc?DBI::DBD]]</pre>
</div>
<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 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="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.
If you're using Windows then you probably want to [[Install DBI using PPM]] instead.</pre>
</div>
<div title="Install DBI from Subversion" modifier="TimBunce" modified="200707181212" created="200706281251" changecount="6">
<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@@
To keep informed about changes to the source you can send an empty email to @@svn-commit-modules-dbi-subscribe@perl.org@@ after which you'll get an email with the change log message and diff of each change checked-in to the source.
Since you've installed using Subversion then you're probably interested in [[Patching the Source]].</pre>