DEV Community: CharlesTechy

Designing SQL Database for a blog application

CharlesTechy — Wed, 28 Jun 2023 14:05:32 +0000

With this tutorial we would have an understanding on how create a database schema for a blog application. It defines several tables and their relationships to store information about authors, blog posts, comments, replies, and post likes.

Here's a breakdown of the script:

Creating the blog database:

CREATE DATABASE IF NOT EXISTS Blog;

Creating the Author table:

CREATE TABLE IF NOT EXISTS Author ( author_id INT AUTO_INCREMENT, full_name VARCHAR(255) NOT NULL, about TEXT, is_admin TINYINT(1), status TINYINT(1), date_registered DATETIME, password VARCHAR(255), PRIMARY KEY (author_id) );

This table stores information about authors, including their ID, full name, about section, admin status, status, registration date, and password.

Creating the Posts table:

CREATE TABLE IF NOT EXISTS Posts ( post_id INT AUTO_INCREMENT, title VARCHAR(255) NOT NULL, description TEXT, is_published TINYINT(1), date_published DATETIME, date_edited DATETIME, author_id INT NOT NULL, thumbnail VARCHAR(255) DEFAULT('thumbnail.png'), PRIMARY KEY (post_id), FOREIGN KEY (author_id) REFERENCES Author(author_id) );

This table stores information about blog posts, including their ID, title, description, published status, publication date, last edited date, author ID (foreign key referencing the Author table), and thumbnail image.

Creating the Comments table:

CREATE TABLE IF NOT EXISTS Comments ( c_id INT AUTO_INCREMENT, post_id INT NOT NULL, comment TEXT, is_published TINYINT(1), date_published DATETIME, date_edited DATETIME, author_id INT NOT NULL, PRIMARY KEY (c_id), FOREIGN KEY (post_id) REFERENCES Posts(post_id) );

This table stores information about comments on blog posts, including their ID, post ID (foreign key referencing the Posts table), comment text, published status, publication date, last edited date, and author ID (foreign key referencing the Author table).

Creating the Replies table:

CREATE TABLE IF NOT EXISTS Replies ( r_id INT AUTO_INCREMENT, c_id INT NOT NULL, reply TEXT, is_published TINYINT(1), date_published DATETIME, date_edited DATETIME, author_id INT NOT NULL, PRIMARY KEY (r_id), FOREIGN KEY (c_id) REFERENCES Comments(c_id) );

This table stores information about replies to comments, including their ID, comment ID (foreign key referencing the Comments table), reply text, published status, publication date, last edited date, and author ID (foreign key referencing the Author table).

Creating the PostLikes table:

CREATE TABLE IF NOT EXISTS PostLikes ( like_id INT AUTO_INCREMENT, post_id INT NOT NULL, likes TINYINT(1), is_published TINYINT(1) DEFAULT('1'), date_published DATETIME, date_edited DATETIME, author_id INT NOT NULL, PRIMARY KEY (like_id), FOREIGN KEY (post_id) REFERENCES Posts(post_id) );

This table stores information about post likes, including their ID, post ID (foreign key referencing the Posts table), number of likes, published status, publication date, last edited date, and author ID (foreign key referencing the Author table).

Performing queries on the tables: The script includes sample queries to retrieve data from the tables. These queries include selecting all posts, retrieving a single post by its ID,

A program to calculate the area of a triangle using python

CharlesTechy — Wed, 02 Sep 2020 22:56:07 +0000

Yo! guys today am dropping a snippet to calculate the area of a triangle using Python Programming..

Just like other programming languages like; C++, Java, JavaScript and the rest you can do a lot of mathematical stuff with the Python Lang.

Tho forks may not want to do this but will like to just work with another approach other than this.

1. The First thing to do is to print a message on the screen telling the user about your program.

Using the print statement in Python, we can easily print messages to the user's screen.

print ("A Program to calculate the Area of a Triangle");

2. The next thing to do is to wait for the user's command, by printing on the screen press any button to continue.

input("Press any button to continue...");

with python version 2.x we can easily use

raw_input("Press any button to continue");

3. Tell the user to enter the base of the angle, which will be stored in a variable called 'angleBase'.

angleBase = input("Enter Angle Base\n");

4. Request for the height of the angle, which will be stored in a variable called 'angleHeight'.

angleHeight = input("Enter Angle Height\n");

5. I then declared two variables called 'isHeightANumber' and 'isBaseANumber' and assigned them to the language(Python)'s function called "isdigit()".

isHeightANumber = angleHeight.isdigit();
isBaseANumber = angleBase.isdigit();

What is the work of isdigit()?

"isdigit()" is a python function which checks if a variable value(s) are/is a digit(s).

The last part of the code is shown below

Before Processing/ Calculating the user data, i tried to verify that the fields are not empty or void by using the

if statement and the not equal (!=) operator

if angleBase!="" and angleHeight!="":

Also i consider checking and validating by making sure what the user entered is a number by using the

if statment and isdigit() if isBaseANumber and isHeightANumber:

The last part is all about declaring a variable called areaOfATriangle which will calculate the area of the input entered by the user, if the base and height entered by the user are/is a number, it will print out the area of the triangle, if not it will show the

else statement

which says "Angle Base and Height must be a number"

areaOfATriangle = int(int(angleBase) * int(angleHeight) / int(2));

print("Area of a triangle whose base = ", angleBase, " and height = ", angleHeight, " is = ", areaOfATriangle);


else:
       print("Angle Base and Height must be a number");
else:
       print("Height and Base can't be empty.");

A Letter to young Developers

CharlesTechy — Tue, 14 Apr 2020 19:58:49 +0000

Hey fellow developers, programmers and tech guys in the building. How has be your day and families? I thank GOD for making you see this very day most especially 2020 even though there is the life-threatening pandemic "Codvi-19".

It is a great pleasure writing you this text this day;my aim of delivering this text to you, is a about an advice titled :

How to become a awesome and fabulous programmer

Which deals on the simple errors and corrections you need to adopt in this 2020.

I will be sharing with you the advice quoted above just with the text below in unordered manner.

Use a very cute and code completion text editor e.g Visual Studio code,latest version of Sublime Text ,Github Atom or any other text editor you know how to use best.
Read other people’s code be it pdf or the programs extensions respectively.
Edit the code and try them out by substituting them with your own values, variables or any other related features you can change.
Never make any attempt of claiming the code
Share your codes with other developers far better than you.
Always ask questions when you’re freaking out ;don’t assume you know it because a preacher once said

assumption is not reality.
Check out your environment or social media groups and pages mainly concerned on programming, developing, technology and coding stuffs and seek for mentorship.
Don’t /never be proud when you’re good in some aspects because

pride goes before a fall.
Create a project with what you have learnt so far.
If you think you’re now really,then contribute to open source.
Less i forget read your interested programming language documentations, also CODE && CODE && CODE.

Even if you’re a senior developer i hope you will also find piece this helpful

With this text I really hope you become a great, awesome, fabulous tech dude and word class developer in this 2020.

Much love
From: Sedenu Aloaye Charles
Founder: charlestechy.com.ng

Delta State University Survey Form By Sedenu Aloaye Charles

CharlesTechy — Tue, 18 Feb 2020 06:38:32 +0000