Re: Seeking *non* thread-friendly DBD

2005-07-29 Thread Matt Sergeant
On 22 Jul 2005, at 12:30, Dean Arnold wrote: Hoping someone can point me at a DBD thats known to be non-thread-friendly (ie, hasn't implemented the clone() methods). However, its underlying client libs and XS subs (if any) do need to be thread-capable (ie, no writing to process-global variables

Re: DBD::SQLite bug?

2004-11-16 Thread Matt Sergeant
On 14 Nov 2004, at 23:17, Tim Bunce wrote: On Sun, Nov 14, 2004 at 10:23:07PM +0100, Max Maischein wrote: Tim Bunce wrote: Anyone got an update to this? Nope - http://www.perlmonks.org/index.pl?node_id=404191 points out that the problem also appeared with the MySQL DBD (no version info), but I can

DBD::SQLite: Migration to SQLite 3.0

2004-07-17 Thread Matt Sergeant
Hi guys, Anyone who has read my journal will know that I now have DBD::SQLite ported to SQLite 3.0, which provides better datatypes, better concurrency, proper blob support, etc. Now the big problem is that sqlite 3.0 is incompatible with sqlite 2.x (which the current CPAN version of DBD::SQLit

Re: DBD::SQLite V 0.26 under Win2K

2003-08-28 Thread Matt Sergeant
ns are not added explicitly to stop compiler warnings, but barring that, the tests all pass, so I feel it is time to try a few home-grown tests. I'm sure Matt Sergeant will happily accept patches :) (or at least a list of compiler warnings) Indeed. Frankly I'm surprised it compiles on Windows at all :-) Matt.

Re: DBI on a pocketPC - preliminary success

2002-12-18 Thread Matt Sergeant
On Wednesday, Dec 18, 2002, at 01:26 Europe/London, Jeff Zucker wrote: Just a preliminary report - thanks to Rainier Keuchel's port of perl to winCE, I now have DBI (PurePerl) and DBD::AnyData doing database read access on my Toshiba e740 (a palm-like handheld running pocketPC on an xScale pro

Re: [RFC] Date/Time standard for input/output

2002-08-04 Thread Matt Sergeant
ODBC has a built-in standard for this - I forget exactly what it is, but it's something like {d -MM-DD}, {t HH:MM:SS} and {ts -MM-DD HH:MM:SS} (for input, that is - I think output is still database specific, but I could be wrong). Alternatively, you could specify something like a Time

Re: Perl SDK?

2002-06-11 Thread Matt Sergeant
On Tue, 11 Jun 2002, Jarkko Hietaniemi wrote: > > I think the Software Development Kit (SDK) approach has more appeal: > > Define a standard bundle of extra modules that people are recommended > > to install with Perl. There was an attempt at an defining an SDK > > for Perl some time ago but it s

Re: DBD::SQLite with Japanese Character problem

2002-03-27 Thread Matt Sergeant
On Wed, 27 Mar 2002, Tatsuhiko Miyagawa wrote: > At Wed, 27 Mar 2002 10:25:53 + (GMT), > Matt Sergeant wrote: > > > Ah this is much clearer now. > > *grin* > > > SQLite expects and requires utf-8 characters > > as input (it can't cope with binary data

Re: DBD::SQLite with Japanese Character problem

2002-03-27 Thread Matt Sergeant
On Wed, 27 Mar 2002, Tatsuhiko Miyagawa wrote: > use DBI; > > my $dbname = "t/db.$$"; > my $orig = "\xa4\xa2"; # japanese "A" in EUC-JP > insert_string($dbh, $orig); Ah this is much clearer now. SQLite expects and requires utf-8 characters as input (it can't cope with binary data - it is pu

Re: DBD::SQLite with Japanese Character problem

2002-03-26 Thread Matt Sergeant
On Tue, 26 Mar 2002, Tatsuhiko Miyagawa wrote: > At Tue, 26 Mar 2002 20:27:47 +0900, > KAWAI,Takanori <[EMAIL PROTECTED]> wrote: > > > > I found these lines in "dbdimp.c" must be the point. > > > > line : 375 - 381 > > sv_setpvn(AvARRAY(av)[i], val, len); > > SvUTF8_on(AvA

ANNOUNCE: DBD::SQLite

2002-02-19 Thread Matt Sergeant
Some of you may have seen this elsewhere (perlmonks or my use.perl.org journal), so forgive me. I've just uploaded the first public version of DBD::SQLite to CPAN. What is it? DBD::SQLite is a DBD driver that contains the database engine in the driver. That means you don't need to install anyth

Re: Important: Subclassing and Merging DBIx::AnyDBD into the DBI

2002-01-03 Thread Matt Sergeant
Hi Tim, Not much I can say really except I think it seems extremely coherent, and compliant with KISS, and well, you know I like the general concept :-) On Thu, 3 Jan 2002, Tim Bunce wrote: > The logic for mapping a connection into a hierarchy of classes > will be extensible and overridable

Re: DBIx-XML_RDB

2001-04-23 Thread Matt Sergeant
On Mon, 23 Apr 2001, Thirumalai, Radhika wrote: > Can someone suggest me (any url / reference manual...) where I can find a > working example of the perl module DBIx-XML_RDB? Thanks It comes with two scripts - sql2xml and xml2sql. They are the best references it has. -- /||** Founder

ANNOUNCE: DBIx::AnyDBD 1.99

2001-04-22 Thread Matt Sergeant
This class is an alternative approach to developing database independant code, which differs from modules that write SQL for you (such as DBIx::Recordset). Instead this module provides an OO inheritance hierarchy for putting methods that do your SQL. For example, you create a Default.pm file (in

Re: FW: DBIx::XML_RDB

2001-04-19 Thread Matt Sergeant
On Thu, 19 Apr 2001, Thirumalai, Radhika wrote: > > > > -Original Message- > > From: Thirumalai, Radhika > > Sent: Thursday, April 19, 2001 4:25 PM > > To: '[EMAIL PROTECTED]' > > Subject:DBIx::XML_RDB > > > > I'm trying to export data from a database to an XML file

Re: DBD::Sybase freezes on execute()

2001-03-21 Thread Matt Sergeant
On Wed, 21 Mar 2001, Vladimir Jebelev wrote: > Hi, > > I am having problems with DBD::Sybase when execute() blocks and never > returns - don't know for sure if it's the driver or maybe the client > library (I am using DBI 1.14, DBD::Sybase 0.91 and Sybase server 11.0.3 on > Linux). Once in a whi

Re: Good Book on PostgreSQL?

2001-03-10 Thread Matt Sergeant
On Sat, 10 Mar 2001, Matthew Tedder wrote: > > Can someone recommend to me a good book on PostgreSQL? > Although I am mostly a DB2 fan, PostgreSQL will enable me to offer my > healthcare apps to low-cost centers such as Hospices and low-income > community medical facilities of various sorts. Th

Re: Expat.pm & DBI.pm incompatible? Undefined subroutine &main: !?

2001-03-08 Thread Matt Sergeant
On Thu, 8 Mar 2001, [EMAIL PROTECTED] wrote: > > > I've switched to "use DBI"; instead of Oraperl. I still get Undefined > subroutine &main: called from Parser.pm. $SIG{__DIE__} is being defined somewhere, would be my guess. -- /||** Founder and CTO ** ** http://axkit.com/

Re: Expat.pm & DBI.pm incompatible? Undefined subroutine &main: !?

2001-03-08 Thread Matt Sergeant
On Thu, 8 Mar 2001, [EMAIL PROTECTED] wrote: > > > Anybody out there have experience using both Expat.pm and DBI.pm? I haven't tried with Oracle yet, but I have plenty of stuff using PostgreSQL and MySQL. > Undefined subroutine &main: called at Parser.pm line 185. (Parser.pm > is just a wrap

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Mon, 5 Feb 2001, Hardy Merrill wrote: > Matt, I was hoping that Time::Object and Time::Seconds were part > of the Perl distribution, but I couldn't find it in Perl 5.005_03 > nor 5.6. I did find it on CPAN - do you know if these will become > part of the standard distribution at some point?

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Tue, 6 Feb 2001, Kiran Kumar M wrote: > > Thanks, for your mail.. But for this which module should load.. It is > giving the error.. > > Can't locate Time/Object.pm in @INC (@INC > contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 > /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr

Re: How to get the Date + some days

2001-02-05 Thread Matt Sergeant
On Tue, 6 Feb 2001, Kiran Kumar M wrote: > > > Hi, > > How can I get the Date + some days (for example 6th of Feb 2001 + 10 > should give 16th of Feb 2001...). How can I achieve this. I installed > Date::calc perl module... use Time::Object; use Time::Seconds; my $today = localtime; my $today