473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

DBI and what else..

2
Hi!

Are there any other interfaces like DBI for Perl?
Sep 6 '07 #1
5 1173
Kelicula
176 Expert 100+
What are you trying to do?

Why do you want something else?

Google is an invaluable resource...
Sep 7 '07 #2
numberwhun
3,509 Expert Mod 2GB
Hi!

Are there any other interfaces like DBI for Perl?
DBI is a module to allow Perl to more easily interface with Databases. If you you are curious as to what other modules are available for Perl, then you can check all of them out on CPAN.

Regards,

Jeff
Sep 7 '07 #3
KevinADC
4,059 Expert 2GB
these are all listed on the CPAN search homepage as "interfaces"


Database Interfaces

Commercial Software Interfaces

Operating System Interfaces

Language Interfaces

User Interfaces

http://search.cpan.org/
Sep 7 '07 #4
RaV
2
What are you trying to do?

Why do you want something else?

Google is an invaluable resource...
I have to find something that is threadsafe and allows you to build multi thread app that connect to SQL Server.
DBI with all the modules from DBD:: is not thread safe.
Sep 9 '07 #5
Kelicula
176 Expert 100+
I have to find something that is threadsafe and allows you to build multi thread app that connect to SQL Server.
DBI with all the modules from DBD:: is not thread safe.
I believe it can be...

The multithreading capabilities of DBD::mysql depend completely on the underlying C libraries: The modules are working with handle data only, no global variables are accessed or (to the best of my knowledge) thread unsafe functions are called. Thus DBD::mysql is believed to be completely thread safe, if the C libraries are thread safe and you don't share handles among threads.

The obvious question is: Are the C libraries thread safe? In the case of MySQL the answer is "mostly" and, in theory, you should be able to get a "yes", if the C library is compiled for being thread safe (By default it isn't.) by passing the option -with-thread-safe-client to configure. See the section on How to make a threadsafe client in the manual.
Quoted from DBD::mysql

Also an interesting and informative read:
Perl should specify

Is anyone else going to be editing the SQL database at the same time your scripts will be?
if the SQL is only going to be edited by your scripts (eg: a dynamic website)
This should work fine:
Expand|Select|Wrap|Line Numbers
  1. use Fcntl qw(:DEFAULT :flock);
  2. flock();
  3.  
  4.  
  5.  
type: perldoc -q "\block" into your command line.

Hope this sorta helped...
Sep 11 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

15
by: lkrubner | last post by:
I want to give users the power to edit files from an easy interface, so I create a form and a PHP script called "fileUpdate". It does a reasonable about of error checking and prints out some...
33
by: Diez B. Roggisch | last post by:
Hi, today I rummaged through the language spec to see whats in the for ... else: for me. I was sort of disappointed to learn that the else clauses simply gets executed after the loop-body -...
92
by: Reed L. O'Brien | last post by:
I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption?...
125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
8
by: werner | last post by:
Hi! I don't want to use eval() in order to parse a user-supplied formula. What alternatives do I have? PHP has no standard functionality for tokenizing or parsing expressions in this regard. ...
1
by: hantuitm | last post by:
i need help to find errors in this program and improve its interface. #include <iostream> #include <string> int main() { string InputNumber; string words1,words2,words3,valCheck;
13
by: Protoman | last post by:
I'm getting an error: 10 C:\Dev-Cpp\Enigma.cpp no match for 'operator<' in 'i < (+cleartext)->std::basic_string<_CharT, _Traits, _Alloc>::end ()' Code: Enigma.hpp...
3
by: bb nicole | last post by:
I have did the company login and job post which means that company can post the job after they login in my webpage.. I had set company_ID(tablename:company) is foreign key of table job. But when i...
4
by: Protoman | last post by:
Can you please help me figure out what the error is here, in this rotor cipher simulator, which I wrote to amuse myself? The runtime error is that it isn't symmetrical --decrypting a piece of...
13
by: DAHMB | last post by:
I keep geeting an "Else without If " error in line 163 could some one please point out my error? Private Sub HoursPay_Exit(Cancel As Integer) Dim db As DAO.Database, rs As DAO.Recordset Dim...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.