gitwtfhub

wtf is webdb-ii-challenge?

scottschindler/webdb-ii-challenge — explained in plain English

Analysis updated 2026-08-04 · repo last pushed 2019-08-10

Audience · developerComplexity · 2/5DormantSetup · easy

TL;DR

A student coding challenge to build a car dealership inventory API using a database. Students create database tables for car records and build endpoints to add and retrieve car data like VIN, make, model, and mileage.

Mindmap

mindmap
  root((repo))
    What it does
      Car inventory database
      Add new car records
      Look up car records
    Tech stack
      Knex
      SQLite
      Postman or Insomnia
    Use cases
      Bootcamp practice project
      Learn database schemas
      Practice API endpoints
    Audience
      Web dev students
      Bootcamp learners
    Workflow
      Fork and branch
      Submit pull request
    Stretch goals
      Update and delete records
      Sample data seeding
      Track car sales

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Why would anyone build with this?

REASON 1

Build a backend API for a car dealership to manage inventory records.

REASON 2

Practice creating database schemas to store structured car data like VIN, make, and model.

REASON 3

Learn to write API endpoints that let other software add and retrieve records from a database.

REASON 4

Extend the project with update, delete, and sales-tracking features as stretch goals.

What's in the stack?

KnexSQLiteJavaScriptNode.jsPostman

How it stacks up

scottschindler/webdb-ii-challenge00kaku/gallery-slider-block04amanrajj/netwatch
Stars0
LanguageJavaScriptRust
Last pushed2019-08-102021-05-19
MaintenanceDormantDormant
Setup difficultyeasyeasymoderate
Complexity2/52/53/5
Audiencedevelopergeneralops devops

Figures from each repo's GitHub metadata at analysis time.

How do you spin it up?

Difficulty · easy Time to first run · 30min

Requires Node.js, Knex, and SQLite installed locally, plus Postman or Insomnia to test the API endpoints.

No license information is provided, so default copyright restrictions apply and others may not freely reuse or distribute this code.

Wtf does this do

This is a coding challenge repository for students learning to build backend APIs with databases. The practical scenario is a car dealership that needs a system to manage its inventory. The student's job is to build a small application that can store and retrieve car records, tracking details like VIN, make, model, and mileage, along with optional information like transmission type and title status. At a high level, the project asks students to set up a database structure (called a "schema") for storing car data, and then write the code that lets other software talk to that database. Students use tools called Knex and SQLite to handle the database side of things. On the API side, they create endpoints, essentially URLs that respond to requests, that let you add new cars to the database or look up the cars already in it. Testing tools like Postman or Insomnia are used to simulate those requests and make sure everything works. The audience here is a student in a web development bootcamp or course, likely working under the guidance of a project manager or instructor. The workflow itself is part of the learning: students fork the repo, work on their own branch, and submit a pull request for review rather than merging their own code. This mirrors how real development teams collaborate on shared codebases. Beyond the core requirements, there are optional stretch goals for students who finish early or want extra practice. These include adding the ability to update or delete car records, pre-populating the database with sample data, and designing a separate table to track car sales. That last goal introduces the concept of linking related tables together, which is a foundational skill in working with relational databases. The README doesn't go into much detail about the expected code structure or specific implementation patterns, which is typical for a challenge where the student is expected to apply what they've learned rather than follow step-by-step instructions.

Yoink these prompts

Prompt 1
I am working on a car dealership inventory challenge using Knex and SQLite. Help me write a database schema that stores car records with fields for VIN, make, model, mileage, transmission type, and title status.
Prompt 2
I need to build API endpoints for a car dealership inventory app. Write the endpoint code so I can add a new car record and retrieve all cars from a SQLite database using Knex.
Prompt 3
I finished the core requirements for my car inventory API challenge. Help me add stretch goals: an endpoint to update a car record, an endpoint to delete a car record, and a function to seed the database with sample car data.
Prompt 4
I want to add a sales tracking table to my car dealership database that links to the cars table. Help me design the schema and write the Knex migration to connect car sales to existing car records.

Frequently asked questions

wtf is webdb-ii-challenge?

A student coding challenge to build a car dealership inventory API using a database. Students create database tables for car records and build endpoints to add and retrieve car data like VIN, make, model, and mileage.

Is webdb-ii-challenge actively maintained?

Dormant — no commits in 2+ years (last push 2019-08-10).

What license does webdb-ii-challenge use?

No license information is provided, so default copyright restrictions apply and others may not freely reuse or distribute this code.

How hard is webdb-ii-challenge to set up?

Setup difficulty is rated easy, with roughly 30min to a first successful run.

Who is webdb-ii-challenge for?

Mainly developer.

View the repo → Decode another repo

This repo across BitVibe Labs

Don't trust strangers blindly. Verify against the repo.