DEV Community: Anas Dew

MySQL Tutorial for Beginners: A Step-by-Step Guide to Getting Started. Quick SQL connector

Anas Dew — Wed, 23 Aug 2023 06:21:46 +0000

MySQL Tutorial for Beginners: A Step-by-Step Guide to Getting Started. Quick SQL connector

Introduction

Hey Dev! You got to the right place to learn about MySQL. It's an easy yet detailed guide, you will learn about MySQL and it's benefits, a python library which is so easy to perform queries and at the end, some cool projects to do. So without any further do. Let's writes some quieres.

Introduction to MySQL and Python

What is MySQL?

MySQL is a popular open-source relational database management system (RDBMS). It is a widely used tool for managing and organizing data in a structured way, particularly for use in web applications. MySQL is known for its reliability, simplicity, and performance, which makes it a good choice for many developers and organizations. It is developed, distributed, and supported by Oracle Corporation.

Why use MySQL with Python?

There are several reasons why you might want to use MySQL with Python:

Integration: MySQL is a widely used database and integrating it with Python can help you take your application to the next level.
Speed: MySQL is known for its speed, which makes it a good choice for high-performance applications.
Ease of use: Python is a very easy-to-use language, which makes it easy for developers to write and maintain code.
Scalability: Both MySQL and Python are highly scalable, which makes them a good choice for applications that are expected to grow over time.
Popularity: MySQL and Python are both widely used, which means there is a large community of developers who can provide support and guidance.

Overall, using MySQL with Python can be a powerful combination for building robust, high-performance applications.

Setting up a MySQL database and installing Quick SQL connector

To set up a MySQL database and install the Python MySQL libraries, you can follow these steps:

Install MySQL: You can download MySQL from the official website and install it on your system.
Create a database: After installing MySQL, you can create a new database using the MySQL command-line client or MySQL Workbench.

To create a database, simply use command CREATE DATABASE [database_name];
Install the Python MySQL libraries: There are several Python libraries that you can use to connect to a MySQL database, such as PyMySQL, MySQL Connector, MySQLdb and a newly born library which is Quick SQL connector, which we will be using in this tutorial. You can install these libraries using pip, the Python package manager. For example, to install Quick SQL connector, you can use the following command: pip install quicksqlconnector.
Connect to the database: Once you have installed the Python MySQL libraries and created a database, you can use Python to connect to the database and execute SQL queries.

Here is an example of how you can use Quick SQL connector to connect to a MySQL database in Python:

from quicksqlconnector import quicksqlconnector

# Syntax
# DB = quicksqlconnector('database','host', port, 'username', 'password')

DB = quicksqlconnector('mysql','localhost', 6606,'root', 'anas9916')

Learn more about Quick SQL connector.

NOTE

Quick SQL has abilty to work with MySQL, PostgreSQL and SQLite as well. If you're working with SQlite you don't need connection arguments. You'll only need to provide database and database_name as parameters.

DB = quicksqlconnector('sqlite', database_name='my_example_database')

Basic MySQL operations with Python

To execute any query for MySQL with Quick SQL Connector. It only has one method. Which is query and you can just put your raw SQL commands into it, And it will be executed.

# Syntax
DB.query('query','parameters':optional)

Creating and deleting a table

To create a table in a database, you can use the following SQL command:

CREATE TABLE table_name (
   column1 datatype,
   column2 datatype,
   column3 datatype,
   ...
);

For example, to create a table called "customers" with columns "id", "name", and "email", you could use the following code:

DB.query("CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, email TEXT );")

To delete a table, you can use the following code:

DB.query("DROP table customers");

Inserting data into table.

To insert data into a table, you can use the following SQL command:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

With Quick SQL connctor, the code will go like this.

DB.query("INSERT INTO customers (id, name, email) VALUES (1, 'John Smith', 'john@example.com');")

The code above is correct but to be more secure and prevent our database from SQL injection, we will do the same with query parameters. See below

DB.query("INSERT INTO customers (id, name, email) VALUES (%s, %s, %s);", (1, "John Smith", "john@example.com"))

That is perfect!

To update data in a table, you can use the following SQL command:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

With Quick SQL connector. the code will go like this.

DB.query("UPDATE customers SET email= %s WHERE id= %s;", ("john.smith@example.com", 1))

Recommendation

Now you got the basic idea of how to work with Quick SQL connector library. As a beginner, I would suggest you to learn this way as it is much more easier and stratforward and less complex as compared to other libraries out there (I tested).

Retrieving data from a table using SELECT statements

The SELECT statement is used to retrieve data from a database. Here is the basic syntax for a SELECT statement:

SELECT column1, column2, ...
FROM table_name
WHERE condition;

This statement retrieves all rows from the table_name table where the condition is true. The WHERE clause is optional, so if you omit it, the statement will return all rows from the table.

Here's an example to the same with Quick SQL connector

DB.query("SELECT id FROM customers WHERE name = 'anas dew';")

# This statement retrieves `id` column from the `Customers` table where the `name` column is 'anas dew'.

You can also use the * wildcard to select all columns from the table:

SELECT *
FROM table_name
WHERE condition;

For example:

output_data = DB.query("SELECT * FROM customers WHERE name = 'anas dew';")

print(output_data)

NOTE : Since you're in a programming language, you'll need to store it in a variable to access it further.

# Output
[(2, 'Anas Dew', 'anas@example.com')]

You can also use various clauses such as GROUP BY, HAVING, and ORDER BY to further refine your query.

GROUP BY: The GROUP BY clause is used in a SELECT statement to group the results by a specific column or columns. This allows you to perform aggregations (such as COUNT, SUM, AVG, etc.) on groups of data within the result set.

HAVING: The HAVING clause is similar to the WHERE clause, but is used in conjunction with the GROUP BY clause to filter the results of the grouped data. It is used to apply a condition to the grouped data, similar to how the WHERE clause is used to filter the entire result set.

ORDER BY: The ORDER BY clause is used in a SELECT statement to sort the results by a specific column or columns in ascending or descending order. It is usually used after the WHERE and GROUP BY clauses, if they are present in the query.

For example:

SELECT
  Country,
  COUNT(Country)
FROM
  Customers
GROUP BY
  Country
HAVING
  COUNT(Country) > 10
ORDER BY
  Country ASC;

This statement retrieves the Country column and counts the number of rows in the Customers table for each country. It then groups the results by country and filters the results to only include countries with more than 10 customers. Finally, it sorts the results by country in ascending order.

Using WHERE clauses and operators to filter data

The WHERE clause is used in a SELECT statement to filter the results based on specific criteria. It is used to specify a condition that must be met for a row to be included in the result set.

There are several operators that can be used in the WHERE clause to filter data.

= : equal to
: greater than
< : less than
= : greater than or equal to
<= : less than or equal to
<> or != : not equal to
BETWEEN : between a specific range
IN : within a set of values
LIKE : matching a specific pattern

For example:

SELECT * FROM Products WHERE Price > 50;

This statement retrieves all columns (*) from the Products table where the Price column is greater than 50.

SELECT * FROM Customers WHERE Country IN ('USA', 'Canada', 'Mexico');

This statement retrieves all columns (*) from the Customers table where the Country column is either 'USA', 'Canada', or 'Mexico'.

SELECT * FROM Employees WHERE FirstName LIKE '%a%';

This statement retrieves all columns (*) from the Employees table where the FirstName column contains the letter 'a'.

SELECT * FROM Orders WHERE OrderDate BETWEEN '2022-01-01' AND '2022-12-31';

This statement retrieves all columns (*) from the Orders table where the OrderDate column is between the dates of January 1st, 2022 and December 31st, 2022.

Sorting data using ORDER BY

The ORDER BY clause is used in a SELECT statement to sort the results by a specific column or columns in ascending or descending order. It is usually used after the WHERE and GROUP BY clauses, if they are present in the query.

To sort the results in ascending order, use the ASC keyword. To sort the results in descending order, use the DESC keyword. If no keyword is specified, the default is ASC.

For example:

SELECT * FROM Customers ORDER BY LastName ASC;

This statement retrieves all columns (*) from the Customers table and sorts the results by the LastName column in ascending order.

SELECT * FROM Products ORDER BY Price DESC;

This statement retrieves all columns (*) from the Products table and sorts the results by the Price column in descending order.

SELECT * FROM Employees ORDER BY Department ASC, LastName DESC;

This statement retrieves all columns (*) from the Employees table and sorts the results first by the Department column in ascending order, and then by the LastName column in descending order.

Next Steps

This was all that you need to get started with MySQL. Now your next step is to practice yourself and make some projects. Below are few MySQL projects to build right now.

Here are a few ideas for projects using Python and MySQL

A simple program that connects to a MySQL database and performs a SELECT query to retrieve data. The program could then display the results in a text-based user interface.
A program that allows a user to insert new rows into a MySQL database table via a simple user interface.
A program that generates reports based on data stored in a MySQL database. For example, you could create a program that generates reports on the most popular products or customers.
A program that imports data from a CSV file into a MySQL database.
A program that performs a full-text search on a MySQL database.

This is The Fastest and Simplest Chrome Extension on the Chrome Web Store!

Anas Dew — Fri, 07 Apr 2023 11:06:52 +0000

Building a Chrome extension for the first time is an exciting experience.

It's a feeling of accomplishment to see your idea come to life and be available to the public. That's what happened to me when I built my first-ever chrome extension, and

I'm proud to say it's now live on the Chrome Web Store.

The extension I built is a productivity tool that can help anyone who wants to get more done in less time. It's fast, simple, and easy to use. The reason for its simplicity is that it follows the principle of the VIM text editor. It means that the extension is entirely keyboard-based, so you can do everything using your keyboard.

The best part is that the extension doesn't require any personal data from the user. It's completely offline and secure, so you don't have to worry about any data breaches. The extension is built to help people get things done, not to steal their information.

One of the most significant features of the extension is its ability to send notifications for pending tasks. If you have a to-do list, this feature will help you stay on track and make sure that you're completing your tasks on time.

The extension is called TodoStack, and it's available for free on the Chrome Web Store. It's the perfect tool for anyone who wants to be more productive and get things done quickly. TodoStack is my brainchild, and I'm happy to see it help others in their daily lives.

If you're interested in trying out TodoStack, head over to todostack.vercel.app to get started. It's a great way to start your day on the right foot and be more productive.

With TodoStack, you'll be able to accomplish more in less time and make the most out of your day.

In conclusion,

building a chrome extension is a great way to share your ideas with the world. My experience building TodoStack has been fantastic, and I'm proud to see it finally live on the Chrome Web Store.

If you're looking for a productivity chrome extension or a todo app, give TodoStack a try. It's fast, simple, and keyboard-based, making it the perfect tool for anyone looking to get things done.

I made this AI tool in 69 lines of code in single HTML file.

Anas Dew — Wed, 01 Feb 2023 12:52:53 +0000

Hi Geeks!

In this blog, I am going to share with you my latest project - a simple AI tool that I built in just 69 lines of code within a single HTML file. With the growing popularity of Artificial Intelligence and its applications, I wanted to demonstrate how easy it is to create a basic AI tool with minimal effort and code. Whether you are a beginner in the field of AI or an experienced developer, I believe this blog will provide some useful insights and inspiration for your future AI projects.

Idea

The idea is simple, Find a closest suitable word meaning for a phrase given as input.

Tech

You gussed it right, I'm going to use OpenAI's model to find that word. And for the frontend, Bootstrap will be fine.

Let's CODE...

I will breakdown this coding part into 2 parts as javascript, frontend. So let's dive in.

Writing the fetch() API

First of all we're going to code an API that will take our prompt and return us a reponse. See code Below

const response = await fetch(url, {
                method: 'POST',
                headers: {
                    'Content-Type': 'application/json',
                    'Authorization': 'Bearer $your-openai-api-key'
                },
                body: JSON.stringify({
                    "model": "text-davinci-003",
                    "prompt": `find one word for this phrase : ${that_phrase}`,
                    "temperature": 0.7,
                    "max_tokens": 256,
                    "top_p": 1,
                    "frequency_penalty": 0,
                    "presence_penalty": 0
            })

Now in prompt, You see that i've just sent a phrase and said that "find one word for this phrase" and OpenAI' model will do it's work and as a reponse we will get json.

That json will filled with lots of data that we don't need for this project so i've made it simple for you.

.then(response => response.json()).then(
                data => { 
                    let response = data['choices'][0]['text'];
                    console.log(response);
                    document.getElementById('reponse-display').innerText = "That word is : " + response
                 }
            )

Now it will extract that text reponse came from OpenAI and store it in reponse variable. And there's an element in the frontend that will show the text as well. that is why i wrote the line.

document.getElementById('reponse-display').innerText = "That word is : " + response

Also at the bottom i put a code to trigger this API as shown below.

<script>
    let button = document.getElementById('find-button');
        button.addEventListener('click', (() => {
            let user_input = document.getElementById('phraseInput').value
            generateWord('https://api.openai.com/v1/completions', user_input)
        }))
</script>

And that is all. Javascript part is done.

Frontend

As i said earlier, I will be using Bootstrap. And I'm not going to install it. Because it's a very small project, I will be using cdn links to get job done.

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65" crossorigin="anonymous">
    <script defer src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"
        integrity="sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK/7HAuoJl+0I4"
        crossorigin="anonymous"></script>

By pasting this code into the head tag of the HTML file, I can use the a power of Bootstrap. So let's goto bootstrap and get forms to make UI better.

I will copy form from Bootstap and edit according to the need. That is all. Below

<div>
        <div class="mb-3">
            <label for="phraseInput" class="form-label">Write your phrase below</label>
            <textarea type="text" class="form-control" id="phraseInput" aria-describedby="emailHelp" placeholder="For Eg. Walking in sunrise while listening to beautiful music."></textarea>
        </div>
        <button type="button" id="find-button" class="btn btn-primary">Find</button>
    </div>

Below this form I will place the h2 tag to display that response word.

<h2 style="margin-top: 2rem;" id="reponse-display">Click "Find" to find a word for your phrase</h2>

That's it. The Tool is ready to deploy and for the i see netlify is the easiest.

Final Thoughts

Altough, this tool is complete but i've got more ideas to implement into this so i will keep updating the app.

Also this project is open to all to contribute. So fork the repo and make changes, and i will push it.

Here's the app

Thank you!

Yo! i keep building exciting and interesting things around so don't forget to follow!.

45 Days of Leetcode - Majority Element - Day 4.1

Anas Dew — Tue, 20 Dec 2022 04:02:36 +0000

Hey dev! In case you don't know, I've started #45daysofleetcode and in these 45 days i'll be writing about two problems every day.

The problem, how I solved it and a bit of detailed explanation.

I'm sharing this progress with you so that you too can learn a bit of different perspective and have new solutions so hit like to join this journey.

I've chosen the best list of problems from medium to hard. That made lots of developers crack the interview.

Are you excited?

Today's Problem

Name
Majority Element

Description
Given an array nums of size n, return the majority element.

The majority element is the element that appears more than ⌊n / 2⌋ times. You may assume that the majority element always exists in the array.

Example

Input: nums = [3,2,3]
Output: 3

My Approach

We create a dictionary. And add each element to it but with how many times it occured in the list like {value:occurence}. For that we iterate through the list and check if the value is in dictionary: if it is, increase occurence of value by 1; else add that value to the dictionary with the value = 1. and then return the key of the maximum value in the dictionary.

Code

class Solution:
    def majorityElement(self, nums: List[int]) -> int:
        maj = {}
        for i in nums:
            if i in maj:
                maj[i] += 1
            else :
                maj[i] = 1
        return max(zip(maj.values(), maj.keys()))[1]

Let me know if you've any questions or suggestions!.

If you want full list of solutions, here's the list. Make sure you star the repository.

Follow to join this #45daysofleetcode
Bye!

45 Days of Leetcode - Find Pivot Index - Day 3.1

Anas Dew — Mon, 19 Dec 2022 05:05:55 +0000

Hey dev! In case you don't know, I've started #45daysofleetcode and in these 45 days i'll be writing about two problems every day.

The problem, how I solved it and a bit of detailed explanation.

I'm sharing this progress with you so that you too can learn a bit of different perspective and have new solutions so hit like to join this journey.

I've chosen the best list of problems from medium to hard. That made lots of developers crack the interview.

Are you excited?

Today's Problem

Name
Find Pivot Index

Description
Given an array of integers nums, calculate the pivot index of this array.

The pivot index is the index where the sum of all the numbers strictly to the left of the index is equal to the sum of all the numbers strictly to the index's right.

If the index is on the left edge of the array, then the left sum is 0 because there are no elements to the left. This also applies to the right edge of the array.

Return the leftmost pivot index. If no such index exists, return -1.

Example

Input: nums = [1,7,3,6,5,6]
Output: 3
Explanation:
The pivot index is 3.
Left sum = nums[0] + nums[1] + nums[2] = 1 + 7 + 3 = 11
Right sum = nums[4] + nums[5] = 5 + 6 = 11

My Approach

We will iterate through the array, and at each index, we check if the sum of the left side of the index is equal to the sum of the right side of the index.

Code

class Solution:
    def pivotIndex(self, nums: List[int]) -> int:
        total_sum, right_sum, left_sum = sum(nums), 0, 0
        for i in range(len(nums)):
            right_sum = total_sum - nums[i] - left_sum
            if left_sum == right_sum:
                return i
            left_sum += nums[i]
        return -1

Let me know if you've any questions or suggestions!.

If you want full list of solutions, here's the list. Make sure you star the repository.

Follow to join this #45daysofleetcode
Bye!

#45Days of Leetcode - Running sum of 1d array - Day 2.2

Anas Dew — Sun, 18 Dec 2022 15:34:20 +0000

Hey dev! In case you don't know, I've started #45daysofleetcode and in these 45 days i'll be writing about two problems every day.

The problem, how I solved it and a bit of detailed explanation.

I'm sharing this progress with you so that you too can learn a bit of different perspective and have new solutions so hit like to join this journey.

I've chosen the best list of problems from medium to hard. That made lots of developers crack the interview.

Are you excited?

Today's Problem

Name
Running sum of 1d array

Description
Given an array nums. We define a running sum of an array as runningSum[i] = sum(nums[0]…nums[i]).

Return the running sum of nums.

Example

Input: nums = [1,2,3,4]
Output: [1,3,6,10]
Explanation: Running sum is obtained as follows: [1, 1+2, 1+2+3, 1+2+3+4].

My Approach

Simply add first value of original array to running array, and then start a loop from 1.

With each iteration, append (last element + current element) to the running array. then return it.

Code

class Solution:
    def runningSum(self, nums: List[int]) -> List[int]:
        runningArray = [nums[0]]
        for i in range(1, len(nums)):
            runningArray.append(runningArray[i-1]+nums[i])
        return runningArray

Let me know if you've any questions or suggestions!.

If you want full list of solutions, here's the list. Make sure you star the repository.

Follow to join this #45daysofleetcode
Bye!

#45Days of LeetCode - Best time to buy and sell stock II - Day 2

Anas Dew — Sun, 18 Dec 2022 05:00:15 +0000

Hey dev! In case you don't know, I've started #45daysofleetcode and in these 45 days i'll be writing about two problems every day.

The problem, how I solved it and a bit of detailed explanation.

I'm sharing this progress with you so that you too can learn a bit of different perspective and have new solutions so hit like to join this journey.

I've chosen the best list of problems from medium to hard. That made lots of developers crack the interview.

Are you excited?

Today's Problem

Name - Best time to buy and sell stock - 2

Description - You are given an integer array prices where prices[i] is the price of a given stock on the ith day.

On each day, you may decide to buy and/or sell the stock. You can only hold at most one share of the stock at any time. However, you can buy it then immediately sell it on the same day.

Find and return the maximum profit you can achieve.

Example

Input: prices = [7,1,5,3,6,4]

Output: 7
Explanation: Buy on day 2 (price = 1) and sell on day 3 (price = 5), profit = 5-1 = 4.
Then buy on day 4 (price = 3) and sell on day 5 (price = 6), profit = 6-3 = 3.
Total profit is 4 + 3 = 7.

My Approach

Initialize two values -> maxProfits and step.
Iterate through the array from 0 to list length-1 and step is for jumping because we cannot buy sell twice a day.

If next day price is higher than today's price then -> next day price - today's price = today profit.
add it to maxProfits, and skip next day and goto another day and so on.

But if next day price is not higher than today's price then do nothing and move on. ref: else condition. step = 1 will do nothing but step = 2 skips a day.

Code

class Solution:

    def maxProfit(self, prices: List[int]) -> int:
        maxProfits = 0
        step = 1
        for i in range(0, len(prices)-1, step):
            if prices[i+1] > prices[i] :
                maxProfits += prices[i+1] - prices[i]
                step = 2
            else :
                step = 1
        return maxProfits

Let me know if you've any questions or suggestions!.

If you want full list of solutions, here's the list. Make sure you star the repository.

Follow to join this #45daysofleetcode
Bye!

#45Days of LeetCode - Move Zeros - Day 1

Anas Dew — Sat, 17 Dec 2022 14:50:27 +0000

Hey dev! In case you don't know, I've started #45daysofleetcode and in these 45 days i'll be writing about two problems every day.

The problem, how I solved it and a bit of detailed explanation.

I'm sharing this progress with you so that you too can learn a bit of different perspective and have new solutions so hit like to join this journey.

I've chosen the best list of problems from medium to hard. That made lots of developers crack the interview.

Are you excited?

Today's Problem

Name - Move Zeros
Description - Given an integer array nums, move all 0's to the end of it while maintaining the relative order of the non-zero elements.

Note that you must do this in-place without making a copy of the array.

Example -
Input: nums = [0,1,0,3,12] Output: [1,3,12,0,0]

My Approach - I will iterate through the list and when found a zero in the path take it and append it to the list and remove it.

When you find a zero in the path, you append it to the list and then remove it from the path. Simple.

Code -
class Solution: def moveZeroes(self, nums: List[int]) -> None: """ Do not return anything, modify nums in-place instead. """ for i in range(len(nums)): if nums[i] == 0: nums.append(nums[i]) nums.remove(nums[i])

Let me know if you've any questions or suggestions!.

Follow to join this #45daysofleetcode
Full list of solutions are found in this repo. make sure you star it.

Bye!

You need to know about Neubrutalism Style

Anas Dew — Mon, 12 Dec 2022 13:19:03 +0000

I recently came to know about Neubrutalism. Well bear with me for a minute. I'll let you know the thing I'm talking about.

What is Neubrutalism ?

For short, Neubrutalism is an architectural style that emerged in the 1950s, characterized by its use of raw, unadorned concrete construction. Buildings in this style often have a blocky, geometric appearance, with a focus on functionality and simplicity.

How did it come to web design?

A few popular websites, like Gumroad and Figma, popularized it in some way. And lots of websites are using it.

See Below

Why I Got Excited to Tell You About this?

Because I've done it with my website too! And I transformed it from a normal design to a neubrutalism style in just 4-5 hours.

This is what I did.

Here are a few things that I did to make it look neubrutalism style.

Used Headings in CAPITAL LETTER
Bold fonts
High Contrast Colors
High Contrast Shadows
Sharp Edges (In some elements)

And the result that came out was BEAUTIFUL. Although I'll make some changes in a few days and make it more BRUTAL. And I'm planning to add some animations too.

🍕 Check Out -> http://anasdew.tech/

Thanks for reading this post! I'll see you in the next one!

Your Next Read -> I Built a REDDIT BOT

I created my own custom blog, Does it cool?

Anas Dew — Sat, 10 Dec 2022 14:13:19 +0000

About a week ago, I was fascinated by the thought that why not create my custom own blog and share about tech news and stuff, So i did. Here's how I did it.

First things first.

I've built this whole custom blog on HTML, CSS and Javascript. And used a free template for frontend.

The Design

I followed a design similar to a wordpress blog named TechCrunch and it goes like this.

Blog/index.html -> main page
Blog/2022/12/ -> all blogs which published in Dec 2022.

For doing something like this, I've created a master folder in the root to store css and javascript files. And all HTML files will be blogs and I will have to be replicated.

I know this may sound a little tricky so see the screenshot below.

So each blog HTML will get it's css and js files from assets folder. That's it how it's done. And the custom blog is ready.

Each time I do have to publish a blog I'll duplicate the old one and then edit the Title, Meta Description, Image, And Content Inside it. It takes a few minutes to do it.

And then push it to github and it is published. And the next step is to goto google search console and request indexing of my new blog's URL.

How Do I Write A Blog?

First I get the idea (Of course) and then I write my blog in Markdown using any online tool (Not decided which to use for permanent) and then I convert that Markdown into HTML using this tool.

And then I replace it with the content in HTML and then time to post.

I didn't create any panel like in Dev.to just edit and post it.

How is it?
Oh the link of blog is here, check out and comment here if you got any feedbacks.

🎈 Thanks for reading...

Follow me if you're interested in web dev and about tech stuff and interesting projects.

This weekend I'm going to build a google clone. And I'll share about this only on Devto. So follow me to not MISS OUT!

ChatGPT is taking over the world by this.

Anas Dew — Sat, 03 Dec 2022 17:05:39 +0000

OpenAI is a research institute focused on developing artificial intelligence in a safe and responsible manner. It was founded by Elon Musk, Sam Altman, and other prominent figures in the tech industry with the goal of advancing the field of AI and ensuring that it is used for the benefit of all humanity. OpenAI is known for its work on developing advanced AI algorithms, including GPT-3, which is one of the largest and most powerful language processing models in the world.

What is Chat GPT

It is a trained chatbot that has conversational interactions. According to OpenAI, the dialog format enables ChatGPT to respond to follow-up queries, acknowledge its errors, refute false premises, and reject inappropriate requests.

It is claimed that it can respond to all types of writing, including theoretical essays, mathematical solutions, and stories.

What I asked to Chat GPT

Explain me machine learning in simple words.

Would it be possible for humans to stay on Mars?

It was fun talking to the chat gpt about various topics.

So it was a quick short blog about my experience with chat gpt.

If you liked it, share it with a friend.
See you.

Introducing Notastic - Because notes have emotions too! | MongoDB Atlas Hackathon 2022 on DEV

Anas Dew — Sat, 26 Nov 2022 03:46:15 +0000

What I built

I've built an on the go notes web app that helps you keep track of your notes while you're on the go. It's easy to use and you can access your notes from anywhere.

Category Submission:

Choose Your Own Adventure

App Link

https://notastic.web.app/

Screenshots

Description

Notes are secured with a JSON Web Token (JWT) authentication. User has unlimited notes per account.

The notes are colored according to tags or what I call emotions. Such as red for love, blue for work, yellow for notes and so on.

Link to Source Code

Github

Permissive License

MIT

Background

I was fascinated by the MERN stack's capabilities while learning about it, and I wanted to know more. So I had the inspiration to make a notes app, and as I was working on it, I considered adding an emotion function.

How I built it

(How did you utilize MongoDB Atlas? Did you learn something new along the way? Pick up a new skill?)

Additional Resources/Info

Null

Finally, i want to thank Devto and MongoDB who've organized this amazing hackathon.