Build US Sales Tax Calculator CLI App - Node programming + SQLite DB

In this tutorial, I will show you how to create a powerful node CLI application to calculate the sales tax on your purchases based on your state of residence in the United States of America.
The application uses SQLite to store the tax rates for each state and Inquirer to prompt the user for the purchase amount and state.
I will start by creating a new instance of an in-memory SQLite database and then create a new database table.
After populating the table with the sales tax data for 2023 from the Tax Foundation website, I will use Inquirer to prompt the user for the purchase amount and state. Finally, he will use the state entered by the user to retrieve the tax rate from the SQLite database and calculate the sales tax owed. Whether you're a seasoned developer or just starting out, this tutorial is for you. So grab your favorite coding tools, and let's dive right in!

Equipment used in this production:
1- Keyboard
Logitech POP Keys Mechanical Wireless Keyboard with Customizable Emoji Keys, Durable Compact Design, Bluetooth or USB Connectivity, Multi-Device, OS Compatible - Blast Yellow

2- Microphone
Rode VideoMic Pro R Camera-Mount Shotgun Microphone

[Excel file for tax rates 2023 is included].

Connect with me on social media:

Join this channel to get access to perks:

[amarek]

Hi Amir, thanks for this tutorial it is very useful and I will be very grateful if you continue doing more of these little applications, not that’s only useful but teaching a lot of programming features

[marcus]

So cool man these apps I liked also the bus CLI, please do more and r these apps as I learn a lot

[MounirSMalak]

Can you create a tutorial in Django or express that calculates how many calories to be consumed to loose certain weight ? Btw very good tutorial seriously you do great work in every video you post

[robertwolinski]

Not to be 'that guy' but LA is Louisiana, AR is Arkansas, AZ is Arizona, and AK is Alaska.

More focused on the code, I originally thought there was a typo on the variable 'amount' in the callback function when getting the response from inquirer (line 100 in the video, 98 in GitHub). Did you fix that and I missed it or did the code somehow work as is? Looking at the GitHub repo the typo clearly isn't there.

[helionyxcollective]

Doesn’t the US tax rates vary based on jurisdictions within the state too? How to solve that problem?

[henoknigatu]

hey bek...can you make a crash course on how to import mysql db which have two tables connected with "primary and foregin key"(eg. passangers info with one table and their detail info with another table ) in to django and make post request to both tables using axios in react. i have tried it with djangorestframework nested serializer but the axios post request only works for only the parent table data the other(detail) returns "200 0" success code but the data is empty when i check it. but it works fine on the restapi get and post page.