DEV Community: Timileyin D

Introduction Cyber Security

Timileyin D — Sun, 11 Feb 2024 11:42:39 +0000

From my experience, I will define cyber security as the science or an art of keeping business in business.
It is a deliberate attempt to keep business safe on the internet.

Introduction Cyber Security

Timileyin D — Sun, 11 Feb 2024 11:42:34 +0000

From my experience, I will define cyber security as the science or an art of keeping business in business.
It is a deliberate attempt to keep business safe on the internet.

How to use SQLC with Golang

Timileyin D — Wed, 03 Jan 2024 10:16:07 +0000

What is SQLC

SQLC is a type-safe SQL code generator, it is used to generates fully type-safe idiomatic code from SQL and catch failure before they happen, it support different languages like Golang, Kotlin and Python. The main advantage of using SQLC is that it generate type-safe code from the SQL queries.

How SQLC work

You write SQL queries
You run sqlc to generate Go code that presents type-safe interfaces to those queries
You write application code that calls the methods sqlc generated

SQLC golang sample

To get started, we need to navigate to the desired directory and run the command below in our terminal:

mkdir sqlc_go && cd sqlc_go

also create db/migration and db/queries folder

Implementing SQLC in golang involves installing *golang-migrate * package,this helps to fully utilize SQLC full potential.

We proceed to install the required golang-migrate dependencies with:

$ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$os-$arch.tar.gz | tar xvz

The code above install golang-migrate. We can then proceed to creating the migration file for the user by running the below code.

migrate create -ext sql -dir db/migration -seq add_users

This will generate two serialized file that looks like the image attached below.

where the .up.sql file is for the SQL query model definition while the .down.sql file is for changes reversal.

Insert the SQL query into the .up.sql file. see the code below

while the below code inside the .down.sql file

The code in the .down.sql file will be use to reverse the changes made to the database(DB)

The user.sql file in the db/queries folder will contain the code below which instruct SQLC on the method to be generated.
It will create CreateUser, GetUser among other method

Pull a Postgres image from the docker hub and create a database on the running Postgres instance.
Create sqlc.yaml by running

sqlc init

(image below) to set the configuration for the SQLC

The code above instruct golang-migrate to look out for the db/migration folder when the migration code below is been executed

migrate -path db/migration -database "$(DB_URL)" -verbose up

sqlc generate

the code above will create sqlc folder in the db folder also create a db.go file in the db/sqlc folder
which explicitly define the database architecture and database method that can be used in our controller, remember this method was defined in our db/queries folder. Image attached below

Conclusion

This article demonstrate how to use SQLC in a golang application, its role in building type-safe idiomatic code and how to get started by building a user management service with Golang and Postgres DB.

The Basics of Web Development: A Comprehensive Guide for Beginners

Timileyin D — Mon, 01 Jan 2024 15:52:13 +0000

Introduction

In the fast-evolving world of technology, understanding the basics of web development has become an essential skill. Whether you're an aspiring developer, a business owner looking to build an online presence, or simply curious about how websites work, this comprehensive guide will provide you with a solid foundation in web development.

What is Web Development?

Web development encompasses the creation and maintenance of websites and web applications. It involves a combination of programming, design, and problem-solving skills. There are two main components of web development:

Front-End Development

Front-end development focuses on the user interface and user experience. It involves designing and building the elements that users interact with directly. HTML, CSS, and JavaScript are fundamental languages in front-end development. HTML structures the content, CSS styles it, and JavaScript adds interactivity.

Back-End Development

Back-end development involves server-side programming, databases, and server management. It's responsible for the functionality of the website, handling data, and ensuring smooth communication between the front end and the server. Common back-end languages include Python, Ruby, PHP, and Node.js.

Key Technologies in Web Development

HTML (Hypertext Markup Language): HTML is the backbone of web development. It structures content on the web, defining elements like headings, paragraphs, and images and below is how the HTML skeleton looks like

CSS (Cascading Style Sheets): CSS is used to style HTML elements, making websites visually appealing. It controls layout, colors, fonts, and overall design.
JavaScript: According to MDN JavaScript is a scripting or programming language that allows you to implement complex features on web pages — every time a web page does more than just sit there and display static information for you to look at — displaying timely content updates, interactive maps, animated 2D/3D graphics, scrolling video jukeboxes. JavaScript adds interactivity to websites. It enables features like dynamic content, form validation, and the manipulation of webpage elements in real-time.
Responsive Design: With the increasing use of various devices, responsive design ensures that websites look and function well on desktops, tablets, and smartphones.
Frameworks and Libraries: Frameworks like React.js and Angular.js, as well as libraries like jQuery, streamline the development process by providing pre-written code and structure.
Server-Side Development: For back-end development, understanding server-side languages (e.g., Node.js, Django, Gin and Fibre) and databases (e.g., MySQL, MongoDB) is crucial.

Learning Resources for Beginners

Online Courses: Platforms like Codecademy, Udacity, and freeCodeCamp offer interactive courses for beginners to learn web development step by step.
Documentation: Explore the official documentation of web technologies. For instance, MDN Web Docs is an excellent resource for HTML, CSS, and JavaScript.
Community and Forums: Engage with the web development community on platforms like Stack Overflow, Reddit (e.g., r/webdev), and join forums to seek advice and solutions to common problems.
Projects: Apply your knowledge by working on small projects. Building a personal portfolio or a simple website allows you to practice and showcase your skills.

Conclusion

Web development is an exciting and dynamic field that welcomes beginners with open arms. By mastering the basics, exploring key technologies, and engaging with the community, you'll pave the way for a rewarding journey into the world of web development. Remember, practice and continuous learning are the keys to becoming a proficient web developer. So, roll up your sleeves, dive into the code, and embark on your web development adventure!

Golang Database Migration With Golang Migrate and Sqlc

Timileyin D — Fri, 11 Aug 2023 13:55:01 +0000

Database migrations are a crucial component of controlling a software application's evolution. They give programmers the ability to modify the database schema while maintaining the accuracy and consistency of the data. Golang-migrate, a strong library for the Go programming language, offers a practical method for managing database migrations. In this article, we'll look at how to do efficient database migrations in Go using golang-migrate.
Firstly, let's start by answering:

What Is SQLC

SQLC stands for SQL Compiler is a tool and framework used for type-safe SQL queries in Go programming. SQLC allows you to write SQL queries as part of your Go code, and it automatically generates Go code that represents those queries as native Go functions. like we defined it earlier it is just a framework to generate type safe queries in Golang.

Getting Started With Golang Migrate
To start with golang migrate you have to first install Golang on your machine. Here is the link to download Go for your respective device OS then get your project setup.
The next thing is to install golang migrate



go get -u -d github.com/golang-migrate/migrate/cmd/migrate


```             or `brew install golang-migrate` for Mac OS 

You can use golang-migrate to manage your database migrations once the installation is complete.



## How To Create A Migration

Running a golang `migrate create` command will help you create a sequence up and down .sql file for your migration name. This SQL files are used by Golang-migrate to specify database migrations. Each migration file contains a series of SQL statements that must be run and reflects a particular version of the database schema.
And below is the command to generate a migration files

migrate create -ext sql -dir -seq {theName}

This command will generate a new migration file in the specified directory with a name reflecting the migration version and a descriptive name. 
For example: ```


migrate create -ext sql -dir  <db/migration> -seq init-schema

This will generate this files for us in the db/migration folder

where the up.sql file is use to make changes to the database why down.sql file is to revert the changes.

How To use the migration file

Below is an instance of how to use the migration file in the generated init-schema.up.sql file.

In the image above is our SQL queries to create users table in the table and below is how to revert the changes.

The above steps has create for us migration file, the next step is to migrate the schema migration file to the Database.

Migrating the migration file to the database.

The code below shows how to migrate a migration file to a Postgres Database

where root is the username and secret is the password, localhost is the host, 5432 is the port and Sample is the name of the database to migrate into.

To remove such migration from the DB also, all we have to do is to run this command.

In the next article I will explain how to generate CRUD Golang code from the SQL files.

I hope you learn a thing or two from this, see you in the next one.