The perl tag has no wiki summary.
0
votes
0answers
30 views
Mysql query browser can't connect, Toad, Perl, workbench and command line can?
Mysql query browser used to work fine then suddenly stopped working:
cannot connect to database server. Your connection attempt failed for user 'brianp' from your host to server at viper:3306: Could ...
0
votes
1answer
16 views
Cannot create perlplu function
Running PostgreSQL 9.1.8 on Xubuntu 12.04, installed from the repos.
From the shell, I have executed:
createlang plperl db_name;
createlang plperlu db_name;
As the superuser running psql, I have ...
0
votes
3answers
127 views
How to avoid deadlock while updating 2 rows in MySQL
This is a interview problem:
There is a perl program that updates the database, and it could run in different processes.
One process may execute a transaction like:
update row A -> update ...
1
vote
1answer
90 views
Sybase Databse Migration from 11.5 to 15
I have to migrate the Sybase Database from 11.5 version to 15.
I would like to know few things mentioned below -
i) What are the neccessary steps i need to follow in this migration.
ii) What are the ...
1
vote
4answers
371 views
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
What could be the best approach ?
Till now could figure out the following (Oracle)
Calling exp.exe and imp.exe utilities in Oracle client using Java and inturn call it from Perl.
Calling exp.exe ...
2
votes
2answers
682 views
Limit WHERE to MAX() & COUNT()
This is my current mySQL query:
SELECT e.*, MAX(m.datetime) AS unread_last, COUNT(m.id) AS unread
FROM TAB_EVENT e
LEFT JOIN TAB_MESSAGE m ON e.id=m.event_id
WHERE ( m.`read` IS NULL OR ...
1
vote
1answer
88 views
Sybase internal tables for ORM generation
I am working on a Perl application that uses DBIx::Class::Schema::Loader in order to generate the ORM layer of the application, against a Sybase ASE 15.5 database.
We recently migrated from Sybase ...
3
votes
1answer
361 views
PostgreSQL pl/perl trigger, differentiate null vs empty
I've been trying to speed up a generic auditing trigger that I had written in pl/pgsql some time back. On update, it generates a list of columns in the table being updated and inserts rows in the ...
5
votes
1answer
290 views
How can I create and initialize a schema for a embedded MySQL DB?
I want to create an embedded MySQL database for running tests, but I'm not sure how to do it.
How do I initialize the database?
How do I run my create table statements?
I'm using Perl, so it ...
