| Name : perl-DBD-Sprite
| |
| Version : 6.12
| Vendor : obs://build_opensuse_org/devel:languages:perl
|
| Release : 1.50
| Date : 2024-08-05 19:48:44
|
| Group : Development/Libraries/Perl
| Source RPM : perl-DBD-Sprite-6.12-1.50.src.rpm
|
| Size : 0.30 MB
| |
| Packager : (none)
| |
| Summary : Perl extension for DBI, providing database emmulation via flat files
|
Description :
DBD::Sprite is a DBI extension module adding database emulation via
flat-files to Perl\'s database-independent database interface. Unlike other
DBD::modules, DBD::Sprite does not require you to purchase or obtain a
database. Every thing you need to prototype database-independent
applications using Perl and DBI are included here. You will, however,
probably wish to obtain a real database, such as \"mysql\", for your
production and larger data needs. This is because emulating databases and
SQL with flat text files gets very slow as the size of your \"database\"
grows to a non-trivial size (a few dozen records or so per table).
DBD::Sprite is built upon an old Perl module called \"Sprite\", written by
Shishir Gurdavaram. This code was used as a starting point. It was
completly reworked and many new features were added, producing a module
called \"JSprite.pm\" (Jim Turner\'s Sprite). This was then merged in to
DBI::DBD to produce what you are installing now. (DBD::Sprite). JSprite.pm
is included in this module as a separate file, and is required.
Many thanks go to Mr. Gurdavaram.
The main advantage of DBD::Sprite is the ability to develop and test
prototype applications on personal machines (or other machines which do not
have an Oracle licence or some other \"mainstream\" database) before
releasing them on \"production\" machines which do have a \"real\" database.
This can all be done with minimal or no changes to your Perl code.
Another advantage of DBD::Sprite is that you can use Perl\'s regular
expressions to search through your data. Maybe, someday, more \"real\"
databases will include this feature too!
DBD::Sprite provides the ability to emulate basic database tables and SQL
calls via flat-files. The primary use envisioned for this to permit website
developers who can not afford to purchase an Oracle licence to prototype
and develop Perl applications on their own equipment for later hosting at
larger customer sites where Oracle is used. :-)
DBD::Sprite attempts to do things in as database-independent manner as
possible, but where differences occurr, JSprite most closely emmulates
Oracle, for example \"sequences/autonumbering\". JSprite uses tiny one-line
text files called \"sequence files\" (.seq). and \"seq_file_name.NEXTVAL\"
function to insert into autonumbered fields. The reason for this is that
the Author works in an Oracle shop and wrote this module to allow himself
to work on code on his PC, and machines which did not have Oracle on them,
since obtaining Oracle licences was sometimes time-consuming.
DBD::Sprite is similar to DBD::CSV, but differs in the following ways:
1) It creates and works on true \"databases\" with user-ids and passwords,
real datatypes like numeric, varchar, blob, etc. with max. precisions and
scales.
2) The database author specifies the field delimiters, record delimiters,
user, password, table file path, AND extension for each database.
3) Transactions (commits and rollbacks) are fully supported!
4) Autonumbering and user-defined functions are supported.
5) You don\'t need any other modules or databases. (NO prerequisites
except Perl 5 and the DBI module!
6) Quotes are not used around data.
7) It is not necessary to call the \"$dbh->quote()\" method all the time
in your sql.
8) NULL is handled as an empty string.
9) Users can \"register\" their own data-conversion functions for use in
sql. See \"fn_register\" method below.
10) Optional data encryption.
11) Optional table storage in XML format.
12) Two-table joins now supported!
|
RPM found in directory: /packages/linux-pbone/ftp5.gwdg.de/pub/opensuse/repositories/devel:/languages:/perl:/CPAN-D/openSUSE_Tumbleweed/noarch |
