Table T1, Table T2
INNER JOIN returns only matching rows from T1, T2
LEFT OUTER JOIN returns (all T1 rows) X (matching T1 rows in T2)
RIGHT OUTER JOIN returns (all T2 rows) X (matching T2 rows in T1)
UNION returns only unique rows from T1, and T2.
UNION ALL returns T1+T2 rows
Simple 5 step guide to setting up https with your own self-signed certificate
Prerequisites: Apache2, Ubuntu Server
/usr/bin/openssl genrsa -des3 -out {your domain name}.key 3072
/usr/bin/openssl req -new -key {your domain name}.key -x509 -out {your domain name}.crt
<VirtualHost {your ip}:443>
...
SSLEngine on
SSLCertificateFile {path where certificate is}/{your domain name}.crt
SSLCertificateKeyFile {path where key file is}/{your domain name}.key
SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown
...
</VirtualHost>
/usr/bin/openssl rsa -in {path where key file is}/{your domain name}.key -out {path where key file is}/{your domain name}.key.nopass# SSLCertificateKeyFile {path where key fileis}/{your domain name}.key
SSLCertificateKeyFile {path where key file is}/{your domain name}.key.nopassIf you receive a certificate warning, simply accept it, and proceed. Congratulations, your communication is now encrypted, and safe from prying eyes!
Very often we are impressed with awe when we see a beautiful picture, photo, advert. The colors, their combination presents an alluring view just right for our eyes. If you notice more closer, you can seeing that more often the colors are complemented (red with white, green with blue…) to give a undistracted overall look. This is essentially because our eyes find this visually pleasant.
I have a tool which can offer such combinations, and you should design your color combinations using the suggested patterns
http://9i9.me/colors/index.html/ – For visually stunning color combinations
Keep working!
More recently, all Secretmyth BDRips I download started to have a audio out of sync with video issue. Real sad, because the movie quality is too good when watching on a 24 inch screen. I use K-Lite, but it seems SecretMyth recommends either KMPlayer or VLC.
The problem solved using VLC.
I stumbled upon this url. The list of various options on databases is pretty amazing.
http://www.webresourcesdepot.com/25-alternative-open-source-databases-engines/
It’s a definite read. I never knew so many existed.
Much recently to my dismay, I figured out that I cannot remove Symantec’s Endpoint Protection from my own laptop without administrator password. I do not own this password, and I do not want anybody other than me permitting me what to uninstall. Hence I went ahead for manual uninstall according to these instructions (from Symantec’s own site) below-
The instructions are crisp and clear. I could manually uninstall following each step of those instructions, but there is one big trouble. The instructions talk to removing over 100’s of registry keys, values which I believe is sheer impossible manually. Why didn’t Symantec simply provide a small tool which has all those instructions bundled in a simple click-n-go fashion?
I have tried to create a small registry file which can automate the removal of registry entries Uninstall Registry entries for Symantec Endpoint Protection
For all other manual deletion of files, it would be great to write a small AutoIt script compiled to an exe. Maybe sometime later…
Crazy stuff people do these days.
1)On solr.master: +Edit scripts.conf: solr_hostname=localhost solr_port=8983 rsyncd_port=18983 +Enable and start rsync: rsyncd-enable; rsyncd-start +Run snapshooter: snapshooter After running this, you should be able to see a new folder named snapshot.* in data/index folder. You can can solrconfig.xml to trigger snapshooter after a commit or optimise. 2) On slave: +Edit scripts.conf: solr_hostname=solr.master solr_port=8986 rsyncd_port=18986 data_dir= webapp_name=solr master_host=localhost master_data_dir=$MASTER_SOLR_HOME/data/ master_status_dir=$MASTER_SOLR_HOME/logs/clients/ +Run snappuller: snappuller -P 18983 +Run snapinstaller: snapinstaller You should setup crontab to run snappuller and snapinstaller periodically.
