{"id":106,"date":"2023-09-20T23:19:51","date_gmt":"2023-09-20T17:49:51","guid":{"rendered":"https:\/\/farrukhnaveed.co\/blogs\/?p=106"},"modified":"2023-09-20T23:19:54","modified_gmt":"2023-09-20T17:49:54","slug":"data-ingestion-from-kafka-to-mysql-using-python","status":"publish","type":"post","link":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/","title":{"rendered":"Data Ingestion from Kafka to MySQL using Python"},"content":{"rendered":"\n

In today’s data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.<\/p>\n\n\n\n

Understanding the Components<\/h2>\n\n\n\n

Before we dive into the code, let’s understand the components involved in this process:<\/p>\n\n\n\n

    \n
  1. Kafka<\/strong>: Apache Kafka is a distributed streaming platform that allows you to publish and subscribe to streams of records, store them in a fault-tolerant manner, and process them in real-time. Kafka uses topics to categorize data streams, and producers write data to these topics, which can be consumed by consumers.<\/li>\n\n\n\n
  2. Python<\/strong>: We will use Python, a versatile and widely adopted programming language, to interact with both Kafka and MySQL. The confluent-kafka-python<\/code> library will help us consume data from Kafka, while the mysql-connector-python<\/code> library will allow us to interact with MySQL.<\/li>\n\n\n\n
  3. MySQL<\/strong>: MySQL is an open-source relational database management system known for its speed and reliability. We will store the data ingested from Kafka into a MySQL database table.<\/li>\n<\/ol>\n\n\n\n

    Setting Up the Environment<\/h2>\n\n\n\n

    To get started, make sure you have Kafka and MySQL installed and running. You’ll also need Python installed on your system.<\/p>\n\n\n\n

    Next, install the required Python libraries:<\/p>\n\n\n\n

    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    pip install confluent<\/span>-<\/span>kafka<\/span><\/span>\npip install mysql<\/span>-<\/span>connector<\/span>-<\/span>python<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
    Writing Python Code<\/h2>\n\n\n\n
    Let’s create a Python script to ingest data from Kafka and insert it into MySQL. Below is a step-by-step guide:<\/p>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    from<\/span> confluent_kafka <\/span>import<\/span> Consumer<\/span>,<\/span> KafkaError<\/span><\/span>\nimport<\/span> mysql<\/span>.<\/span>connector<\/span><\/span>\n<\/span>\n# Kafka consumer configuration<\/span><\/span>\nconf <\/span>=<\/span> <\/span>{<\/span><\/span>\n    <\/span>'<\/span>bootstrap.servers<\/span>'<\/span>:<\/span> <\/span>'<\/span>localhost:9092<\/span>'<\/span>,<\/span>  <\/span># Replace with your Kafka broker(s)<\/span><\/span>\n    <\/span>'<\/span>group.id<\/span>'<\/span>:<\/span> <\/span>'<\/span>my-consumer-group<\/span>'<\/span>,<\/span><\/span>\n    <\/span>'<\/span>auto.offset.reset<\/span>'<\/span>:<\/span> <\/span>'<\/span>earliest<\/span>'<\/span>  <\/span># Start from the beginning of the topic<\/span><\/span>\n}<\/span><\/span>\n<\/span>\n# Create a Kafka consumer<\/span><\/span>\nconsumer <\/span>=<\/span> <\/span>Consumer<\/span>(<\/span>conf<\/span>)<\/span><\/span>\n<\/span>\n# Subscribe to a Kafka topic<\/span><\/span>\nconsumer<\/span>.<\/span>subscribe<\/span>([<\/span>'<\/span>my-topic<\/span>'<\/span>])<\/span>  <\/span># Replace with your Kafka topic name<\/span><\/span>\n<\/span>\n# MySQL database connection configuration<\/span><\/span>\ndb_config <\/span>=<\/span> <\/span>{<\/span><\/span>\n    <\/span>'<\/span>host<\/span>'<\/span>:<\/span> <\/span>'<\/span>localhost<\/span>'<\/span>,<\/span>  <\/span># Replace with your MySQL server hostname<\/span><\/span>\n    <\/span>'<\/span>user<\/span>'<\/span>:<\/span> <\/span>'<\/span>username<\/span>'<\/span>,<\/span>  <\/span># Replace with your MySQL username<\/span><\/span>\n    <\/span>'<\/span>password<\/span>'<\/span>:<\/span> <\/span>'<\/span>password<\/span>'<\/span>,<\/span>  <\/span># Replace with your MySQL password<\/span><\/span>\n    <\/span>'<\/span>database<\/span>'<\/span>:<\/span> <\/span>'<\/span>my_database<\/span>'<\/span>  <\/span># Replace with your database name<\/span><\/span>\n}<\/span><\/span>\n<\/span>\n# Create a MySQL database connection<\/span><\/span>\ndb_connection <\/span>=<\/span> mysql<\/span>.<\/span>connector<\/span>.<\/span>connect<\/span>(<\/span>**<\/span>db_config<\/span>)<\/span><\/span>\ncursor <\/span>=<\/span> db_connection<\/span>.<\/span>cursor<\/span>()<\/span><\/span>\n<\/span>\n# Main data ingestion loop<\/span><\/span>\nwhile<\/span> <\/span>True<\/span>:<\/span><\/span>\n    msg <\/span>=<\/span> consumer<\/span>.<\/span>poll<\/span>(<\/span>1.0<\/span>)<\/span>  <\/span># Poll for Kafka messages<\/span><\/span>\n    <\/span>if<\/span> msg <\/span>is<\/span> <\/span>None<\/span>:<\/span><\/span>\n        <\/span>continue<\/span><\/span>\n    <\/span>if<\/span> msg<\/span>.<\/span>error<\/span>():<\/span><\/span>\n        <\/span>if<\/span> msg<\/span>.<\/span>error<\/span>().<\/span>code<\/span>()<\/span> <\/span>==<\/span> KafkaError<\/span>.<\/span>_PARTITION_EOF<\/span>:<\/span><\/span>\n            <\/span>print<\/span>(<\/span>'<\/span>Reached end of partition<\/span>'<\/span>)<\/span><\/span>\n        <\/span>else<\/span>:<\/span><\/span>\n            <\/span>print<\/span>(<\/span>'<\/span>Error while polling for messages: <\/span>{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>msg<\/span>.<\/span>error<\/span>()))<\/span><\/span>\n    <\/span>else<\/span>:<\/span><\/span>\n        <\/span># Insert the Kafka message value into MySQL<\/span><\/span>\n        data <\/span>=<\/span> msg<\/span>.<\/span>value<\/span>().<\/span>decode<\/span>(<\/span>'<\/span>utf-8<\/span>'<\/span>)<\/span>  <\/span># Assuming data is in UTF-8 encoding<\/span><\/span>\n        insert_query <\/span>=<\/span> <\/span>"<\/span>INSERT INTO my_table (data_column) VALUES (<\/span>%s<\/span>)<\/span>"<\/span><\/span>\n        cursor<\/span>.<\/span>execute<\/span>(<\/span>insert_query<\/span>,<\/span> <\/span>(<\/span>data<\/span>,))<\/span><\/span>\n        db_connection<\/span>.<\/span>commit<\/span>()<\/span><\/span>\n        <\/span>print<\/span>(<\/span>'<\/span>Inserted: <\/span>{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>data<\/span>))<\/span><\/span>\n<\/span>\n# Clean up<\/span><\/span>\ncursor<\/span>.<\/span>close<\/span>()<\/span><\/span>\ndb_connection<\/span>.<\/span>close<\/span>()<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
    In this script:<\/p>\n\n\n\n
      \n
    • We configure the Kafka consumer to connect to your Kafka broker and subscribe to a specific topic.<\/li>\n\n\n\n
    • We set up the MySQL database connection using the provided credentials and specify the database and table where we want to insert the data.<\/li>\n\n\n\n
    • Inside the main loop, we continuously poll for messages from Kafka. When a message is received, we decode it (assuming it’s in UTF-8 encoding) and insert it into the MySQL database table.<\/li>\n\n\n\n
    • We commit the transaction in the database, ensuring data integrity.<\/li>\n<\/ul>\n\n\n\n
      Running the Code<\/h2>\n\n\n\n
      To run the script, simply execute it using Python:<\/p>\n\n\n\n
      <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
      python kafka_to_mysql<\/span>.<\/span>py<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
      Ensure that your Kafka topic exists and has data to consume. As messages are ingested from Kafka, you will see them being inserted into your MySQL database.<\/p>\n\n\n\n
      Conclusion<\/h2>\n\n\n\n
      Ingesting data from Kafka and inserting it into MySQL using Python provides a powerful way to build real-time data pipelines for your applications. This approach allows you to process and analyze data in real-time, enabling faster and more informed decision-making. By following the steps and code provided in this article, you can get started on your journey to building robust data pipelines with Kafka and MySQL.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In today’s data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular […]<\/p>\n","protected":false},"author":1,"featured_media":107,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,4],"tags":[14,16,5],"class_list":["post-106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-engineering","category-python","tag-big-data","tag-mysql","tag-python"],"yoast_head":"\nData Ingestion from Kafka to MySQL using Python - Farrukh's Tech Space<\/title>\n<meta name=\"description\" content=\"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Ingestion from Kafka to MySQL using Python\" \/>\n<meta property=\"og:description\" content=\"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Farrukh's Tech Space\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-20T17:49:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-20T17:49:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/09\/111-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"912\" \/>\n\t<meta property=\"og:image:height\" content=\"424\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Farrukh Naveed Anjum\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Data Ingestion from Kafka to MySQL using Python\" \/>\n<meta name=\"twitter:description\" content=\"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/09\/111-1.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Farrukh Naveed Anjum\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\"},\"author\":{\"name\":\"Farrukh Naveed Anjum\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/ce7d07e6a917b9b73aa79007a2357d29\"},\"headline\":\"Data Ingestion from Kafka to MySQL using Python\",\"datePublished\":\"2023-09-20T17:49:51+00:00\",\"dateModified\":\"2023-09-20T17:49:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\"},\"wordCount\":466,\"publisher\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#organization\"},\"keywords\":[\"Big Data\",\"MySQL\",\"Python\"],\"articleSection\":[\"Data Engineering\",\"Python\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\",\"url\":\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\",\"name\":\"Data Ingestion from Kafka to MySQL using Python - Farrukh's Tech Space\",\"isPartOf\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#website\"},\"datePublished\":\"2023-09-20T17:49:51+00:00\",\"dateModified\":\"2023-09-20T17:49:54+00:00\",\"description\":\"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#website\",\"url\":\"https:\/\/farrukhnaveed.co\/blogs\/\",\"name\":\"Farrukh Naveed Anjum Blogs\",\"description\":\"Empowering Software Architects with Knowledge on Big Data and AI\",\"publisher\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/farrukhnaveed.co\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#organization\",\"name\":\"Farrukh Naveed Anjum Blogs\",\"url\":\"https:\/\/farrukhnaveed.co\/blogs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/06\/IMG_5018-scaled.jpg\",\"contentUrl\":\"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/06\/IMG_5018-scaled.jpg\",\"width\":1707,\"height\":2560,\"caption\":\"Farrukh Naveed Anjum Blogs\"},\"image\":{\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/ce7d07e6a917b9b73aa79007a2357d29\",\"name\":\"Farrukh Naveed Anjum\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bdf1af0d569259df562434e6dc99415a377c6fc053f9e1507aa34a6522561bb8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bdf1af0d569259df562434e6dc99415a377c6fc053f9e1507aa34a6522561bb8?s=96&d=mm&r=g\",\"caption\":\"Farrukh Naveed Anjum\"},\"description\":\"Full Stack Developer and Software Architect with 14 years of experience in various domains, including Enterprise Resource Planning, Data Retrieval, Web Scraping, Real-Time Analytics, Cybersecurity, NLP, ED-Tech, and B2B Price Comparison\",\"sameAs\":[\"https:\/\/farrukhnaveed.co\/blog\"],\"url\":\"https:\/\/farrukhnaveed.co\/blogs\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Ingestion from Kafka to MySQL using Python - Farrukh's Tech Space","description":"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/","og_locale":"en_US","og_type":"article","og_title":"Data Ingestion from Kafka to MySQL using Python","og_description":"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.","og_url":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/","og_site_name":"Farrukh's Tech Space","article_published_time":"2023-09-20T17:49:51+00:00","article_modified_time":"2023-09-20T17:49:54+00:00","og_image":[{"width":912,"height":424,"url":"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/09\/111-1.jpg","type":"image\/jpeg"}],"author":"Farrukh Naveed Anjum","twitter_card":"summary_large_image","twitter_title":"Data Ingestion from Kafka to MySQL using Python","twitter_description":"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.","twitter_image":"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/09\/111-1.jpg","twitter_misc":{"Written by":"Farrukh Naveed Anjum","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/#article","isPartOf":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/"},"author":{"name":"Farrukh Naveed Anjum","@id":"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/ce7d07e6a917b9b73aa79007a2357d29"},"headline":"Data Ingestion from Kafka to MySQL using Python","datePublished":"2023-09-20T17:49:51+00:00","dateModified":"2023-09-20T17:49:54+00:00","mainEntityOfPage":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/"},"wordCount":466,"publisher":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/#organization"},"keywords":["Big Data","MySQL","Python"],"articleSection":["Data Engineering","Python"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/","url":"https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/","name":"Data Ingestion from Kafka to MySQL using Python - Farrukh's Tech Space","isPartOf":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/#website"},"datePublished":"2023-09-20T17:49:51+00:00","dateModified":"2023-09-20T17:49:54+00:00","description":"In today's data-driven world, real-time data processing is crucial for businesses to make informed decisions and stay competitive. Apache Kafka has emerged as a popular choice for building real-time data pipelines due to its distributed and fault-tolerant nature. Meanwhile, MySQL remains a widely used relational database for storing and managing structured data. Combining these two technologies, we can create a robust solution for ingesting data from Kafka and inserting it into MySQL using Python.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/farrukhnaveed.co\/blogs\/data-ingestion-from-kafka-to-mysql-using-python\/"]}]},{"@type":"WebSite","@id":"https:\/\/farrukhnaveed.co\/blogs\/#website","url":"https:\/\/farrukhnaveed.co\/blogs\/","name":"Farrukh Naveed Anjum Blogs","description":"Empowering Software Architects with Knowledge on Big Data and AI","publisher":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/farrukhnaveed.co\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/farrukhnaveed.co\/blogs\/#organization","name":"Farrukh Naveed Anjum Blogs","url":"https:\/\/farrukhnaveed.co\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/06\/IMG_5018-scaled.jpg","contentUrl":"https:\/\/farrukhnaveed.co\/blogs\/wp-content\/uploads\/2023\/06\/IMG_5018-scaled.jpg","width":1707,"height":2560,"caption":"Farrukh Naveed Anjum Blogs"},"image":{"@id":"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/ce7d07e6a917b9b73aa79007a2357d29","name":"Farrukh Naveed Anjum","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/farrukhnaveed.co\/blogs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bdf1af0d569259df562434e6dc99415a377c6fc053f9e1507aa34a6522561bb8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bdf1af0d569259df562434e6dc99415a377c6fc053f9e1507aa34a6522561bb8?s=96&d=mm&r=g","caption":"Farrukh Naveed Anjum"},"description":"Full Stack Developer and Software Architect with 14 years of experience in various domains, including Enterprise Resource Planning, Data Retrieval, Web Scraping, Real-Time Analytics, Cybersecurity, NLP, ED-Tech, and B2B Price Comparison","sameAs":["https:\/\/farrukhnaveed.co\/blog"],"url":"https:\/\/farrukhnaveed.co\/blogs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/posts\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":1,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/posts\/106\/revisions"}],"predecessor-version":[{"id":108,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/posts\/106\/revisions\/108"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/media\/107"}],"wp:attachment":[{"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/media?parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/categories?post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/farrukhnaveed.co\/blogs\/wp-json\/wp\/v2\/tags?post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}