MySQL/Perl Book Recommendation For A Beginner?
Here's the situation: I have a Perl-based forum that I wrote myself. It
currently supports user accounts, but these are stored in a flat text file
(as is everything else for that matter). I'm looking to convert this to a
MySQL database so that I can do more with that information, but with less
processing time (reading through that huge text file to find something isn't
very efficient).
In the future I hope to move the whole forum over to MySQL, but I thought a
good starter project would be just one aspect of it.
At this point I am looking for recommendations on good books for someone
moderately experienced with Perl, but who has NO experience with MySQL or
anything similar. Since I'd prefer to integrate this with my existing
script, I'd rather stick with Perl and not learn PHP at this time. So far it
seems like "MySQL and Perl for the Web" is a good - are there others? I
prefer reference-style texts with useful code examples, rather than
lesson-style books.
View Complete Forum Thread with Replies
Related Forum Messages:
Advanced SQL Book Recommendation
I know I've seen requests from time to time for more advanced sql information. I've recently picked up a book I would highly recommend to anyone looking for more than the basics. SQL Hacks (Tips & Tools for Digging into Your Data), it is an O'Reilly book by Andrew Cumming & Gordon Russell. It has 100 tips and covers necessary code tweaks for Oracle, Postgres, MySQL, SQL Server, Access and DB2.
View Replies !
Recommendation For A MySQL Ole DB Provider
I am developping with Visual Studio 2003 + C# + MySQL 4.1 and the OleDb components and am wondering which MySQL OLE DB provider to use. Right now I am using an Ole DB provider for MySQL which I found on www.MySQL.com, but it was written in Feb/2001 and I am wondering if it could be the source of my many problems. I mean, it's great that current Microsoft tools are backward compatible, but I am sure more performant OLE DB drivers have been written for MySQL since. Any OLE DB MySQL developer out there who can help make a recommendation?
View Replies !
Beginner To Mysql
I have worked with Oracle and i had a few questions regarding the syntax, in oracle we use the number(1) how is it when compared with mysql .I have seen that one can use int but could it be possible also to restrict the number of digits like int(1).I have tried this out n it does not seem to work.I would also like to know the the diff in varchar n varchar2() if it is the same as in oracle
View Replies !
Best MySQL Book
I'd like opinions on what is the very best, most thorough MySQL book available--the database equivalent of O'Reilly's "Running Linux". I'm looking for something with lots of reference, a few tutorials, something not as dense as the MySQL manual but not on the For-Dummies level either.
View Replies !
MySQL Book
I was wondering if anybody knows from where I can buy a MySQL book in .pdf, .html, etc. format. Please remember, I do not want a paper book, just a, lets call it virtual MySQL book. I just need some site names or online stores names.
View Replies !
Best MySQL Learning Book?
I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::
View Replies !
Hardware Recommendation
I am going to have to put MySQL on it's own box, and I am wondering what makes the biggest difference with hardware. I am hoping to set max_connections to 1000 at least (and I will probably use at least 500 several times a day). There are a few tables that are almost constantly running inserts, updates, and selects (they are InnoDB). These tables have millions of records. There are many other tables that are used less frequently. I mostly need the inserts, selects, and updates to be FAST with a high concurrency. Will I see the biggest difference by: 1) maxing out the ram 2) faster processors 3) faster drives 4) more drives 5) more processors Also, I am curious if RAID or replication would be faster in my situation.
View Replies !
Installer Recommendation
I am looking to package a java / swing / mysql application so that it can be installed primarily on Window based systems. I googled for "java mysql installer" and came up with a large number of products, gpl'd or commercial; its hard to know where to start. In addition, I am not a particular expert in mysql installation. Anyone have any suggestion as to installers, where to start etc?
View Replies !
Install Using Book :: Database Driven Website Using PHP And MySql
I've just purchased copy of "Database Driven Website Using PHP and MySql" and have a few problems getting started. I had tried to install apache via the manual install but could'nt make any sence of it. I them found a program called Xampp. I installed it becuase it included PHP, MySQL and would get apache working as well. Having read the first part of the book I did'nt think I needed to install any programs and tried to start on Ch 2. I can't open the msql.exe file or even find it??
View Replies !
MySQL, Perl CGI
I'm developing a simple computer helpdesk system with MySQL as the backend and Apache/CGI/Perl as the user interface. I've sucessfully set up the part where a user enters an issue via HTML form and "submits" it to the MySQL database. My question is: I have it set up where the user posts the issue to the database, the database auto_increments an issue_id number field. How do I return that issue_id number back to Apache so that the user can see it (and use it as a reference number)?
View Replies !
Perl-DBD-MySQL
I have a binary distribution of MySQL 4.0.20 installed in /usr/local/mysql. Therefore, the only libmysqlclient file I have is libmysqlclient.a (static library). And also, Perl:DBI already installed. I'm trying to install perl-DBD-MySQL-2.9004 from source. What should I add to 'perl Makefile.PL' as arguments to make sure it finds the static library? I've tried 'perl Makefile.PL --libs=/usr/local/mysql/lib/libmysqlclient.a and gotten this: --------------------------------- [root@localhost DBD-mysql-2.9004]# perl Makefile.PL --libs=/usr/local/mysql/lib/lib/mysqlclient.a I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include -mcpu=pentiumpro libs (Users choice) = /usr/local/mysql/lib/lib/mysqlclient.a nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Unrecognized argument in LIBS ignored: '/usr/local/mysql/lib/lib/mysqlclient.a' Using DBI 1.30 installed in /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI Writing Makefile for DBD::mysql [root@localhost DBD-mysql-2.9004]# --------------------------------- What should I do to get DBD-MySQL to install correctly?
View Replies !
Using Perl With Mysql
I have heard that if you want a view with mysql, perl is one iof the best applications to use. I want to make a user interface with perl that will prompt the user to enter values and then those values will be stored into the database. I'm just started to learn how to use perl, can anyone give me a little help with writing the code?
View Replies !
Perl DBD::mysql - Using Arrayref
I have an app where I would like to display a returned table with column headings as specified in the inquiry (select), while preserving the column sequence of columns as specified in the original inquiry - without having access to the original inquiry. If I use the fetchrow_hashref method, I can determine the column headings, but I lose the sequence. If I use fetchrow_arrayref, I preserve the sequence, but I lose the column headings. I suspect there is an easy answer. Anybody have it?
View Replies !
Dealing With Mysql Through Perl
i'm working with a mySql database. i have accessed the database through perl. now i want to know how i can store images in the databases through perl and how to retrieve it.. does anyone have an idea abt this?
View Replies !
Perl And Mysql Datetime
I am trying to have an update form for a datetime field. I've been looking all morning and haven't been able to find any examples of how to do it. I have the date in the form formatted by perl like this: 08-14-2006 11:29:28 and when I do the update to mysql nothing happens. It does not work. I need to make it so the user can put the time the student left.
View Replies !
Perl/mysql On Linux
i am not getting the output for the following code (given below) in apache server on linux. but i do get ouput in perl interpreter please replay me . vinaykumarms@rediffmail.com #!/usr/bin/perl print "ContentType: text/plain "; use DBI; # Connecting to the database # Replace DATABASENAME with the name of the database, # HOSTNAME with the hostname/ip address of the MySQL server. $drh = DBI->install_driver("mysql"); $dsn = "DBI:mysql:database=vinay;host=localhost"; $dbh = DBI->connect($dsn,"",""); # Select the data and display to the browser my $sth = $dbh->prepare("SELECT * FROM login"); $sth->execute(); while (my $ref = $sth->fetchrow_hashref()) { print "Found a row: id = $ref->{'id'}, name = $ref->{'name'} "; } $sth->finish(); # Disconnect from the database. $dbh->disconnect();
View Replies !
Replication For A Complete Beginner!
I've set up a mysql server on a Windows XP machine. I need to set up a completely different server on the same machine so that I can work on getting replication.. ie. as I write to one DB, another on the other server gets updated too. Ive read the MYSQL manual but its geared towards UNIX and I just dont understand it to be honest! I know that I need to change a port number to get the 2nd server running completely separately, but other than that, Im not sure. Can anyone put it into plain English?
View Replies !
Beginner Development Process
Whats the best way to develop mySql database to live server? I've work for many years with Access file based database and development was pretty straight forward: 1. design, develop, and test database on local server. 2. after fully tested, ftp up to live server. When comes to mySql management system, I'm not sure how to proceed. I've downloaded and learned how to use the control center and admin interfaces. I've even taken tutorials working at the command line. While this is all good its still all local how the heck do i get it up to a live server. I've read you can use admin tool to dump the data out, but once you've done that what do you do with it? And once you have it up to the server how do you get it back to your machine to back it up or work on it?
View Replies !
Verifying Mysql Writes (perl)
What is a proper way of verifying that a mysql write was successfull, and to retry if it wasnt? In my perl script I add records through: my $dbh=DBI->connect($dsn, $db_user_name, $db_password); my $sth=$dbh->prepare("insert into TABLE (X, Y, Z) values ('1', '2', '3')"); $sth->execute; $sth->finish; I have noticed that from time to time this fails, due to limitations of my webhost. I thus want to do a check after the write, that it actually happened, and if not redo.
View Replies !
Unable To Connect To Mysql Via Perl
I am attempting to connect to my mysql using a perl script, and keep getting an error message that tells me the I am missing a sub routine. I have installed DBI and DBD::mysql but still can not use my $dbh = open_dbi($db,$username,$password) I am assuming that open_dbi is not installed, does anyone know of another, or better way to access mysql via perl.
View Replies !
Installing MySQL 5 Perl DBI Must Be Installed?
the steps to installing MySQL 5 on Red Hat Linux 9? When I follow the steps as outlined in the manual or Red Hat text I get an error that Perl DBI must be installed. After attempting to download the Perl DBI; that failed because the server was not availabe. Eventually I was able to download some Perl stuff, but not the DBI. Here is the problem at its root. Where is the information to handle all of the error messages? Where is the source of knowledge to work around these problems?
View Replies !
Retreiving MySql Data With Perl (DBI)
I have been trying to retrive data out of MySql data file using DBI and Perl for a while with no luck. I get message "Can't locate loadable object for module DBI in @INC (@INC contains: C:/Program Files/Perl/lib C:/Program Files/Perl/site/lib .) at C:/Program Files/Perl/lib/DBI.pm line 258" I have DBI.pm in above respected directories. I have no problem retreiving data out of flat files ie simple text file with delimiters. I use windows xp,Perl,Apache server and MySql server at home with no other problems.
View Replies !
Beginner: How Do I Upload A .sql File To My Database?
I searched about the forum for this, but it only came up with issues of people have problems with uploading a database through phpMyAdmin that was too large. I don't have this problem (I don't think, the file is 7,000 KB), my problem is, I am completely lost in this area. The instruction for the files I have read as: 'Upload the database database.sql to the mysql database.' I presume I use phpMyAdmin for this? So I log into it, I have my fresh database created, I have all my details, dbname dbpass etc at hand... ha... now what? Do I have to upload the .sql file to my webspace through my FTP? Do I need a command line to type into the phpMyAdmin thing? Something else? Anything I have ever used previously, such a forums auto-created the databases for me or did whatever it needed to!
View Replies !
Database Beginner Question - Many To Many Relationships
I'm fairly new to databases and i was wondering how to store many-to-many relationships with php and mysql (but i think this is a general database question). For example: in a cms for a blog i have a blog table which stores all blog info including id. However, i want my blog posts to be able to belong to more than one category. so, i have another table which stores each category with id and another which should store blog id and category id for each category for each blog. However, when the php script makes a database entry, it doesn't know what the id for the blog will be because it is automatically generated with AUTO_INCREMENT. I'm guessing that the only way would be to specify the id, but then how to know what id to specify? I like the simplicity of using AUTO_INCREMENT but i need to be able to specify multiple categories.
View Replies !
Calling MySql Select Procedures In Perl
I am trying to call a "select" stored procedure from perl. I am not quite sure how to do it. Here is the stored procedure: CREATE PROCEDURE spTest() begin select x AS X from tblTest; It works fine when called from within MySQL. mysql> call spTest(): +------+ | X | +------+ | 24 | | 3 | +------+ I have the following code in perl: my $spt = $db->prepare("Call spTest()"); $spt->execute(); $spt->bind_columns($id); while($spt->fetchrow_array()){ print "X = $id"; } I get an error that says I need to use "select into". How do I call this procedure from perl?
View Replies !
Book Suggestions
I have a couple questions about books. First, let me explain my situation. I have a CS degree, with some basic courses in DB design. I have been a programmer for many years, the last few years in maintaining legacy Clipper applications and CF web programming. We are moving forward, and have chosen mySql as our DB platform. I will most likely become our DBA. What books would you recommend, and in what order? I understand basic SQL, but haven't done anything with triggers, stored procedures, T-SQL, anything like that. Probably the "recipe site" level of design and querying. I think I used an INNER JOIN once
View Replies !
With Php :: Tutorial Or Book?
I have been reading and learning about php for a couple of weeks now and have just gotten to the part where it talkes aboue MySQL. I know very little about MYSQL. I was wondering would you recommend continuing on with where I am in the php book or stop there and read a book about MySQL?
View Replies !
Admin Focused Book
I am looking for a good MySQL book with in-depth coverage of Administration topics. Something written for a DBA, not a programmer. I am trying to expand my skill-set and cannot for the life of me find any books that go into detail enough on Admin Tasks. I was in a few local book stores this weekend and could only find books geared towards the programmer or first time SQL user. That part I know already.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Access Denied For User 'root'@'localhost' (was "help!!! Just A Beginner..")
Hello i recently installed WAMP5 to handle my phpmysqlapache localhost sever. but when i go to the control panel and clicked the localhost and phpmyadmin everything seems fine because i can see the phpinfo window and also the phpmyadmin.. but not when i clicked the SQLite Manager.Unable to connect to database manager. Could not connect: Access denied for user 'root'@'localhost' (using password: YES).
View Replies !
Perl DBI / SQL
I need to know how to retrieve through Perl DBI a listing of possible ENUM elements from a field for processing under a CGI script. If all I need for this is some form of SELECT statement, please provide a code snippet of this so I can do it. I want to make my code so I'm not having to edit hard-coded Perl CGI scripts if/when I add new elements to the ENUM field.
View Replies !
PHP Or Perl?
As part of my own learning mysql project I'm planning to build databases for all my books and DVD's. Stephen Hawking is probably a better typist than I am so I plan to use barcodes to get the info ,taking the information from various web sites. People tell me that PHP is THE way to do database work with mysql. The thing is, I'm familiar with Perl and it has all kinds of neat string manipulation stuff and LWP. Does PHP have comprable libraries (especially LWP) and how difficult is it to move from Perl.
View Replies !
Fw: PHP Or Perl?
Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you?I'm actually a Delphi, Java, VB, Perl & Ruby developer (done alittle Rebol before) but found it strange that your using TCP/IP to communicate with mySQL
View Replies !
Select Via Perl
I am trying to read a file and see if the contents of it exists in the DB or not and am trying to do it via a Select.I try to do a select * into outfile /tmp/result.txt from table where field like "%$var%"; but it always goes through the first two lines of the input file and then says the file already exists. Is this because I read each line of a file in a for loop in perl and the mysql query tries to recreate the outfile each time? Is there any other way I can dump the results of the select to a file of some sort?
View Replies !
PHP Or Perl? (or Rebol Via TCP/IP)
Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you? I'm actually a Delphi, Java, VB, Perl & Ruby developer (done alittle Rebol before) but found it strange that your using TCP/IP to communicate with mySQL.
View Replies !
Error In Perl
I receive the following error when I try to acces MySQL 4.1 Client does not support authentication protocol requested by server; consider upgrading MySQL client I conntect with Perl in this way : $dbh = DBI->connect("DBI:mysql:dbname:localhost","dbuser","dbpass") or print"I can't connect" .DBI->errstr;;
View Replies !
Uninstall Perl (DBI)
i try to install Mysql Server V5 on a Redhat 5 Enterprise. But the RPM needs Perl (DBI) so I install it following the install guide provide on this site. But it' seems to not be detected by the rpm package when installed.
View Replies !
Perl Dbi And Bitfields
In the past I encoded some bit fields into hex and stored them in a short string. I now want to be able to use sql to select records according to settings of various 'flags'. So I have changed the field to a bit field and have succeded in populating it. I can display the vaules using bin(flags+0) as a string of 1 & 0s but when I try to get the value back into a perl variable from a select * it always comes back as 0?
View Replies !
|
TRACKER
