<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:posterous="http://posterous.com/help/rss/1.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:media="http://search.yahoo.com/mrss/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">
  <channel>
    <title>Üstün Özgür</title>
    <link>http://ustunozgur.com</link>
    <description>Most recent posts at Üstün Özgür</description>
    <generator>posterous.com</generator>
    <link xmlns="http://www.w3.org/2005/Atom" href="http://posterous.com/api/sup_update#0177ca8d0" type="application/json" rel="http://api.friendfeed.com/2008/03#sup" />
    
    
    <atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/ustunozgur" /><feedburner:info uri="ustunozgur" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://posterous.superfeedr.com/" /><item>
      <pubDate>Mon, 14 Mar 2011 11:49:08 -0700</pubDate>
      <title>damlaates.net</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/PyYko_rBTp8/damlaatesnet</link>
      <guid isPermaLink="false">http://ustunozgur.com/damlaatesnet</guid>
      <description>&lt;p&gt;
	&lt;a href="http://damlaates.net"&gt;http://damlaates.net&lt;/a&gt; Damla Ates'in yeni web sitesi.
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/damlaatesnet"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/damlaatesnet#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/PyYko_rBTp8" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/damlaatesnet</feedburner:origLink></item>
    <item>
      <pubDate>Wed, 09 Mar 2011 11:38:00 -0800</pubDate>
      <title>koseokuru.com</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/xQ9IbNPgvwk/koseokurucom</link>
      <guid isPermaLink="false">http://ustunozgur.com/koseokurucom</guid>
      <description>&lt;p&gt;
	&lt;p&gt;Gazetelerin k&amp;ouml;şeyazılarına tek bir adresten ulaşmak i&amp;ccedil;in kullanabileceğiniz bir site yaptım. Şimdilik yedi gazetenin t&amp;uuml;m k&amp;ouml;şeyazılarını her g&amp;uuml;n g&amp;uuml;ncelleyerek g&amp;ouml;steriyor.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://koseokuru.com" title="Kose Okuru"&gt;http://koseokuru.com&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="http://twitter.com/koseokuru"&gt;http://twitter.com/koseokuru&lt;/a&gt;&amp;nbsp;adresinden gelişmeleri takip edebilirsiniz. Facebook sayfası da&amp;nbsp;&lt;a href="http://www.facebook.com/pages/Koseokurucom/195045633849801"&gt;http://www.facebook.com/pages/Koseokurucom/195045633849801&lt;/a&gt;&amp;nbsp;adresinde.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/koseokurucom"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/koseokurucom#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/xQ9IbNPgvwk" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/koseokurucom</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 03 Mar 2011 03:59:00 -0800</pubDate>
      <title>Tips for using VirtualBox</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/uHhrqcPKIhA/tips-for-using-virtualbox</link>
      <guid isPermaLink="false">http://ustunozgur.com/tips-for-using-virtualbox</guid>
      <description>&lt;p&gt;
	&lt;ol&gt;
&lt;li&gt;Port forwarding:&lt;/li&gt;
&lt;/ol&gt;


&lt;p&gt;&lt;a href="http://www.virtualbox.org/manual/ch06.html#natforward"&gt;http://www.virtualbox.org/manual/ch06.html#natforward&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;e.g :&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;VBoxManage modifyvm &amp;quot;VM name&amp;quot; --natpf1 &amp;quot;guestssh,tcp,,2222,,22&amp;quot;
VBoxManage modifyvm &amp;quot;VM name&amp;quot; --natpf1 &amp;quot;guestdjango,tcp,,8888,,8081&amp;quot;

ssh -p 2222 localhost&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;p&gt;Start Django server at 0.0.0.0:8081 on guest, and access the site at
127.0.0.1:8888 on the host.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;Starting vm from command line:&lt;/p&gt;

&lt;p&gt; VBoxManage startvm &amp;ldquo;VM name&amp;rdquo;&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;


&lt;p&gt;This still displays a gui though. If you just want to start it up (to ssh), try&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;vboxheadless -s &amp;quot;VM name&amp;quot;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;p&gt;or better yet pass the `&amp;mdash;type headless'&amp;lsquo; parameter to vboxmanage startvm so that it returns.&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;vboxmanage startvm &amp;quot;VM name&amp;quot; --type headless&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;ol&gt;
&lt;li&gt;&lt;p&gt;List vm&amp;rsquo;s:&lt;/p&gt;

&lt;p&gt; VBoxManage list vm&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;List running vm&amp;rsquo;s:&lt;/p&gt;

&lt;p&gt; VBoxManage list runningvms&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;See Vagrant for automation. &lt;a href="http://vagrantup.com/"&gt;http://vagrantup.com/&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Disable framebuffer if command line is slow. See
&lt;a href="http://serverfault.com/questions/148874/command-line-is-horribly-slow-in-ubuntu-server"&gt;http://serverfault.com/questions/148874/command-line-is-horribly-slow-in-ubun...&lt;/a&gt;&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;


&lt;p&gt;Sources:
&amp;ndash; &lt;a href="http://michaelhallsmoore.com/blog/Running-A-Local-Web-Development-Environment-With-VirtualBox"&gt;http://michaelhallsmoore.com/blog/Running-A-Local-Web-Development-Environment...&lt;/a&gt;
&amp;ndash; &lt;a href="http://mydebian.blogdns.org/?p=148"&gt;http://mydebian.blogdns.org/?p=148&lt;/a&gt;&lt;/p&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/tips-for-using-virtualbox"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/tips-for-using-virtualbox#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/uHhrqcPKIhA" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/tips-for-using-virtualbox</feedburner:origLink></item>
    <item>
      <pubDate>Mon, 21 Feb 2011 08:23:00 -0800</pubDate>
      <title>Version Control with Cachebusting - GitHub</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/c0wv_a91zAU/version-control-with-cachebusting-github</link>
      <guid isPermaLink="false">http://ustunozgur.com/version-control-with-cachebusting-github</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;p&gt;&lt;strong&gt;What is ?v=1"&lt;/strong&gt;
&lt;/p&gt;&lt;p&gt;'?v=1' is the JavaScript/CSS Version Control with Cachebusting&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Why do you need to cache JavaScript CSS?&lt;/strong&gt;
Web page designs are getting richer and richer, which means more scripts and stylesheets in the page. A first-time visitor to your page may have to make several HTTP requests, but by using the Expires header you make those components cacheable. This avoids unnecessary HTTP requests on subsequent page views. Expires headers are most often used with images, but they should be used on all components including scripts, stylesheets etc.&lt;/p&gt;&lt;/div&gt;&lt;div class="posterous_quote_citation"&gt;via &lt;a href="https://github.com/paulirish/html5-boilerplate/wiki/Version-Control-with-Cachebusting"&gt;github.com&lt;/a&gt;
    &lt;p&gt;&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/version-control-with-cachebusting-github"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/version-control-with-cachebusting-github#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/c0wv_a91zAU" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/version-control-with-cachebusting-github</feedburner:origLink></item>
    <item>
      <pubDate>Mon, 21 Feb 2011 08:10:00 -0800</pubDate>
      <title>Using the Mark of the Web (MOTW)</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/cDXT32mqSbo/using-the-mark-of-the-web-motw</link>
      <guid isPermaLink="false">http://ustunozgur.com/using-the-mark-of-the-web-motw</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_medium_quote"&gt;If you develop Web sites, and you add even the littlest bit of JavaScript (like the "framebuster" script I add to my sites), you get the warning message when you preview the site in Internet Explorer because of Active Content. I thought the only option for disabling this message was to modify my security settings (which I'm very hesitant to do, given some of the files that I receive). However, Microsoft has provided a way to disable this message for those pages that you know are safe.&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://www.helpstuff.com/motw.html"&gt;helpstuff.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;This disables security warnings on IE when testing local html files with js.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/using-the-mark-of-the-web-motw"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/using-the-mark-of-the-web-motw#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/cDXT32mqSbo" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/using-the-mark-of-the-web-motw</feedburner:origLink></item>
    <item>
      <pubDate>Mon, 17 Jan 2011 00:37:00 -0800</pubDate>
      <title>awesome (window manager) - Wikipedia, the free encyclopedia</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/my6SNv1xZgk/awesome-window-manager-wikipedia-the-free-enc</link>
      <guid isPermaLink="false">http://ustunozgur.com/awesome-window-manager-wikipedia-the-free-enc</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;div class='p_embed p_image_embed'&gt;
&lt;img alt="Media_httpuploadwikim_djpdg" height="240" src="http://posterous.com/getfile/files.posterous.com/ustunozgur/IkFdAgJlhdqwdftmiIfyveqqoGFwxpjriACwpDedoiGAqbAzjyeHcasrovEi/media_httpuploadwikim_djpdg.png.scaled500.png" width="300" /&gt;
&lt;/div&gt;


&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://en.wikipedia.org/wiki/Awesome_%28window_manager%29"&gt;en.wikipedia.org&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;Awesome window manager is awesome! Documentation could be better though. (Mod4 key is usually the Windows key.)&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/awesome-window-manager-wikipedia-the-free-enc"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/awesome-window-manager-wikipedia-the-free-enc#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/my6SNv1xZgk" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
      <media:content type="image/png" height="240" width="300" url="http://getfile3.posterous.com/getfile/files.posterous.com/ustunozgur/IkFdAgJlhdqwdftmiIfyveqqoGFwxpjriACwpDedoiGAqbAzjyeHcasrovEi/media_httpuploadwikim_djpdg.png">
        <media:thumbnail height="240" width="300" url="http://getfile0.posterous.com/getfile/files.posterous.com/ustunozgur/IkFdAgJlhdqwdftmiIfyveqqoGFwxpjriACwpDedoiGAqbAzjyeHcasrovEi/media_httpuploadwikim_djpdg.png.scaled500.png" />
      </media:content>
    <feedburner:origLink>http://ustunozgur.com/awesome-window-manager-wikipedia-the-free-enc</feedburner:origLink></item>
    <item>
      <pubDate>Mon, 17 Jan 2011 00:35:00 -0800</pubDate>
      <title>Gmrun - Substitute for gnome run dialog in Ubuntu | Ubuntu Geek</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/tu9RlZ7QTJE/gmrun-substitute-for-gnome-run-dialog-in-ubun</link>
      <guid isPermaLink="false">http://ustunozgur.com/gmrun-substitute-for-gnome-run-dialog-in-ubun</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_short_quote"&gt;‘Gmrun’ is a run-program utility that provides bash-like TAB completion and history, the ability to run commands in a terminal using CTRL-Enter.&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://www.ubuntugeek.com/gmrun-substitute-for-gnome-run-dialog-in-ubuntu.html"&gt;ubuntugeek.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;This is better than Alt-F2 for running terminal commands.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/gmrun-substitute-for-gnome-run-dialog-in-ubun"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/gmrun-substitute-for-gnome-run-dialog-in-ubun#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/tu9RlZ7QTJE" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/gmrun-substitute-for-gnome-run-dialog-in-ubun</feedburner:origLink></item>
    <item>
      <pubDate>Sun, 05 Dec 2010 12:24:00 -0800</pubDate>
      <title>Fixing emacs colors on Terminal Consoles</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/SOyllQIfIiw/fixing-emacs-colors-on-terminal-consoles</link>
      <guid isPermaLink="false">http://ustunozgur.com/fixing-emacs-colors-on-terminal-consoles</guid>
      <description>&lt;p&gt;
	&lt;p&gt;Use: &lt;p /&gt;  export TERM=xterm-256color &lt;p /&gt; If this causes problems, try: &lt;p /&gt; # terminal settings &lt;br /&gt;if [ -n "$DISPLAY" ]; &lt;br /&gt; then export TERM="xterm-color" &lt;br /&gt; else export TERM="linux" &lt;br /&gt;fi&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;See &lt;a href="http://www.robmeerman.co.uk/unix/256colours" title="this."&gt;http://www.robmeerman.co.uk/unix/256colours&lt;/a&gt;&lt;/p&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/fixing-emacs-colors-on-terminal-consoles"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/fixing-emacs-colors-on-terminal-consoles#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/SOyllQIfIiw" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/fixing-emacs-colors-on-terminal-consoles</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 18 Nov 2010 06:02:18 -0800</pubDate>
      <title>Programlama icin Guzel Bir Turkce Kaynak</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/9X8f7sgPdeI/programlama-icin-guzel-bir-turkce-kaynak</link>
      <guid isPermaLink="false">http://ustunozgur.com/programlama-icin-guzel-bir-turkce-kaynak</guid>
      <description>&lt;p&gt;
	&lt;a href="http://www.emrah.com/"&gt;http://www.emrah.com/&lt;/a&gt; &lt;br /&gt;Asagidaki "Notlar" kismi oldukca guzel.
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/programlama-icin-guzel-bir-turkce-kaynak"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/programlama-icin-guzel-bir-turkce-kaynak#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/9X8f7sgPdeI" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/programlama-icin-guzel-bir-turkce-kaynak</feedburner:origLink></item>
    <item>
      <pubDate>Wed, 17 Nov 2010 15:23:00 -0800</pubDate>
      <title>SQLite'a Giriş</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/5aoFu1F63FU/sqlitea-giris</link>
      <guid isPermaLink="false">http://ustunozgur.com/sqlitea-giris</guid>
      <description>&lt;p&gt;
	
&lt;h1 class="title"&gt;&lt;span style="font-weight: normal; font-size: 13px;"&gt;[Bu belgenin PDF hali aşağıdadır, Scribd kutusunun sol altındaki Download linkinden indirilebilir.]&lt;/span&gt;&lt;/h1&gt;
&lt;div class="contents topic"&gt;
&lt;p class="topic-title first"&gt;&lt;div class='p_embed p_file_embed'&gt;
&lt;a href="http://ustunozgur.com/sqlitea-giris"&gt;&lt;img alt="" src="http://posterous.com/images/filetypes/pdf.png" /&gt;&lt;/a&gt;
&lt;div class='p_embed_description'&gt;
&lt;strong&gt;sqlitenotlari.pdf&lt;/strong&gt;
&lt;a href="http://posterous.com/getfile/files.posterous.com/temp-2010-11-17/tecFBgCzwCbcDdHJwplDljumHdtzgDHkFvBEjrctzoFGzkxDEqpjdtngvcrB/sqlitenotlari.pdf"&gt;Download this file&lt;/a&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/p&gt;
&lt;h1 class="title" style="font-size: 2em;"&gt;&lt;span style="font-size: small;"&gt;SQLite Notları&lt;/span&gt;&lt;/h1&gt;
&lt;p class="topic-title first"&gt;İ&amp;ccedil;indekiler&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;a href="#kavramlar" class="reference internal"&gt;Kavramlar&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#veritabani-ve-tablo-olusturmak" class="reference internal"&gt;Veritabanı ve tablo oluşturmak&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#sqlite-ifadeleri" class="reference internal"&gt;SQLite İfadeleri&lt;/a&gt; 
&lt;ul&gt;
&lt;li&gt;&lt;a href="#veritabanindaki-tum-bilgiyi-secmek-yazdirmak" class="reference internal"&gt;Veritabanındaki t&amp;uuml;m bilgiyi se&amp;ccedil;mek (yazdırmak)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#onemli-operatorler" class="reference internal"&gt;&amp;Ouml;nemli operat&amp;ouml;rler:&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;a href="#veri-eklemek-guncellemek-ve-silmek" class="reference internal"&gt;Veri eklemek, g&amp;uuml;ncellemek ve silmek&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#verileri-sorgulamak" class="reference internal"&gt;Verileri sorgulamak&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#kisitlamalar" class="reference internal"&gt;Kısıtlamalar&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#tablolari-birlestirmek" class="reference internal"&gt;Tabloları birleştirmek&lt;/a&gt; 
&lt;ul&gt;
&lt;li&gt;&lt;a href="#inner-join" class="reference internal"&gt;Inner Join&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#outer-join" class="reference internal"&gt;Outer Join&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;a href="#sqlite-fonksiyonlari" class="reference internal"&gt;SQLite Fonksiyonları&lt;/a&gt; 
&lt;ul&gt;
&lt;li&gt;&lt;a href="#temel-fonksiyonlar" class="reference internal"&gt;Temel fonksiyonlar&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#aggregate-fonksiyonlar" class="reference internal"&gt;Aggregate fonksiyonlar&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#tarih-ve-zaman-fonksiyonlari" class="reference internal"&gt;Tarih ve zaman fonksiyonları&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;a href="#gorunumler-views-tetikler-trigger-ve-transactions" class="reference internal"&gt;G&amp;ouml;r&amp;uuml;n&amp;uuml;mler (views), tetikler (trigger) ve transactions&lt;/a&gt; 
&lt;ul&gt;
&lt;li&gt;&lt;a href="#gorunumler" class="reference internal"&gt;G&amp;ouml;r&amp;uuml;n&amp;uuml;mler&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#triggers-tetikler" class="reference internal"&gt;Triggers (Tetikler)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#transactions" class="reference internal"&gt;Transactions&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;a href="#diger" class="reference internal"&gt;Diğer&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="#nokta-ile-baslayan-komutlar-sqlite3-programina-ozel-komutlar" class="reference internal"&gt;Nokta ile başlayan komutlar (sqlite3 programına &amp;ouml;zel komutlar)&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;p&gt;SQLite konfig&amp;uuml;rasyon, kurulum, sunucu program gerektirmeyen, tek bir dosya &amp;uuml;zerinde bulunan bir veritabanı t&amp;uuml;r&amp;uuml;d&amp;uuml;r. Bir&amp;ccedil;ok dilde kullanılabilmektedir. &lt;cite&gt;sqlite3&lt;/cite&gt; programı ile programlama dili kullanmadan veritabanları oluşturulabilir.&lt;/p&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id1" class="toc-backref"&gt;Kavramlar&lt;/a&gt;&lt;/h1&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;relational database: ilişkisel veritabanı&lt;/li&gt;
&lt;li&gt;table: Veriler tablo halinde saklanır.&lt;/li&gt;
&lt;li&gt;schema: Tablodaki s&amp;uuml;tunlara ait bilgiler (meta veri)&lt;/li&gt;
&lt;li&gt;row: record, kayıt&lt;/li&gt;
&lt;li&gt;column: alan adı&lt;/li&gt;
&lt;li&gt;field: alan, h&amp;uuml;cre&lt;/li&gt;
&lt;li&gt;primary key: birincil anahtar&lt;/li&gt;
&lt;li&gt;foreign key: yabancı anahtar&lt;/li&gt;
&lt;li&gt;trigger: tetik, d&amp;uuml;rt&amp;uuml;&lt;/li&gt;
&lt;li&gt;view : g&amp;ouml;r&amp;uuml;n&amp;uuml;m&lt;/li&gt;
&lt;li&gt;transaction: etkileşim&lt;/li&gt;
&lt;li&gt;result set: sonu&amp;ccedil; k&amp;uuml;mesi (&lt;tt class="docutils literal"&gt;SELECT&lt;/tt&gt; işlemi sonucu se&amp;ccedil;ilen)&lt;/li&gt;
&lt;li&gt;index&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id2" class="toc-backref"&gt;Veritabanı ve tablo oluşturmak&lt;/a&gt;&lt;/h1&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veritabanı oluşturmak i&amp;ccedil;in: &lt;tt class="docutils literal"&gt;sqlite3.exe veritabanı.db&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Tablo oluşturmak i&amp;ccedil;in: &lt;tt class="docutils literal"&gt;CREATE TABLE &lt;span class="pre"&gt;tablo_adı(alan_adları...)&lt;/span&gt;&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Alan adlarına &amp;ouml;rnek:&lt;/p&gt;
&lt;blockquote&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;T&amp;uuml;r belirtmeden:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE notlar(öğrenci_no, harf_notu);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;T&amp;uuml;r belirterek:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE notlar(öğrenci_no integer, harf_notu text);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veri t&amp;uuml;rleri: null, integer, real, text, blob&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Tabloyu silmek: &lt;tt class="docutils literal"&gt;DROP TABLE notlar&lt;/tt&gt;;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;ALTER TABLE&lt;/tt&gt;: Tablo adını değiştirmek veya s&amp;uuml;tun eklemek i&amp;ccedil;in kullanılır. S&amp;uuml;tun adını değiştirmek, s&amp;uuml;tunu silmek ya da s&amp;uuml;tuna sınırlama (constraint) getirmek i&amp;ccedil;in kullanılamaz. [&lt;a href="http://www.sqlite.org/lang_alterTABLE.html" class="reference external"&gt;http://www.sqlite.org/lang_alterTABLE.html&lt;/a&gt;]&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id3" class="toc-backref"&gt;SQLite İfadeleri&lt;/a&gt;&lt;/h1&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id4" class="toc-backref"&gt;Veritabanındaki t&amp;uuml;m bilgiyi se&amp;ccedil;mek (yazdırmak)&lt;/a&gt;&lt;/h2&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veritabanındaki her şeyi se&amp;ccedil;mek:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT * FROM tablo_adı;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veritabanındaki bazı alan adlarını (s&amp;uuml;tunları) se&amp;ccedil;mek:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT alan_adı FROM tablo_adı;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veritabanındaki bazı kayıtları (satırları) se&amp;ccedil;mek:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT * FROM tablo_adı WHERE alan_adı=KOŞUL;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Yukarıdaki iki koşul birleştirilip veritabanındaki bazı h&amp;uuml;creler se&amp;ccedil;ilebilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT bir_alan_adı FROM tablo WHERE başka_bir_alan_adı=KOŞUL;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Se&amp;ccedil;im koşulları operat&amp;ouml;rlerle zenginleştirilebilir.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id5" class="toc-backref"&gt;&amp;Ouml;nemli operat&amp;ouml;rler:&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;Eşitlik işlemi yerine kullanılabilecekler:&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;IN&lt;/tt&gt; : K&amp;uuml;mede olup olmadığına bakar.&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;LIKE&lt;/tt&gt;: Wildcard eşleştirme i&amp;ccedil;in (% * gibi, _ ? gibi.)&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;GLOB&lt;/tt&gt;: &lt;tt class="docutils literal"&gt;LIKE&lt;/tt&gt; gibi; ancak UNIX'teki shell globbing'e benzer, b&amp;uuml;y&amp;uuml;k/k&amp;uuml;&amp;ccedil;&amp;uuml;k harf duyarlı&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;BETWEEN&lt;/tt&gt;: Aralık belirtmek i&amp;ccedil;in kullanılır.&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&amp;Ouml;r:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT bir_alan_adı FROM tablo
       WHERE başka_bir_alan_adı LIKE KOŞUL BETWEEN 200 AND 400;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id6" class="toc-backref"&gt;Veri eklemek, g&amp;uuml;ncellemek ve silmek&lt;/a&gt;&lt;/h1&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;DEFAULT&lt;/tt&gt; anahtar s&amp;ouml;zc&amp;uuml;ğ&amp;uuml;: Veri girilmezse alacağı değer . &amp;Ouml;r:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE kitaplar(id integer primary key, kitap_adı text,
                      yayım_tarihi text default 'belli değil');&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veri ekleme:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;INSERT INTO kitaplar(id,kitap_adı, yayım_tarihi)
     VALUES(12,&amp;quot;Puslu Kıtalar Atlası&amp;quot;,&amp;quot;1999&amp;quot;);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;T&amp;uuml;m alanlara ekleme yapılacaksa tablo_adından sonraki kısım gerekli değildir:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;INSERT INTO kitaplar
     VALUES(12,&amp;quot;Puslu Kıtalar Atlası&amp;quot;,&amp;quot;1999&amp;quot;);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;MySQL'dekinin aksine toplu veri girişi yoktur.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;INSERT INTO kitaplar
     VALUES(12,&amp;quot;Puslu Kıtalar Atlası&amp;quot;,&amp;quot;1999&amp;quot;),
     VALUES(13,&amp;quot;Karanlığa Okunan Ezanlar&amp;quot;,&amp;quot;2005&amp;quot;);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Veri eklerken t&amp;uuml;m alanların girilmesi zorunlu değildir. &lt;tt class="docutils literal"&gt;Default&lt;/tt&gt; değer verilmişse o değer kullanılır, yoksa &lt;tt class="docutils literal"&gt;NULL&lt;/tt&gt; girilir; ancak bu durumda tablo adından sonra hangi alanlara giriş yapıldığı belirtilmelidir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;INSERT INTO kitaplar(id,kitap_adı) VALUES(12,&amp;quot;Puslu Kıtalar Atlası&amp;quot;);
INSERT INTO kitaplar(kitap_adı) VALUES(&amp;quot;Divan);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Var olan veriyi değiştirmek i&amp;ccedil;in &lt;tt class="docutils literal"&gt;INSERT INTO&lt;/tt&gt; yerine &lt;tt class="docutils literal"&gt;REPLACE INTO&lt;/tt&gt; kullanılır.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;Primary key&lt;/tt&gt;: Her tabloda bir primary key vardır, bu a&amp;ccedil;ık&amp;ccedil;a belirtilmezse &lt;tt class="docutils literal"&gt;rowid&lt;/tt&gt; adında otomatik bir alan oluşturulur. (Belirtilirse &lt;tt class="docutils literal"&gt;primary key&lt;/tt&gt; ile &lt;tt class="docutils literal"&gt;rowid&lt;/tt&gt; birbirinin kopyası olur.)&lt;/p&gt;
&lt;p&gt;Aynı ana anahtarı i&amp;ccedil;eren bir kayıt girilmek istenirse buna izin verilmez. Bu kayıt &amp;ouml;nce silinmeli, sonra ekleme yapılmalıdır ya da doğrudan &lt;tt class="docutils literal"&gt;REPLACE INTO&lt;/tt&gt; komutu ile değiştirilmelidir.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;INSERT OR REPLACE INTO&lt;/tt&gt; komutu ile kayıt varsa g&amp;uuml;ncellenir, yoksa oluşturulur.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;INSERT INTO&lt;/tt&gt; ve &lt;tt class="docutils literal"&gt;SELECT&lt;/tt&gt; komutları birleştirilebilir:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;INSERT INTO yeni_tablo SELECT * FROM varolan_tablo;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Kayıt silmek i&amp;ccedil;in &lt;tt class="docutils literal"&gt;DELETE&lt;/tt&gt; komutu kullanılır. Koşul belirtilmezse t&amp;uuml;m tablo silinir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;DELETE FROM tablo; -- tüm tabloyu sıfırlar.&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Belli satırlardaki verilerin bazı alanlarını değiştirmek i&amp;ccedil;in &lt;tt class="docutils literal"&gt;UPDATE&lt;/tt&gt; komutu kullanılır. &lt;tt class="docutils literal"&gt;UPDATE tablo_adı SET &lt;span class="pre"&gt;alan_adı='yeni&lt;/span&gt; değer' WHERE id=1;&lt;/tt&gt;&lt;/p&gt;
&lt;p&gt;Bu işlemin &lt;tt class="docutils literal"&gt;REPLACE&lt;/tt&gt;'den farkı t&amp;uuml;m kaydı girmenin gerekmemesi, sadece değişmesi gereken alanları g&amp;uuml;ncellemesidir.   Bunun dışında &lt;tt class="docutils literal"&gt;REPLACE&lt;/tt&gt; aslında &lt;tt class="docutils literal"&gt;INSERT OR REPLACE&lt;/tt&gt; ifadesine denk bir kısayol olduğundan halihazırda kayıt yoksa oluşturulur.&lt;/p&gt;
&lt;p&gt;&lt;tt class="docutils literal"&gt;UPDATE&lt;/tt&gt; komutunda ise yeni kayıt oluşturulmaz; kayıt yoksa hata mesajı verilmez, varsa g&amp;uuml;ncellenir.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id7" class="toc-backref"&gt;Verileri sorgulamak&lt;/a&gt;&lt;/h1&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;SELECT * FROM tablo_adı;&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;SELECT alan_adı1, alan_adı2 FROM tablo_adı;&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;G&amp;ouml;sterim esnasında s&amp;uuml;tunları yeniden adlandırmak i&amp;ccedil;in &lt;tt class="docutils literal"&gt;AS&lt;/tt&gt; anahtar s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; kullanılır.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT alan_adı1 AS YeniSütunAdı FROM tablo_adı;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;G&amp;ouml;sterilen kayıt sayısını limitlemek i&amp;ccedil;in &lt;tt class="docutils literal"&gt;LIMIT&lt;/tt&gt; s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; kullanılır. &lt;tt class="docutils literal"&gt;SELECT * FROM tablo_adı limit 2;&lt;/tt&gt; ilk iki kaydı g&amp;ouml;sterecektir. Offset s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; ile başlangı&amp;ccedil; satırı belirtilebilir. &lt;tt class="docutils literal"&gt;SELECT * FROM tablo_adı limit 2 offset 1;&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;G&amp;ouml;sterilen veriyi sıralamak i&amp;ccedil;in &lt;tt class="docutils literal"&gt;ORDER BY alan_adı ASC/DESC;&lt;/tt&gt; kalıbı kullanılır. Birden fazla alan adı kullanılabilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;ORDER BY alan_adı1 desc, alan_adı2 ASC;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Sadece belli satırları g&amp;ouml;stermek i&amp;ccedil;in &lt;tt class="docutils literal"&gt;WHERE&lt;/tt&gt; s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; kullanılır.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT * FROM tablo_adı WHERE id = 1;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;G&amp;ouml;sterilen kayıtlarda yineleme varsa &lt;tt class="docutils literal"&gt;DISTINCT&lt;/tt&gt; s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; ile yinelenen kayıtlar filtrelenebilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT DISTINCT yazar_adı FROM kitaplar WHERE fiyat &amp;lt; 20;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;Group by&lt;/tt&gt; kalıbı ile yinelenen kayıtlara ait veriler gruplanabilir. Daha sonra &lt;tt class="docutils literal"&gt;sum()&lt;/tt&gt; gibi toplam fonksiyonları ile bu gruplar hakkında &amp;ouml;zet bilgiye ulaşılabilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT sum(orderPrice) AS Total, Customer FROM orders
    GROUP BY customer;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Toplam (aggregate) fonksiyonları kullanılırsa &lt;tt class="docutils literal"&gt;WHERE&lt;/tt&gt; yerine &lt;tt class="docutils literal"&gt;HAVING&lt;/tt&gt; anahtar s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; kullanılmalıdır.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT sum(OrderPrice) AS Total, Customer FROM Orders
    GROUP BY Customer HAVING sum(OrderPrice)&amp;gt;1000;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;(Bkz: &lt;a href="http://zetcode.com/databases/sqlitetutorial/SELECT/" class="reference external"&gt;http://zetcode.com/databases/sqlitetutorial/SELECT/&lt;/a&gt; )&lt;/p&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id8" class="toc-backref"&gt;Kısıtlamalar&lt;/a&gt;&lt;/h1&gt;
&lt;p&gt;Bazı alan adlarına kısıtlama koyabiliriz, bu şekilde anlamsız veri girişi &amp;ouml;nlenir.&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;NOT NULL&lt;/tt&gt;: Verinin girilmesini zorunlu yapar.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;UNIQUE&lt;/tt&gt;: Girilen veri eşsiz olmalıdır.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt;: Birincil anahtar&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;FOREIGN KEY&lt;/tt&gt;: Yabancı anahtar&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;CHECK&lt;/tt&gt;: Kabul edilebilir veri girişi aralığı.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;DEFAULT&lt;/tt&gt;: Varsayılan değer.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;NOT NULL&lt;/tt&gt;: Alan adını zorunlu yapar. &lt;tt class="docutils literal"&gt;CREATE TABLE &amp;ouml;ğrenciler(ad text, soyad text NOT NULL);&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;UNIQUE&lt;/tt&gt;: S&amp;uuml;tundaki her değer farklı olmak zorundadır. &lt;tt class="docutils literal"&gt;CREATE TABLE markalar(Id integer, markaadi text unique);&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt;: Tablodaki her kaydın en az bir eşsiz s&amp;uuml;tunu olmalıdır. Bunlardan en onemlisi &lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt;'dir. birden fazla &lt;tt class="docutils literal"&gt;UNIQUE&lt;/tt&gt; key olabilir, ancak &lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt; bir tanedir. &lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt; otomatik olarak &lt;tt class="docutils literal"&gt;UNIQUE&lt;/tt&gt;'tır.&lt;/p&gt;
&lt;p&gt;Başka tablolarla bağlantı kurulurken &lt;tt class="docutils literal"&gt;PRIMARY KEY&lt;/tt&gt;'ler diğer tablolarda &lt;tt class="docutils literal"&gt;FOREIGN KEY&lt;/tt&gt; olarak bağlantıyı sağlar. Birincil anahtar t&amp;uuml;r&amp;uuml; tamsayı (integer) ise &lt;tt class="docutils literal"&gt;auto increment&lt;/tt&gt; &amp;ouml;zelliği de eklenir.&lt;/p&gt;
&lt;p&gt;Varsayılan olarak &lt;tt class="docutils literal"&gt;rowid&lt;/tt&gt; adında bir birincil anahtar vardır. Birincil anahtar ayrıca verilse bile, &lt;tt class="docutils literal"&gt;rowid&lt;/tt&gt; birincil anahtar olarak kullanılabilir.)&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;FOREIGN KEY&lt;/tt&gt;: Bir tablodaki bir yabancı anahtar başka bir tablodaki birincil anahtardir ve iki tablo arasındaki bağlantıyı sağlar.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE yazarlar(yazarid integer primary key, ad text);
CREATE TABLE kitaplar(kitapid integer primary key, başlık text,
     yazarid integer, foreign key(yazarid) references yazarlar (yazaradı));&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;p&gt;Bu şekilde yazarlar tablosunda bulunmayan bir yazara ait bir kitabın veritabanına eklenmesi engellenmiş olur.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;CHECK&lt;/tt&gt;: &lt;tt class="docutils literal"&gt;Not null&lt;/tt&gt;'a benzer bir şekilde, belli bir koşulu sağlamayan verilerin veritabanına girilmesini engeller.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE Orders(Id integer PRIMARY KEY, OrderPrice integer
     CHECK(OrderPrice&amp;gt;0), Customer text);

sqlite&amp;gt; INSERT INTO Orders(OrderPrice, Customer) VALUES(-10, 'Johnson');
SQL error: constraint failed&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;DEFAULT&lt;/tt&gt; kısıtlaması: Bir alana veri girilmezse varsayılan değer girilir.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id9" class="toc-backref"&gt;Tabloları birleştirmek&lt;/a&gt;&lt;/h1&gt;
&lt;p&gt;İlişkisel (relational) veritabanlarının en &amp;ouml;nemli &amp;ouml;zelliği tabloları birleştirebilmeleridir. &lt;tt class="docutils literal"&gt;JOIN&lt;/tt&gt; operasyonu ile iki ya da daha fazla tablo birleştirilir. Bu işlem, &lt;tt class="docutils literal"&gt;INNER JOIN&lt;/tt&gt; ve &lt;tt class="docutils literal"&gt;OUTER JOIN&lt;/tt&gt; olarak iki &amp;ccedil;eşittir; aksi belirtilmedik&amp;ccedil;e &lt;tt class="docutils literal"&gt;INNER JOIN&lt;/tt&gt; yapılır.&lt;/p&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id10" class="toc-backref"&gt;Inner Join&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;İki tablodan eşleşen değerlere sahip kayıtları g&amp;ouml;sterir. &amp;Uuml;&amp;ccedil; &amp;ccedil;eşittir: Inner join, natural inner join ve cross inner join.&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;Inner Join&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT Name, Day FROM Customers, Reservations
       WHERE Customers.CustomerId = Reservations.CustomerID;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Natural Inner Join: Otomatik olarak ortak s&amp;uuml;tunlar &amp;uuml;zerinden eşleştirme yapar.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Cross Inner Join: Bir tablodaki t&amp;uuml;m kayıtlarla diğer tablodaki t&amp;uuml;m kayıtları birleştirir. (Kartezyen &amp;ccedil;arpım gibi)&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id11" class="toc-backref"&gt;Outer Join&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;Outer join işleminde, birleştirilen tabloların eşleşen kaydı olması gerekemez. Left outer join, right outer join, full outer join olarak &amp;uuml;&amp;ccedil; &amp;ccedil;eşit olsa da SQLite sadece left outer join destekler. Bu nedenle işlem &lt;tt class="docutils literal"&gt;left join&lt;/tt&gt; olarak da yazılabilir. Eşleşmeyen kayıtlara ait değerler &lt;tt class="docutils literal"&gt;NULL&lt;/tt&gt; olarak g&amp;ouml;sterilir.&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;Outer Join:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT Name, Day FROM Customers LEFT JOIN Reservations
                 ON Customers.CustomerId=Reservations.CustomerId;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;p&gt;ya da eşleştirilen alan adı ortaksa &lt;tt class="docutils literal"&gt;USING&lt;/tt&gt; anahtar s&amp;ouml;zc&amp;uuml;ğ&amp;uuml; ile&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT Name, Day FROM Customers LEFT JOIN Reservations USING (CustomerId);&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Natural Left Outer Join: Ortak s&amp;uuml;tun adlarıyla otomatik outer join yapar.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;SELECT Name, Day FROM Customers NATURAL LEFT OUTER JOIN Reservations;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id12" class="toc-backref"&gt;SQLite Fonksiyonları&lt;/a&gt;&lt;/h1&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id13" class="toc-backref"&gt;Temel fonksiyonlar&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;&lt;a href="http://www.sqlite.org/lang_corefunc.html" class="reference external"&gt;http://www.sqlite.org/lang_corefunc.html&lt;/a&gt;&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;SELECT&lt;/tt&gt; komutu ile fonksiyonlar ekrana yazdırılabilir.&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;SELECT &lt;span class="pre"&gt;fonksiyon_adı();&lt;/span&gt;&lt;/tt&gt; gibi&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;sqlite_version()&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;random()&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;upper()/lower()/length()&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id14" class="toc-backref"&gt;Aggregate fonksiyonlar&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;&lt;a href="http://www.sqlite.org/lang_aggfunc.html" class="reference external"&gt;http://www.sqlite.org/lang_aggfunc.html&lt;/a&gt;&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;max()/min()/sum()&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;count()/count(*)&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;avg()&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;sum()/total()&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id15" class="toc-backref"&gt;Tarih ve zaman fonksiyonları&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;&lt;a href="http://www.sqlite.org/lang_datefunc.html" class="reference external"&gt;http://www.sqlite.org/lang_datefunc.html&lt;/a&gt;&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;date();&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;date('now');&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;datetime();&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;datetime('now');&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;strftime('%d-%m-$Y');&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;&lt;span class="pre"&gt;date('now','start&lt;/span&gt; of &lt;span class="pre"&gt;year','10&lt;/span&gt; &lt;span class="pre"&gt;months','weekday&lt;/span&gt; &lt;span class="pre"&gt;4');&lt;/span&gt;&lt;/tt&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id16" class="toc-backref"&gt;G&amp;ouml;r&amp;uuml;n&amp;uuml;mler (views), tetikler (trigger) ve transactions&lt;/a&gt;&lt;/h1&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id17" class="toc-backref"&gt;G&amp;ouml;r&amp;uuml;n&amp;uuml;mler&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;G&amp;ouml;r&amp;uuml;n&amp;uuml;mler bir ya da birden fazla tablodaki verilerin yeni bir tablo olmadan istenen şekilde g&amp;ouml;sterilmesidir. Sanal bir tablo olarak d&amp;uuml;ş&amp;uuml;n&amp;uuml;lebilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE VIEW UcuzKitaplar AS Select KitapAdı From Kitaplar WHERE Fiyat &amp;lt; 20;

SELECT * FROM UcuzKitaplar;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;p&gt;Yaratılan g&amp;ouml;r&amp;uuml;n&amp;uuml;m, &lt;tt class="docutils literal"&gt;DROP VIEW&lt;/tt&gt; kalıbı ile silinebilir.&lt;/p&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id18" class="toc-backref"&gt;Triggers (Tetikler)&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;Veritabanında belli bir olay olduğunda otomatik olarak ger&amp;ccedil;ekleştirilen işlemlere trigger(tetik) denir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;CREATE TABLE Log(Id integer PRIMARY KEY, EskiAd text, YeniAd  text, Tarih text)

CREATE TRIGGER mytrigger UPDATE OF Ad ON Arkadaşlar
BEGIN
 INSERT INTO Log(EskiAd,YeniAd, Tarih) VALUES(eski.Ad, new.Name, datetime('now'));
END;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;p&gt;B&amp;ouml;ylece &lt;tt class="docutils literal"&gt;Arkadaşlar&lt;/tt&gt; adlı tabloda bir &lt;tt class="docutils literal"&gt;Ad&lt;/tt&gt; g&amp;uuml;ncellenirse &lt;tt class="docutils literal"&gt;Log&lt;/tt&gt; adlı tabloya g&amp;uuml;ncellemeyle ilgili bir kayıt otomatik olarak girilir.&lt;/p&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h2&gt;&lt;a href="#id19" class="toc-backref"&gt;Transactions&lt;/a&gt;&lt;/h2&gt;
&lt;p&gt;Transaction, veritabanında yapılan işlemlerin en k&amp;uuml;&amp;ccedil;&amp;uuml;k par&amp;ccedil;asını g&amp;ouml;sterir. &lt;tt class="docutils literal"&gt;SELECT&lt;/tt&gt; dışındaki komutlarda i&amp;ccedil;kin (implicit) bir transaction vardır.&lt;/p&gt;
&lt;p&gt;Elle transaction başlatmak i&amp;ccedil;in &lt;tt class="docutils literal"&gt;Begin Transaction&lt;/tt&gt; ifadesi kullanılır. &lt;tt class="docutils literal"&gt;Commit&lt;/tt&gt; ya da &lt;tt class="docutils literal"&gt;Rollback&lt;/tt&gt; ifadelerine kadar olan t&amp;uuml;m ifadeler tek bir transaction'da ger&amp;ccedil;ekleştirilir. Bu şekilde veri tabanında yapılan işlem hızlanır ve kilitlenmeler (lock) azaltılır. (Birden fazla kişi transaction yaparken her biri transaction sırasında veritabanını kilitler, transactionlar gruplandıklarında bu işlem seyrekleşir.) (Bkz: [&lt;a href="http://stackoverflow.com/questions/54998/how-scalable-is-sqlite" class="reference external"&gt;http://stackoverflow.com/questions/54998/how-scalable-is-sqlite&lt;/a&gt;] )&lt;/p&gt;
&lt;p&gt;&lt;tt class="docutils literal"&gt;Rollback&lt;/tt&gt; t&amp;uuml;m değişiklikleri geri alır (Niye?)&lt;/p&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id20" class="toc-backref"&gt;Diğer&lt;/a&gt;&lt;/h1&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;||&lt;/tt&gt;: String birleştirme operat&amp;ouml;r&amp;uuml;. &amp;Ouml;r: &lt;tt class="docutils literal"&gt;SELECT "ABC" | | "DEF"&lt;/tt&gt;&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;CREATE TABLE IF NOT EXISTS Testing(id integer primary key);&lt;/tt&gt; : Tablo yoksa oluşturulur, varsa hi&amp;ccedil;bir şey yapılmaz.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;Home dizininde &lt;tt class="docutils literal"&gt;.sqliterc&lt;/tt&gt; adında bir dosya oluşturulabilir:&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$ cat .sqliterc
.mode column
.header on
.nullvalue NULL&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;li&gt;
&lt;p class="first"&gt;&lt;tt class="docutils literal"&gt;sqlite&lt;/tt&gt; komutu, komut satırından se&amp;ccedil;enek ve emir alabilir.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;sqlite3 -help/
sqlite3 -html deneme.db
sqlite3 deneme.db &amp;quot;.dump&amp;quot; &amp;gt; output.txt&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div class="section"&gt;
&lt;h1&gt;&lt;a href="#id21" class="toc-backref"&gt;Nokta ile başlayan komutlar (sqlite3 programına &amp;ouml;zel komutlar)&lt;/a&gt;&lt;/h1&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.help&lt;/tt&gt;: Yardım&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.databases&lt;/tt&gt;: Bağlı bulunan veritabanlarını g&amp;ouml;rmek i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.tables&lt;/tt&gt;: T&amp;uuml;m tabloları g&amp;ouml;rmek i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.schema&lt;/tt&gt;: T&amp;uuml;m tabloların schemalarını g&amp;ouml;rmek i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.schema tablo_adı&lt;/tt&gt;: Bir tabloya ait schema'yı g&amp;ouml;rmek i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.output filename&lt;/tt&gt;: Ekran yerine dosyaya yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.output stdout&lt;/tt&gt;: Dosya yerine ekrana yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.headers on/off&lt;/tt&gt;: Başlık satırlarını  yazdırmak icin&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.nullvalue STRING&lt;/tt&gt;: &lt;tt class="docutils literal"&gt;Nullvalue&lt;/tt&gt; yerine &lt;tt class="docutils literal"&gt;STRING&lt;/tt&gt; yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.mode {csv, column, html, INSERT, line, list, tabs}&lt;/tt&gt;: &amp;Ccedil;ıktı t&amp;uuml;rleri&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.log FILE/stderr&lt;/tt&gt;: Log yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.dump&lt;/tt&gt;: Veritabanını SQL ifadeleri olarak yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.dump tablo_adı&lt;/tt&gt;: Tabloyu SQL olarak yazdırmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.separator STRING&lt;/tt&gt;: Ayırıcı olarak STRING s&amp;ouml;zc&amp;uuml;ğ&amp;uuml;n&amp;uuml; kullanmak i&amp;ccedil;in&lt;/li&gt;
&lt;li&gt;&lt;tt class="docutils literal"&gt;.width sayı1, &lt;span class="pre"&gt;sayı2...&lt;/span&gt;&lt;/tt&gt;: S&amp;uuml;tun genişliklerini ayarlamak i&amp;ccedil;in&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Bkz:&lt;/p&gt;
&lt;ul class="simple"&gt;
&lt;li&gt;[&lt;a href="http://zetcode.com/databases/sqlitetutorial/" class="reference external"&gt;http://zetcode.com/databases/sqlitetutorial/&lt;/a&gt;]&lt;/li&gt;
&lt;li&gt;[&lt;a href="http://www.sqlite.org/lang.html" class="reference external"&gt;http://www.sqlite.org/lang.html&lt;/a&gt;]&lt;/li&gt;
&lt;li&gt;&lt;a href="http://www.istihza.com/py2/sqlite.html"&gt;http://www.istihza.com/py2/sqlite.html&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul class="simple"&gt;
&lt;/ul&gt;
&lt;/div&gt;

	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/sqlitea-giris"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/sqlitea-giris#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/5aoFu1F63FU" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/sqlitea-giris</feedburner:origLink></item>
    <item>
      <pubDate>Sun, 14 Nov 2010 06:16:00 -0800</pubDate>
      <title>Untitled</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/-xJ2sPsU0T4/33438136</link>
      <guid isPermaLink="false">http://ustunozgur.com/33438136</guid>
      <description>&lt;p&gt;
	&lt;h1&gt;Düzenli İfadeler Notları (Regular Expressions)&lt;/h1&gt;

&lt;p&gt;&amp;ldquo;Learning Perl&amp;rdquo; kitabından bazı notlar:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;Arama yapmak için /deneme/ benzeri ifadeler kullanılır.&lt;/p&gt;

&lt;p&gt;Aksi belirtilmedikçe $_ değişkeni üzerinde arama yapılır.
Ör:&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;merhaba&amp;quot;;
if (/mer/){
print &amp;quot;eşleşti&amp;quot;}&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


Farklı bir değişkeni eşleştirmek için binding (bağlama) operatörü (~=)
kullanılır.

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$yazı = &amp;quot;merhaba&amp;quot;
if ($yazı ~= /mer/)
print &amp;quot;eşleşti&amp;quot;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Sınıf betimleyici (class quantifier): [a-z], [0-3] gibi&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Sınıf betimleyiciler için kısayollar:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;\w: Sözcük (&lt;em&gt;w&lt;/em&gt;ord) karakteri: [a-zA-z0-9_] ifadesine denk&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;\d: Rakam (&lt;em&gt;d&lt;/em&gt;igit/decimal) karakteri: [0-9] ifadesine denk&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;\W, \D: Yukarıdaki ifadelerin tam tersi&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;\s: Boşluk (White&lt;em&gt;s&lt;/em&gt;pace) karakteri: &lt;code&gt;[\f\t\r\n ]&lt;/code&gt;&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Gruplamak için () kullanılır, bunlara referans vermek için /1, /2 gibi
referans numarası.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Or: /(fred) /1/ ifadesi &amp;ldquo;fred fred&amp;rdquo; ile eşleşir.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;| operatörü: (Alternating op.) Veya anlamında kullanılır. (fred|wilma),
&amp;ldquo;fred&amp;rdquo;  ve &amp;ldquo;wilma&amp;rdquo; sözcükleriyle eşleşir.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Çapa operatörleri: Bir ifadenin ana dizideki yerini belirtmek için
kullanılır.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;^: Satır başı,
$: Satır sonu,
\b: Sözcük sınırı (word &lt;em&gt;b&lt;/em&gt;oundary): Sözcük başlarını ve sonlarını bulur.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Yineleme operatörleri:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;*: Önceki karakter ya da grup 0 veya daha fazla kez tekrar edilir.&lt;/li&gt;
&lt;li&gt;+: Önceki karakter ya da grup en az bir kez tekrar edilir.&lt;/li&gt;
&lt;li&gt;{i,j}: Önceki karakter en az i, en fazla j kez tekrar edilir.&lt;/li&gt;
&lt;li&gt;{i,}: Önceki karakter en az i kez tekrar edilir.&lt;/li&gt;
&lt;li&gt;?: Önceki karakter 0 ya da 1 kez tekrar edilir.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Joker karakterler:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;. : Yeni satır karakteri dışında her karakter ile eşleşir.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Ters seçim karakteri (negation): Köşeli parantezler içerisinde (sınıf
operasyonu) ters seçim yapar. [&lt;sup&gt;a]&lt;/sup&gt; a karakteri dışında her karakter ile
eşleşir.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Kaçış (escape) karakterleri: ., () gibi karakterlerin özel anlamı olduğu için,
bu karakterler ile eşleşme yapılmak istendiğinde \ ifadesi karakterin önüne
eklenir. Or: . ifadesi . karakteri ile eşleşir.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Eşleştirme ve değiştirme operatörleri: Varsayılan operatör eşleştirme (match)
operatörüdür. Bu nedenle m/abc/ ile /abc ifadeleri aynıdır. Ayırıcı olarak /
ifadesi yerine başka bir ifade kullanılabilir. m%abc% gibi.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Seçenekler Değişkenleri:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;/i: Büyük harf/ küçük harf ayrımı yapmadan (case-&lt;em&gt;i&lt;/em&gt;nsensitive) arama
yapar. /mer/i ifadesi Merhaba ve merhaba ifadeleri ile eşleşir.&lt;/li&gt;
&lt;li&gt;/s: . ifadesinin yeni satır (\n) karakteri ile de eşleşmesini
sağlar. Böylece tüm metin tek bir satır olarak algılanır. Normal arama satır satır yapılır.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Eşleştirme değişkenleri:
Gruplandırma yapıldıktan sonraki satırlarda gruplara $1, $2 gibi ifadelerle
erişilebilir.&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;Hello there, neighbor&amp;quot;
if (/\s(\w+),/)
print (&amp;quot;the word was $1&amp;quot;)&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;p&gt;işlemi sonucunda ekrana &amp;ldquo;the word was there&amp;rdquo; yazdırılacaktır.&lt;/p&gt;

&lt;p&gt;Bu değişkenler bir sonraki başarılı eşleştirmeye kadar korunur. Dikkat: Son
eşleştirme başarısızsa $1 değişkeni bir önceki eşleştirmenin sonucunu
gösterir.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Otomatik Eşleştirme Değişkenleri&lt;/p&gt;

&lt;p&gt;Kolaylık açısından parantezler kullanılmasa da eşleştirme sonuçları bazı
değişkenlerde saklanır. $&amp;amp; ifadesi aramanın başarılı olan kısmını saklar. $`
ifadesi aranan kelimede, aramanın başarılı olduğu kısımdan önceki kısmını
saklar. $&amp;lsquo; ise eşleşmeden sonraki kısımları saklar.&lt;/p&gt;

&lt;p&gt;Or:&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;Perl 6 mi, Python mu?&amp;quot;;
if /6/{
print $&amp;amp;;
print $`;
print $';
}&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Değişiklik operatörü: Değişiklik yapmak için s// operatörü kullanılır. Yine
aksi belirtilmedikçe $_ değişkeni üzerinde işlem yapar.&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;En sevdiğim karakter Fred.&amp;quot;;
s/Fred/Barney/;
print &amp;quot;$_\n&amp;quot;;
#Kitaptan bir örnek:
$_ = &amp;quot;green scaly dinosaur&amp;quot;;
s/(\w+) (\w+)/$2, $1/; #&amp;quot;scaly, green dinosaur&amp;quot;
s/^/huge, /; #&amp;quot;huge, scaly, green dinosaur&amp;quot;
s/,.*een//; #huge dinosaur
s/green/red/; #huge dinosaur # eşleşme yok, değişlik de yok
s/(\w+)$/($`!)$&amp;amp;/; #huge (huge!) dinosaur&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;/g : Tüm eşlenenleri değiştirmek için /g (&lt;em&gt;g&lt;/em&gt;lobal) bayrağı kullanılır.&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;home, sweet home&amp;quot;;
s/home/cave/g; # &amp;quot;cave, sweet cave&amp;quot;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;\U : uppercase operatörü (\L, \E (end case))&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;split operatörü : Bir diziyi belli bir ayırıcıya göre bir diziye ayırmak için
kullanılır.&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$_ = &amp;quot;abc:def:gef&amp;quot;;
@dizi = split /:/, $_;

$_ = &amp;quot;abc def     gef&amp;quot;;
@dizi = split /(\w+)/, $_;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;p&gt;split operatörü varsayılan olarak yukarıdaki işlemi yapar, $_ ifadesini
boşluklara göre ayırır.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;join operatörü: Split operatörünün tersi&lt;/p&gt;

&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;$result = join $glue, @pieces;
$x = join &amp;quot;$&amp;quot;, 4, 6, 8, 10; # $x = &amp;quot;4$6$8$10&amp;quot;&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;qw operatörü: Boşluklara göre ayıran split operatörüne benzer.&lt;/p&gt;

&lt;p&gt;qw(foo bar baz);&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/33438136"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/33438136#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/-xJ2sPsU0T4" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/33438136</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 22 Jul 2010 12:49:01 -0700</pubDate>
      <title>Using CSS Media Queries to Style Your iPhone and iPad HTML - O'Reilly Broadcast</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/jAEGSyoD1jM/using-css-media-queries-to-style-your-iphone-0</link>
      <guid isPermaLink="false">http://ustunozgur.com/using-css-media-queries-to-style-your-iphone-0</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_short_quote"&gt;Using CSS Media Queries to Style Your iPhone and iPad HTML&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://broadcast.oreilly.com/2010/04/using-css-media-queries-ipad.html"&gt;broadcast.oreilly.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;See also &lt;a href="http://hicksdesign.co.uk/journal/finally-a-fluid-hicksdesign"&gt;http://hicksdesign.co.uk/journal/finally-a-fluid-hicksdesign&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/using-css-media-queries-to-style-your-iphone-0"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/using-css-media-queries-to-style-your-iphone-0#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/jAEGSyoD1jM" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/using-css-media-queries-to-style-your-iphone-0</feedburner:origLink></item>
    <item>
      <pubDate>Mon, 05 Jul 2010 07:31:40 -0700</pubDate>
      <title>Homebrew — MacPorts driving you to drink? Try Homebrew!</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/OzqQ87Q6SeY/homebrew-macports-driving-you-to-drink-try-ho</link>
      <guid isPermaLink="false">http://ustunozgur.com/homebrew-macports-driving-you-to-drink-try-ho</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_short_quote"&gt;Homebrew is the easiest and most flexible way to install the UNIX tools Apple didn't include with OS X.&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://mxcl.github.com/homebrew/"&gt;mxcl.github.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;I installed the aforementioned proctools using this. We'll see how it fares with macports or fink.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/homebrew-macports-driving-you-to-drink-try-ho"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/homebrew-macports-driving-you-to-drink-try-ho#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/OzqQ87Q6SeY" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/homebrew-macports-driving-you-to-drink-try-ho</feedburner:origLink></item>
    <item>
      <pubDate>Sun, 04 Jul 2010 09:13:35 -0700</pubDate>
      <title>Pgrep and pkill on OS X</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/DkZsaUan6RM/pgrep-and-pkill-on-os-x</link>
      <guid isPermaLink="false">http://ustunozgur.com/pgrep-and-pkill-on-os-x</guid>
      <description>&lt;p&gt;
	Use &lt;a href="http://sourceforge.net/projects/proctools/"&gt;http://sourceforge.net/projects/proctools/&lt;/a&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/pgrep-and-pkill-on-os-x"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/pgrep-and-pkill-on-os-x#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/DkZsaUan6RM" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/pgrep-and-pkill-on-os-x</feedburner:origLink></item>
    <item>
      <pubDate>Tue, 29 Jun 2010 06:46:32 -0700</pubDate>
      <title>Using patches made by git format-patch on non-git repositories</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/N7_3hZEcG7Q/using-patches-made-by-git-format-patch-on-non</link>
      <guid isPermaLink="false">http://ustunozgur.com/using-patches-made-by-git-format-patch-on-non</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_long_quote"&gt;&lt;p&gt;Patches, that &lt;code&gt;git diff&lt;/code&gt; yields, are correctly processed by &lt;code&gt;patch&lt;/code&gt; tool.&lt;/p&gt;

&lt;p&gt;&lt;code&gt;patch&lt;/code&gt; skips all the additional info git appends to the patch file.  To apply the patch you most likely will need &lt;code&gt;-p1&lt;/code&gt; option.&lt;/p&gt;&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://stackoverflow.com/questions/1594477/can-git-format-patch-so-it-can-be-used-with-patch-program"&gt;stackoverflow.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;-p1 option is important.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/using-patches-made-by-git-format-patch-on-non"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/using-patches-made-by-git-format-patch-on-non#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/N7_3hZEcG7Q" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/using-patches-made-by-git-format-patch-on-non</feedburner:origLink></item>
    <item>
      <pubDate>Tue, 29 Jun 2010 04:59:00 -0700</pubDate>
      <title>Sending patches with Git with Gmail</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/t02h2E5lrhg/sending-patches-with-git-with-gmail</link>
      <guid isPermaLink="false">http://ustunozgur.com/sending-patches-with-git-with-gmail</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
&lt;blockquote class="posterous_long_quote"&gt;
&lt;p&gt;If you want to use Git to submit patches via email over secure &lt;a href="http://kbase.wincent.com/old/knowledge-base/Installing_Net::SMTP::SSL_for_sending_patches_with_Git_over_secure_SMTP.html/SMTP.html" title="SMTP"&gt;SMTP&lt;/a&gt; you will need to install the Net::SMTP::SSL module, if you don't have it installed already on your system.&lt;/p&gt;
&lt;div class="CodeRay"&gt;
&lt;div class="code"&gt;
&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;sudo -H cpan Net::SMTP::SSL&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;
&lt;/div&gt;
&lt;/blockquote&gt;
&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://kbase.wincent.com/old/knowledge-base/Installing_Net::SMTP::SSL_for_sending_patches_with_Git_over_secure_SMTP.html"&gt;kbase.wincent.com&lt;/a&gt;
&lt;/div&gt;
&lt;p&gt;Then put the following in .gitconfig:&lt;/p&gt;
&lt;p&gt;[sendemail] &lt;br /&gt; smtpencryption = tls &lt;br /&gt; smtpserver = smtp.gmail.com &lt;br /&gt; smtpuser = &lt;a href="mailto:yourmail@gmail.com"&gt;yourmail@gmail.com&lt;/a&gt; &lt;br /&gt; smtpserverport = 587&lt;/p&gt;
&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/sending-patches-with-git-with-gmail"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/sending-patches-with-git-with-gmail#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/t02h2E5lrhg" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/sending-patches-with-git-with-gmail</feedburner:origLink></item>
    <item>
      <pubDate>Fri, 11 Jun 2010 01:03:29 -0700</pubDate>
      <title>Git Reference</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/-FOKCclBQRw/git-reference-1</link>
      <guid isPermaLink="false">http://ustunozgur.com/git-reference-1</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote&gt;&lt;div&gt;
        &lt;div&gt;
  &lt;h3&gt;Introduction to the Git Reference&lt;/h3&gt;
  &lt;div&gt;
    &lt;p&gt;
    This is the Git reference site. This is meant to be a quick
    reference for learning and remembering the most important and
    commonly used Git commands.  The commands are organized into
    sections of the type of operation you may be trying to do, and
    will preset the common options and commands needed to accomplish
    these common tasks.
    &lt;/p&gt;
    &lt;p&gt;
    Each section will link to the next section, so it can be used
    as a tutorial.  Every page will also link to more in-depth
    Git documentation such as the offical manual pages and relevant
    sections in the &lt;a href="http://progit.org"&gt;Pro Git book&lt;/a&gt;, 
    so you can learn more about any of 
    the commands. First, we'll start with thinking about source code 
    management like Git does.
    &lt;/p&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;div&gt;
  &lt;h3&gt;How to Think Like Git&lt;/h3&gt;
  &lt;div&gt;
    &lt;p&gt;
    This first thing that is important to understand about Git is
    that it thinks about version control very differently than 
    Subversion or Perforce or whatever SCM you may be used to. It
    is often easier to learn Git by trying to forget your assumptions
    about how version control works and try to think about it in the
    Git way.
    &lt;/p&gt;

    &lt;p&gt;
    Let's start from scratch.  Assume you are designing a new source 
    code management system.  How do you do basic version control before
    you used a tool for it?  Chances are that you simply copied your 
    project directory to save what it looked like at that point.
    &lt;/p&gt;

    &lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;1 $ cp -R project project.bak&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;


    &lt;p&gt;
    That way, you can easily revert files that get messed up later, or 
    see what you have changed by comparing what the project looks like
    now to what it looked like when you copied it.
    &lt;/p&gt;

    &lt;p&gt;
    If you are really paranoid, you may do this often, maybe putting the
    date in the name of the backup:
    &lt;/p&gt;

    &lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;1 $ cp -R project project.2010-06-01.bak&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;


    &lt;p&gt;
    In that case, you may have a bunch of snapshots of your project that 
    you can compare and inspect from. You can even use this model to 
    fairly effectively share changes with someone.  If you zip up your
    project at a known state and put it on your website, other developers
    can download that, change it and send you a patch pretty easily.
    &lt;/p&gt;

    &lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;div class="CodeRay"&gt;
  &lt;div class="code"&gt;&lt;pre&gt;1 $ wget http://sample.com/project.2010-06-01.zip
2  $ unzip project.2010-06-01.zip
3  $ cp -R project.2010-06-01 project-my-copy
4  $ unzip project.2010-06-01.zip
5  $ cd project-my-copy
6  $ (change something)
7  $ diff project-my-copy project.2010-06-01 &amp;gt; change.patch
8  $ (email change.patch)&lt;/pre&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;


    &lt;p&gt;
    Now the original developer can apply that patch to their copy of the
    project and they have your changes. This is how many open source 
    projects have been collaborated on for several years.
    &lt;/p&gt;

    &lt;p&gt;
    This actually works fairly well, so let's say we want to write a tool
    to make this basic process faster and easier.  Instead of writing a tool
    that versions each file individually, like Subversion, we would probably
    write one that makes it easier to store snapshots of our project without
    having to copy the whole directory each time.
    &lt;/p&gt;

    &lt;p&gt;
    This is essentially what Git is. You tell Git you want to save a snapshot
    of your project with the &lt;code&gt;git commit&lt;/code&gt; command and it basically 
    records a manifest of what all of the files in your project look like at 
    that point.  Then most of the commands work with those manifests to see
    how they differ or pull content out of them, etc.  
    &lt;/p&gt;

    &lt;center&gt;&lt;img src="http://gitref.org/images/snapshots.png" height="151" width="500" /&gt;&lt;/center&gt;

    &lt;p&gt;
    If you think about Git
    as a tool for storing and comparing and merging snapshots of your project,
    it may be easier to understand what is going on and how to do things 
    properly.
    &lt;/p&gt;

  &lt;/div&gt;
&lt;/div&gt;

&lt;p&gt;&lt;a href="http://gitref.org#"&gt;On to Getting and Creating Projects »&lt;/a&gt;&lt;/p&gt;

      &lt;/div&gt;&lt;/blockquote&gt;&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://gitref.org/"&gt;gitref.org&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;From the author of the book ProGit.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/git-reference-1"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/git-reference-1#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/-FOKCclBQRw" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/git-reference-1</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 10 Jun 2010 04:32:35 -0700</pubDate>
      <title>Calendar World Cup 2010 by MARCA.com</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/h0Fpg234edU/calendar-world-cup-2010-by-marcacom-2</link>
      <guid isPermaLink="false">http://ustunozgur.com/calendar-world-cup-2010-by-marcacom-2</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;object type="application/futuresplash" align="middle" height="422" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="500" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0"&gt;
&lt;param name="allowScriptAccess" value="always" /&gt;
&lt;param name="allowfullscreen" value="true" /&gt;
&lt;param name="movie" value="http://estaticos.marca.com/multimedia/graficos/futbol/2010/mundial/calendariomundialingles.swf" /&gt;
&lt;param name="quality" value="high" /&gt;
&lt;param name="bgcolor" value="#B7A98C" /&gt;
&lt;embed pluginspage="http://www.macromedia.com/go/getflashplayer" allowfullscreen="true" src="http://estaticos01.marca.com/multimedia/graficos/futbol/2010/mundial/calendariomundialingles.swf" type="application/futuresplash" allowscriptaccess="sameDomain" height="422" align="middle" quality="high" width="500"&gt;
&lt;/embed&gt;&lt;/object&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://www.marca.com/deporte/futbol/mundial/sudafrica-2010/calendario-english.html"&gt;marca.com&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;Flash gerektirse de guzel.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/calendar-world-cup-2010-by-marcacom-2"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/calendar-world-cup-2010-by-marcacom-2#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/h0Fpg234edU" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/calendar-world-cup-2010-by-marcacom-2</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 10 Jun 2010 03:39:06 -0700</pubDate>
      <title>Matematik Dünyası Aboneliği</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/U-p9b2QH-qs/matematik-dunyas-aboneligi</link>
      <guid isPermaLink="false">http://ustunozgur.com/matematik-dunyas-aboneligi</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_long_quote"&gt;112 sayfalık Matematik Dünyası dergisinin fiyatı yıllardan beri 5 YTL. Maliyetimizi &lt;a href="http://www.matematikdunyasi.org/arsiv/PDF/08_3_9_9_MALIYET.pdf"&gt;http://www.matematikdunyasi.org/arsiv/PDF/08_3_9_9_MALIYET.pdf &lt;/a&gt;sayfasinda bulabilirsiniz. Derginin fiyatını artırmamak için direniyoruz. Ama daha ne kadar direnebileceğiz?
“Kurumsal destek” diye bir şey ortaya attık. Ayda 500 TL’lik destek karşılığı kurumların dergide ve internet sayfamızda reklamlarını yapacaktık… Olmadı. Hiç rağbet görmedi.&lt;br /&gt;
Yeni çözümler peşindeyiz. Zenginden değil, hali vakti hallice olandan alıp fakir öğrenciye vermek gibi bir fikir geliştirdik. Derginin fiyatının artmaması, dolayısıyla daha çok gencin dergiye ulaşabilmesi için “platin, altın, gümüş ve bronz abonelik” sistemi getiriyoruz. Bu da başarılı olmazsa dergiye üzülerek zam yapmak zorunda kalacağız.&lt;br /&gt;
• Platin abonelik 100 TL&lt;br /&gt;
• Altın abonelik 75 TL&lt;br /&gt;
• Gümüş abonelik 50 TL&lt;br /&gt;
• Bronz abonelik 25 TL&lt;br /&gt;
• Normal abonelik 16 TL&lt;br /&gt;
Abonelik için &lt;a href="http://www.matematikdunyasi.org/abonelik/"&gt;tıklayın&lt;/a&gt;. Desteğinizden yararlanacak gençler adına çok teşekkür ederiz.&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://www.md.math.bilgi.edu.tr/"&gt;md.math.bilgi.edu.tr&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/matematik-dunyas-aboneligi"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/matematik-dunyas-aboneligi#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/U-p9b2QH-qs" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/matematik-dunyas-aboneligi</feedburner:origLink></item>
    <item>
      <pubDate>Thu, 10 Jun 2010 03:25:59 -0700</pubDate>
      <title>Ali Nesin'den TÜBİTAK Başkanı'na açık mektup</title>
      <link>http://feedproxy.google.com/~r/ustunozgur/~3/0gA8BuOKkKo/ali-nesinden-tUbItak-baskanna-ack-mektup</link>
      <guid isPermaLink="false">http://ustunozgur.com/ali-nesinden-tUbItak-baskanna-ack-mektup</guid>
      <description>&lt;p&gt;
	&lt;div class="posterous_bookmarklet_entry"&gt;
      &lt;blockquote class="posterous_long_quote"&gt;&lt;p align="left"&gt;&lt;strong&gt;TÜBİTAK  Başkanı Sayın Prof. Dr. Nüket Yetiş’e Açık Mektup&lt;/strong&gt;&lt;br /&gt;
                      &lt;/p&gt;
                      &lt;p&gt;Sayın  Prof. Dr. Nüket Yetiş,&lt;br /&gt;
                        Sorumlusu  olduğunuz TÜBİTAK’tan şikâyetçiyim. Sadece ben değil, matematikçi ya da değil,  tanıdığım herkes şikâyetçi. Ben kendi dertlerimi size anlatmak istiyorum. Eğer  isterseniz diğerlerinin dertlerini kendilerine sorup dinlersiniz.&lt;/p&gt;
                      &lt;p&gt;Sayın  Prof. Dr. Nüket Yetiş,&lt;br /&gt;
                        Basından mutlaka  takip etmişsinizdir: 2007 yılında Şirince’de dağ başında, Nesin Vakfı  bünyesinde bir “Matematik Köyü” kurduk. Kereste, taş, çamur ve samandan  yapılmış geleneksel tarzda evleriyle, taş kaplanmış avluları ve daracık serin  sokaklarıyla, çardakları, amfitiyatrosu, sadeliği ve içtenliğiyle, herkesin ilk  bakışta âşık olduğu dünya güzeli yemyeşil bir köy oldu.&lt;/p&gt;&lt;p&gt;
                        
                        Halkımızın maddi  katkısı ve emeğiyle kurduk bu köyü. Çoluk çocuk ve gönüllüler çalıştı  inşaatında. Tam bir imece ürünü. Başka türlüsü de olamazdı zaten, biz günü  gününe yaşayan mütevazı bir vakıfız.&lt;br /&gt;
                        Hiçbir maddi  çıkar gütmeden bireysel çabalarımla 1998’ten beri her yaz düzenlediğim  matematik yazokullarını artık Matematik Köyü’nde yapıyorum. Her yaz 500  dolayında liseli ve üniversiteli genç Matematik Köyü’nde dünya çapında  matematikçilerle ve olağanüstü bir matematikle tanışıyor. Söylemeye gerek var  mı? Bu öğrencilerin büyük çoğunluğu dar gelirli ya da yoksul.&lt;/p&gt;&lt;p&gt;
                        
                        Dünyanın her  yerinde böyle bir girişim devlet tarafından desteklenir. Biz de projelerimizi  desteklemesi için doğal olarak TÜBİTAK’a başvuruyoruz. Bu yıl da 11 yazokulu  projemizin 7’sine maddi destek vermesi için TÜBİTAK’a başvurduk. Tüm  projelerimizi desteklemeyeceğini deneyimle bildiğimizden, sunduğumuz projelerin  iki ya da üçünü desteklerse, bu destekle diğer projelerimizi de  yürütebileceğimizi düşündük.&lt;/p&gt;&lt;p&gt;
                        
                        TÜBİTAK, 7  projemizin 7’sini de reddetti!&lt;/p&gt;&lt;/blockquote&gt;

&lt;div class="posterous_quote_citation"&gt;via &lt;a href="http://www.md.math.bilgi.edu.tr/"&gt;md.math.bilgi.edu.tr&lt;/a&gt;&lt;/div&gt;
    &lt;p&gt;Mektubun tamamini okumanizi oneririm.&lt;/p&gt;&lt;/div&gt;
	
&lt;/p&gt;

&lt;p&gt;&lt;a href="http://ustunozgur.com/ali-nesinden-tUbItak-baskanna-ack-mektup"&gt;Permalink&lt;/a&gt; 

	| &lt;a href="http://ustunozgur.com/ali-nesinden-tUbItak-baskanna-ack-mektup#comment"&gt;Leave a comment&amp;nbsp;&amp;nbsp;&amp;raquo;&lt;/a&gt;

&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/ustunozgur/~4/0gA8BuOKkKo" height="1" width="1"/&gt;</description>
      <posterous:author>
        <posterous:userImage>http://files.posterous.com/user_profile_pics/472252/aphextwin_logo.gif</posterous:userImage>
        <posterous:profileUrl>http://posterous.com/users/3sifrI9kkoA9</posterous:profileUrl>
        <posterous:firstName>Üstün</posterous:firstName>
        <posterous:lastName>Özgür</posterous:lastName>
        <posterous:nickName>ustunozgur</posterous:nickName>
        <posterous:displayName>Üstün Özgür</posterous:displayName>
      </posterous:author>
    <feedburner:origLink>http://ustunozgur.com/ali-nesinden-tUbItak-baskanna-ack-mektup</feedburner:origLink></item>
  </channel>
</rss>

