Connecting to a Domino Db

[DMB]

Ok,

I'll try harder this time. Perhaps it is my impatient nature, but I
tend to have difficulty posting questions that don't draw fire (not
enough info, vague errors, etc.).

I've been programming in Perl long enough (for about 5 years on and
off) to know that I suck at it. I don't find it very intuitive to me
and no matter how long I use it, I still feel like I have to look up
darn near everything. I'm sure it's a flaw with how my brain works,
but I don't have this problem with C, Java, Pascal, BASIC, or
JavaScript, so it can't ALL be me.

Any way, I've never connected a Perl script to ANY database, let alone
a Domino one, so perhaps the syntax is similar. Has anyone here ever
connected to a Lotus Domino database? If so, could you post a code
snippet?

My goal is to run a Perl script which then looks up some information in
a Lotus Domino database and returns the findings to the web browser.

Hopefully I laid this question out well enough to avoid too many flames.

 

[Constantin Wiemer]

Any way, I've never connected a Perl script to ANY database, let alone
a Domino one, so perhaps the syntax is similar. Has anyone here ever
connected to a Lotus Domino database? If so, could you post a code
snippet?

My goal is to run a Perl script which then looks up some information in
a Lotus Domino database and returns the findings to the web browser.

Hopefully I laid this question out well enough to avoid too many flames.

Traditionally Lotus Notes / Domino has been using a proprietary database
format (NSF). I don't know if there is a way to directly access these
databases. But IBM recently (not sure which version of Domino) added the
possibility to use DB2 as database backend. In that case you could use
the DBI module together with DBD:B2 to connect to the DB2 database. Of
course, then you still have the problem to find out where the
information you're looking for is located. Might be a bit tricky because
Notes / Domino databases usually contain quite unstructured data and I
don't know how IBM managed to map them onto the relational structure of DB2.

Hope this helps,

Constantin Wiemer

 

[DMB]

The DB2 option isn't available until version 7 which is not quite fully
Gold. Even after it is rolled out, most databases will likely remain
as .nsf files rather than mess with converting to db2. I have some
Java code that connects to a .nsf database. If I post that would you
know how to write similar code in Perl?

 

[Constantin Wiemer]

The DB2 option isn't available until version 7 which is not quite fully
Gold. Even after it is rolled out, most databases will likely remain
as .nsf files rather than mess with converting to db2. I have some
Java code that connects to a .nsf database. If I post that would you
know how to write similar code in Perl?

I guess so, if you pay me enough

I suggest you try on your own and come back to the group if you have
specific Perl questions. Actually rewriting the Java code in Perl
shouldn't be too hard.

Constantin Wiemer