It’s difficult for the begginners to install Linux. The project Instalinux can help to chose needed parts of famous Linux distributions, create custom install image and download it. Currently you can try to create yourown disribution for Fedora, SUSE, Debian and Ubuntu. Good luck!
To insert many records in one time it’s better to use extended INSERT:
INSERT INTO table_name (field1, field2, ..., fieldN) VALUES(value11, value12, ..., value1N), (value21, value22, ..., value2N), ... , (valueN1, valueN2, ..., valueNN);
There is an one default restiction in MYSQL. It doesn’t allow execute query with more than 1 MB.
The speed of this kind of insert is amazing! For example, extended insert of 30000 records took 5.252 sec. Inserting record by record as usual took 29.681 sec. That’s why if you need to insert a huge set of records the extended INSERT is the best choice!
Note: it maybe useful if you need to copy existing table srtucture somewhere.
To do that just type:
For example, let’s run this command for table ‘test’:
and there is our result:
mysql> show create table test1; +-------+-------------------------------------+ | Table| Create Table | +-------+-------------------------------------+ | test1 | CREATE TABLE `test1` ( `f1` varchar(20) default NULL ) TYPE=MyISAM | +-------+-------------------------------------+ 1 row in set (0.00 sec)
Simon Cozens is an author more than 90 CPAN modules and second edition of Advanced Perl Programming published an article on Perl.com where he gave some significant additions since first edition.
The most interesting for me in this article was a mention about module Class::Accessor. I use Class::DBI for a long time. It lightens the routine work when you need to develop some classes which represent database tables orr saying in OO terms to produce persistent objects. As I understand Class::Accessor does the same but for non persistent object too.
Here is an example. Usually, to develop a simple class we should implement method new() and some accessors:
package MyClass;
sub new { bless { %{@_} }, shift; }
sub name {
my $self = shift;
$self->{name} = shift if @_;
$self->{name}
}
sub address {
my $self = shift;
$self->{address} = shift if @_;
$self->{address}
}
But using of Class::Accessor saves a lot of your time:
package MyClass; use base qw(Class::Accessor); __PACKAGE__->mk_accessors(qw( name address ));
Cool, isn’t it? Additionaly there is a possibility to specify read-only accessors or separate them on read and wtite. Defenatelly, I’ll use this module to develop new modules and improve existing.
I found some screenshots of KDE 4 which is planning to be released this year. What can I say? It’s amazing, it’s really cool! I’m waiting for KDE 4. I like it and use it every day. It grows reliase by reliase and it’s much better than three years ago when I switched to Linux.
Very clear and useful article about configure and use .htaccess. Somethimes it’s easier to put your setting in the place where you have permissions to write. Also, after add or change existing settings in the .htaccess you don’t have to restart Apache. Read it and tune your web host!
Memotoo.com is an online system to keep contacts, calendar, phone book, email addresses and bookmarks and synchronize them between desktop computer, mobile phone, laptop etc. It was developed by French guys I think. But it includes English interface as well.
I just created an account and didn’t dive into functionality. But idea to put information from different places in one is great.
de.lirio.us is social bookmarking system which allows to store and organize your bookmarks and describe them by key words aka tags. I use the similar system – del.icio.us for an year and I like it. de.lirio.us seems less handy than del.icio.us. But maybe I just got used to it 
Anyway, you can find useful de.lirio.us plugin for Firefox. It allows to add new page as bookmark without loading of site (similar plugins exist for del.icio.us also: del.icio.us, del.icio.us post, Foxylicious and so on).
