Hack with SQL

• 

  hack-with-sql-image.png

Inspiration

This project is inspired by MLH GHW: INIT (2023) — Day 3 Challenge: Hack with SQL

What it does

This project uses SQLAlchemy to access a Postgres database. The data must readily be available in the database.

How I built it

I built this project from scratch by first setting up the environment and installing the dependencies. There is also an additional resource in the setup folder that helps to ease setting up and populating a sample database on the local machine to test the functionality of the project.

Challenges I ran into

Due to time constraints, I am unable to implement the frontend of the project and some additional features in the backend. But hopefully, the idea of backend development with SQL should be visible at this level.

Accomplishments that I'm proud of

I am happy to introduce this concise project to help introduce beginners to the concept of backend development and the idea of setting up a database with SQL and manipulating it using SQLAlchemy in a Flask application and through the shell environment.

What I learned

Through practicing this exercise, I have solidified my experience with SQL, SQLAlchemy, and Flask. I have also had some experience with the shell environment after a long time. It seems like a good time to get up to speed with backend development.

What's next for Hack with SQL

Hack with SQL will continue to evolve into a standalone application for tutorials and demonstration across workshops and hackathons. Contributions are also encouraged. — Godspeed.

Built With

• flask
• postgresql
• shell
• sqlalchemy