05-18-2008
Additional book recommendations
To my surprise, I found many of my personal favorites to be missing from the
book recommendations thread.
Although dated, Kernighan & Pike's
The Unix Programming Environment is a classical introduction, covering the shell, the scripting languages, make, troff, and some fundamental C programming concepts, in a distinctive "Bell Labs" style, by two pivotal figures in the history of Unix.
Jeffrey Friedl's
Mastering Regular Expressions is a must for anybody who uses scripting languages. It is suitable even for beginners, although you have to be serious about regular expressions to read it cover to cover.
Eric Raymond's
The Art of Unix Programming attempts to teach not only programming, but the philosophy and mind-set of the Unix masters. Although if it is mainly about "real" programming languages, it is worth a read even if you are only into scripting languages.
Kernighan and Pike's
The Practice of Programming has examples in both systems priogramming languages (C and Java) and in scripting languages (Perl, TCL, awk, etc). Like the previous one, this book is more about mindset and philosophy than about any particular programming language. Another classic from the duo who wrote
The Unix Programming Environment.
(The cover art is not particularly convincing, as such.)
Last edited by era; 05-20-2008 at 04:18 AM..
Reason: Minor inaccuracy in tpop description
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm on my way, I've seen the light and it's not a train at the other end of the tunnel :)
What tutorial or manual or reference point(s) would you recommend for an experienced DOS and CP/M type, who wants to learn the command equivalents within Unix?
I have a good understanding of program... (2 Replies)
Discussion started by: Keith
2 Replies
2. Shell Programming and Scripting
Hi all,
I'm trying to teach myself shell programming and scripting. What are good introduction level programming and/or scripting books that you recommend?
I will gather your suggestions into a list and check out the IT-related sections of the nearest Barnes & Noble stores. Or if you could... (1 Reply)
Discussion started by: antalexi
1 Replies
3. Solaris
Core dumps on larger systems have become quite large.
Sun, is beginning to ship 146Gig drives. What is the recommended partition size for swap?
I can not get a good answer to this question. The double your RAM recommendation is quite old and outdated.
thanks (1 Reply)
Discussion started by: bgboost
1 Replies
4. UNIX for Dummies Questions & Answers
Hello , im not sure if its the right forum... im sorry if not
im working with putty allot , but now I started to work with more graphical applications and
im looking for free simple and fast Xserver to remote connection, can someone recommend me
if there is something like that ? (3 Replies)
Discussion started by: umen
3 Replies
5. UNIX for Advanced & Expert Users
Hello Guru's,
I created this shell script to copy over the files from one location to other location and generating a list of files to process them through ETL tool. Could you please review the code and tell me if you have any recommendations or changes for my code or any thing wrong in my code.... (1 Reply)
Discussion started by: Ariean
1 Replies
6. UNIX for Dummies Questions & Answers
I'm currently running 32-bit Xubuntu 8.10 and I'm thinking of changing over to 64-bit Ubuntu 9.04. Any recommendations on how to make this go more smoothly?
-----Post Update-----
Can I shuffle around the partitions and install it as a second OS? Is there a good way to do that? (2 Replies)
Discussion started by: CRGreathouse
2 Replies
7. UNIX for Dummies Questions & Answers
i have a little background in C (2 sems in university), and have been studying the bash articles on tldp.org i just wanted to know what you guys recommend i look up next. i'm interested in the server administration side of linux, and in kernel and peripheral interface. so i'm not sure whether to... (3 Replies)
Discussion started by: momo.reina
3 Replies
8. UNIX for Dummies Questions & Answers
Can someone please recommend a book or a website that has info on how to design a secure fault tolerant network (routers, firewall, domain servers, etc) of 300 wireless computers separated in multiple buildings and floor with multiple users for each station mainly utilizing dtp and internet... (1 Reply)
Discussion started by: rukasu
1 Replies
LEARN ABOUT DEBIAN
data::phrasebook::sql
Data::Phrasebook::SQL(3pm) User Contributed Perl Documentation Data::Phrasebook::SQL(3pm)
NAME
Data::Phrasebook::SQL - The SQL/DBI Phrasebook Model.
SYNOPSIS
use Data::Phrasebook;
use DBI;
my $dbh = DBI->connect(...);
my $book = Data::Phrasebook->new(
class => 'SQL',
dbh => $dbh,
file => 'queries.txt',
);
my $q = $book->query( 'find_author', {
author => "Lance Parkin"
});
while ( my $row = $q->fetchrow_hashref ) {
print "He wrote $row->{title}
";
}
$q->finish;
queries.txt:
find_author=select title,author from books where author = :author
DESCRIPTION
In order to make use of features like placeholders in DBI in conjunction with phrasebooks, it's helpful to have a phrasebook be somewhat
more aware of how DBI operates. Thus, you get "Data::Phrasebook::SQL".
"Data::Phrasebook::SQL" has knowledge of how DBI works and creates and executes your queries appropriately.
CONSTRUCTOR
new
Not to be accessed directly, but via the parent Data::Phrasebook, by specifying the class as SQL.
Additional arguments to those described in Data::Phrasebook::Generic are:
o "dbh" - a DBI database handle.
METHODS
dbh
Set, or get, the current DBI handle.
query
Constructs a Data::Phrasebook::SQL::Query object from a template. Takes at least one argument, this being the identifier for the query. The
identifier is used as a key into the phrasebook "file". A second argument can be provided, which is an optional hashref of key to value
mappings.
If phrasebook has a YAML source looking much like the following:
---
find_author:
sql: select class,title,author from books where author = :author
You could write:
my $q = $book->query( 'find_author' );
OR
my $q = $book->query( 'find_author', {
author => 'Lance Parkin'
} );
OR
my $author = 'Lance Parkin';
my $q = $book->query( 'find_author', {
author => $author,
} );
# sql = select class,title,author from books where author = ?
# args = 'Lance Parkin'
In the above examples, the parameters are bound to the SQL using the bind parameters functionality. This is more efficient in most cases
where the same SQL is reused with different values for fields.
However, not all SQL statements just need to bind parameters, some may require the ability to replace parameters, such as a field list.
---
find_author:
sql: select :fields from books where author = :author
my $q = $book->query( 'find_author',
replace => { fields => 'class,title,author' },
bind => { author => 'Lance Parkin' }
);
# sql = select class,title,author from books where author = ?
# args = 'Lance Parkin'
In all instances, if the SQL template requested does not exist or has no definition, then an error will be thrown.
Consult Data::Phrasebook::SQL::Query for what you can then do with your returned object.
For reference: the bind hashref argument, if it is given, is given to the query object's "order_args" and then "args" methods.
SEE ALSO
Data::Phrasebook, Data::Phrasebook::Generic, Data::Phrasebook::SQL::Query.
SUPPORT
Please see the README file.
AUTHOR
Original author: Iain Campbell Truskett (16.07.1979 - 29.12.2003)
Maintainer: Barbie <barbie@cpan.org> since January 2004.
for Miss Barbell Productions <http://www.missbarbell.co.uk>.
COPYRIGHT AND LICENSE
Copyright (C) 2003 Iain Truskett.
Copyright (C) 2004-2010 Barbie for Miss Barbell Productions.
This module is free software; you can redistribute it and/or
modify it under the Artistic Licence v2.
perl v5.10.1 2010-08-31 Data::Phrasebook::SQL(3pm)