Skip to content

This project implements a simple contact management system using SQLite as the backend database. It allows users to perform various operations such as adding new contacts, deleting contacts, updating contact information, and checking if a contact exists by name. This system is designed to be simple and make use of command line as UI.

Notifications You must be signed in to change notification settings

ARAVINDs2002/Contact_Management_system_using_SQLITE_and_Python

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Please remember that while testing or using any app online use meaningfull data and dont be a fool like m...ahem..certain people i know.

Contact Management System Documentation

Overview

This project implements a simple contact management system using SQLite as the backend database. It allows users to perform various operations such as adding new contacts, deleting contacts, updating contact information, and checking if a contact exists by name ,all done with dictionary in python. This system is designed to be simple and make use of command line as UI.

Database Setup

The project uses a SQLite database named contacts.db to store contact information. The database has a single table named contacts with the following schema:

👉name: The contact's name (Primary Key)

👉phone_number: The contact's phone number

Features

The following operations are available to manage contacts:

👉Insert Contact Adds a new contact with a given name and phone number. If a contact with the same name already exists, it is replaced with the new phone number.

👉Clear All Contacts Deletes all contacts from the database.

👉Delete a Contact Deletes a contact by name.

👉Add or Update Contact Adds a new contact or updates the phone number of an existing contact.

👉Display All Contacts Displays a list of all contacts in the database.

👉Check Contact by Name Checks if a contact with a given name exists, and if so, displays the phone number.

👉Exit Closes the database connection and exits the program.

How to Use

👉Run the Script Execute the Python script to start the contact management system.

Select an Option

A menu will appear with different operations. Enter the corresponding number for the desired operation.

👉Perform the Operation

Depending on the chosen option, follow the prompts to enter information or confirm actions.

👉Exit To exit the program, select option 7. This will close the database connection safely.

Please understand that I have not implemented this with a real web-based UI or an app because I focus on completing my projects through the command line for testing purposes initially. I recognize that the command line may seem a bit old-fashioned, but it provides all the necessary operations just like a web interface or an app. Thank you for your time, and have a great day!.

About

This project implements a simple contact management system using SQLite as the backend database. It allows users to perform various operations such as adding new contacts, deleting contacts, updating contact information, and checking if a contact exists by name. This system is designed to be simple and make use of command line as UI.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages