-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathblogs.sql
43 lines (36 loc) · 78.1 KB
/
blogs.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 08, 2023 at 09:26 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `deblog`
--
--
-- Dumping data for table `blogs`
--
INSERT INTO `blogs` (`Id`, `BlogTitle`, `BlogBody`, `BlogImageUrl`, `BlogAuthor`, `BlogType`, `BlogTopic`, `BlogStatus`, `BlogDatetime`, `BlogReadtime`) VALUES
(3, 'Hello World in Python3', '{\"ops\":[{\"attributes\":{\"align\":\"center\"},\"insert\":\"\\n\"},{\"insert\":\"Python is a high-level, general-purpose programming language. Its design philosophy emphasizes code readability with the use of significant indentation via the off-side rule. Python is dynamically typed and garbage-collected.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Designed by: \"},{\"insert\":\"Guido van Rossum\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Developer: \"},{\"insert\":\"Python Software Foundation\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"First appeared:\"},{\"insert\":\" 20 February 1991\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Hello world program:\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"print(\\\"hello world\\\")\"},{\"attributes\":{\"align\":\"justify\",\"code-block\":true},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"for Loop in python :\"},{\"insert\":\"\\n\\nfor i in range(0,10,1):\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" print(\\\"hello world\\\",i)\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"while Loop in python:\"},{\"insert\":\"\\n\\ni=0\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"while i<10:\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" print(\\\"hello world\\\",i)\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\"}]}', 'https://uploads-ssl.webflow.com/62d3dd44074c2ea7b534b1a6/62f3fec9c69d4a6a3fbd4676_Why-Python-Is-Still-Better-Than-Other-Programming-Languages.png', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'private', 'python,python3', 0, '2023-07-09 00:43:45.299088', 7),
(4, 'Why debkumar bad?', '{\"ops\":[{\"attributes\":{\"header\":4},\"insert\":\"\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"What does a bad person mean?\"},{\"insert\":\"\\n> person who does harm to others\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"What is another word for a very bad person?\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"> Some common synonyms of villainous are corrupt, degenerate, iniquitous, nefarious, and vicious. While all these words mean \\\"highly reprehensible or offensive in character, nature, or conduct,\\\" villainous applies to any evil, depraved, or vile conduct or characteristic.\\n\\nWhat makes a person bad?\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"One person might define a \\\"bad person\\\" as someone who engages in harmful or destructive behaviors. Another person might define a bad person as an individual who doesn\'t care about other people, regardless of the type of actions they engage in.\\n\\nSo who is the Person?\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"attributes\":{\"alt\":\"Debkumar CHOWDHURY | Professor (Assistant) | B-TECH, M-TECH Ph.D (Pursuing) | COMPUTER SCIENCE & ENGINEERING | Research profile\"},\"insert\":{\"image\":\"https://i1.rgstatic.net/ii/profile.image/905845227405313-1592981740599_Q512/Debkumar-Chowdhury-2.jpg\"}},{\"insert\":\"\\n\\nWhat he actually did?\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"scamming, over-eating, misleading, misguiding, lazyness.\\n\"}]}', 'https://thumbs.dreamstime.com/b/grumpy-customer-support-man-frowning-face-wearing-phone-headset-office-brick-background-banner-businessman-168153822.jpg', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'bad-person,scammer,faculty', 1, '2023-07-08 14:55:39.936926', 69),
(5, 'Importance of DBMS', '{\"ops\":[{\"attributes\":{\"bold\":true},\"insert\":\"Database Management System\"},{\"insert\":\" or \"},{\"attributes\":{\"bold\":true},\"insert\":\"DBMS\"},{\"insert\":\" in short refers to the technology of storing and retrieving usersí data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Why to Learn DBMS?\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Traditionally, data was organized in file formats. DBMS was a new concept then, and all the research was done to make it overcome the deficiencies in traditional style of data management. A modern DBMS has the following characteristics −\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Real-world entity\"},{\"insert\":\" − A modern DBMS is more realistic and uses real-world entities to design its architecture. It uses the behavior and attributes too. For example, a school database may use students as an entity and their age as an attribute.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Relation-based tables\"},{\"insert\":\" − DBMS allows entities and relations among them to form tables. A user can understand the architecture of a database just by looking at the table names.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Isolation of data and application\"},{\"insert\":\" − A database system is entirely different than its data. A database is an active entity, whereas data is said to be passive, on which the database works and organizes. DBMS also stores metadata, which is data about data, to ease its own process.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Less redundancy\"},{\"insert\":\" − DBMS follows the rules of normalization, which splits a relation when any of its attributes is having redundancy in values. Normalization is a mathematically rich and scientific process that reduces data redundancy.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Consistency\"},{\"insert\":\" − Consistency is a state where every relation in a database remains consistent. There exist methods and techniques, which can detect attempt of leaving database in inconsistent state. A DBMS can provide greater consistency as compared to earlier forms of data storing applications like file-processing systems.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Query Language\"},{\"insert\":\" − DBMS is equipped with query language, which makes it more efficient to retrieve and manipulate data. A user can apply as many and as different filtering options as required to retrieve a set of data. Traditionally it was not possible where file-processing system was used.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 'https://www.infoclutch.com/knowledge-base/wp-content/uploads/2018/01/DBMS-BANNER.jpg', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'DBMS', 1, '2023-07-08 14:56:37.490407', 69),
(6, 'Java Programming in 5 minutes', '{\"ops\":[{\"insert\":\"What is Java?\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Java is popular high-level, class-based object oriented programming language originally developed by Sun Microsystems and released in 1995. Currently Java is owned by Oracle and more than 3 billion devices run Java. Java runs on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX. Java is used to develop numerious types of software applications like Mobile apps, Web apps, Desktop apps, Games and much more.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Java is a general-purpose programming language intended to let programmers write once, run anywhere (WORA). This means that compiled Java code can run on all platforms that support Java without the need to recompile.\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"This \"},{\"attributes\":{\"bold\":true},\"insert\":\"Java\"},{\"insert\":\" Tutorial has been prepared by well experienced Java Programmers for the Software Engineers to help them understand the basic to advanced concepts of Java Programming Language. After completing this tutorial, you will find yourself at a moderate level of expertise in Java, from where you can take yourself to the next levels.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"\\nJava Online Compiler\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"This tutorial provides enough number of examples to explain to concepts. To compile and execute your examaples in your browser itself, we have provided \"},{\"attributes\":{\"bold\":true},\"insert\":\"Java Online Compiler\"},{\"insert\":\". You can \"},{\"attributes\":{\"bold\":true},\"insert\":\"Edit\"},{\"insert\":\" and \"},{\"attributes\":{\"bold\":true},\"insert\":\"Execute\"},{\"insert\":\" almost all the examples directly from your browser. Try to click the run icon to run the following Java code to print conventional \\\"Hello, World!\\\".\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Below code box allows you to change the value of the code. Try to change the value inside \"},{\"attributes\":{\"bold\":true},\"insert\":\"println()\"},{\"insert\":\" and run it again to verify the result.\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"public class MyFirstJavaProgram {\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\\n\"},{\"insert\":\" /* This is my first java program.\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" * This will print \'Hello World\' as the output\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" */\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\\n\"},{\"insert\":\" public static void main(String []args) {\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" System.out.println(\\\"Hello World\\\"); // prints Hello World\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" }\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"}\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\\nJava Applications\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"The latest release of the Java Standard Edition is Java SE 18. With the advancement of Java and its widespread popularity, multiple configurations were built to suit various types of platforms. For example: J2EE for Enterprise Applications, J2ME for Mobile Applications.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"The new J2 versions were renamed as Java SE, Java EE, and Java ME respectively. Java is guaranteed to be \"},{\"attributes\":{\"bold\":true},\"insert\":\"Write Once, Run Anywhere.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Multithreaded\"},{\"insert\":\" − With Java\'s multithreaded feature it is possible to write programs that can perform many tasks simultaneously. This design feature allows the developers to construct interactive applications that can run smoothly.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Interpreted\"},{\"insert\":\" − Java byte code is translated on the fly to native machine instructions and is not stored anywhere. The development process is more rapid and analytical since the linking is an incremental and light-weight process.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"High Performance\"},{\"insert\":\" − With the use of Just-In-Time compilers, Java enables high performance.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Distributed\"},{\"insert\":\" − Java is designed for the distributed environment of the internet.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Dynamic\"},{\"insert\":\" − Java is considered to be more dynamic than C or C++ since it is designed to adapt to an evolving environment. Java programs can carry extensive amount of run-time information that can be used to verify and resolve accesses to objects on run-time.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 'https://blog.isimtescil.net/wp-content/uploads/2018/09/java-development-banner1.jpg', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'java', 1, '2023-07-08 14:58:43.329670', 5),
(7, 'Javascript programming', '{\"ops\":[{\"attributes\":{\"bold\":true},\"insert\":\"JavaScript\"},{\"insert\":\" is a lightweight, interpreted \"},{\"attributes\":{\"bold\":true},\"insert\":\"programming\"},{\"insert\":\" language. It is designed for creating network-centric applications. It is complimentary to and integrated with Java. \"},{\"attributes\":{\"bold\":true},\"insert\":\"JavaScript\"},{\"insert\":\" is very easy to implement because it is integrated with HTML. It is open and cross-platform.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Why to Learn Javascript\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Javascript\"},{\"insert\":\" is a MUST for students and working professionals to become a great Software Engineer specially when they are working in Web Development Domain. I will list down some of the key advantages of learning Javascript:\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Javascript is the most popular \"},{\"attributes\":{\"bold\":true},\"insert\":\"programming language\"},{\"insert\":\" in the world and that makes it a programmer’s great choice. Once you learnt Javascript, it helps you developing great front-end as well as back-end softwares using different Javascript based frameworks like jQuery, Node.JS etc.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Javascript is everywhere, it comes installed on every modern web browser and so to learn Javascript you really do not need any special environment setup. For example Chrome, Mozilla Firefox , Safari and every browser you know as of today, supports Javascript.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Javascript helps you create really beautiful and crazy fast websites. You can develop your website with a console like look and feel and give your users the best Graphical User Experience.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"JavaScript usage has now extended to mobile app development, desktop app development, and game development. This opens many opportunities for you as Javascript Programmer.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Due to high demand, there is tons of job growth and high pay for those who know JavaScript. You can navigate over to different job sites to see what having JavaScript skills looks like in the job market.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Great thing about Javascript is that you will find tons of frameworks and Libraries already developed which can be used directly in your software development to reduce your time to market.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"There could be 1000s of good reasons to learn Javascript Programming. But one thing for sure, to learn any \"},{\"attributes\":{\"bold\":true},\"insert\":\"programming language\"},{\"insert\":\", not only Javascript, you just need to code, and code and finally code until you become expert.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Hello World using Javascript\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Just to give you a little excitement about \"},{\"attributes\":{\"bold\":true},\"insert\":\"Javascript programming\"},{\"insert\":\", I\'m going to give you a small conventional Javascript Hello World program, You can try it using Demo link\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"#232323\",\"color\":\"#ffffff\",\"link\":\"http://tpcg.io/aMKLYm\"},\"insert\":\" Live Demo\"},{\"insert\":\"\\n\\n\\n<html>\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" <body> \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" <script language = \\\"javascript\\\" type = \\\"text/javascript\\\">\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" <!--\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" document.write(\\\"Hello World!\\\")\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" //-->\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" </script> \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" </body>\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"</html>\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"\\n\\nThere are many useful \"},{\"attributes\":{\"bold\":true},\"insert\":\"Javascript frameworks\"},{\"insert\":\" and libraries available:\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Angular\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"React\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"jQuery\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Vue.js\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Ext.js\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Ember.js\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meteor\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Mithril\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Node.js\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Polymer\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Aurelia\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Backbone.js\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"It is really impossible to give a complete list of all the available Javascript frameworks and libraries. The Javascript world is just too large and too much new is happening.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\\n\"},{\"insert\":\"Applications of Javascript Programming\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"As mentioned before, \"},{\"attributes\":{\"bold\":true},\"insert\":\"Javascript\"},{\"insert\":\" is one of the most widely used \"},{\"attributes\":{\"bold\":true},\"insert\":\"programming languages\"},{\"insert\":\" (Front-end as well as Back-end). It has it\'s presence in almost every area of software development. I\'m going to list few of them here:\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Client side validation\"},{\"insert\":\" - This is really important to verify any user input before submitting it to the server and Javascript plays an important role in validting those inputs at front-end itself.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Manipulating HTML Pages\"},{\"insert\":\" - Javascript helps in manipulating HTML page on the fly. This helps in adding and deleting any HTML tag very easily using javascript and modify your HTML to change its look and feel based on different devices and requirements.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"User Notifications\"},{\"insert\":\" - You can use Javascript to raise dynamic pop-ups on the webpages to give different types of notifications to your website visitors.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Back-end Data Loading\"},{\"insert\":\" - Javascript provides Ajax library which helps in loading back-end data while you are doing some other processing. This really gives an amazing experience to your website visitors.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Presentations\"},{\"insert\":\" - JavaScript also provides the facility of creating presentations which gives website look and feel. JavaScript provides RevealJS and BespokeJS libraries to build a web-based slide presentations.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Server Applications\"},{\"insert\":\" - Node JS is built on Chrome\'s Javascript runtime for building fast and scalable network applications. This is an event based library which helps in developing very sophisticated server applications including Web Servers.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"This list goes on, there are various areas where millions of software developers are happily using Javascript to develop great websites and others softwares.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 'https://www.mwanmobile.com/wp-content/uploads/2022/09/image-7.png', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'js', 1, '2023-07-08 14:56:32.543380', 10),
(8, 'How to use Git efficiently', '{\"ops\":[{\"attributes\":{\"size\":\"large\",\"color\":\"#888888\"},\"insert\":\"The code was working yesterday but today it is not\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"attributes\":{\"size\":\"large\",\"color\":\"#888888\"},\"insert\":\"The code got deleted\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"attributes\":{\"size\":\"large\",\"color\":\"#888888\"},\"insert\":\"A weird bug has been introduced suddenly and no-one knows how\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"\\nIf you have been in any of the above situations then \"},{\"attributes\":{\"bold\":true},\"insert\":\"this post is for you\"},{\"insert\":\".\\nApart from knowing \"},{\"attributes\":{\"background\":\"#f2f2f2\",\"code\":true},\"insert\":\"git add\"},{\"insert\":\", \"},{\"attributes\":{\"background\":\"#f2f2f2\",\"code\":true},\"insert\":\"git commit\"},{\"insert\":\" , and \"},{\"attributes\":{\"background\":\"#f2f2f2\",\"code\":true},\"insert\":\"git push\"},{\"insert\":\" , there are a bunch of other important techniques in Git. Knowing these will help a lot in the long run. Here I will be covering some of the things which will enable you to make the \"},{\"attributes\":{\"bold\":true},\"insert\":\"best use of Git.\"},{\"insert\":\"\\nGit workflows\"},{\"attributes\":{\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Whenever multiple developers are involved in a project it is necessary to use the right workflow for Git. Here I will be covering one workflow which is very effective in big projects with multiple developers.\\n\\n\"},{\"insert\":{\"image\":\"https://miro.medium.com/v2/resize:fit:875/1*KyJB0gCRmgjdBdJbZpT3vw.jpeg\"}},{\"insert\":\"\\n\\n\\nScenario\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"All of a sudden you have become the tech lead for a project in which you are planning to build the next Facebook. The team has three developers:\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Alice\"},{\"insert\":\": has one year of experience and knows programming\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Bob\"},{\"insert\":\": has one year of experience and knows programming\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"John\"},{\"insert\":\": has 3 years of experience and knows programming well\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"You:\"},{\"insert\":\" assigned as tech lead for this project\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Development process in Git\"},{\"attributes\":{\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Master branch\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"The Master Branch should always have a copy of the existing code in Production.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"No-one — \"},{\"attributes\":{\"bold\":true},\"insert\":\"including\"},{\"insert\":\" the tech lead — should be coding directly in the master branch since it is a copy of production code.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"The actual code is written in other branches.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Release branch\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"When the project begins the first thing to do is to create a \"},{\"attributes\":{\"bold\":true},\"insert\":\"release branch\"},{\"insert\":\" for the project. The release branch is created from the \"},{\"attributes\":{\"bold\":true},\"insert\":\"master branch\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"All code pertaining to this project will be in the \"},{\"attributes\":{\"bold\":true},\"insert\":\"release branch.\"},{\"insert\":\" The release branch is just a normal branch with the prefix \"},{\"attributes\":{\"bold\":true},\"insert\":\"release/\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Let’s call the release branch for this example \"},{\"attributes\":{\"bold\":true},\"insert\":\"release/fb.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"It’s possible that there are multiple projects running on the same code base. So, for each project, a separate release branch is created. Let’s say there is one more project running in parallel. Then that project can have a separate release branch like \"},{\"attributes\":{\"bold\":true},\"insert\":\"release/messenger\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"The reason to have a release branch is that the same code base can have multiple projects running in parallel — there should be no conflict between the projects.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Feature branch\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"For every feature that is built in the application a separate \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature branch \"},{\"insert\":\"is created. This ensures that the features can be built independently\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Feature branch is just like any other branch but with the prefix \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature/\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Now you, being the tech lead, have asked \"},{\"attributes\":{\"bold\":true},\"insert\":\"Alice\"},{\"insert\":\" to build a login screen for Facebook. So she creates a new feature branch for this. Lets call the feature branch \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature/login.\"},{\"insert\":\" Alice would write the entire login code only in this feature branch.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"The feature branch is generally created from the \"},{\"attributes\":{\"bold\":true},\"insert\":\"release branch\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Bob has been tasked with building the “Friend” request page. So Bob creates a feature branch called \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature/friendrequest\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"John’s task is to build the news feed. So John creates a feature branch called \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature/newsfeed\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"All of the developers code in their individual feature branches. So far so good 😃\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Now, let’s say that Alice finished her task and the login code is ready. She needs to send her code to the release branch \"},{\"attributes\":{\"bold\":true},\"insert\":\"release/fb\"},{\"insert\":\" from her feature branch \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature/login.\"},{\"insert\":\" This is done through a \"},{\"attributes\":{\"bold\":true},\"insert\":\"pull request.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Pull request\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"First and foremost, a pull request is not to be confused with \"},{\"attributes\":{\"background\":\"#f2f2f2\",\"code\":true},\"insert\":\"git pull\"},{\"insert\":\" .\\n\\nThe developer cannot push the code directly into the release branch. The tech lead needs to review the \"},{\"attributes\":{\"bold\":true},\"insert\":\"feature\"},{\"insert\":\" code before it goes into the \"},{\"attributes\":{\"bold\":true},\"insert\":\"release\"},{\"insert\":\" branch. This is done through a pull request.\\n\"}]}', 'https://retool.com/blog/content/images/2022/02/gotchas-git-github-banner-1.png', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'git,version-control,github', 1, '2023-07-08 14:56:30.204294', 20),
(9, 'Learn DataBase Management System with SQL', '{\"ops\":[{\"attributes\":{\"bold\":true},\"insert\":\"SQL\"},{\"insert\":\" is a database computer language designed for the retrieval and management of data in a relational databases like MySQL, MS Access, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres etc. \"},{\"attributes\":{\"bold\":true},\"insert\":\"SQL\"},{\"insert\":\" stands for \"},{\"attributes\":{\"bold\":true},\"insert\":\"Structured Query Language\"},{\"insert\":\". SQL was developed in the 1970s by IBM Computer Scientists.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"SQL\"},{\"insert\":\" is not a database management system, but it is a query language which is used to store and retrieve the data from a database or in simple words SQL is a language that communicates with databases.\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"This SQL tutorial helps you learn SQL in simple and easy steps so that you can start your database programming quickly. It covers most of the important concepts related to SQL for a basic to advanced understanding of SQL and to get a feel of how SQL works.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\\n\\n\"},{\"insert\":\"Why to Learn SQL?\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"SQL (Structured Query Language) is a MUST for the students and working professionals to become a great Software Engineer specially when they are working in Software Development Domain. SQL is the most common language used almost in every application software including banking, finance, education, security etc. to store and manipulate data.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"SQL is fairly easy to learn, so if you are starting to learn any programming language then it is very much advised that you should also learn SQL and other Database related concepts to become a complete Software Programmer. There are many good reasons which makes SQL as the first choice of any programmer −\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"SQL is the standard language for any Relational Database System. All the Relational Data Base Management Systems (RDBMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Also, software industry is using different dialects of SQL, such as −\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"MS SQL Server using T-SQL,\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Oracle using PL/SQL,\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"MS Access version of SQL is called JET SQL (native format) etc.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Applications of SQL\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"SQL is one of the most widely used Query Language over the databases. SQL provides following functionality to the database programmers −\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Execute different database queries against a database.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Define the data in a database and manipulate that data.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Create data in a relational database management system.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Access data from the relational database management system.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Create and drop databases and tables.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Create and maintain database users.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Create view, stored procedure, functions in a database.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Set permissions on tables, procedures and views.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Audiences\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"This \"},{\"attributes\":{\"bold\":true},\"insert\":\"SQL tutorial\"},{\"insert\":\" is prepared for beginners to help them understand the basic as well as the advanced concepts related to SQL languages. This tutorial will give you enough understanding on the various concepts of SQL along with suitable examples.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Prerequisites\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Before you start practicing with various types of SQL examples given in this tutorial, I am assuming that you are already aware about what is a Database, especially the basics of RDBMS and associated concepts.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 'https://www.keyjob.lu/sites/default/files/styles/meta/public/2022-09/banner-news-sql.png?itok=ghC8MaGL', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'SQL,DBMS,database-management-system', 1, '2023-07-08 14:56:27.233673', 10),
(10, 'C Programming for beginer', '{\"ops\":[{\"attributes\":{\"bold\":true},\"insert\":\"C programming\"},{\"insert\":\" is a general-purpose, procedural, imperative computer programming language developed in 1972 by Dennis M. Ritchie at the Bell Telephone Laboratories to develop the UNIX operating system. C is the most widely used computer language. It keeps fluctuating at number one scale of popularity along with Java programming language, which is also equally popular and most widely used among modern software programmers.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Why to Learn C Programming?\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"C programming\"},{\"insert\":\" language is a MUST for students and working professionals to become a great Software Engineer specially when they are working in Software Development Domain. I will list down some of the key advantages of learning C Programming:\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Easy to learn\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Structured language\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"It produces efficient programs\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"It can handle low-level activities\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"It can be compiled on a variety of computer platforms\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Facts about C\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"C was invented to write an operating system called UNIX.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"C is a successor of B language which was introduced around the early 1970s.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"The language was formalized in 1988 by the American National Standard Institute (ANSI).\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"The UNIX OS was totally written in C.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Today C is the most widely used and popular System Programming Language.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Most of the state-of-the-art software have been implemented using C.\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Hello World using C Programming.\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Just to give you a little excitement about \"},{\"attributes\":{\"bold\":true},\"insert\":\"C programming\"},{\"insert\":\", I\'m going to give you a small conventional C Programming Hello World program, You can try it using Demo link.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"#232323\",\"color\":\"#ffffff\",\"link\":\"http://tpcg.io/3Ty4QP\"},\"insert\":\" Live Demo\"},{\"insert\":\"\\n#include <stdio.h>\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\\n\"},{\"insert\":\"int main() {\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" /* my first program in C */\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" printf(\\\"Hello, World! \\\\n\\\");\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\" return 0;\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"}\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Applications of C Programming\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"C was initially used for system development work, particularly the programs that make-up the operating system. C was adopted as a system development language because it produces code that runs nearly as fast as the code written in assembly language. Some examples of the use of C are -\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"Operating Systems\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Language Compilers\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Assemblers\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Text Editors\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Print Spoolers\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Network Drivers\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Modern Programs\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Databases\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Language Interpreters\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Utilities\"},{\"attributes\":{\"align\":\"justify\",\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Audience\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"This tutorial is designed for software programmers with a need to understand the \"},{\"attributes\":{\"bold\":true},\"insert\":\"C programming\"},{\"insert\":\" language starting from scratch. This \"},{\"attributes\":{\"bold\":true},\"insert\":\"C tutorial\"},{\"insert\":\" will give you enough understanding on C programming language from where you can take yourself to higher level of expertise.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Prerequisites\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Before proceeding with this tutorial, you should have a basic understanding of Computer Programming terminologies. A basic understanding of any of the programming languages will help you in understanding the \"},{\"attributes\":{\"bold\":true},\"insert\":\"C programming\"},{\"insert\":\" concepts and move fast on the learning track.\"},{\"attributes\":{\"align\":\"justify\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 'https://stg.org.in/wp-content/uploads/2022/02/c-language-1024x530.png', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'c,c-programming', 1, '2023-07-08 14:56:24.486587', 5);
INSERT INTO `blogs` (`Id`, `BlogTitle`, `BlogBody`, `BlogImageUrl`, `BlogAuthor`, `BlogType`, `BlogTopic`, `BlogStatus`, `BlogDatetime`, `BlogReadtime`) VALUES
(11, 'IoT & Robotics for beginer', '{\"ops\":[{\"insert\":\"Microcontroller IOT Boards\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://en.wikipedia.org/wiki/List_of_Arduino_boards_and_compatible_systems\"},\"insert\":\"Arduino boards\"},{\"insert\":\" (UNO,MEGA,NANO,LEONARDO etc)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"ESP8266/ESP32/ESP S/C/H DevKit\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi Pico /W\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Minimal Component Requirements\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"One of the above board(Recommended : Arduino UNO)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"USB type A\"},{\"insert\":\" to \"},{\"attributes\":{\"italic\":true},\"insert\":\"USB type B\"},{\"insert\":\" connector for arduino\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"led(Red,green,blue)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"jumpers(MtoM and MtoF)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"breadboard\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Register(220ohm,1Kohm,10Kohm)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"capacitor(220 microfarad,47 microfarad)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Buzzer\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"8mm common anode RGB led\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Potentiometer\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Sensors and Modules(Required : based on project)\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Sensors\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"HC-SR04 Ultrasonic distance sensor*\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"DHT11 temparature and humidity sensor*\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"BISS0001 PIR Motion sensor\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"MPU-6050 3-Axis Accelerometer and Gyro Sensor\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"TTP223B\"},{\"insert\":\" Capacitive Touch Sensor Module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"LM393 Sound Detection Module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"IR receiver + Remote\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Wireless Modules\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"ESP-01 ESP8266 Serial WIFI Module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"HC-05 Bluetooth Module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Displays\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"16x2 LCD\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Single digit \"},{\"attributes\":{\"italic\":true},\"insert\":\"7 segment\"},{\"insert\":\" display\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"0.96inch OLED I2C display\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Motors\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"12V 200 RPM DC Motor\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"28BYJ-48 Unipolar Stepper Motor\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"SG90 Servo Motor (180° Rotation)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Motor Drivers\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"L293D Motor Driver Shield(Arduino UNO/Mega)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"L293D Motor Driver Board for ESP8266 NodeMcu 12E\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"L298N motor driver module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"ULN2003 Stepper Motor Driver\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"A4988 driver Stepper Motor Driver\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Others\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"2N2222 transistor\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"2/4 - channel 5V relay module\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Softwere requirements\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.arduino.cc/en/software\"},\"insert\":\"Arduino IDE(Latest version)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://downloads.arduino.cc/arduino-1.8.3-windows.exe\"},\"insert\":\"Arduino IDE(v1.8.3 if you have arduino nano)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://thonny.org/\"},\"insert\":\"Thonny(If micropython/circuitpython is used)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://platformio.org/\"},\"insert\":\"Platform IO\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://docs.espressif.com/projects/esp-idf/en/latest/esp32/\"},\"insert\":\"ESP-IDF\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"How to get started\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Installation of IDEs and Clone repo.\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"Install the Arduino IDE & Clone this repository\"},{\"insert\":\"\\ngit clone https://github.com/tirtharajsinha/IOT-and-Robotics.git\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"Connect the arduino board via USB.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Open the arduino IDE\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"select the board and port number(something like \"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"COM5\"},{\"insert\":\")\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Now open \"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"LED_BLINK/LED_BLINK.ino\"},{\"insert\":\" in arduino ide.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Connect the circuit diagram available the .ino code location.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Open the arduino ide and validate and upload the script.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"If you see led lights up and down periodically then you are good to go. othewise contact a experienced friend. if you friend refuses then your are fucked up, go search on youtube.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Upstream the repository\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"git reset --hard origin/main\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"git remote add upstream https://github.com/tirtharajsinha/IOT-and-Robotics.git\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"git fetch upstream\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"git checkout main\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"git merge upstream/main\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"If anytime you think you messed up with the original repo code then you can consider reset the rerository.\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Reset repository\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"git reset --hard origin/main\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Arduino libraries you need to get started\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Adafruit Circuit Playground by Adafruit*\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Servo by Michael Margolis, Arduino\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"DHT sersor library by Adafruit*\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Adafruit Unified sensor by Adafruit*\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Firmata by firmata developers\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"WiFi by Arduino\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"LiquidCrystal by Arduino, Adafruit\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino_JSON by Arduino\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Diffrent type arduino boards\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Classic family\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Arduino UNO R3\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Mega 2560 Rev3\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Leonardo\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino UNO Mini Limited Edition\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Due\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Micro\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Zero\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino UNO WiFi Rev2\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Nano family\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano 33 IoT\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano RP2040 Connect\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano 33 BLE Sense\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano 33 BLE\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano Every\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"MKR family\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR 1000 WiFi\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR WiFi 1010\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR FOX 1200\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR WAN 1300\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR WAN 1310\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR GSM 1400\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR NB 1500\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR Vidor 4000\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino MKR Zero\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Portena family(Arduino Pro)\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Portena H7\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Portena X8\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Portena Max Carrier(Carrier for portena)\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"ESP based boards\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"As ESP based borads are also available from third-party manufactures like adafruit,unexpectedmaker,wemos etc. so listing all boards impossible. This \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.espressif.com/en/products/modules\"},\"insert\":\"Page\"},{\"insert\":\" lists all esp official espressif products.Here we are only listing the popular ESP32 SOC series.\\nESP8266\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 H2\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 C3\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 C6\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 S2\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 S3\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Development Environment and Languages for ESP boards\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"ESP32 supports multiple development Environment and Languages\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"Arduino IDE (C++)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"ESP-IDF (C and C++)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"PlatformIO (C)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Thonny (MicroPython,CircuitPython)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"nanoFramework(C#)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi 2040 Based Boards\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi Pico /W.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Adafruit Feather RP2040.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino Nano 2040 Connect.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Cytron Maker Pi Pico.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Adafruit QT Py RP2040.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Seeed XIAO RP2040.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Pimoroni Tufty 2040.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Pimoroni Keybow 2040.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Sparkfun Pro Micro.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"... etc.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Development Environment and Languages for RP2040 based bords\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"RP2040 based board supports multiple development Environment and Languages\"},{\"attributes\":{\"blockquote\":true},\"insert\":\"\\n\"},{\"insert\":\"Arduino IDE (C++)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"PlatformIO (C)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Thonny (MicroPython,CircuitPython)\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"C/C++ SDK\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":1},\"insert\":\"\\n\"},{\"insert\":\"Setup of Development Environmnts\"},{\"attributes\":{\"header\":1},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Arduino IDE Setup for Boards\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Arduino boards\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"These board has arduino IDE Support by default.\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"ESP Boards\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Start Arduino and open Preferences window.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\\n\"},{\"insert\":\"for your specific boards use below url to install boards manager\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"ESP8266\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"https://arduino.esp8266.com/stable/package_esp8266com_index.json\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\\n\"},{\"insert\":\"ESP32/ESP32 H/S/C\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"https://raw.githubusercontent.com/espressif/arduino-esp32/gh-pages/package_esp32_index.json\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"Put these url into Additional Board Manager URLs field. You can add multiple URLs, separating them with commas.\\nOpen Boards Manager from Tools > Board menu and find esp8266/esp32 platform.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\\n\"},{\"insert\":\"Select the version you need from a drop-down box.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Click install button.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Don’t forget to select your esp board from Tools > Board menu after installation.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Additional/Importent Arduino Libraries for esp8266/esp32\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"esp8266 by ESP8266 Community\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 by Espressif Systems\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://github.com/me-no-dev/ESPAsyncWebServer\"},\"insert\":\"ESPAsyncWebServer\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://github.com/me-no-dev/ESPAsyncTCP\"},\"insert\":\"ESPAsyncTCP for esp8266\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://github.com/me-no-dev/AsyncTCP\"},\"insert\":\"AsyncTCP for esp32\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi Pico /W\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Follow \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.tomshardware.com/how-to/program-raspberry-pi-pico-with-arduino-ide\"},\"insert\":\"this tutorial\"},{\"insert\":\" to set up arduino ide with RPi Pico boards.\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://github.com/earlephilhower/arduino-pico\"},\"insert\":\"Arduino Core\"},{\"insert\":\" for RP2040 based boards.\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Micropython(Some selected boards are supported) setup\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Common boards that supported by micropython\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"all esp based boards.\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino nano RP2040 connect and Arduino Nano 33 BLE Sense\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Arduino pro portena H7\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"all pyboards\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi pico & Pico W\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"BBC micro:bit v1\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Adafruit Feather series\"},{\"attributes\":{\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"IDE Installation\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Now you need a IDE. I prefer \"},{\"attributes\":{\"italic\":true},\"insert\":\"thonny\"},{\"insert\":\" for this as it has REPL terminal For Installation guide follow this \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://learn.adafruit.com/circuitpython-libraries-on-micropython-using-the-raspberry-pi-pico/thonny-setup\"},\"insert\":\"blog form Adafruit\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Firmware Installation to target board\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"First read micropython \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://micropython.org/download/\"},\"insert\":\"docs\"},{\"insert\":\" to check if your micropython support your board. If your board is supported you can go ahead.\\n[Easy method] Connect board to computer via USB > Open thonny > tools > options > interpreter > select Micropython > install or update Micropython.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\\n\"},{\"insert\":\"[Other Method] Download the micropython firmware file :\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://micropython.org/download/esp32/\"},\"insert\":\"esp32\"},{\"attributes\":{\"indent\":1,\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://micropython.org/download/esp8266/\"},\"insert\":\"esp8266\"},{\"attributes\":{\"indent\":1,\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"For others you can find \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://micropython.org/download/\"},\"insert\":\"here\"},{\"attributes\":{\"indent\":1,\"list\":\"ordered\"},\"insert\":\"\\n\"},{\"insert\":\"Install the flash tool for esp boards :\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"pip install esptool\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"or\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"pip3 install esptool\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"verify installation with \"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"esptool --help\"},{\"insert\":\" command.\"},{\"attributes\":{\"indent\":1,\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Connect the esp board wit your computer and get the port number. It should be like \"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"COM5 or /dev/ttyUSB0\"},{\"attributes\":{\"indent\":1,\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Now open cmd where you downloaded the firmware/bin file.\"},{\"attributes\":{\"indent\":1,\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Run the following commands :\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Notice : After entering the command before pressing \"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"Enter\"},{\"insert\":\" press the boot button in your esp board and press enter in your keyboard don\'t unpress until command executes.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Erase previous firmware\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"esptool --port <PORT_NO> erase_flash\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"Install micropython firmware\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"esptool --port <PORT_NO> --baud 460800 write_flash --flash_size=detect 0 <FIRMWARE.bin>\"},{\"attributes\":{\"indent\":1,\"code-block\":true},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Clear Flash\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"To remove and get back to Arduino IDE, Run the following command :\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"esptool.py --port <PORT_NO> erase_flash\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"CircuitPython(Some selected boards are supported)\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Find the \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://docs.circuitpython.org/en/latest/README.html\"},\"insert\":\"CircuitPython Docs\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\\n\"},{\"insert\":\"First search you board \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://circuitpython.org/downloads\"},\"insert\":\"here\"},{\"insert\":\" to check if your CircuitPython support your board.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"IDE/Text Editor Installation\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Now you need a IDE. I prefer \"},{\"attributes\":{\"italic\":true},\"insert\":\"thonny\"},{\"insert\":\" for this as it has REPL terminal For Installation guide follow this \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://learn.adafruit.com/circuitpython-libraries-on-micropython-using-the-raspberry-pi-pico/thonny-setup\"},\"insert\":\"blog form Adafruit\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"For just minor editing you can use \"},{\"attributes\":{\"italic\":true},\"insert\":\"VS Code\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"Firmware Installation\"},{\"attributes\":{\"header\":3},\"insert\":\"\\n\"},{\"insert\":\"In this case every board have diffrent method to install circuitpython. follow boards specific method in adafruit site.\\nDownload the circuitpython \"},{\"attributes\":{\"italic\":true},\"insert\":\"BOOTLOADER ZIP\"},{\"insert\":\" and .uf2 file \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://circuitpython.org/downloads\"},\"insert\":\"here.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\\n\"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"[Recommended Method]\"},{\"insert\":\" follow the Install, Repair, or Update UF2 Bootloader instruction in Adafruit site.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"var(--bgColor-neutral-muted, var(--color-neutral-muted))\",\"code\":true},\"insert\":\"[Other Method]\"},{\"insert\":\" Connect board to computer via USB > Open thonny > tools > options > interpreter > select CircuitPython > install or update CircuitPython.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"ESP32 S/C/H : For reference Follow this \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.youtube.com/watch?v=RYkwgs5rXBM\"},\"insert\":\"Youtube Video\"},{\"insert\":\".\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Raspberry Pi Pico with \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://learn.adafruit.com/getting-started-with-raspberry-pi-pico-circuitpython/circuitpython\"},\"insert\":\"CircuitPython\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Flash Resetting UF2\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"If your Pico ever gets into a really weird state and doesn\'t even show up as a disk drive when installing CircuitPython, try installing this \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://cdn-learn.adafruit.com/assets/assets/000/099/419/original/flash_nuke.uf2?1613329170\"},\"insert\":\"flash_nuke.uf2\"},{\"insert\":\" which will do a \'deep clean\' on your Flash Memory. You will lose all the files on the board, but at least you\'ll be able to revive it! After nuking, re-install CircuitPython.\\n\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"Install CircuitPython packages\"},{\"attributes\":{\"header\":4},\"insert\":\"\\n\"},{\"insert\":\"CircuitPython libraries are written in Python. They provide additional functionality and support external devices, beyond what is in CircuitPython itself.After connect your board to your computers usb you should see a drive named \"},{\"attributes\":{\"italic\":true},\"insert\":\"CIRCUITPY\"},{\"insert\":\". Libraries are stored on your CIRCUITPY drive in a folder called lib.\\nYou can get the library packages bundle from \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://circuitpython.org/libraries\"},\"insert\":\"here\"},{\"insert\":\" or find the indevidual library from thonny package installer.\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"ESP-IDF\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"Follow this official instruction for installing \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://github.com/espressif/vscode-esp-idf-extension/blob/master/docs/tutorial/install.md\"},\"insert\":\"ESP-IDF\"},{\"insert\":\" in VS Code.\\nFollow this \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.youtube.com/watch?v=XDDcS7HQNlI\"},\"insert\":\"Youtube tutorial\"},{\"insert\":\" for more precise instruction.\\n\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"insert\":\"PlatformIO\"},{\"attributes\":{\"header\":2},\"insert\":\"\\n\"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://docs.platformio.org/en/latest/tutorials/index.html\"},\"insert\":\"Get started\"},{\"insert\":\" with PlatformIO.\\nFollow This \"},{\"attributes\":{\"color\":\"var(--fgColor-accent, var(--color-accent-fg))\",\"background\":\"transparent\",\"link\":\"https://www.youtube.com/watch?v=JmvMvIphMnY\"},\"insert\":\"Youtube Video\"},{\"insert\":\" to learn about installation and Usage.\\n\"}]}', 'https://github.com/tirtharajsinha/IOT-and-Robotics/raw/main/banner.jpg', '5083aca3-4fa6-463b-9621-12c6b0d8b2f3', 'public', 'arduino,iot,robotics,esp,raspberrypi', 1, '2023-07-08 14:56:21.441872', 20);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;