| 1 |
README FILE FOR MODULES SQL::Statement and SQL::Parser |
| 2 |
|
| 3 |
These modules can be used stand-alone to parse SQL statements |
| 4 |
or used with DBI and DBD::CSV, DBD::AnyData or other drivers to |
| 5 |
create, modify, and query data in many kinds of formats including |
| 6 |
XML, CSV, Fixed Length, Excel Spreadsheets and many others. |
| 7 |
|
| 8 |
WHO NEEDS IT? |
| 9 |
|
| 10 |
If you use the DBI drivers for flatfiles, Excel spreadsheets, or |
| 11 |
formats such as XML via the CSV, AnyData, or Excel DBDs, this |
| 12 |
distribution will greatly expand the range of supported SQL, as |
| 13 |
well as provide support for text-like numbers and alphabetic |
| 14 |
comparisons previously missing in those drivers. Some of the |
| 15 |
features included in this release are partial support for |
| 16 |
multi-table joins, for set and string functions, for numeric |
| 17 |
expressions, for the IN and BETWEEN predicates and much more. |
| 18 |
|
| 19 |
HOW DO I INSTALL IT? |
| 20 |
|
| 21 |
If you are familiar with the standard make/nmake procedures, |
| 22 |
simply do as always: |
| 23 |
|
| 24 |
perl Makefile.PL |
| 25 |
make |
| 26 |
make test |
| 27 |
make install |
| 28 |
|
| 29 |
You may also use nmake or dmake on windows. Since the modules |
| 30 |
are pure perl, you may also simply copy the enclosed SQL |
| 31 |
directory into your lib directory (either your main site/lib or |
| 32 |
a private area). |
| 33 |
|
| 34 |
WHAT ELSE DO I NEED? |
| 35 |
|
| 36 |
to parse SQL statements: |
| 37 |
|
| 38 |
perl |
| 39 |
|
| 40 |
to create, query, & modify databases |
| 41 |
|
| 42 |
perl |
| 43 |
DBI |
| 44 |
DBD::CSV or DBD::AnyData or other DBDs that subclass SQL::Statement |
| 45 |
|
| 46 |
|
| 47 |
WHERE DO I FIND OUT MORE? |
| 48 |
|
| 49 |
If you are using it via one of the DBD drivers, see the help |
| 50 |
documentation for that driver. If you are subclassing the |
| 51 |
moduels, there are extensive help documents included with the |
| 52 |
modules. Use perldoc or pod2html or simply read the POD section |
| 53 |
of the .pm files. For further questions, write to the |
| 54 |
the [email protected] listserv or try www.perlmonks.org. |
| 55 |
|
| 56 |
WHO DUNNIT? |
| 57 |
|
| 58 |
The original XS versions of the modules were written by Jochen |
| 59 |
Wiedmann. The current, pure perl versions were rewritten |
| 60 |
(mostly from the ground up) by Jeff Zucker |
| 61 |
<jzuckerATcpan.org>. Both versions are currently maintained |
| 62 |
by Jens Rehsack <[email protected]>. |