Re^2: Efficient way to handle huge number of records?

Yes true it's bioinformatics, but I don't need any modules, I have my data in the text file...
I wanted to start using Mysql with Perl but I can't seem to be able to install the Mysql module. I tried CPAN but the command:

 perl -MCPAN -e 'install Mysql'
[download]

returns:

cpan[9]> install Mysql
Running install for module 'Mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
Checksum for /home/leo/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysq
+l-3.0008.tar.gz ok
DBD-mysql-3.0008/
DBD-mysql-3.0008/ChangeLog
DBD-mysql-3.0008/constants.h
DBD-mysql-3.0008/dbdimp.c
DBD-mysql-3.0008/dbdimp.h
DBD-mysql-3.0008/eg/
DBD-mysql-3.0008/eg/prepare_memory_usage.pl
DBD-mysql-3.0008/eg/proc_example1.pl
DBD-mysql-3.0008/eg/proc_example2.pl
DBD-mysql-3.0008/eg/proc_example3.pl
DBD-mysql-3.0008/INSTALL.html
DBD-mysql-3.0008/lib/
DBD-mysql-3.0008/lib/Bundle/
DBD-mysql-3.0008/lib/Bundle/DBD/
DBD-mysql-3.0008/lib/Bundle/DBD/mysql.pm
DBD-mysql-3.0008/lib/DBD/
DBD-mysql-3.0008/lib/DBD/mysql/
DBD-mysql-3.0008/lib/DBD/mysql/GetInfo.pm
DBD-mysql-3.0008/lib/DBD/mysql/INSTALL.pod
DBD-mysql-3.0008/lib/DBD/mysql.pm
DBD-mysql-3.0008/lib/Mysql/
DBD-mysql-3.0008/lib/Mysql/Statement.pm
DBD-mysql-3.0008/lib/Mysql.pm
DBD-mysql-3.0008/Makefile.PL
DBD-mysql-3.0008/Makefile.PL.embedded
DBD-mysql-3.0008/MANIFEST
DBD-mysql-3.0008/MANIFEST.SKIP
DBD-mysql-3.0008/META.yml
DBD-mysql-3.0008/myld
DBD-mysql-3.0008/mysql.xs
DBD-mysql-3.0008/README
DBD-mysql-3.0008/t/
DBD-mysql-3.0008/t/00base.t
DBD-mysql-3.0008/t/10dsnlist.t
DBD-mysql-3.0008/t/20createdrop.t
DBD-mysql-3.0008/t/30insertfetch.t
DBD-mysql-3.0008/t/35limit.t
DBD-mysql-3.0008/t/35prepare.t
DBD-mysql-3.0008/t/40bindparam.t
DBD-mysql-3.0008/t/40bindparam2.t
DBD-mysql-3.0008/t/40blobs.t
DBD-mysql-3.0008/t/40listfields.t
DBD-mysql-3.0008/t/40nulls.t
DBD-mysql-3.0008/t/40numrows.t
DBD-mysql-3.0008/t/41bindparam.t
DBD-mysql-3.0008/t/41blobs_prepare.t
DBD-mysql-3.0008/t/42bindparam.t
DBD-mysql-3.0008/t/50chopblanks.t
DBD-mysql-3.0008/t/50commit.t
DBD-mysql-3.0008/t/60leaks.t
DBD-mysql-3.0008/t/dbdadmin.t
DBD-mysql-3.0008/t/insertid.t
DBD-mysql-3.0008/t/lib.pl
DBD-mysql-3.0008/t/mysql.dbtest
DBD-mysql-3.0008/t/param_values.t
DBD-mysql-3.0008/t/._prepare_noerror.t
DBD-mysql-3.0008/t/prepare_noerror.t
DBD-mysql-3.0008/t/texecute.t
DBD-mysql-3.0008/TODO

  CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz

Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem 
to contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Failed to determine directory of mysql.h. Use

  perl Makefile.PL --cflags=-I<dir>

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

  perl Makefile.PL --help
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=s
+ite]
  CAPTTOFU/DBD-mysql-3.0008.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 CAPTTOFU/DBD-mysql-3.0008.tar.gz             : writemakefile NO '/usr
+/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512
[download]

Comment on Re^2: Efficient way to handle huge number of records? Select or Download Code

Replies are listed 'Best First'.
Re^3: Efficient way to handle huge number of records? by Marshall (Canon) on Dec 11, 2011 at 10:43 UTC
OK. I recommend that you not mess with MySQL. There is more pain past just getting the DBI module. You will have to get a MySQL daemon started and there is admin hassle. I recommend that you start with SQLite. There is no daemon. There is no admin. It does 90% of what MySQL does for a single user and with a lot less hassle. I use the SQLMangager plug-in for firefox instead of the command line I/F which I have never bothered to install on my machine. You will need to install the DBD::SQlite module and that's about it. Try installing DBD::SQLite and see how it goes. Update: I do have a MySQL server running right now on my Windows machine. I know how to do it and that is why I am advising you not to do it! Too much hassle!	[reply]

Replies are listed 'Best First'.

Re^3: Efficient way to handle huge number of records?
by Marshall (Canon) on Dec 11, 2011 at 10:43 UTC

I recommend that you start with SQLite. There is no daemon. There is no admin. It does 90% of what MySQL does for a single user and with a lot less hassle.

I use the SQLMangager plug-in for firefox instead of the command line I/F which I have never bothered to install on my machine. You will need to install the DBD::SQlite module and that's about it.

Try installing DBD::SQLite and see how it goes.

Update:
I do have a MySQL server running right now on my Windows machine.
I know how to do it and that is why I am advising you not to do it!
Too much hassle!

[reply]