Daily Coding Challenges & Projects

Frontend Mini Project Challenge

Theme: Vue.js Components

Challenge :

Create a reusable Vue component for a star rating system.

Requirements :

• Accept props for maxStars, selectedStars
• Emit event on star click
• Supports hover and active state

Bonus : Allow half-star ratings using mouse position.

Backend Challenge

Language Focus : Python, PHP

Challenge :

Python Flask API : Create a simple Flask endpoint that accepts a JSON payload with user data and stores it in a dictionary (simulate DB).

Bonus: Add basic validation and return appropriate status codes.

Database Query Challenge

Problems on SQL - HR Database :

1. Write a SQL query to list all managers who supervise more than 5 employees.
2. Write a query to find employees whose salary is higher than their department average.

Data Structures & Algorithms Challenge

• Easy:
• Problem : Given a string, check if it's a palindrome.
• Hint : Compare characters from both ends.
• Medium:
• Problem : Implement the merge interval algorithm.
• Hint : Sort intervals by start and merge overlapping ones.
• Hard:
• Problem : Solve the Word Ladder problem using BFS.
• Hint : Preprocess the word list into transformation groups.

Bug of the Day

Language Focus :

Language : Python

Buggy Code:

# What's wrong?
def get_max(numbers):
  max = 0
  for n in numbers:
    if n > max:
      max = n
  return max

print(get_max([-3, -5, -2]))

Fix the bug :

Hint : What's the default value doing here?

📋 Daily Micro-Project

Database Focus :

Optimize an SQL query to fetch employees with the highest salary per department.

• Use ROW_NUMBER() or MAX() with GROUP BY.
• Benchmark performance using EXPLAIN.

Trivia: 5 Fun Facts

1. The original Python name was inspired by Monty Python's Flying Circus.
2. PHP originally stood for Personal Home Page.
3. The term "Pythonic" describes idiomatic Python code.
4. The first SQL database was called System R developed by IBM.
5. Vue.js was created by Evan You in 2014 after working at Google.

Tool & Resource of the Day

Tool : DB Fiddle

Test and share SQL queries easily. Great for interviews or experiments.

https://www.db-fiddle.com

Interview Question of the Day

Daily Interview Questions

Frontend :
1. What is the difference between props and data in Vue.js?
2. How do watchers differ from computed properties?
3. What are Vue.js lifecycle hooks?
4. How does v-model achieve two-way binding?

Backend :
1. How does Python handle memory allocation for variables?
2. What is a WSGI application?
3. What are PHP sessions and how are they managed?
4. How do you protect against SQL injection in PHP?

Database ( SQL ) :
1. What is a correlated subquery?
2. How does AUTO_INCREMENT work in MySQL?
3. What is the difference between VARCHAR and TEXT?

Others :
1. What is a deadlock? How can it be prevented?
2. What is the role of a shell in Unix/Linux?

Daily Quiz Challenge

Frontend Quiz :

1. What directive binds a value to an input in Vue.js?
• v-text
• v-model
• v-bind
• v-on
2. Vue’s v-if and v-show differ in:
• Both remove element from DOM
• v-show toggles visibility only
• v-if toggles display:block
• v-if binds innerHTML
3. Which of the following is not a Vue lifecycle hook?
• mounted
• destroyed
• beforeUpdate
• onClick

Backend Quiz :

1. Which HTTP method is idempotent?
• POST
• GET
• PATCH
• DELETE
2. Which PHP function connects to MySQL?
• mysql_start()
• mysqli_connect()
• connect_mysql()
• db_link()
3. In Flask, which decorator is used for routing?
• @run
• @path
• @route
• @app.route

Others :

1. Database : What SQL clause helps group results?
• ORDER BY
• GROUP BY
• HAVING
• WHERE
2. General : Which command lists running processes in Unix?
• jobs
• ls
• ps
• run

Weekly Cross-Domain Activities ( June 20 to June 26, 2025 )

API of the Day:

Task : Integrate the News API to fetch top headlines based on user-selected categories.

Bonus :Add search and filter by country or keyword.

Linux/DevOps Tip :

Title : Monitor Server Resources

Commands :

• top – Live process monitoring
• df -h – Disk space usage
• free -m – Memory usage
• uptime – Server load
• lsof – Open files

Real-World Project of the Week ( June 20 to June 26, 2025 )

Project of the Week:

Build a Resume Builder Web App

• Tech Stack: HTML, CSS, JavaScript (React optional)
• Features: Section-wise input (Education, Experience, Skills), Live Preview, Download as PDF

Collaborative Project:

Idea : Open-source a Daily Code Challenge Tracker

• Use GitHub Projects or issues to track challenges.
• Allow contributors to submit PRs for daily code solutions.

Case Study:

How Netflix Handles Streaming at Scale

• Topics: CDN, Microservices, Chaos Engineering
• Activity: Recreate a mini Netflix UI with static video thumbnails and categories using React or Vue.