Skip to main content
Tech Trek
  • Database Design
  • Personal Projects
    • boardgameplays
    • gunsmith db
    • Halloween2015
    • pantry
  • DBMS Specific
    • MongoDB
    • MySQL
    • SQLite
    • SQL Server
  • About Me
  • Contact

Tag: gunsmith db

Gunsmith Db and App Part 6: Final Thoughts and Future Development

February 2, 2016February 2, 2016 allison 1 Comment

I’ve been writing a lot about my gunsmith database and application lately.  It has been my largest database project to date by far and has been a really great learning opportunity.  I’ve learned a lot about Visual Basic (this was my first project of really any size with VB).  I’ve learned a lot about building […]

Read More

Gunsmith Db and App Part 5: Search

January 29, 2016January 29, 2016 allison Leave a comment

We have already discussed the gunsmith database and app in depth.  If you want to catch up, there are posts an overview, adding customers, acquisition flow and code, and disposition flow and code. In this post, we will go over the third and final major function of the app: searching.  Sometimes, the user may only […]

Read More

Gunsmith Db and App Part 4.2: Disposition Code

January 22, 2016February 15, 2016 allison Leave a comment

In Part 4.1, I showed the user flow for disposing of a gun.  In this part, we’ll go over the VB code and MySQL commands to get the disposition working. Search For An Acquisition Transaction General Overview VB checks each of the textboxes in the GUI and creates a MySQL query to reflect the criteria the user […]

Read More

Gunsmith Db and App Part 4.1: Disposition Flow

January 19, 2016February 15, 2016 allison Leave a comment

Hey!  Before I get into details on today’s post, I want to point out that I’ve added a way for you to subscribe to new blog posts!  Just enter your email address under SUBSCRIBE on the right side of the site and you will receive an email when I publish a new post! In Part […]

Read More

Gunsmith Db and App Part 3.2: Acquisition Code

January 15, 2016February 15, 2016 allison Leave a comment

In Part 3.1, I showed the user flow for acquiring a gun.  In this portion, we will go over the VB code and MySQL commands to get the acquisition working. Search For a New Customer General Overview VB checks each of the textboxes in the customer search panel and adds those values to a string, […]

Read More

Gunsmith Db and App Part 3.1: Acquisition Flow

January 12, 2016February 15, 2016 allison Leave a comment

In Part 2 of this series, I discussed how I added the ability for a user to create a new customer in the database.  In this part, we will discuss how a user will track an acquisition and how I set it up in VB and MySQL. If you’d like to follow along, you can install […]

Read More

Gunsmith Db and App Part 2: Adding Customers

January 1, 2016January 12, 2016 allison Leave a comment

publish In Gunsmith Db and App Part 1 I discussed the overall goal of this project and an overview of where I was at that time.  I finally had the time (and desire) to pick this project up again and realized pretty quickly that I needed to change how the database is designed. Previously, I […]

Read More

Gunsmith Db and App Part 1: Overview

December 18, 2015February 15, 2016 allison

Background I have a friend who owns his own gunsmith business.  By law, he must track the acquisition and disposition of his guns.  His current method of doing this is by filling out, by hand, papers issued by the government.  Once he has so many entries in his logbook, it gets stored away for a […]

Read More

Archives

  • January 2019 (2)
  • December 2018 (3)
  • November 2018 (2)
  • December 2017 (4)
  • January 2017 (1)
  • October 2016 (6)
  • September 2016 (9)
  • August 2016 (9)
  • July 2016 (9)
  • June 2016 (8)
  • May 2016 (9)
  • April 2016 (9)
  • March 2016 (9)
  • February 2016 (8)
  • January 2016 (9)
  • December 2015 (9)
  • November 2015 (8)

Categories

  • Personal Projects 43
  • How To 33
  • Programming 24
  • Python 23
  • Methodology 18
  • Uncategorized 5
  • Electronics 1

Tags

Administration ASPNET Automation boardgameplays boardgames c++ certification containers datawarehouse Django git gunsmith db Halloween2015 itil keyforge kubernetes Linux Machine Learning matlab microcontrollers MongoDB MySQL nfldb NoSQL pantry PlayItForwardFundraiser powerbi powershell Python Qlik R Sheets SQLite SQL Server statistics Ubuntu vb Visualization

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
  • LinkedIn
  • GitHub
  • facebook
  • Twitter
Theme by Colorlib Powered by WordPress