dbi
Perl: Reading from a database table line by line
Is there someway to read from 开发者_如何学Pythona database table line by line using the DBI module? The table is huge and I keep running out of memory if I try to do a select. I\'m working with an or[详细]
2023-04-13 06:02 分类:问答AnyEvent::DBI and database reconnection
I\'m using AnyEvent::DBI in a singleton package, and when there is no activity in the database / queries etc after many hours, I get this error while trying to issue a query:[详细]
2023-04-11 04:56 分类:问答Can DBI statement handles use cached calls to execute()?
I have an application where the database rarely changes, and the application requires many reads from the database that is slowing down the performance quite significantly. Many of these reads are exa[详细]
2023-04-09 20:24 分类:问答Ruby OCI8 DBI, how to check query generated after parameter binding? need to check for "in" queries
While using Ruby-DBI I am facing issues with parameter binding for where \"in\" queries. Two questions:[详细]
2023-04-09 04:05 分类:问答DBD::Informix connection issues
I\'m having somewhat weird problem with DBD::Informix. If I run a simple script like that: use DBI; my $dbh = DBI->connect_cached(\'dbi:Informix:database\', \'\', \'\');[详细]
2023-04-05 07:58 分类:问答How to install DBD::Advantage
I have tried using DBD::Advantage on both Linux and Windows with no luck.The Windows version comes with what appears to be a full fledged installer, but it leaves behind the DBD-Advantage-8.10.tar.gz.[详细]
2023-04-04 13:26 分类:问答SQLite: selectall_arrayref speed question
Is there a difference in speed between these two modi? selectall_arrayref( \"SELECT * FROM $table\", { Slice => {开发者_JAVA技巧 a => 1, b => 1 } } );[详细]
2023-04-03 21:36 分类:问答open .dbi files with PHP
i want to open a .dbi file with PHP. i cant find anything about this on google. maybe some guys of you can help me?[详细]
2023-04-02 00:09 分类:问答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[详细]
2023-03-30 12:52 分类:问答Integer comparision using DBD::SQLite
I\'m facing a problem with DBIx::Class against an SQLite3 database. If you don\'t want to read the following in full, here\'s the TL;DR version:[详细]
2023-03-29 07:33 分类:问答