SQL - lesson 8 | HackIndia Skills

SQL - lesson 8 | HackIndia Skills | HackIndia

Example

Simple repo layout

Use names that make sense without explanation. If someone opens your repo on a phone, they should know where the database files are.

canteen-orders/
  README.md
  package.json
  src/
    server.js
    db.js
    orders.js
  db/
    schema.sql
    seed.sql
  .env.example

Example

README starter

Your README is the demo guide. Write it for a classmate who has Node.js and a database installed, but has never seen your code.

# Canteen Orders

A small SQL-backed feature to create and view canteen orders.

## Feature
Students can place an order with item name, quantity, and phone number.
The app stores orders in SQL and lists recent orders.

## Tech
Node.js, Express, PostgreSQL

## Run locally
1. Clone the repo
2. Run npm install
3. Create a local database named canteen_orders
4. Run psql -d canteen_orders -f db/schema.sql
5. Run psql -d canteen_orders -f db/seed.sql
6. Copy .env.example to .env and set DATABASE_URL
7. Run npm start

## Sample query
SELECT id, item_name, quantity, created_at
FROM orders
ORDER BY created_at DESC
LIMIT 10;

## Safety
User input is sent using parameterised queries, not string joining.

Ship the SQL feature repo

Repo proves the feature

What to ship

Use this structure

Simple repo layout

README starter

Do not hide SQL

Use AI carefully

Do this now

Quick check