DEV Community: Preethi Vuchuru27916

Blog App using AWS Amplify, Angular

Preethi Vuchuru27916 — Mon, 27 May 2024 05:37:00 +0000

This is a submission for the The AWS Amplify Fullstack TypeScript Challenge

What I Built

I built a Blog Application using AWS Amplify and Angular where we can create a Blog by providing Title and description, list all the blogs and read a specific Blog.

Demo and Code

SOURCE CODE: https://github.com/PreethiVuchuru27916/amplify-angular-template
App URL: https://main.dvwj8fwztcl1x.amplifyapp.com/blog-list/0fefede3-f5ac-4f8c-be69-4ed412601c8d

[1] Create Blog Button provides the user with a text editor to start working on the blog.

[2] Used the ngx-editor to build the text editor and provided a scroll to add content of any size.

[3] Have a publish option to create the Blog and show it under the list of Blogs

[4] List of Blogs

[5] Read more option on the list will take us to the individual Blog.

[6]Utilized Sign out and Sign In and Create Account features provided by Amplify

Integrations

I have create a model called Blog that has title and description. To save it to a personal cloud sandbox, I ran the npx ampx sandbox to get amplify_outputs.json file. This allowed me to make backend updates in a private cloud space.
I have used authentication module and @aws-amplify/ui-angular for building the Sign Up, Sign In, Create Account. Also tried out the customization available for the Authenticator.

FUTURE WORK

Will add a cover image that will make use of the File Storage concepts in AWS Amplify.
Will add notifications to be sent over by using serverless functions.
Will add draft versions and make sure only the loggedin users can see the drafts of their own.

Thank you Dev.to for interesting challenges :) I knew about the challenge really late and was not able to finish what I had in mind. But something is better than nothing and hence my submission. Challenges like these are a great opportunity to explore new technologies. Excited for more challenges in future.

Deploying Spring Boot Application on Heroku and connecting the app to MongoDB Atlas

Preethi Vuchuru27916 — Wed, 01 Mar 2023 23:32:55 +0000

Hello Readers,

I recently tried to set up a Spring Boot application on Heroku that could connect to a MongoDB database hosted on MongoDB Atlas. Along the way, I faced several challenges that I wanted to document for future reference. I thought this information could also be helpful for other people who may be trying to do the same thing.

Here are the things I'll need for a quick deployment:

A text editor such as IntelliJ
A Spring Boot project
An account with MongoDB Atlas
An account with Heroku

I set up a sample Spring Boot project using Spring Initializr [start.spring.io].

Next, I added some simple dependencies like Spring Web, Spring Boot Dev Tools, and Spring Data MongoDB.

I created a simple REST service that only has one POST method to store details to the database.

Model

Repository

Controller

Deployment to Heroku

To deploy my application to Heroku, I followed these steps:

First, I created an account on Heroku.
Then, I created a new app by clicking on "New" and gave it a name and region.
Heroku automatically creates many things for us, but we only need to focus on the deploy option it provides for hosting applications.
To deploy my code to Heroku, I needed to have a GitHub repository to store it. This repository could either be my personal GitHub repository or a Heroku-provided GitHub repository that is created when the app is created.
I chose to use the Heroku-provided GitHub repository for pushing my changes.

To push changes to heroku git repository

git init
heroku git:remote -a sample-prooject
git add
git commit -m "initial commit"
git push https://git.heroku.com/sample-prooject.git

Now, whenever I push changes to the repository, Heroku automatically starts the build process to deploy the updated application.

However, I faced an error during the deployment process. The reason for this error was that Heroku, by default, compiles using Java 8, but my project was specified to use Java 17.

To resolve this issue and instruct Heroku to handle Java 17, I needed to add a file called "system.properties" in the root folder of my project. This file included the following line:

java.runtime.version=17

After adding and committing the changes to my repository, I pushed the changes to Heroku using the command "git push https://git.heroku.com/sample-prooject.git".

Next, I wanted to store my data in a cloud-based MongoDB database and decided to use MongoDB Atlas for this purpose.

To get started with MongoDB Atlas, I followed these steps:

I created an account on MongoDB Atlas.
I chose the M0 option for deploying the database, as it was free of cost.
I selected AWS as the provider and chose the nearest available region.
I named my cluster "Cluster".

After setting up the cluster, I created a database user for my MongoDB database.

Now I clicked on "Connect" in the MongoDB Atlas dashboard.

spring.data.mongodb.uri=mongodb+srv://preethi27916:<yourpw>@cluster.ogokpuw.mongodb.net/?retryWrites=true&w=majority

spring.data.mongodb.database=sampledb

Now I pushed my changes to heroku git to host the application.
Next, I added a connection IP address (i.e., the IP address from which I wanted to connect to this database) and clicked on "Connect to Application". [During the initial stages of setting up the connection between my application and database, I faced an issue where the connection was failing. After some investigation, I discovered that the Heroku-deployed application IP was not being recognized by MongoDB Atlas. To resolve this issue, I had to whitelist the IP address by specifying 0.0.0.0/0, which means that my database could be accessed from any IP address.].
MongoDB Atlas provided me with a connection string, which I needed to specify in the application properties file (located in the resources folder) of my Spring Boot project.

Finally, I tested my application by invoking the URL "https://sample-prooject.herokuapp.com/name/ihteerp" with a POST method.

After testing my application and verifying that the data was being inserted into my MongoDB database, I can confirm that I have successfully completed the deployment of my application and database, and have set up the interaction between the two.

What exactly does Indexing in a Database do?

Preethi Vuchuru27916 — Sun, 04 Oct 2020 07:18:12 +0000

Hey there! While working with the database, I came to know how important it is to use index on a table which holds a large number of records. In this article, I will be explaining
what difference does it make to add an index to a table.

Consider the below student table is created in Oracle SQL Database.

Now I want to get the details of the students who are in Primary Grade. Obviously I need to write a select query.

Select * from student where student_grade = “Primary”;

Now what happens?

Internally it identifies the column student_grade and searches sequentially all the records which match Primary.

It finds the first record matching primary and returns the row. It finds the second record matching primary and returns the row. It continues its process of finding Primary. Skips third record and finds fourth record matching primary. Now does it stop? No. It still continues to go till the end of the table searching for primary.

It will look fine for a table with just 5 rows but what if I have a table with 10000 records.

Lot of time gets involved and who would respect such a time delay?

Here is where our Indexing comes to save the time. We are all aware of what indexing means. It keeps references for quicker access. A cliche example would be a index of a textbook keeping page references to topics covered in the book.

Now lets create a index on the column Student_grade and see what happens.

Create index student_student_grade_I on student(student_grade);

student_student_grade_I is the index_name.

With the addition of index on our table, a new data structure gets created which will hold the student_grade and a pointer that references the original record in the table. The Data Structure is BTree which offers the advantage that it has all the records sorted. A index would look similar to the below table on the left.

It now finds 2,3,4 records matching primary. Stops executing and returns the records with the help of record_pointer.

References

1)https://www.youtube.com/watch?v=aZjYr87r1b8
2)https://chartio.com/learn/databases/how-does-indexing-work/