{"id":18946,"date":"2025-04-23T04:45:16","date_gmt":"2025-04-23T01:45:16","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sqlite-ve-python-ile-paylasimsiz-dagitik-kuyruk-olusturma\/"},"modified":"2025-04-23T04:45:16","modified_gmt":"2025-04-23T01:45:16","slug":"sqlite-ve-python-ile-paylasimsiz-dagitik-kuyruk-olusturma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sqlite-ve-python-ile-paylasimsiz-dagitik-kuyruk-olusturma\/","title":{"rendered":"SQLite ve Python ile Payla\u015f\u0131ms\u0131z Da\u011f\u0131t\u0131k Kuyruk Olu\u015fturma"},"content":{"rendered":"

<\/p>\n

SQLite ve Python ile Payla\u015f\u0131ms\u0131z Da\u011f\u0131t\u0131k Kuyruk Olu\u015fturma<\/p>\n

Merhaba! Bu makalede, SQLite ve Python kullanarak basit ama etkili bir payla\u015f\u0131ms\u0131z da\u011f\u0131t\u0131k kuyruk nas\u0131l olu\u015fturabilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. Payla\u015f\u0131ms\u0131z mimari, her i\u015f\u00e7inin kendi veritaban\u0131na sahip oldu\u011fu ve merkezi bir veritaban\u0131 ihtiyac\u0131n\u0131 ortadan kald\u0131rd\u0131\u011f\u0131 i\u00e7in \u00f6l\u00e7eklenebilirlik ve performans a\u00e7\u0131s\u0131ndan \u00f6nemli avantajlar sunar. Bu yakla\u015f\u0131m, \u00f6zellikle kaynak k\u0131s\u0131tl\u0131 ortamlarda veya b\u00fcy\u00fck veri i\u015fleme senaryolar\u0131nda olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

\u00d6ncelikle, payla\u015f\u0131ms\u0131z mimarinin avantajlar\u0131n\u0131 anlayal\u0131m. Bir\u00e7ok i\u015f\u00e7inin tek bir veritaban\u0131n\u0131 payla\u015fmas\u0131, performans darbo\u011fazlar\u0131na ve veritaban\u0131 sunucusuna a\u015f\u0131r\u0131 y\u00fcklenmelere yol a\u00e7abilir. Ancak, her i\u015f\u00e7inin kendi SQLite veritaban\u0131 kullanmas\u0131yla bu sorunlar\u0131 ortadan kald\u0131r\u0131r\u0131z. Bu durum, daha y\u00fcksek performans ve daha iyi \u00f6l\u00e7eklenebilirlik sa\u011flar. Ayr\u0131ca, bir i\u015f\u00e7inin \u00e7\u00f6kmesi di\u011ferlerini etkilemez, sistemin genel kararl\u0131l\u0131\u011f\u0131n\u0131 art\u0131r\u0131r.<\/p>\n

Sistem Mimarisi<\/h2>\n

Sistemimizde, her bir i\u015f\u00e7i kendi SQLite veritaban\u0131n\u0131 kullanarak g\u00f6revleri s\u0131raya alacak ve i\u015fleyecektir. \u0130\u015f\u00e7iler aras\u0131nda koordinasyon olmayacak; sistemin tamam\u0131 ba\u011f\u0131ms\u0131z \u00e7al\u0131\u015fan i\u015f\u00e7ilerden olu\u015facakt\u0131r. Yeni bir g\u00f6rev eklemek i\u00e7in yeni bir i\u015f\u00e7i ba\u015flat\u0131l\u0131r veya var olan i\u015f\u00e7ilerden biri yeni g\u00f6revleri i\u015flemeyi \u00fcstlenir. Bu yakla\u015f\u0131m, basitli\u011fi ve \u00f6l\u00e7eklenebilirli\u011fi nedeniyle tercih edilir.<\/p>\n

Python ve SQLite ile Uygulama<\/h2>\n

\u015eimdi, Python ve SQLite kullanarak da\u011f\u0131t\u0131k kuyru\u011fumuzun temel i\u015flevlerini ger\u00e7ekle\u015ftirelim. A\u015fa\u011f\u0131daki kod, yeni bir g\u00f6rev ekleme ve kuyruktan g\u00f6rev alma i\u015flemlerini g\u00f6stermektedir:<\/p>\n

\nimport sqlite3\nimport uuid\nimport os\n\ndef create_queue(db_path):\n    conn = sqlite3.connect(db_path)\n    cursor = conn.cursor()\n    cursor.execute('''\n        CREATE TABLE IF NOT EXISTS tasks (\n            id TEXT PRIMARY KEY,\n            task TEXT\n        )\n    ''')\n    conn.commit()\n    conn.close()\n\n\ndef add_task(db_path, task):\n    conn = sqlite3.connect(db_path)\n    cursor = conn.cursor()\n    task_id = str(uuid.uuid4())\n    cursor.execute(\"INSERT INTO tasks (id, task) VALUES (?, ?)\", (task_id, task))\n    conn.commit()\n    conn.close()\n    return task_id\n\ndef get_task(db_path):\n    conn = sqlite3.connect(db_path)\n    cursor = conn.cursor()\n    cursor.execute(\"SELECT id, task FROM tasks LIMIT 1\")\n    task = cursor.fetchone()\n    if task:\n        task_id, task_data = task\n        cursor.execute(\"DELETE FROM tasks WHERE id = ?\", (task_id,))\n        conn.commit()\n        conn.close()\n        return task_data\n    else:\n        conn.close()\n        return None\n\n# \u00d6rnek Kullan\u0131m\ndb_path = \"tasks.db\"\ncreate_queue(db_path)\nadd_task(db_path, \"G\u00f6rev 1\")\nadd_task(db_path, \"G\u00f6rev 2\")\nprint(get_task(db_path)) # G\u00f6rev 1'i d\u00f6nd\u00fcr\u00fcr\nprint(get_task(db_path)) # G\u00f6rev 2'yi d\u00f6nd\u00fcr\u00fcr\n\n<\/code><\/pre>\n
Bu kod,  her i\u015f\u00e7inin kendi tasks.db dosyas\u0131n\u0131 kullanarak g\u00f6revleri y\u00f6netmesini sa\u011flar.  Her i\u015f\u00e7i bu fonksiyonlar\u0131 \u00e7a\u011f\u0131rarak g\u00f6rev ekleyebilir ve i\u015fleyebilir.<\/p>\n
\u00d6l\u00e7eklenebilirlik ve Performans<\/h2>\n
Bu payla\u015f\u0131ms\u0131z mimari, \u00f6l\u00e7eklenebilirli\u011fi \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r.  Yeni i\u015f\u00e7iler ekleyerek sistemin i\u015flem kapasitesini kolayca art\u0131rabiliriz. Ayr\u0131ca, her i\u015f\u00e7inin ba\u011f\u0131ms\u0131z \u00e7al\u0131\u015fmas\u0131, bir i\u015f\u00e7inin ba\u015far\u0131s\u0131zl\u0131\u011f\u0131n\u0131n di\u011ferlerini etkilememesini sa\u011flar. Sistemin genel kararl\u0131l\u0131\u011f\u0131 ve sa\u011flaml\u0131\u011f\u0131 da bu sayede korunmu\u015f olur.   SQLite’\u0131n hafif yap\u0131s\u0131 da performans\u0131 olumlu y\u00f6nde etkiler.<\/p>\n
Sonu\u00e7<\/h2>\n
Bu makalede, SQLite ve Python kullanarak basit ve etkili bir payla\u015f\u0131ms\u0131z da\u011f\u0131t\u0131k kuyruk olu\u015fturmay\u0131 g\u00f6sterdim. Bu yakla\u015f\u0131m, \u00f6l\u00e7eklenebilirlik ve performans a\u00e7\u0131s\u0131ndan \u00f6nemli avantajlar sunar.  Sisteminizin ihtiya\u00e7lar\u0131na g\u00f6re daha geli\u015fmi\u015f \u00f6zelliklerle zenginle\u015ftirebilirsiniz. \u00d6rne\u011fin, g\u00f6revlerin \u00f6nceliklendirilmesi veya hata y\u00f6netimi gibi.<\/p>\n
Daha fazla bilgi i\u00e7in  fatihsoysal.com<\/a> adresini ziyaret edebilirsiniz.<\/p>\n
Faydal\u0131 bulabilece\u011finiz kaynaklar:<\/p>\n