To learn Python and SQL, I built a command line application!
Users sould be able to create notes with titles and contents. They should be able to see a list of their notes and select and view a specific note.
- Clone this repository.
- (Optional) Set up the SQL database for this exercise (instructions below).
- Change into directory created from clone.
- Follow setup instructions below.
- Run
python3 main.py
Before you get started, create a new database called notes and load the
provided data in notes.sql:
# Enter psql:
psql
# Create database:
CREATE DATABASE notes;
# Connect to notes:
\c notes
# Load note.sql:
\i path/to/notes.sql
# (replace /path/to/notes.sql with the actual path to the file)
# ex. /Documents/sandbox/cython_cli_notes/lib/notes.sqlOnce you have the command line version working consider the following bonuses:
- Get Update and Delete working
- Build a user interface with tkinter, pygame, or PySimpleGUI
- Use web scraping to pull data from a webpage using requests and BeautifulSoup
- All content is licensed under a CCBYNCSA 4.0 license.
- All software code is licensed under GNU GPLv3. For commercial use or alternative licensing, please contact legal@ga.co.