{"id":13924,"date":"2025-08-16T09:22:21","date_gmt":"2025-08-16T06:22:21","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=13924"},"modified":"2025-08-16T11:58:20","modified_gmt":"2025-08-16T08:58:20","slug":"sqlite-nedir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/sqlite-nedir\/","title":{"rendered":"SQLite Nedir? Nas\u0131l Kurulur?"},"content":{"rendered":"<p>\u015e\u00f6yle bir hayal et: Ufak bir uygulama yaz\u0131yorsun, belki bir masa\u00fcst\u00fc uygulamas\u0131, belki bir mobil app&#8230; Ama i\u015fin veri k\u0131sm\u0131na geldi\u011finde dev sunucular, kar\u0131\u015f\u0131k kurulumlar, port ayarlar\u0131 seni bo\u011fuyor. \u0130\u015fte tam bu noktada <strong>SQLite<\/strong> devreye giriyor: kurulumu basit, kullan\u0131m\u0131 pratik ve dosya kadar ta\u015f\u0131nabilir.<\/p>\n<p>Bu yaz\u0131da SQLite nedir, nas\u0131l kurulur, ne gibi avantajlar\u0131 ve dezavantajlar\u0131 vard\u0131r onlardan bahsedece\u011fiz.<\/p>\n<h2>SQLite Nedir?<\/h2>\n<p>SQLite ili\u015fkisel bir veritaban\u0131 sistemidir ama di\u011ferlerinden \u00e7ok farkl\u0131d\u0131r. \u00c7\u00fcnk\u00fc ortada ne bir <a href=\"https:\/\/www.inetmar.com\/sunucu\/vds-sunucu\/\" target=\"_blank\" rel=\"noopener\">veritaban\u0131 sunucusu<\/a> vard\u0131r, ne de kar\u0131\u015f\u0131k ba\u011flant\u0131 ayarlar\u0131. Her \u015fey tek bir <code>.db<\/code> dosyas\u0131n\u0131n i\u00e7inde d\u00f6ner.<br \/>\nBu ne demek?<\/p>\n<ul>\n<li>Uygulaman yan\u0131nda veritaban\u0131n\u0131 da ta\u015f\u0131yabilir,<\/li>\n<li>An\u0131nda \u00e7al\u0131\u015fmaya ba\u015flayabilirsin,<\/li>\n<li>Hatta internet ba\u011flant\u0131s\u0131na bile ihtiyac\u0131n olmaz.<\/li>\n<\/ul>\n<h2>SQLite Kurulumu<\/h2>\n<p>Kurulum dedi\u011fime bakma asl\u0131nda sadece birka\u00e7 dosya indirip do\u011fru yere koyuyorsun. \u0130\u015fletim sistemine g\u00f6re anlatay\u0131m. \u0130lk olarak en yayg\u0131n kullan\u0131lan sistemle ba\u015flayal\u0131m:<\/p>\n<h3>Windows SQLite Kurulumu<\/h3>\n<ol>\n<li><strong>Gerekli Dosyay\u0131 \u0130ndir:<\/strong><br \/>\n<a href=\"https:\/\/www.sqlite.org\/download.html\" target=\"_blank\" rel=\"nofollow noopener\">SQLite Download<\/a> adresine girip &#8220;sqlite-tools-win32-x86-*.zip&#8221; dosyas\u0131n\u0131 indirin.<\/li>\n<li><strong>Dosyalar\u0131 Uygun Bir Klas\u00f6re Ta\u015f\u0131:<\/strong><br \/>\n<code>C:\\sqlite<\/code> ad\u0131nda bir klas\u00f6r olu\u015fturup ZIP dosyas\u0131n\u0131 buraya \u00e7\u0131kar\u0131n. \u0130\u00e7inde <code>sqlite3.exe<\/code> dosyas\u0131 olmal\u0131.<\/li>\n<li><strong>Ortam De\u011fi\u015fkenine Ekle:<\/strong><br \/>\nBa\u015flat men\u00fcs\u00fcnden <em>\u201cOrtam De\u011fi\u015fkenlerini D\u00fczenle\u201d<\/em> yaz\u0131p \u00e7\u0131kan se\u00e7ene\u011fe t\u0131klay\u0131n.<br \/>\nPath de\u011fi\u015fkenine <code>C:\\sqlite<\/code> yolunu ekleyin.<\/li>\n<li><strong>Kurulumu Test Et:<\/strong><br \/>\n<code>C:\\sqlite<\/code> klas\u00f6r\u00fcndeyken adres \u00e7ubu\u011funa <code>cmd<\/code> yaz\u0131p enter\u2019a bas\u0131n. A\u00e7\u0131lan komut istemine <code>sqlite3<\/code> yaz. Versiyon bilgisi geliyorsa i\u015flem tamam.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13926 aligncenter zoooom\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2025\/04\/sqlitekurulum-300x161.png\" alt=\"sqlite kurulumu\" width=\"721\" height=\"387\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2025\/04\/sqlitekurulum-300x161.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2025\/04\/sqlitekurulum-1024x550.png 1024w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2025\/04\/sqlitekurulum-768x413.png 768w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2025\/04\/sqlitekurulum.png 1111w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/p>\n<h3>macOS SQLite Kurulumu<\/h3>\n<p>Cihaz\u0131n\u0131z\u0131n i\u015fletim sistemi macOS ise Terminal\u2019i a\u00e7\u0131p a\u015fa\u011f\u0131daki komutu yaz\u0131n.<\/p>\n<pre><code>sqlite3<\/code><\/pre>\n<p>\u00c7al\u0131\u015fm\u0131yorsa Homebrew kullanarak kurun.<\/p>\n<pre><code>brew install sqlite<\/code><\/pre>\n<h3>Linux (Debian\/Ubuntu)<\/h3>\n<pre><code>sudo apt update\r\nsudo apt install sqlite3<\/code><\/pre>\n<h3>RedHat\/Fedora<\/h3>\n<pre><code>sudo dnf install sqlite<\/code><\/pre>\n<h2>SQLite Avantajlar\u0131<\/h2>\n<ul>\n<li><strong>Kurulum yok gibi:<\/strong> birka\u00e7 dosya indir, kullan.<\/li>\n<li><strong>Sunucu gerekmez:<\/strong> tek ba\u015f\u0131na \u00e7al\u0131\u015f\u0131r.<\/li>\n<li><strong>Performans\u0131 iyi:<\/strong> k\u00fc\u00e7\u00fck ve orta \u00f6l\u00e7ekli projelerde h\u0131zl\u0131d\u0131r.<\/li>\n<li><strong>Dosya tabanl\u0131d\u0131r:<\/strong> veritaban\u0131n bir <code>.db<\/code> dosyas\u0131d\u0131r.<\/li>\n<li><strong>Ta\u015f\u0131nabilir:<\/strong> dosyay\u0131 ba\u015fka yere kopyala, \u00e7al\u0131\u015ft\u0131r.<\/li>\n<li><strong>\u00dccretsiz ve a\u00e7\u0131k kaynak:<\/strong> lisans derdi yok.<\/li>\n<\/ul>\n<h2>SQLite Dezavantajlar\u0131<\/h2>\n<ul>\n<li><strong>\u00c7oklu kullan\u0131c\u0131 deste\u011fi s\u0131n\u0131rl\u0131:<\/strong> e\u015f zamanl\u0131 eri\u015fimde sorun \u00e7\u0131kabilir.<\/li>\n<li><strong>Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc sorunlar\u0131:<\/strong> y\u00fcksek trafik ve paralel i\u015flemlerde s\u0131k\u0131nt\u0131 olabilir.<\/li>\n<li><strong>Sunucu mimarisi yok:<\/strong> geli\u015fmi\u015f yetkilendirme veya uzaktan eri\u015fim yok.<\/li>\n<li><strong>S\u0131n\u0131rl\u0131 veri tipi deste\u011fi:<\/strong> karma\u015f\u0131k veri t\u00fcrlerinde yetersiz kalabilir.<\/li>\n<\/ul>\n<h2>SQLite Ne Zaman Kullan\u0131l\u0131r?<\/h2>\n<p>SQLite tam bir \u201cgerekti\u011fi yerde m\u00fckemmel\u201d teknolojidir. Basit uygulamalar, prototip geli\u015ftirmeler, mobil uygulamalar, e\u011fitim ama\u00e7l\u0131 projeler gibi senaryolarda harikad\u0131r. Ama b\u00fcy\u00fck \u00f6l\u00e7ekli, \u00e7ok kullan\u0131c\u0131ya sahip sistemlerde yetersiz kalabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u015e\u00f6yle bir hayal et: Ufak bir uygulama yaz\u0131yorsun, belki bir masa\u00fcst\u00fc uygulamas\u0131, belki bir mobil app&#8230; Ama i\u015fin veri k\u0131sm\u0131na geldi\u011finde dev sunucular, kar\u0131\u015f\u0131k kurulumlar, port ayarlar\u0131 seni bo\u011fuyor. \u0130\u015fte tam bu noktada SQLite devreye&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":13932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-13924","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/13924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=13924"}],"version-history":[{"count":9,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/13924\/revisions"}],"predecessor-version":[{"id":13938,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/13924\/revisions\/13938"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/13932"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=13924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=13924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=13924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}