{"id":8684,"date":"2016-10-11T15:29:32","date_gmt":"2016-10-11T13:29:32","guid":{"rendered":"https:\/\/ihs.com.tr\/blog\/?p=8684"},"modified":"2016-10-11T15:29:32","modified_gmt":"2016-10-11T13:29:32","slug":"sqlite-mi-mysql-mi","status":"publish","type":"post","link":"https:\/\/www.ihs.com.tr\/blog\/sqlite-mi-mysql-mi\/","title":{"rendered":"SQLite m\u0131 MySQL mi?"},"content":{"rendered":"

SQLite ondan faydalanan uygulaman\u0131n i\u00e7ine g\u00f6m\u00fcl\u00fc olarak yerle\u015ftirilen bir k\u00fct\u00fcphanedir. Her t\u00fcrl\u00fc verinin i\u015flenebilmesini sa\u011flayan birtak\u0131m faydal\u0131 ara\u00e7 sunar. \u00c7al\u0131\u015fmak i\u00e7in ba\u015fka bir programa ihtiya\u00e7 duymayan, m\u00fcstakil ve dosya tabanl\u0131 bir veritaban\u0131 olan SQLite bu bak\u0131mdan MySQL gibi host edilen alternatifleriyle kar\u015f\u0131la\u015ft\u0131r\u0131labilir.<\/span><\/p>\n

Desteklenen Veri \u00c7e\u015fitleri<\/span><\/strong><\/p>\n

SQLite BLOB, NULL, INTEGER ve TEXT\u2019i desteklerken, MySQL NUMERIC, DATE, DATETIME, TIMESTAMP, NTINYTEXT, BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, TIME, YEAR, CHAR, VARCHAR, TINYBLOB, TINYINT, SMALLINT, MEDIUMINT, INT or INTEGER, BIGINT, FLOAT, DOUBLE, DOUBLE DECIMAL, LONGBLOB, LONGTEXT, PRECISION, REAL, ENUM ve SET\u2019i destekler. SQLite ve MySQL\u2019in kendilerine \u00f6zg\u00fc farkl\u0131 avantajlar\u0131 vard\u0131r.<\/span><\/p>\n

SQLite dosya tabanl\u0131d\u0131r. Veritaban\u0131 hard disk i\u00e7erisindeki tek bir dosyadan olu\u015fur. Bu da SQLite\u2019\u0131 olduk\u00e7a g\u00fcvenli ve ta\u015f\u0131nabilir k\u0131lan bir \u00f6zelliktir. Her ne kadar \u201cbasit\u201d bir veritaban\u0131 uygulamas\u0131 gibi g\u00f6r\u00fcnse de, SQLite\u2019ta SQL kullan\u0131l\u0131r. Dolay\u0131s\u0131yla\u00a0hem geli\u015ftirme hem de test i\u00e7in olduk\u00e7a elveri\u015flidir ve geli\u015ftirme s\u00fcreci i\u00e7in gerekenden \u00e7ok daha fazlas\u0131n\u0131 sunar.<\/span><\/p>\n

\"MySQL\"<\/p>\n

\u00d6te yandan, MySQL\u2019le \u00e7al\u0131\u015fmas\u0131 da \u00e7ok kolayd\u0131r. \u00d6rne\u011fin, MySQL \u00e7ok basit bir \u015fekilde kurulabilir, bir\u00e7ok iyi \u00f6zelli\u011fe sahiptir ve \u00fc\u00e7\u00fcnc\u00fc parti veritabanlar\u0131 sayesinde ba\u015flang\u0131\u00e7 a\u015famas\u0131nda b\u00fcy\u00fck kolayl\u0131klar sunar. Bir RDBMS\u2019ten beklenen hemen t\u00fcm SQL i\u015flevselli\u011fini sunar. Bir hayli g\u00fcvenlidir ve ayn\u0131 zamanda olduk\u00e7a da geli\u015fmi\u015ftir. B\u00fcy\u00fck miktarda veriyi i\u015fleyebildi\u011fi i\u00e7in her t\u00fcrl\u00fc \u00f6l\u00e7ekte kullan\u0131labilir. H\u0131z s\u00f6z konusu oldu\u011fu zaman da gayet verimli ve rand\u0131manl\u0131 bir \u015fekilde \u00e7al\u0131\u015f\u0131r.<\/span><\/p>\n

Dezavantajlar\u0131<\/span><\/strong><\/p>\n

Kullan\u0131c\u0131 y\u00f6netimi olmamas\u0131:<\/strong> \u0130leri seviye veritabanlar\u0131 i\u00e7in kullan\u0131c\u0131 deste\u011fi \u00f6nemli \u00f6nceliklerden biridir. SQLite bu tip \u00f6zellikleri desteklemez.<\/span><\/p>\n

Ayarlar\u0131n\u0131n performans\u0131 artt\u0131racak \u015fekilde yap\u0131lamamas\u0131:<\/strong> Tasar\u0131m s\u00f6z konusu oldu\u011funda, SQLite\u2019ta daha y\u00fcksek performans i\u00e7in gerekli ayarlar\u0131n yap\u0131labilme \u00f6zelli\u011fi bulunmamaktad\u0131r. K\u00fct\u00fcphanesinin ince ayarlar\u0131 ve kullan\u0131m\u0131 olduk\u00e7a basittir fakat performans\u0131 artt\u0131racak \u015fekilde ayar yapma se\u00e7ene\u011fi sunmaz.<\/span><\/p>\n

G\u00fcvenilirlik:<\/strong> Tasar\u0131m\u0131 gere\u011fi MySQL her \u015feyi yapacak \u015fekilde geli\u015ftirilmemi\u015ftir, fakat baz\u0131 son teknoloji \u00fcr\u00fcn\u00fc uygulamalar\u0131n gerektirdi\u011fi i\u015flevsel \u00f6zellikleri sunar. MySQL RDBMS\u2019lere g\u00f6re biraz daha az g\u00fcvenilirdir. MySQL bir a\u00e7\u0131k kaynak \u00fcr\u00fcn\u00fcd\u00fcr ama geli\u015ftirme s\u00fcreciyle ilgili baz\u0131 \u015fikayetlere de neden olmaktad\u0131r.<\/span><\/p>\n

Hangisi, Ne Zaman Kullan\u0131l\u0131r?<\/span><\/strong><\/p>\n

SQLite’\u0131n ve MySQL\u2019in ne zaman kullan\u0131laca\u011f\u0131na dair birtak\u0131m sorular bulunmaktad\u0131r. A\u015fa\u011f\u0131da bu sorular\u0131n yan\u0131tlar\u0131 bulunmakta.<\/span><\/p>\n

SQLite Ne Zaman Kullan\u0131l\u0131r?<\/span><\/strong><\/p>\n

– Uygulamalar\u0131n ta\u015f\u0131nabilir olmas\u0131 gerekti\u011fi ve geni\u015fletilmelerine ihtiya\u00e7 olmad\u0131\u011f\u0131 durumlarda.<\/span><\/p>\n

– Uygulamalar\u0131n dosyalar\u0131 do\u011frudan okumas\u0131 veya diske yazmas\u0131 gerekti\u011fi durumlarda.<\/span><\/p>\n

MySQL Ne zaman kullan\u0131l\u0131r?<\/span><\/strong><\/p>\n

– Veriye eri\u015fim i\u00e7in \u00fcst d\u00fczey g\u00fcvenlik \u00f6zelliklerinin olmas\u0131 gerekti\u011fi durumlarda.<\/span><\/p>\n

– Web<\/a> sitelerinin baz\u0131 k\u0131s\u0131tlamalar olmas\u0131na ra\u011fmen MySQL\u2019de \u00e7al\u0131\u015fmas\u0131 gerekti\u011fi durumlarda. MySQL y\u00f6netimi kolay, \u00f6l\u00e7eklendirilebilir bir ara\u00e7t\u0131r.<\/span><\/p>\n

Dolay\u0131s\u0131yla SQLite da MySQL de kendi ni\u015fleri i\u00e7in uygun, kendilerine has \u00f6zellikleri olan veritabanlar\u0131d\u0131r.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

SQLite ondan faydalanan uygulaman\u0131n i\u00e7ine g\u00f6m\u00fcl\u00fc olarak yerle\u015ftirilen bir k\u00fct\u00fcphanedir. Her t\u00fcrl\u00fc verinin i\u015flenebilmesini sa\u011flayan birtak\u0131m faydal\u0131 ara\u00e7 sunar. \u00c7al\u0131\u015fmak i\u00e7in ba\u015fka…<\/p>\n","protected":false},"author":3,"featured_media":8686,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-haberler"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/posts\/8684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=8684"}],"version-history":[{"count":3,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/posts\/8684\/revisions"}],"predecessor-version":[{"id":8696,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/posts\/8684\/revisions\/8696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/media\/8686"}],"wp:attachment":[{"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=8684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=8684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ihs.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=8684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}