RE: :ODBC - File size limit exceeded
Which driver are you using? UnixODBC is the driver manager. I'd check:
df -h -- volumes with low disk space
log files (at or near your ulimit)
Jeff
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 5:25 PM
To: dbi-users@perl.org
Subject: DBD::ODBC - File size limit exceeded
Greetings.
One of our PCs has suddenly started bailing out when opening a DBD::ODBC
connection, with the error:
File size limit exceeded
The line of code it exits on is:
my $ms_dbh = DBI-connect(
dbi:ODBC:SQLServer,
some_username,
some_password,
{
PrintError = 1,
odbc_cursortype =
DBI::SQL_CURSOR_DYNAMIC
}
)
|| die Database connectin not made: $DBI::errstr;
I haven't updated anything on this box recently. I can't really see what
the problem is. The app runs fine on our other systems. Any clues?
All systems are running Gentoo, with a 2.6.x kernel, perl-5.8.7,
unixODBC-2.2.11 ( previously 2.2.8 - I just updated this to see if a
newer version would fix our problem ) and DBD::ODBC-1.13.
Dan
--
BEGIN-ANTISPAM-VOTING-LINKS
--If you are not the
CanIt administrator and you think this
message is spam, please give the id 23262 and magic value
9839f5472950 to [EMAIL PROTECTED] to be marked as spam.
Teach CanIt if this mail (ID 23262) is spam:
Spam:
http://entropy.homelinux.org/canit/b.php?c=si=23262m=9839f5472950
Not spam:
http://entropy.homelinux.org/canit/b.php?c=ni=23262m=9839f5472950
Forget vote:
http://entropy.homelinux.org/canit/b.php?c=fi=23262m=9839f5472950
--
END-ANTISPAM-VOTING-LINKS
Problem:Can't locate object method query_param via package
Hi, My name is Kotra Kiran Kumar .I am working in HSBC Software ,Pune,India .I installed Http::Recorder perl modules .When I am trying to run http-recorder I am getting code when I moved from one page to another page through links.But when I submits any form in the web page the proxy program(which is running in command prompt) is terminating by showing the below message.Http recorder also stops working. Can't locate object method query_param via package rec-action=submitformrec- formname=_fCustomLoginrec-formnumber=1rec-form1-hidden-%25%25ModDate=1%25%25M odDate=00280540rec-form1-unknown-Username=1Username=kirankumar2+kotra rec-form1-password-Password=1Password=oceanllanrec-form1-hidden-RedirectTo=1R edirectTo=%2FHSDIApplications%2Fdiscuss.nsf%2F (perhaps you forgot to load rec -action=submitformrec-formname=_fCustomLoginrec-formnumber=1rec-form1-hidden- %25%25ModDate=1%25%25ModDate=00280540rec-form1-unknown-Username=1User name=kirankumar2+kotrarec-form1-password-Password=1Password=oceanllanrec-form 1-hidden-RedirectTo=1RedirectTo=%2FHSDIApplications%2Fdiscuss.nsf%2F?) at C:/P erl/site/lib/HTTP/Recorder.pm line 352. Can you please help me in solving the problem.Quick reply will be appreciated. Thanks and Regards, KOTRA KIRAN KUMAR GLTi 2.0 Off No:020 5642 2194 HSBC Software Development (India) Pvt Ltd HSBC Center Riverside,West Avenue , 25 B Kalyani Nagar Pune 411 006 INDIA Telephone: +91 20 26683000 Fax: +91 20 26681030 - *** This e-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return e-mail. Internet communications cannot be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions. ***
RE: Problem:Can't locate object method query_param via package
This is not a DBI question. Please don't post off-topic questions to the dbi-users list. Suffice it to say, the error message suggests that you are calling query_param() on a string rather than an object. Ronald -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 5:22 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; dbi- [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problem:Can't locate object method query_param via package Hi, My name is Kotra Kiran Kumar .I am working in HSBC Software ,Pune,India .I installed Http::Recorder perl modules .When I am trying to run http-recorder I am getting code when I moved from one page to another page through links.But when I submits any form in the web page the proxy program(which is running in command prompt) is terminating by showing the below message.Http recorder also stops working. Can't locate object method query_param via package rec-action=submitformrec- formname=_fCustomLoginrec-formnumber=1rec-form1-hidden- %25%25ModDate=1%25%25M odDate=00280540rec-form1-unknown- Username=1Username=kirankumar2+kotra rec-form1-password-Password=1Password=oceanllanrec-form1-hidden- RedirectTo=1R edirectTo=%2FHSDIApplications%2Fdiscuss.nsf%2F (perhaps you forgot to load rec -action=submitformrec-formname=_fCustomLoginrec-formnumber=1rec-form1- hidden- %25%25ModDate=1%25%25ModDate=00280540rec-form1-unknown- Username=1User name=kirankumar2+kotrarec-form1-password- Password=1Password=oceanllanrec-form 1-hidden-RedirectTo=1RedirectTo=%2FHSDIApplications%2Fdiscuss.nsf%2F?) at C:/P erl/site/lib/HTTP/Recorder.pm line 352. Can you please help me in solving the problem.Quick reply will be appreciated. Thanks and Regards, KOTRA KIRAN KUMAR GLTi 2.0 Off No:020 5642 2194 HSBC Software Development (India) Pvt Ltd HSBC Center Riverside,West Avenue , 25 B Kalyani Nagar Pune 411 006 INDIA Telephone: +91 20 26683000 Fax: +91 20 26681030 - *** This e-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return e-mail. Internet communications cannot be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions. ***
DBD::Oracle
Hi, I am upgrading my Oracle client. This probably means I need to recompile DBD::Oracle. Correct? Thanks, Ian
Re: DBD::Oracle
Correct. On Tue, 2005-11-29 at 08:33 -0700, Ian Harisay wrote: Hi, I am upgrading my Oracle client. This probably means I need to recompile DBD::Oracle. Correct? Thanks, Ian -- Scott T. Hildreth [EMAIL PROTECTED]
Re: undefined behaviour for sub-transactions?
Tim Bunce [EMAIL PROTECTED] wrote: I'll guess that what you're really after is to be able to call begin_work again whilst an earlier begin_work is in effect and have the DBI keep a counter of how deeply nested the begin_work calls are. Then commit would decrement the counter and only commit at the outer most level. If you really want that then it's straightforward to implement via a subclass. This has been done. I'm only using it in two other packages so far, but both those and it's own unit tests seem to work well. http://search.cpan.org/~CRAKRJACK/DBIx-Transaction-0.001/ I've got some ideas for enhancements too, but those are a bit more vauge. One of them is that there's differences in transaction behaviour across drivers when a query within a transaction fails. eg; under PostgreSQL, doing a SELECT on a table that doesn't exist poisons the rest of the transaction, whereas under MySQL and SQLite2 the transaction is allowed to continue. There's gotta be some way to wrap this behaviour cleanly so that your application can expect the same behaviour regardless of the underlying database layer... but this leads to another question :-) Are all database drivers expected to supply one method to execute a query? Eg; do do, execute, etc. all always funnel into one core method that returns success, error, or exception (if RaiseError) is turned on? Or if I wanted to create this functionality and expect it to work under multiple database drivers, should I override multiple methods? Thanks, Tyler
Re: undefined behaviour for sub-transactions?
On Tue, Nov 29, 2005 at 10:50:01AM -0800, Tyler MacDonald wrote: Tim Bunce [EMAIL PROTECTED] wrote: I'll guess that what you're really after is to be able to call begin_work again whilst an earlier begin_work is in effect and have the DBI keep a counter of how deeply nested the begin_work calls are. Then commit would decrement the counter and only commit at the outer most level. If you really want that then it's straightforward to implement via a subclass. This has been done. I'm only using it in two other packages so far, but both those and it's own unit tests seem to work well. http://search.cpan.org/~CRAKRJACK/DBIx-Transaction-0.001/ I've got some ideas for enhancements too, but those are a bit more vauge. One of them is that there's differences in transaction behaviour across drivers when a query within a transaction fails. eg; under PostgreSQL, doing a SELECT on a table that doesn't exist poisons the rest of the transaction, whereas under MySQL and SQLite2 the transaction is allowed to continue. PostgreSQL is non-standard (and inconvenient) in this respect. There's gotta be some way to wrap this behaviour cleanly so that your application can expect the same behaviour regardless of the underlying database layer... There isn't, as far as I know, except to accept the 'lowest common denominator'. In this case that means forcing a rollback if any statement fails. but this leads to another question :-) Are all database drivers expected to supply one method to execute a query? Eg; do do, execute, etc. all always funnel into one core method that returns success, error, or exception (if RaiseError) is turned on? Or if I wanted to create this functionality and expect it to work under multiple database drivers, should I override multiple methods? execute() is sufficient if the driver doesn't also supply it's own do() because DBI's default do() calls execute(). But some drivers do supply their own do() method (for good reasons). Tim.
ANNOUNCE: DBI-1.49
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.49.tar.gz
size: 385494 bytes
md5: dd9c7b50d0fbfd04d1737c273cb1b9a5
=head2 Changes in DBI 1.49 (svn rev 2287), 29th November 2005
Fixed assorted attribute handling bugs in DBD::Proxy.
Fixed croak() in DBD::NullP thanks to Sergey Skvortsov.
Fixed handling of take_imp_data() and dbi_imp_data attribute.
Fixed bugs in DBD::DBM thanks to Jeff Zucker.
Fixed bug in DBI::ProfileDumper thanks to Sam Tregar.
Fixed ping in DBD::Proxy thanks to George Campbell.
Fixed dangling ref in $sth after parent $dbh destroyed
with thanks to [EMAIL PROTECTED] for the bug report #13151
Fixed prerequisites to include Storable thanks to Michael Schwern.
Fixed take_imp_data to be more practical.
Change to require perl 5.6.1 (as advertised in 2003) not 5.6.0.
Changed internals to be more strictly coded thanks to Andy Lester.
Changed warning about multiple copies of Driver.xst found in @INC
to ignore duplicated directories thanks to Ed Avis.
Changed Driver.xst to enable drivers to define an dbd_st_prepare_sv
function where the statement parameter is an SV. That enables
compiled drivers to support SQL strings that are UTF-8.
Changed use DBI to only set $DBI::connect_via if not already set.
Changed docs to clarify pre-method clearing of err values.
Added ability for DBI::ProfileData to edit profile path on loading.
This enables aggregation of different SQL statements into the same
profile node - very handy when not using placeholders or when working
multiple separate tables for the same thing (ie logtable_2005_11_28)
Added $sth-{ParamTypes} specification thanks to Dean Arnold.
Added $h-{Callbacks} attribute to enable code hooks to be invoked
when certain methods are called. For example:
$dbh-{Callbacks}-{prepare} = sub { ... };
With thanks to David Wheeler for the kick start.
Added $h-{ChildHandles} (using weakrefs) thanks to Sam Tregar
I've recoded it in C so there's no significant performance impact.
Added $h-{Type} docs (returns 'dr', 'db', or 'st')
Adding trace message in DESTROY if InactiveDestroy enabled.
Ported DBI::ProfileDumper::Apache to mod_perl2 RC5+
thanks to Philip M. Golluci
=cut
Enjoy!
Tim.
Problem with Oracle 10.2 and Perl dbd/dbi interface
There is a problem in Oracle 10.2 that surfaces after you install the latest Perl, dbd-oracle and dbi on a windows box. The symptom is that sqlplus and sqlplusw no longer function, they return almost immediately to the command prompt. This is a know but undocumented problem in oracle. I submitted a tar to get the information. The problem file is 'oraociei10.dll' was not compiled at the correct level. Renaming this file will get sqlplus and sqlplusw functioning again. The file is located in Perl\bin'. There is also a problem with the dbi installation if you have blanks in the path name. The symptom of this is an error message when the license agreement is being displayed.
Re: Proxy question?
Whoops, trace file was to big... attached is the first 200 lines. On Tue, 2005-11-29 at 11:39 -0600, Scott T. Hildreth wrote: Perl: 5.008003(i686-linux) OS : linux (2.4.24-abi) DBI : 1.48 DBD::mysql : 2.9008 DBD::Sponge : 11.10 DBD::Proxy : 0.2004 Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBD/Proxy.pm line 533. Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBD/Proxy.pm line 533. Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBD/Proxy.pm line 533. Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBD/Proxy.pm line 533. ...this is a grep from the trace log, why are the NUM_OF_FIELDS 'undef' and not 0? STORE DBI::st=HASH(0x85a8bc8) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x85a8e98) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x85ae1d4) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x8397b18) 'NUM_OF_FIELDS' = undef STORE DBI::st=HASH(0x8482598) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x8488e6c) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x8482838) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x8482658) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x848141c) 'NUM_OF_FIELDS' = undef STORE DBI::st=HASH(0x8488f44) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x848ead4) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x848d7e8) 'NUM_OF_FIELDS' = undef STORE DBI::st=HASH(0x848cb90) 'NUM_OF_FIELDS' = '1' STORE DBI::st=HASH(0x848762c) 'NUM_OF_FIELDS' = undef DBI Trace Level 9 attached, Thanks, STH -- Scott T. Hildreth [EMAIL PROTECTED] DBI 1.48-nothread default trace level set to 0x0/5 (pid 14499) - DBI-connect(dbi:Oracle:sth, foo, , HASH(0x84e9a18)) DBI_AUTOPROXY: dbi:Proxy():hostname=scotth;port=;dsn=dbi:Oracle:sth - DBI-install_driver(Proxy) for linux perl=5.008003 pid=14499 ruid=1013 euid=1013 install_driver: DBD::Proxy version 0.2004 loaded from /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBD/Proxy.pm New DBI::dr (for DBD::Proxy::dr, parent=, id=) dbih_setup_handle(DBI::dr=HASH(0x832f784)=DBI::dr=HASH(0x8582910), DBD::Proxy::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::Proxy::dr, 112, 0) thr#0 dbih_setup_attrib(DBI::dr=HASH(0x8582910), Err, Null!) SCALAR(0x833220c) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x8582910), State, Null!) SCALAR(0x83321f4) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x8582910), Errstr, Null!) SCALAR(0x8332224) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x8582910), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x8582910), FetchHashKeyName, Null!) 'NAME' (already defined) - install_driver= DBI::dr=HASH(0x832f784) !! warn: 0 CLEARED by call to connect method - connect for DBD::Proxy::dr (DBI::dr=HASH(0x832f784)~0x8582910 'hostname=scotth;port=;dsn=dbi:Oracle:sth' 'foo' HASH(0x84edb98)) New DBI::db (for DBD::Proxy::db, parent=DBI::dr=HASH(0x8582910), id=) dbih_setup_handle(DBI::db=HASH(0x85828f8)=DBI::db=HASH(0x85a23b4), DBD::Proxy::db, 832f4d8, Null!) dbih_make_com(DBI::dr=HASH(0x8582910), 84eb5f8, DBD::Proxy::db, 112, 0) thr#0 dbih_setup_attrib(DBI::db=HASH(0x85a23b4), Err, DBI::dr=HASH(0x8582910)) SCALAR(0x8334840) (already defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), State, DBI::dr=HASH(0x8582910)) SCALAR(0x83348a0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), Errstr, DBI::dr=HASH(0x8582910)) SCALAR(0x8334870) (already defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), TraceLevel, DBI::dr=HASH(0x8582910)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), FetchHashKeyName, DBI::dr=HASH(0x8582910)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), HandleSetErr, DBI::dr=HASH(0x8582910)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x85a23b4), HandleError, DBI::dr=HASH(0x8582910)) undef (not defined) STORE DBI::db=HASH(0x85828f8) 'Active' = 1 - connect= DBI::db=HASH(0x85828f8) at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBI.pm line 598 via /home/me/src/Tools/local/match2/blib/lib/Allant/Tools/DNC.pm line 173 - STORE for DBD::Proxy::db (DBI::db=HASH(0x85a23b4)~INNER 'PrintError' 0) STORE DBI::db=HASH(0x85a23b4) 'PrintError' = 0 - STORE= 1 at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBI.pm line 645 via /home/me/src/Tools/local/match2/blib/lib/Allant/Tools/DNC.pm line 173 - STORE for DBD::Proxy::db (DBI::db=HASH(0x85a23b4)~INNER 'AutoCommit' 0) - STORE= '1' at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/DBI.pm line 645 via
Re: detecting the existance of a table [was: undefined behaviour for sub-transactions?]
Tim Bunce [EMAIL PROTECTED] wrote:
PostgreSQL is non-standard (and inconvenient) in this respect.
I chatted with Mischa (my work's resident DB guru) about this, and
according to him, the error behaviour when you attempt to SELECT from a
table that does not exist is undetermined in the SQL standard, so it
really is the individual DBMS' choice. I think that's actually worse; all of
these DBMs are behaving completely differently but still correctly on such
a basic SQL operation due to a lack of standard!
There isn't, as far as I know, except to accept the 'lowest common
denominator'. In this case that means forcing a rollback if any
statement fails.
execute() is sufficient if the driver doesn't also supply it's own do()
because DBI's default do() calls execute(). But some drivers do supply
their own do() method (for good reasons).
Fair enough. So what I've done, is modified DBIx::Transaction to
mark a transaction error if any query in the transaction returns false;
--snip--
sub execute {
my $self = shift;
my $rv = eval { DBI::st::execute($self, @_); };
if($@) {
$self-{Database}-inc_transaction_error;
die [EMAIL PROTECTED];
}
if(!$rv) {
$self-{Database}-inc_transaction_error;
}
return $rv;
}
--snip--
(and similar logic for db::do()).
The package I'm working on that uses DBIx::Transaction now also
checks for the existance of a table before attempting to manipulate it.
I was considering using the table_info method for this, but
there's a problem there; I don't know how to ask DBI what database/catalog
name I am currently working in, and undef is documented as returning
tables in *every* database, not just the current one.
So what I've done instead is defaulted to this query to check for a
table:
SELECT 1 FROM information_schema.tables WHERE table_name = ?
... then for MySQL,
SHOW TABLES LIKE ?
... and SQLite2,
SELECT 1 FROM sqlite_master WHERE type ='table' AND name = ?
The default query does work for postgres, and I'm told I can expect
it to work with M$SQL, Sybase, and Oracle as well. Can you think of any DBI
drivers I should expect it to *not* work with?
DB::Introspector claims to help you do this, so I might just use it.
Although it does a lot more stuff that I don't need, and I only see MySQL,
Oracle, and Postgres subclasses for it. Is there a better module or method
out there?
- Tyler
What's the best free DB for a web-based app?
Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server, etc.). We want to go with Perl because it's the best programming language invented by humans.
RE: What's the best free DB for a web-based app?
You're likely to get as many opinions as there are respondents to your question. MySQL seems to be the most popular for smaller Web apps. It's free, Free, easy to use, well documented, widely understood, and capable enough for most tasks. PostgreSQL is also popular for similar reasons, but my impression is far fewer people are familiar with it than MySQL. I've heard that PostgreSQL might be somewhat more capable than MySQL, but I haven't used PostgreSQL myself. Since this sounds like your first open-source DB experience, I think you'd be better off with MySQL, since it's easiest to find help should you need it. Ted Behling -Original Message- From: John Armstrong [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 8:02 PM To: dbi-users@perl.org Cc: cgiapp@lists.erlbaum.net Subject: What's the best free DB for a web-based app? Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server, etc.). We want to go with Perl because it's the best programming language invented by humans.
RE: [cgiapp] What's the best free DB for a web-based app?
On Tue, 29 Nov 2005 20:09:26 -0500, Josh Danziger wrote: Hi Josh arbitrary SQL statements on the database a breeze. I've heard arguments that postgresql is a better database platform; the claim is that postgres is more functional and runs faster (I don't know how this changed with MySQL 5). Ask N programmers, get N+M opinions. In my, admittedly simplistic, testing, Postgres 8.0 under Windows is 5 .. 10 times slower (repeat, slower) than MySQL 4.1 on the same box. Of course, there's always a later version, which is always allegedly faster, bettter, whatever... So use GNU/Linux. -- Cheers Ron Savage, [EMAIL PROTECTED] on 30/11/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company
Re: What's the best free DB for a web-based app?
John Armstrong [EMAIL PROTECTED] wrote: Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server, etc.). We want to go with Perl because it's the best programming language invented by humans. I vote for PostgreSQL. I used MySQL for many years, but since I've been introduced to postgres, I find it to be a lot more reliable and full-featured. The new MySQL 5.x claims to have a lot of the stuff that postgres does (proper transactions, replication, etc, etc) but I haven't had a chance to try it yet. - Tyler
Re: What's the best free DB for a web-based app?
At 5:02 PM -0800 11/29/05, John Armstrong wrote: Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server, etc.). We want to go with Perl because it's the best programming language invented by humans. If you want something that's trivially easy to use, try SQLite. The database manager is embedded in the DBD::SQLite module itself, and you have no separate server processes to maintain, and you can specify a database's storage location like an ordinary file. Its also faster than anything else for some types of usage, and unlike many typical MySQL setups, it is fully transactional, ACID compliant, and safe. Certain kinds of usage with many writing processes may be slow, though, since only one active writer can access a SQLite database at once. SQLite is also public domain, which is about as liberty as you can get. -- Darren Duncan
Re: What's the best free DB for a web-based app?
postgreSQL! On Tue, 29 Nov 2005, John Armstrong wrote: Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server, etc.). We want to go with Perl because it's the best programming language invented by humans. -- /** Louis Gonzales ***\ /** http://www.linuxlouis.net \ / [EMAIL PROTECTED] **\ / BSCS Eastern Michigan Univ. \ /** HP Certified Professional \
