Build a Facial Recognition Attendance System

Eventually, I turned my script into a web app with Flask and hosted it on Heroku. I charged $9/month for unlimited scraping, and within a few months, I had over 50 active users paying for access.

• Simple ideas can be profitable. You don’t need to build the next big startup to make money.
• Marketing is just as important as coding. I promoted my work on Reddit, Twitter, and Discord developer communities.
• Automate where you can. Instead of writing a new script for every client, I built a reusable tool and sold it multiple times.

import schedule
import time

# Schedule the price checker to run every hour
schedule.every(1).hour.do(check_price)

while True:
    schedule.run_pending()
    time.sleep(1)

Run the script, and it will automatically check the product price every hour and send email alerts if the price drops below your threshold.

from openpyxl.styles import Font, Alignment

# Bold headers
for col in range(1, 6):
    cell = sheet.cell(row=1, column=col)
    cell.font = Font(bold=True)

# Set column widths
sheet.column_dimensions['A'].width = 15
for col in ['B', 'C', 'D', 'E']:
    sheet.column_dimensions[col].width = 12

# Center-align headers
for col in range(1, 6):
    cell = sheet.cell(row=1, column=col)
    cell.alignment = Alignment(horizontal="center")

# Save the formatted workbook
workbook.save('sales_report_formatted.xlsx')

We’ll highlight products with total sales greater than 4000 in green.

• Always validate and sanitize user inputs to prevent SQL injection attacks, even though SQLite is less prone to such vulnerabilities compared to other DBMS.

• As demonstrated in the tutorial, use parameterized queries (? placeholders) to prevent SQL injection.