Stack Overflow
Stack Overflow

Questions tagged [dbd]

DBD is a common prefix for all perl modules used as database drivers by the DBI module. These drivers hide the internals of different relational database management systems by providing a common API through the DBI module.

Access to relational databases in Perl is usually accomplished by the CPAN DBI module. See also DBI tag wiki entry.

DBI provides a common API for database access that uses separate drivers (DBD::*) internally to handle the specifics of different database management system implementations.

Some of the most popular DBD modules available on CPAN are:

DBD::MySQL
DBD::Oracle
DBD::Pg       (PostgreSQL)
DBD::ODBC
DBD::SQLite
DBD::Informix
DBD::Mock     (for testing purposes) 
DBD::CSV      (limited SQL access for CSV files)
DBD::JDBC
169 questions
4
votes
1 answer

DBI::CSV Implementation Based on Sqlite

I deal a lot with text files, comparing one to another in a "SQL manner". DBD::CSV is obviously a good choice to start with, as I can use the power of SQL syntax on text tables. However, I deal with huge text files, making DBD::CSV useless in terms…
Mattan
  • 733
  • 7
  • 19
4
votes
6 answers

How do I fix "Symbol not found: _is_prefix" when compiling Perl's DBD::mysql?

First I wanted to build the DBD::mysql package. That kept failing because whatever make resulted in could not be loaded for the tests with a Symbol not found: _is_prefix. So I assumed that cpan might be a tad old. I know it's a random assumption,…
dlamblin
  • 43,965
  • 20
  • 101
  • 140
3
votes
4 answers

Anyone been able to install DBD::mysql on Mac Snow Leopard with i5 Processor?

I'm trying to install DBD::mysql using most of the popular methods, including sudo cpanm -S DBD::mysql. However, I am having some serious problems with this and I am beginning to think it might be my processor. I have successfully installed this on…
Jeff Erickson
  • 3,783
  • 8
  • 36
  • 43
3
votes
1 answer

how to fake a perl module for dependency?

An external Perl library that I am using has a dependency (DBD::mysql) that I will not be using in my application (DBD::SQLite), so I would like the system to just pretend the dependency is there, even if it's a "fake". Can I just create an empty…
719016
  • 9,922
  • 20
  • 85
  • 158
3
votes
5 answers

How do you install perl DBD::Oracle on OSX Snow Leopard 10.6

I'm trying to connect to Oracle 10.2.0.4 on a remote system from my intel mac running OSX 10.6 snow leopard. I've tried using perl CPAN to install DBD::Oracle (DBI worked ok) but get compilation errors. Could someone provide an easy to follow guide?…
nick fox
  • 570
  • 8
  • 15
3
votes
1 answer

Trouble installing DBD::mysql under macOS Catalina 10.15.1

Can't install DBD::mysql under macOS Catalina 10.15.1. Mysql 8.0.18 and openssl 1.0.2t are installed through brew. Here is the module installation log: cpan[1]> install DBD::mysql .......... I will use the following settings for compiling and…
Dmitriy
  • 463
  • 1
  • 5
  • 12
3
votes
1 answer

execute failed: Incorrect string value: '\xD6sterl...' with mariadb and perl DBD

I'm a novice perl programmer trying to use DBI to write a buffer of text that contains an email with umlauts and other non-ASCII characters to a joomla database and having a problem. DBD::mysql::st execute failed: Incorrect string value:…
Alex Regan
  • 477
  • 5
  • 16
3
votes
1 answer

Character set problems with Perl, DBD::Oracle and Oracle 10g

We have a problem with characters outside of the basic ASCII set appearing as upside down question marks in our Oracle 10g database. I have the following script to load some test data. The script is saved as Latin-1/ISO-8859-1 on a remote UNIX…
Nick
  • 2,418
  • 16
  • 20
3
votes
1 answer

DBD::ODBC vs win32::odbc

I wonder what are the advantages and disadvantages using one over the other. This question originated from an advice I got here: Allocate buffer dynamically for DB query according to the record actual size I am looking for a list of the important…
Rotem Varon
  • 1,597
  • 1
  • 15
  • 32
3
votes
3 answers

Using Ubuntu, how do I install DBD::Sybase from CPAN?

Whenever I try to build DBD::Sybase to connect to MSSQL I get an error, $ sudo cpanp install DBD::Sybase Installing DBD::Sybase (1.15) Running [/usr/bin/perl /usr/bin/cpanp-run-perl /home/ecarroll/.cpanplus/5.14.2/build/DBD-Sybase-1.15/Makefile.PL…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
3
votes
2 answers

Perl dies with: "Usage: DBD::Pg::db::DESTROY(dbh) during global destruction"

A stable, web-based, single-threaded/process, perl application running in production started throwing this error intermittently and only under heavy system load. We can't identify the root cause. Usage: DBD::Pg::db::DESTROY(dbh) during global…
Allen
  • 718
  • 8
  • 9
2
votes
2 answers

missing mysql_config error while installing DBD::mysql

I saw Trying to install Perl-Mysql DBD, mysql_config can't be found, and tried to locate mysql_config, but didn't find it. So, I tried to install mysql-devel, and then I get this error- [nbezzala@stats /]$ sudo yum install mysql-devel [sudo]…
bezz
  • 83
  • 1
  • 12
2
votes
3 answers

how can I insert C structures that have character pointers into DBD file

I am changing from a file system I made into DBD. And I had no choice to convert structures that have character point members to insert these structures into the DBD file for examble, If there is a structure as below typedef struct { int …
user1044764
  • 21
  • 3
2
votes
1 answer

How to check if MySQL service is running with DBD::mysql

I am using the following DBD::mysql statement to connect to a MySQL database: use DBI; # Connect to the database. my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost", "usr", "usr's password", …
Manoj Agarwal
  • 365
  • 2
  • 17
2
votes
2 answers

Perl script raising oci.dll error, DBD

I have perl script which connects to an Oracle database, opens a text file and loads the data from the file in a database table, the script works perfectly on my development machine (windows xp 32 bit), however when i load the script to the…
RobLaw84
  • 175
  • 2
  • 5
  • 18
1
2
3
…
11 12