TextMate shortcuts

SQL Tree

trees in PostgreSQL
http://www.depesz.com/index.php/2008/04/11/my-take-on-trees-in-sql/

trees in SQL
http://www.sqlteam.com/article/more-trees-hierarchies-in-sql
http://c2.com/cgi/wiki?TreeInSql

trees in Oracle:
http://philip.greenspun.com/sql/trees.html
http://www.sql.ru/forum/actualthread.aspx?bid=3&tid=395223&hl=leaf_rn#3770943
http://www.sql.ru/forum/actualthread.aspx?tid=483176&pg=2

http://habrahabr.ru/blogs/development/111754/ - database-design online:
http://dbdsgnr.appspot.com/
http://code.google.com/p/wwwsqldesigner/
http://ondras.zarovi.cz/sql/demo/

TextMate

http://domhay.com/2009/apr/10-cool-textmate-tips
http://www.mactips.org/archives/category/textmate-tips/
http://higher.com.ua/news/131/textmate-i-windows-1251

Bundles:
ftp/ssh:
http://fuerstnet.de/ftp-ssh-bundle-textmate
http://lists.macromates.com/textmate/2006-February/008636.html - ftp hack
encoding:
http://higher.com.ua/news/131/textmate-i-windows-1251
Examples:
http://manual.macromates.com/en/bundles#bundles
http://sage.ucsc.edu/xtal/textmate_iterm.html
http://wiki.macromates.com/textmate/show/Howtos.html

E Texteditor - Textmate under Windows and Linux:
http://github.com/etexteditor/e/
http://www.e-texteditor.com/
http://www.nerdpad.com/how-to/building-and-running-etexteditor-on-ubuntu-64-bit
http://code.google.com/p/textmate-huacnlee/downloads/list
http://milandobrota.tumblr.com/post/289551133/e-text-editor-for-ubuntu

ffmpeg

http://ubuntuforums.org/showthread.php?t=786095 - Ubuntu HOWTO: Install and use the latest FFmpeg and x264
http://rob.opendot.cl/index.php/useful-stuff/psp-video-guide/
http://juliensimon.blogspot.com/2009/01/howto-ffmpeg-x264-presets.html
http://www.haykranen.nl/2007/11/21/howto-install-and-use-ffmpeg-on-mac-os-x-leopard/
http://stephenjungels.com/jungels.net/articles/ffmpeg-howto.html
http://goinggnu.wordpress.com/2007/02/13/convert-avi-to-3gp-using-ffmpeg/
http://codesnippets.joyent.com/posts/show/2021
http://oddmanout.wordpress.com/2008/01/26/converting-an-mkv-h264-file-to-ps3-mp4-without-re-encoding-on-mac-os-x/
http://ffmpegx.com/download.html

Android convert:
ffmpeg -i input.avi -f mp4 -vcodec mpeg4 -s qvga -r 25 -b 900k -acodec aac -ac 2 -ar 24000 -ab 128k -strict experimental output.mp4

DNS

http://private.dnsstuff.com/tools/customlookup.ch?formaction=DNSLOOKUP&name=cname.domain.name&r=235660&detail=0&type=CNAME

FirstVDS:
http://forum.firstvds.ru/viewtopic.php?t=3502
ttp://forum.firstvds.ru/viewtopic.php?t=4895&highlight=dns+google

Blogspot:
http://homelessinbelarus.com/category/domains

whois reports:
http://every-ip.net/nsreport.php
www.who.is

Кол-во доменов и ip у провайдера:
http://1stat.ru/?ns=firstvds.ru&date1=01-03-2010&date2=01-04-2010&page=&sortby=&p=1
http://www.db.ripe.net/whois?form_type=simple&full_query_string=&searchtext=ISPSYSTEM&submit.x=16&submit.y=6

Xen

Xen on Ubuntu 10.04:
http://www.opennet.ru/tips/info/2342.shtml
http://bderzhavets.wordpress.com/2010/04/24/set-up-ubuntu-10-04-server-pv-domu-at-xen-4-0-dom0-pvops-2-6-32-10-kernel-dom0-on-top-of-ubuntu-10-04-server/

Xen on debian:
http://xgu.ru/xen/manual/
http://www.debian-administration.org/articles/533
http://wiki.debian.org/DebianRussian/Xen
http://wiki.debian.org/Xen
http://www.xen-support.com/?p=16
http://habrahabr.ru/blogs/linux/37824/
http://www.howtoforge.com/virtualization-with-xen-on-debian-lenny-amd64
http://mediakey.dk/~cc/installing-xen-on-debian-etch-40/
http://mediakey.dk/~cc/howto-resize-xen-loop-disk-image/comment-page-1/
http://wiki.xensource.com/xenwiki/XenFaq
LVM:
http://wiki.kartbuilding.net/index.php/LVM_on_XEN_%28dom0%29
http://xgu.ru/wiki/LVM
http://xgu.ru/wiki/%D0%A1%D0%BE%D0%B7%D0%B4%D0%B0%D0%BD%D0%B8%D0%B5_%D0%B3%D0%BE%D1%81%D1%82%D0%B5%D0%B2%D0%BE%D0%B3%D0%BE_%D0%B4%D0%BE%D0%BC%D0%B5%D0%BD%D0%B0_Xen


http://www.howtoforge.com/nfs_ssh_tunneling
http://jazzslider.wordpress.com/2009/01/15/my-home-nas-part-9-nfs-over-ssh/

Xen VPS-hostin:
http://vpslink.com/xen-vps/

Windows on Xen:
http://wiki.xensource.com/xenwiki/HVM_Compatible_Processors
http://ark.intel.com/VTList.aspx
http://www.xgu.ru/wiki/Windows_XP_%D0%B2_Xen
http://l0rda.biz/2008/12/02/xen-windows-2/ - windows on xen
http://www.kood.org/terminal-server-patch/ - windows terminal server patch
http://support.microsoft.com/kb/888794 - Active Directory domain controller in virtual hosting environments
http://mediakey.dk/~cc/howto-install-windows-xp-vista-on-xen/

Xen on Mac OS:
http://www.scl.ameslab.gov/Projects/mini-xen/index.html
http://wiki.onmac.net/index.php/Triple_Boot_via_BootCamp

Xen on Ubuntu 10.04 with grub2:
https://wiki.ubuntu.com/LucidLynx/ReleaseNotes
https://help.ubuntu.com/community/Grub2
https://help.ubuntu.com/community/GrubHowto
http://lists.xensource.com/archives/html/xen-users/2010-06/msg00759.html
http://bderzhavets.wordpress.com/2010/04/24/set-up-ubuntu-10-04-server-pv-domu-at-xen-4-0-dom0-pvops-2-6-32-10-kernel-dom0-on-top-of-ubuntu-10-04-server/


Bugs post-install':
-------------------
ssh bug "stdin: is not a tty":
aptitude install udev

clocksource/0: Time went backwards:
http://wiki.debian.org/Xen#A.27clocksource.2BAC8-0.3ATimewentbackwards.27

patch /etc/xen/scripts/network-bridge for using multiple network cards:
do_ifup() {
- if ! ifup $1 ; then
+ if ! ifconfig $1 up ; then
https://systemausfall.org/wikis/howto/XenUpgrade3.2#head-d2738f3bf79081767e26f85298afc4522544b01a

losetup -a
losetup /dev/loopN /path2img
mount /dev/loopN /path2mount
umount /path2mount

http://nhc-it.livejournal.com/tag/kerio - kerio winroute firewall на xp-xen
vmware2xen:
http://ian.blenke.com/vmware/vmdk/xen/hvm/qemu
http://tx.downloads.xensource.com/products/v2xva/index.php

virtualbox:
http://www.my-guides.net/en/content/view/122/26/ - how to resize virtualbox image
http://forum.ubuntu.ru/index.php?topic=57578.0

KVM:
https://help.ubuntu.com/community/KVM/FAQ#How%20to%20prevent%20Virtualbox%20and%20KVM%20from%20conflicting?
http://wiki.infn.it/cn/ccr/virtualizzazione/documentazione/xen_to_kvm
http://rwmj.wordpress.com/tag/kvm/
http://itsignals.cascadia.com.au/?p=28 - HOWTO: Resize a KVM Virtual Machine Image
http://combatwombat.7doves.com/2008/12/20/resizing-kvm-hard-disk-image-file

После клонирования для того, чтобы заработал сетевой интерфейс необходимо на клоне удалить файл /etc/udev/rules.d/70-persistent-net.rules

http://searchservervirtualization.techtarget.com/tip/Six-steps-for-migrating-Xen-virtual-machines-to-KVM :
1. Make sure that you have installed the parted and kpartx utilities in the host environment
2. Open the virtual machine you want to migrate, and install the GRUB boot loader.
3. dd if=/dev/images/xevvm1 of=xen.img bs=1M
4. dd if=/dev/zero of=kvm.img bs=1M count=10240
5. Create partitions in the KVM image file you've just created.
parted kvm.img mklabel msdos
parted kvm.img mkpart primary ext2 0 9000
parted kvm.img mkpart primary linux-swap 9000 10000
parted kvm.img set 1 boot on
6. Copy the old Xen image to the new KVM image.
modprobe dm-mod
losetup /dev/loop kvm.img
kpartx -a /dev/loop0
dd if=xen.img of=/dev/mapper/loop0p1 bs=1M
fsck.ext3 -f /dev/mapper/loop0p1
7. qemu kvm.img

http://habrahabr.ru/blogs/linux/70512/ - proxy_arp
http://habrahabr.ru/blogs/virtualization/71709/
sudo virt-install -n debian-601 -r 256 -f /var/lib/libvirt/images/debian-601.img -s 2 -c ~/iso/debian-6.0.1a-amd64-netinst.iso --accelerate --os-type=linux --vnc -w bridge:br0

http://gparted.sourceforge.net/livecd.php

SVN

http://webnewage.org/2008/04/20/svnexternals-i-django-druzhba-na-vek/
http://svnbook.red-bean.com/en/1.0/ch07s03.html

CAPTCHA

http://recaptcha.net/apidocs/captcha/ - web-сервис

REGEDIT tips

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions]
"MaxAllowedZone"=dword:00000003

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced]
"EnableBalloonTips"=dword:00000000

Антивирус

Eset:
http://nod32eset.org/category/nod32-login-password/

Мобильные игры

http://game.mob.ua/
http://www.mobilegamefaqs.com/
Для SonyEricsson:
http://www.se4ever.ru/java/java_games
http://se-zone.ru/games/
http://blogomobilka.ru/2009/03/30/java-igri-happy-tree-friends-flipps-flying-frenzy-spin-fun/
http://themes.modopo.com/goto_download.php?id=3294&language=en&m=64 - темы