On Sat, Dec 22, 2012 at 12:06:57AM +0100, Jens Rehsack wrote:
> On 21.12.12 22:41, Sven Dowideit wrote:
>
> But I mean the base DBD::RAM you'll find at
> http://search.cpan.org/dist/DBD-RAM/ ;)
>
> I would reduce it for in-memory tables only.
You didn't mention that earlier :)
Hacking on DBD::RA
On Sat, Dec 22, 2012 at 09:14:06AM +, Tim Bunce wrote:
> On Fri, Dec 21, 2012 at 11:38:37PM +, Lyle wrote:
> > Hi,
> > From working through the docs I've hit some issues.
>
> > ftp://sqlstandards.org/SC32/SQL_Registry/
>
> > This FTP link no
On Fri, Dec 21, 2012 at 11:38:37PM +, Lyle wrote:
> Hi,
> From working through the docs I've hit some issues.
> ftp://sqlstandards.org/SC32/SQL_Registry/
> This FTP link no longer works, looks like it hasn't for some time:
> http://www.nntp.perl.org/group/perl.dbi.users/2007/04/msg31292.h
On Thu, Nov 29, 2012 at 10:15:19PM +0100, Jens Rehsack wrote:
>
> But back to the issue - now it seems dbm_tables is fetched earlier
> in some cases than f_dir which causes an invocation of
> DBI::DBD::SqlEngine::Table::get_table_meta (including
> DBI::DBD::SqlEngine::Table::bootstrap_table_meta)
On Wed, Oct 31, 2012 at 08:43:18AM -0700, ch...@abacuscc.org wrote:
> The apostrophe in "it's" stood out to me. Thought I'd point it out.
Fixed. Thanks!
Tim.
On Tue, Oct 30, 2012 at 06:36:17AM +, Jens Rehsack wrote:
> Hi Tim,
>
> 2012/10/29 Tim Bunce :
> > FYI as a trial I've merged trunk into the dbi/branches/sqlengine branch
> > and uploaded it as DBI-1.622_901.tar.gz
>
> Didn't you upload 1.622_901 on 13t
FYI as a trial I've merged trunk into the dbi/branches/sqlengine branch
and uploaded it as DBI-1.622_901.tar.gz
Thanks for all the contributions.
Tim.
On Sun, Oct 21, 2012 at 03:59:56PM +0200, Henri Asseily wrote:
> Some more comments from the user (he should probably modernize his whole
> stack but that's not the point here :)):
What perl and DBI versions?
> From our testing, somewhere $dbh gets overrun by something but we
> could not tell if
[CC'd to dbi-dev@perl.org for discussion]
On Tue, Sep 25, 2012 at 09:55:17PM +0200, Max Maischein wrote:
> Hello Tim,
>
> I was looking at DynaLoader and AutoLoader, and found that some
> old(er) versions of DynaLoader used AutoLoader, like the one
> distributed with 5.10. Having an AUTOLOAD subr
On Thu, Sep 20, 2012 at 10:23:27PM +0200, Carlos Velasco wrote:
>
> Running in a "standard" DBI, results shows some memory fluctuation:
Ignoring what Devel::Leak says, does the actual size of the process grow?
Tim.
On Mon, Sep 17, 2012 at 06:56:34PM +0200, Jens Rehsack wrote:
> Hi there,
>
> today I got some people in irc://irc.perl.org/#dbi to discuss planned
> extension to DBD::File.
>
> There were several goals to reach:
> 1) add readonly mode to DBI::DBD::SqlEngine
>==> will be solved by adding a ne
On Tue, Sep 04, 2012 at 11:28:17AM +0100, Martin J. Evans wrote:
> This issue cropped up because runrig posted a "DBI bind_param_inout trick"
> node (http://perlmonks.org/?node_id=989136) on perl monks which when I ran
> through DBD::ODBC did not work. The code is basically:
>
> my @cols = qw(fo
On Wed, Aug 15, 2012 at 06:02:35PM +0100, Charles Jardine wrote:
>
> $obj is not a string. It is an object of a class which has a
> stringify operator. "$obj" is a string, because "..." stringifies.
>
> It is not at all clear how the DBI should take a copy of an object.
Without any method attrib
On Wed, Aug 15, 2012 at 04:14:52PM +0100, Martin J. Evans wrote:
> I've just been given an rt https://rt.cpan.org/Ticket/Display.html?id=78838
> and am at a loss to explain exactly what is happening. I wonder if anyone can
> help?
>
> Some background:
>
> DBI says for bind_param:
>
> "The bind
On Sat, Aug 11, 2012 at 04:36:26PM +0200, "José Diaz Seng" wrote:
>> > I don't know whether a name such as
>> > DBIx::Table::DataGenerator would be better? Given that you have a
> database
>> > handle, I assume it actively loads the data, rather than generating a
> file
>> > for
On Fri, Aug 10, 2012 at 05:27:47PM -0700, Jonathan Leffler wrote:
> On Sun, Aug 5, 2012 at 12:48 PM, "José Diaz Seng" wrote:
>
> > I am about to write a CPAN module having the working title
> > DBIx::Table::Inflate and would like to hear your opinion about the name.
> >
> > Your comments are very
On Sun, Jul 01, 2012 at 04:37:28PM +0100, Martin J. Evans wrote:
> Just thought the people here might be interested in this. After a
> few problems with SD cards and switching to Debian Wheezy (Perl
> 5.14.2) I managed to build DBI on a Raspberry Pi today. It failed
> spectacularly with cpanp and c
[Sorry for the late reply]
I'd rather DBI::Const::GetInfoReturn and DBI::Const::GetInfoType
were extended and documented to provide whatever API you need.
Tim.
On Mon, Jun 11, 2012 at 09:00:06AM -0400, Brendan Byrd wrote:
> Currently, the following language appears in DBI::Const::GetInfo::ODBC:
as expected.
>
> Version 1.620 of DBI causes this issue, while 1.616 does not. Based on
> the changes document on the DBI CPAN page, the following changes appear
> to be potential candidates for the introduction of this problem:
>
> In 1.617:
> Enhanced performance for threade
On Wed, Apr 18, 2012 at 02:52:24PM +0100, Tim Bunce wrote:
> The DBI currently has 16 tickets in RT:
>
> https://rt.cpan.org/Public/Dist/Display.html?Name=DBI
> I'd appreciate it if someone could review the other non-wishlist
> non-stalled tickets to see if they should b
On Wed, Apr 18, 2012 at 04:35:07PM +0100, Dave Mitchell wrote:
> > Note that this and the just-submitted DBIS patch represent the end of
> > my work on improving performance on DBI, (not counting any remedial work
> > that may be required).
>
> PS - here are some final timings, comparing my
>
The DBI currently has 16 tickets in RT:
https://rt.cpan.org/Public/Dist/Display.html?Name=DBI
Martin is going to apply the patches in two most recent tickets 76520, 76572.
I'd appreciate it if someone could review the other non-wishlist
non-stalled tickets to see if they should be closed or
On Wed, Apr 18, 2012 at 11:55:45AM +0100, Dave Mitchell wrote:
>
> To keep things as simple as possible, I've left mg_obj pointing to
> the SV containing the struct, but added using mg_ptr (with mg_len == 0)
> that caches a direct pointer to the structure, skipping the need to
> indirect via the S
Perfect! Applied. Many thanks Dave.
Tim.
On Wed, Apr 18, 2012 at 11:48:31AM +0100, Dave Mitchell wrote:
> On Fri, Mar 02, 2012 at 05:04:29PM +, Dave Mitchell wrote:
> > On Fri, Mar 02, 2012 at 03:23:30PM +, Dave Mitchell wrote:
> > > I'd be happy in principle, although some guidance would
On Fri, Feb 24, 2012 at 05:18:14PM +, Dave Mitchell wrote:
> (I confess I haven't looked closely at this yet, but...)
[And I confess I forgot about this message - sorry for the delay.]
> I seems that the imp_xxh_t structure is stored in the PVX of an SV
> pointed to by mg_obj.
The DBI is ver
On Tue, Apr 10, 2012 at 03:40:12PM +0200, Jens Rehsack wrote:
>
> Or - what I like to mention - there's missing a European equivalent for
> crowd funding.
>
> I always wanted to rewrite SQL::Statement reusing ribasushi's great
> SQL::Translator (allows to parse different SQL dialects - and have o
Hello Jeff.
On Sun, Apr 08, 2012 at 06:43:13AM -0700, Jeff Anderson wrote:
> Like i said, i was mostly curious of the mindset behind this code that go
> through the hard work of parsing a SQL statement but not providing the
> ability to alter and reuse that statement.
My answer, for your curiosit
On Mon, Apr 02, 2012 at 12:32:08PM +0200, Sebastian Willing wrote:
> Hi all,
>
> I created a new DBD module and submitted it to CPAN.
>
> DBD::Simulated is using the prefix "simulated_" and could create any
> DBI error code required for testing software based on DBI.
>
> I don't know if it shoul
On Tue, Mar 27, 2012 at 04:17:22PM +0200, Elizabeth Mattijsen wrote:
> >> Becomes:
> >> =
> >> my %visitors;
> >> my $values;
> >> while ( $sth= $sth->next ) {
> >>$visitors{ $values->[0] }= undef
> >> while $values= $sth->fetchrow_arrayref;
> >> }
> >> printf "
On Fri, Mar 16, 2012 at 02:18:00PM +, Martin J. Evans wrote:
>
> Perl with threads:
> 1.42
> read: 128 wallclock secs (86.11 usr + 5.41 sys = 91.52 CPU) @ 0.11/s
> (n=10)
> readperrow: 137 wallclock secs (95.33 usr + 4.86 sys = 100.19 CPU) @
> 0.10/s (n=10)
>
> subversion trunk:
>
On Thu, Mar 15, 2012 at 10:33:43AM +, Martin J. Evans wrote:
>
> Argh, DBD::Oracle tracing is a mess wrt to this discussion:
>
> ocitrace.h:
>
> #define DBD_OCI_TRACEON (DBIS->debug >= 6 || dbd_verbose>=6)
> #define DBD_OCI_TRACEFP (DBILOGFP)
>
> #define OCIServerRelease_log_sta
On Wed, Mar 14, 2012 at 01:35:21PM +0100, Elizabeth Mattijsen wrote:
> Maybe some background first:
>
> I'm working on code that does queries on large tables. To be able to support
> the growth of these tables, we need to shard the tables to multiple database
> servers. One way to shard this
On Wed, Mar 14, 2012 at 02:00:19PM +, Martin J. Evans wrote:
> >
> >>There are cases where an imp_sth is passed as a parameter yet
> >>D_imp_xxh(sth) is being called. So you end up with imp_sth and imp_xxh
> >>pointers that point to the same thing. See dbd_st_fetch and dbd_bind_ph for
> >>examp
On Wed, Mar 14, 2012 at 08:52:38AM +, Martin J. Evans wrote:
> On 13/03/12 21:44, Tim Bunce wrote:
> >On Fri, Mar 02, 2012 at 03:11:17PM +0000, Tim Bunce wrote:
> >>>
> >>>The second patch, which makes DBIS more efficient, is a lot more complex,
> >>&g
On Wed, Mar 14, 2012 at 08:24:36AM +0100, H.Merijn Brand wrote:
> On Tue, 13 Mar 2012 21:44:06 +0000, Tim Bunce
> wrote:
>
> > On Fri, Mar 02, 2012 at 03:11:17PM +, Tim Bunce wrote:
> > > >
> > > > The second patch, which makes DBIS more ef
On Fri, Mar 02, 2012 at 03:11:17PM +, Tim Bunce wrote:
> >
> > The second patch, which makes DBIS more efficient, is a lot more complex,
> > and more likely to break things (especially as it's changing a bunch of
> > macros that are directly #included by the
On Fri, Feb 10, 2012 at 03:27:24PM +, Dave Mitchell wrote:
>
> The second patch, which makes DBIS more efficient, is a lot more complex,
> and more likely to break things (especially as it's changing a bunch of
> macros that are directly #included by the DBD drivers. You may need to
> bump API
On Wed, Feb 29, 2012 at 10:49:09AM +, Martin J. Evans wrote:
> On 26/02/12 12:27, Tim Bunce wrote:
> >On Sat, Feb 25, 2012 at 02:18:56PM -0800, Jonathan Leffler wrote:
> >
> >>I'm slightly puzzled by a couple of the tests skipping because 'Not
>
On Sat, Feb 25, 2012 at 02:18:56PM -0800, Jonathan Leffler wrote:
>On Sat, Feb 25, 2012 at 12:47, Tim Bunce <[1]tim.bu...@pobox.com> wrote:
>
>DBI 1.618 installed fine for me on MacOS X 10.7.3 with Perl 5.14.1
Great.
>I'm slightly puzzled by a couple of the
On Sat, Feb 25, 2012 at 02:18:56PM -0800, Jonathan Leffler wrote:
>
>The compilation phase has a couple of warnings with the compiler set very
> fussy...I doubt if they're
>significant, but just in case they're fixable and fixworthy:
>
>Perl.c: In function �XS_DBD__Perl__dr_data_sour
On Wed, Feb 22, 2012 at 08:40:09PM +, Martin J. Evans wrote:
> I've applied Dave's patch and tested in on Windows with Perl 5.8.9
> and it now compiles without errors.
>
> Also the patch from Manoj Kumar is applied and this fixes gofer tests.
Great. Thanks Martin.
> I'd suggest you (Tim) did
On Wed, Feb 22, 2012 at 08:55:05AM +, Martin J. Evans wrote:
> On 22/02/12 08:22, Martin J. Evans wrote:
> >The following rt included a patch to apparently fix that issue - or
> >perhaps it created a new one, or perhaps it did not get in -
> >https://rt.cpan.org/Ticket/Display.html?id=74975
>
DBI 1.617_903 has a 100% pass rate on everything except MSWin32, where
there are three reports so far and 100% failure:
http://matrix.cpantesters.org/?dist=DBI%201.617_903;reports=1;os=mswin32
Result Id OS vers archnamePerl
version
FAIL
On Thu, Feb 16, 2012 at 02:42:32PM +, Martin J. Evans wrote:
> On 16/02/12 12:46, Tim Bunce wrote:
> >On Tue, Feb 14, 2012 at 02:06:30PM +, Martin J. Evans wrote:
> >>Should we be updating dbipport.h before next release.
> >>
> >>I'll do it we t
On Tue, Feb 14, 2012 at 02:06:30PM +, Martin J. Evans wrote:
> Should we be updating dbipport.h before next release.
>
> I'll do it we think it should be done. I believe we have 3.19 and 3.20 is
> available.
Devel::PPPort is mainly about helping new extensions, or new code,
written using the
On Wed, Feb 15, 2012 at 11:43:42AM +, Martin J. Evans wrote:
> It makes no sense to do this during the global destruction phase. Is the
> correct way to avoid this to wrap the call to set_err in:
>
> if (!PL_dirty && !SvTRUE(get_sv("DBI::PERL_ENDING",0))) {
> set_err
> }
>
> I wasn't sure
On Mon, Feb 13, 2012 at 05:01:41PM +, Dave Mitchell wrote:
> On Mon, Feb 13, 2012 at 03:42:21PM +, Dave Mitchell wrote:
> > On Mon, Feb 13, 2012 at 01:43:00PM +, Martin J. Evans wrote:
> > > It seems to come from the following in DBI.xs:
> > >
> > > #ifdef HvMROMETA /*introduced in 5.9
On Fri, Feb 10, 2012 at 03:27:24PM +, Dave Mitchell wrote:
>
> I'm assuming that these won't be applied until after the windows() fork
> issue is fixed, so think of this email more as a preview.
>
> The first fix is relatively straightforward, and is private to DBI.xs,
> since the PERINTERP m
On Sun, Feb 05, 2012 at 09:04:23PM +, Dave Mitchell wrote:
>
> Anyway, attached is the final patch.
> I've tested it under 5.8.1, 5.8.9, 5.14.2 and 5.15.7, with various
> permutations of threaded builds.
I've just noticed that DBI 1.617_901 has been failing on perl 5.10.0
http://matrix.cpante
On Fri, Feb 10, 2012 at 04:48:38PM -0800, Jan Dubois wrote:
> On Fri, 10 Feb 2012, Dave Mitchell wrote:
> > On Thu, Feb 09, 2012 at 11:10:17PM +0100, demerphq wrote:
> > > Well perls fork() relies on threaded perl so it could very easily be
> > > Dave's patch. Dave do you have access to a win32 bu
On Fri, Feb 10, 2012 at 07:03:09PM +0100, H.Merijn Brand wrote:
> On Fri, 10 Feb 2012 17:28:11 +, Charles Jardine
> wrote:
>
> > >> If this reproduces the problem, you have something nothing to do
> > >> with databases to investigate. If it doesn't reproduce the problem,
> > >> it may be that
On Fri, Feb 10, 2012 at 03:27:24PM +, Dave Mitchell wrote:
> On Thu, Jan 26, 2012 at 12:26:44PM +0000, Tim Bunce wrote:
>
> I attach two patches; the first replaces dPERINTERP with dMY_THX,
> while the second extends this to the DBIS stuff too.
>
> The headline figure (YMMV
On Fri, Feb 10, 2012 at 04:29:07PM +0100, H.Merijn Brand wrote:
> On Fri, 10 Feb 2012 10:22:20 -0500, Yanick Champoux
> wrote:
>
> > On 02/10/12 09:56, Yanick Champoux wrote:
> > > which should be okay, but I'm suddenly thinking: on some shells
> > > 'exit' might not do what we would expect
On Thu, Feb 09, 2012 at 09:53:08PM +, Martin J. Evans wrote:
> Something between 1.616_901 and 1.616_902 changed which breaks fork() in DBI
> on Windows.
Ah, 1.616_901 and 1.616_902! So unrelated to Dave's method cache work.
See if this works:
- static int use_xsbypass = 1;
+ static
ccurred between these 2 versions. Some smokers have reported this
> problem in 5.10.1, 5.14.0 and 5.14.2. I can reproduce on my wife's netbook
> which is strawberry perl 5.12.0.
>
> As you'll see from the Changes file the only 2 entries added were:
>
> Enhanced perform
On Thu, Feb 09, 2012 at 10:14:53AM +, Martin J. Evans wrote:
> On 09/02/12 09:15, Martin J. Evans wrote:
> >I've been testing 1.617 on our development system and have not encountered
> >any problems as yet. However, I notice a few UNKNOWN smoke reports like the
> >following one (on mac):
> >
On Tue, Feb 07, 2012 at 11:26:21PM +, Dave Mitchell wrote:
> On Tue, Feb 07, 2012 at 10:54:12PM +0000, Tim Bunce wrote:
> > > +# With this test code and threads, 5.8.1 has issues with freeing freed
> > > +# scalars, while 5.8.9 doesn't; I don't know about in-
On Sun, Feb 05, 2012 at 09:04:23PM +, Dave Mitchell wrote:
> On Mon, Jan 30, 2012 at 10:56:37PM +0000, Tim Bunce wrote:
> >
> > dbih_getcom2 does the first part of that when looking up DBI hande
> > magic. I never added the "move to the top" because I figure
On Fri, Feb 03, 2012 at 08:51:10PM +, Martin J. Evans wrote:
>
> You should also be aware that calling odbc_getdiag* will clear DBI's
> err, errstr and state so if you want DBI's methods to return
> something meaningful you may need to call them first - I'm unsure if
> I can stop this behaviou
On Fri, Feb 03, 2012 at 11:22:19AM +0100, H.Merijn Brand wrote:
>
> Warnings (on HP-UX 11.31/5.14.2-64all-ld) *in* last release:
>
> "DBI.xs", line 1469: warning #4232-D: conversion from "XPVHV *" to a more
> strictly aligned type "XPVMG *" may cause misaligned access
> "DBI.xs", line 2
On Wed, Jan 25, 2012 at 08:37:57PM +, Martin J. Evans wrote:
> I've recently been asked why DBD::ODBC does not tell you which bound
> parameter or bound column is in error when an insert/select
> specifies a type which the driver cannot convert to e.g., column is
> varchar(10) and bind column a
On Mon, Jan 30, 2012 at 11:51:50AM +0100, demerphq wrote:
> On 30 January 2012 00:16, David E. Wheeler wrote:
> > On Jan 29, 2012, at 11:06 AM, Martin J. Evans wrote:
> >
> >> I'd be happy with that as I'm looking forward to asking people to use
> >> DBI_TRACE=DBD.
> >>
> >> I've had no problems
On Mon, Jan 30, 2012 at 12:48:32PM +, Dave Mitchell wrote:
> On Sun, Jan 29, 2012 at 10:06:58PM +0000, Tim Bunce wrote:
> > On Sun, Jan 29, 2012 at 06:12:50PM +, Dave Mitchell wrote:
> > > The code itself (see diff below) just attaches some magic to the outer CV
> >
On Sun, Jan 29, 2012 at 06:12:50PM +, Dave Mitchell wrote:
>
> I've now written some working caching code, that reduces CPU usage on
> while ($sth->fetch()) {$c++} from 15.23s to 13.10s, which is a 14%
> saving!! The test code just fetches millions of rows from a 2-int table
> and then doesn't
I'd like to make a formal DBI release soon.
DBI-1.616_901 tested well and I've just uploaded DBI-1.616_902.
Any reason I shouldn't upload as DBI-1.617 soon?
Tim.
On Fri, Jan 27, 2012 at 03:33:51PM +, Dave Mitchell wrote:
> On Fri, Jan 27, 2012 at 02:53:47PM +0000, Tim Bunce wrote:
> > On Wed, Jan 25, 2012 at 08:17:27PM +0000, Tim Bunce wrote:
> > > On Wed, Jan 25, 2012 at 04:14:07PM +, Dave Mitchell wrote:
> > > > Ju
On Wed, Jan 25, 2012 at 08:17:27PM +, Tim Bunce wrote:
> On Wed, Jan 25, 2012 at 04:14:07PM +, Dave Mitchell wrote:
> > >
> > > The DBI is always allowed to cheat in the name of performance!
> > > My simple but effective xsbypass hack doesn't seem t
On Wed, Jan 25, 2012 at 05:37:13PM -0800, Jan Dubois wrote:
> On Wed, 25 Jan 2012, Tim Bunce wrote:
> > On Wed, Jan 25, 2012 at 04:14:07PM +, Dave Mitchell wrote:
> >
> > > PS - I'm specifically being paid only to fix a performance issue on
> > > non-thr
On Wed, Jan 25, 2012 at 04:14:07PM +, Dave Mitchell wrote:
> On Tue, Jan 24, 2012 at 08:42:28PM +0000, Tim Bunce wrote:
>
> Given that my hacky cache for fetch() lookup reduced overall execution
> time by 16.5%, that reduces overall XS_DBI_dispatch percentage from 33.2%
>
On Mon, Jan 23, 2012 at 12:51:12AM +, Dave Mitchell wrote:
> [ disclaimer: I am being funded to do this work ]
>
> I've been looking into bottlenecks in a tight fetch loop with millions of
> rows, e.g.
>
> $sth->bind_columns(...);
> while ($sth->fetch) {
> # do a small amount of
On Thu, Jan 05, 2012 at 09:53:35AM -0500, Yanick Champoux wrote:
> On 01/05/12 05:59, Charles Jardine wrote:
> >I am completely in favour of the abolition of oraperl, but
> >I think it would be kind to start with a version which
> >emits a warning message from the main line of Oraperl.pm,
> >so any
On Mon, Dec 12, 2011 at 06:15:40PM +, Charles Jardine wrote:
>
> Another way removing the slow-down is to re-authenticate,
> with $dbh->func('', '', 'reauthenticate'), after
> each iteration. This causes Oracle to create a new session
> within the existing connection. Re-authentication
On Fri, Dec 09, 2011 at 08:28:41PM +, Martin J. Evans wrote:
>
> It appears DBIx::Class uses parameter types a lot and is looking at
> improvements using execute_for_fetch. I suggested to the DBIx::Class
> guys the sticky parameter type was probably valid (and certainly is
> in DBD::ODBC) but
On Mon, Nov 28, 2011 at 09:26:02PM -0600, David Nicol wrote:
> An annual minor maintenance version release schedule would be cool, in
> my opinion.
Maybe. Life's crazy busy at the moment.
Tim.
On Wed, Nov 23, 2011 at 09:34:06AM +0100, Jens Rehsack wrote:
> 2011/11/22 Brendan Byrd :
> > (Adding dbi-dev to conversation for
> > https://rt.cpan.org/Ticket/Display.html?id=72588)
> >
> > Still debugging DBD::SNMP right now, and I'm currently fighting with
> > SQL::Statement to allow for schema
On Sun, Nov 13, 2011 at 02:07:25PM +0100, H.Merijn Brand wrote:
> On Sun, 13 Nov 2011 10:42:34 +0000, Tim Bunce ,
> "H.Merijn Brand" wrote:
>
> > On Thu, Nov 10, 2011 at 09:15:43AM -0800, hmbr...@cvs.perl.org wrote:
> > > +} elsif ($driver eq 'Unify'
On Fri, Nov 11, 2011 at 05:38:38PM -0500, Brendan Byrd wrote:
> (Sent this a while ago on a work account, but I guess it didn't go through.)
>
> I am nearing completion of the following modules:
>
> DBD::FusionTables - Mostly complete except for tests/docs; however Google
> is wanting to fix a lo
On Thu, Nov 10, 2011 at 09:15:43AM -0800, hmbr...@cvs.perl.org wrote:
> +} elsif ($driver eq 'Unify') {
> +# Unify does not have varchar
> +$h->{ChopBlanks} = 1;
Why ChopBlanks? Worth a # comment.
> +$blob_column_type = 'binary';
> +$unicode_column_type = 'char'; # or text
> +
On Wed, Nov 09, 2011 at 04:50:29PM +0100, H.Merijn Brand wrote:
> On Tue, 08 Nov 2011 21:12:13 +, "Martin J. Evans"
> wrote:
>
> > I've just checked in unicode_test.pl to DBI's subversion trunk in /ex dir.
>
> So now attached
Any chance you could rework your changes into the (recently updat
On Tue, Nov 08, 2011 at 02:45:39PM +, Martin J. Evans wrote:
> On 08/11/11 13:16, Tim Bunce wrote:
> >On Mon, Nov 07, 2011 at 01:37:38PM +, Martin J. Evans wrote:
>
> >2. Try to make a data-driven common test script.
>
> There is already one attached to th
On Mon, Nov 07, 2011 at 01:37:38PM +, Martin J. Evans wrote:
> >
> >I didn't think I was going to make LPW but it seems I will now - although it
> >has cost me big time leaving it until the last minute.
All your beers at LPW are on me!
> http://www.martin-evans.me.uk/node/121
Great work Mar
On Tue, Oct 04, 2011 at 11:24:51PM +0100, Martin J. Evans wrote:
> On 04/10/2011 22:38, Tim Bunce wrote:
> >I've not had time to devote to this thread. Sorry.
> >
> >I'd be grateful if someone could post a summary of it if/when it
> >approaches some kind of c
I've not had time to devote to this thread. Sorry.
I'd be grateful if someone could post a summary of it if/when it
approaches some kind of consensus.
Thanks.
Tim.
On Tue, Oct 04, 2011 at 02:20:10PM +0200, Reinier Post wrote:
> On Fri, Sep 23, 2011 at 11:19:32PM -0400, Brendan Byrd wrote:
>
> For a start it would be nice to have a matrix up somewhere listing
> DBMSes against SQL constructs, so I can look up, for instance, against
> which types of DBD backend
ot;, even a single hash. Some potential names could be:
>
> DBD::Object
> DBD::Tree
> DBD::TreeObject
> DBD::NestedObject
>
> Which one would work best?
>
> --
> Brendan Byrd
> System Integration Analyst (NOC Web Developer)
>
> -Original Message-
>
Would it be an actual DBI driver?
Could you post some examples or docs?
I'm uncomfortable with it having such a generic name.
Two words after the DBD would be better.
Tim.
On Wed, Sep 21, 2011 at 02:58:09AM +, Byrd, Brendan wrote:
> I think I'm going to end up going the route of a new modul
On Thu, Aug 11, 2011 at 04:42:00PM -0700, Darren Duncan wrote:
> Is it necessary for each DBI driver to have a prefix registered in
> DBI itself, or is this only necessary when the driver wishes to
> expose extra public methods? If the DBD doesn't expose custom
> methods, can it be used without th
On Mon, Sep 12, 2011 at 01:13:58PM -0700, Darren Duncan wrote:
> To be brief, ...
Darren, if you want to do something really directly useful for the DBI
ecosystem I would encorage you (or anyone else) to work on creating a
DBI test suite that's independent of the DBI distribution.
Tim.
p.s. I'm
On Sun, Sep 11, 2011 at 11:25:20PM +0100, Andrew Ford wrote:
> I suggest that we move this discussion to dbi-dev.
[dbi-users dropped]
> On 11/09/11 18:14, Tim Bunce wrote:
> >On Fri, Sep 09, 2011 at 03:50:53PM +0100, Andrew Ford wrote:
>
> my $next_middleware = $go_tra
On Tue, Aug 09, 2011 at 01:05:40AM -, Greg Sabino Mullane wrote:
>
> > Did you have a prefix in mind that is not already in use? Would 'sl_' be
> > appropriate, for example? You can find the current list of assignments at
> > about line 320 in DBI.pm, and 'sl_' appears to be available. (Th
On Wed, Jun 29, 2011 at 03:28:19PM +0100, Martin J. Evans wrote:
> Don't know however, I am inclined to change the error to a warning as Tim
> suggested. It simplifies things for people who might be calling fetch on a
> non-select. However, it isn't going to happen soon unless someone screams for
On Wed, Jun 29, 2011 at 09:02:27AM +0100, Martin J. Evans wrote:
> On 24/06/11 16:17, David Nicol wrote:
>
> perl -le 'use DBI; my $h = DBI->connect(); my $s = $h->prepare("create table
> fred (a int)"); $s->execute; my $r = $s->fetch;'
> DBD::ODBC::st fetch failed: no select statement currently
On Fri, Jun 17, 2011 at 02:46:43PM +0100, Martin J. Evans wrote:
> >The only thing I'm not sure about is whether $sth->{NUM_OF_FIELDS} is always
> >set by $dbh->prepare, or whether some DBMS can't set it until you do
> >$sth->execute.
>
> Right now, I am unsure of that too.
Some can't at all, som
On Fri, Jun 10, 2011 at 10:13:09AM -0500, David Nicol wrote:
> in my opinion this facility should be formally defined as "undefined" and a
> note should go in the selectall* docs recommending "do" instead for
> non-select SQL.
+1
Patch welcome.
Tim.
Fixed (r14873) Thanks!
Tim.
On Mon, May 23, 2011 at 10:21:13PM +0200, Steffen Winkler wrote:
> Hello together,
>
> the error is in a code block:
>
> my $cb = {
> ‘connect_cached.reused’ => sub { delete $_[4]->{AutoCommit} },
> };
> ^^ ^^
> Be greeted fro
Thanks guys.
Tim.
On Mon, May 16, 2011 at 05:00:48PM -0400, yan...@babyl.dyndns.org wrote:
> On Mon, May 16, 2011 at 08:23:55PM +0100, Tim Bunce wrote:
> > On Fri, May 13, 2011 at 07:07:31PM +0100, Martin J. Evans wrote:
> > > http://www.easysoft.com/dbi.avi
> > >
On Fri, May 13, 2011 at 07:07:31PM +0100, Martin J. Evans wrote:
> http://www.easysoft.com/dbi.avi
> ftp://ftp.easysoft.com/pub/dbi.avi
>
> It is done with codeswarm which you can read about and get at
> http://code.google.com/p/codeswarm/. It explains what the
> visualisation is.
Cool. Thanks.
I
On Sun, May 15, 2011 at 02:36:51PM -, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> > Is this a defect in DBI or in DBD::Informix (and NullP)?
> > Or is it WAD - Working As Designed?
>
> Not sure when this was added, but on DBD::Pg, an error is
On Tue, May 10, 2011 at 08:01:02PM +0100, Martin J. Evans wrote:
>
> o returning the data in some native codepage like windows-1252 does
> not help you really, it probably hinders you and in any case you can
> encode it as windows-1252 afterwards when you output it somewhere.
>
> As a result, I t
On Mon, May 09, 2011 at 07:42:53PM +0100, Martin J. Evans wrote:
> I've recently had an rt posted
> (http://rt.cpan.org/Public/Bug/Display.html?id=67994) after a
> discussion on stackoverflow
> (http://stackoverflow.com/questions/5912082/automatic-character-encoding-handling-in-perl-dbi-dbdodbc).
301 - 400 of 1961 matches
Mail list logo
