On Thu, 2005-12-01 at 19:00 -0800, Mark wrote:
> So followup question: are any of these other systems good
> with large'ish databases? I have multi-TB Oracle databases that
> I'd like to explore on a "free" database. Is that realistic?
> My current system relies heavily on partitions, bitmap inde
On Wed, 2005-11-30 at 10:34 -0600, Jesse, Rich wrote:
> Being from primarily an Oracle background (as far as DBs go), I'd say
> overall "Oracle". Free? Yes! There's now a free Express Edition
> ("XE") currently for Linux and Winders (beta) which can be downloaded
> from http://www.oracle.com/tec
Dean Arnold wrote:
RE: LOBs and "SQL Parse Trees": having recently implemented
LOB support for a JDBC driver (and soon for a DBD), I can assure
you that SQL parse trees are unneeded to support them. For databases
Great!
Perhaps you can shed some light on how to do it for this, then.
SQL comma
Darren Duncan wrote:
I should emphasize that I never expected to be able to send any type of
ASTs over the pipe to the database. They would still be interpreted by
the database driver for Perl and/or a wrapper thereon, into the database
native format. Its just that, to an application, it woul
Maxim Sloyko wrote:
But this is not the point. The point was that usage of some file with
passwords by *DEFAULT* is not the way to go, IMHO. It raises more
problems than it solves.
Can you give an example of such a problem that wasn't already there?
Just to be clear, the file would only need
Adam Kennedy wrote:
Yes, native positional support is still important.
positions make it very easy to do SQL math.
To express it in overly simplistic code
$foo = [ "a = ?", "foo" ];
$bar = [ "b = ?", "bar" ];
$baz = "$foo and $bar";
# $baz now is [ "a = ? and b = ?", "foo", "bar" ];
Bearing mind
Darren Duncan wrote:
Okay, considering that using the same name prepare() like this may
confuse some people, here is a refined solution that uses 3 methods
instead; please disregard any contrary statements that I previously made:
I think I'm beginning to like it.
Allow me to suggest one or tw
Darren Duncan wrote:
3. Redefine prepare() and execute() such that the first is expressly for
activities that can be done apart from a database (and hence can also be
done for a connection handle that is closed at the time) while all
activities that require database interaction are deferred to
Richard Nuttall wrote:
- support for automatically pulling database DSN information from a
~/.dbi (or similar) file. This is constantly re-invented poorly.
Let's just do a connect by logical application name and let the
SysAdmins sort out which DB that connects to, in a standard wa
Hey Tim.
> I've kept an eye on Perl 6 and Parrot developments but I'm no expert in
> either. What I'd like *you* to do is make proposals (ideally fairly
> detailed proposals, but vague ideas are okay) for what a Perl 6 DBI API
> should look like.
> Keep in mind that the role of the DBI is to prov
Kemmann, Urs wrote:
I want to show a table of a MySQL Database in the internet using HTML
Templates...
[bzzzt]
wrong list.
You can probably find your solution through careful searching of perlmonks.org. If you can't find someone asking this question
before, then they probably won't mind too much
: %d => %s (%d) pos %d\n",
- imp_sth->params, SvIV(param), SvPV_nolen(value), sql_type, pos);
+ imp_sth->params, SvIV(param), (SvPOK(value) ? SvPV_nolen(value) :
"NULL")
, sql_type, pos);
av_store(imp_sth->params, pos, SvREFCNT_inc(value));
av_s
e database allow for inserting any byte, if they're witched to
literal mode?
Don't know. I expect the documented method works, though.
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
oning that the 10g libraries can't connect to
Oracle 8.
However, the version 8 libraries can definitely connect to 10g.
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
library
authors, but I can't even see from the documentation what the correct
way to use DBI is.
Constructive comments and corrections most welcome.
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
on't care for the escaping conventions of the database. That's why
I use placeholders. The code works if VARCHAR columns are used, for
instance.
What I want to know is if this bug can be fixed, without explicitly
letting the DBD know what type of column a placeholder is.
--
Sam Vilain,
input syntax for type bytea
at test.pl line 18.
ERROR: invalid input syntax for type bytea at test.pl line 18.
Is this going to be possible to fix in the DBD driver without using
bind_param?
I'm on Pg 7.4.3
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
lists on e-mails you send.
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
Oracle that you want, but it not the same as overriding
the physical location of the host by passing in a host= parameter.
The same story would probably hold true for any ORB located database.
--
Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)
ce
(possibly including a schema version), then a module with a config file
maps that to a set of connection parameters.
ie, if we're going to go ahead and try to make some sense of how you
specify the parameters to the DBI connect call, why don't we go the
whole way and think about where t
is case.
Can I point out that you seem to be assuming the MySQL/Pg model of how
servers, ports, databases, users and passwords work.
This all has no meaning to SQL*Net (Oracle), SQLite, ODBC and probably
other databases, too.
I suspect this is part of the reason that Tim is questioning your
objec
21 matches
Mail list logo
