kernology - where laurie and learning meet
  • Home
  • Blog
  • Pictures
    • Art & Craft >
      • Temari
      • Yubinuki
      • Quilting
      • Weaving
      • Lapidary Work
      • Metal Work 2010
      • Metal Work 2009
      • Classes - 2010
      • Classes - 2009
    • Boots
    • Canyon Lake Gorge
    • Views of Texas
    • Views of Scotland
    • Travel >
      • Bunny Bravehart Road Trips
      • Scotland 2012
      • Maine 2011
      • New Mexico 2010
      • Scotland 2008
  • Oh, the places you will go!
  • Contact Laurie

About "That Thing"

8/17/2022

0 Comments

 
Last time, I wrote about working on "a thing"; well it's almost ready for the world. 
BUT WHAT IS IT ???!!! you ask
Sit back with a cuppa and get ready for a long tale.

Several months, even before the BIG WALK, I started pondering a database where I could track the tools, I own, for the hydraulic press I have trust me; there is a never ending list of things to purchase. Yes, it's for metal geeky stuff. Some items come with a part number on them but some things, like the rolling mill texture plates and the impression dies do NOT or it's written in marker that eventually wears off. 

To solve my dilemma I started a MS Access database what would have the information I wanted and I could put pictures of the various items in the record. I won't list the fields I settle on but let's just say it's the basic info about what was bought.

After I returned from my month long vacation, somehow in the PotterUSA Facebook group (a.k.a PotterPeople) a discussion began on how do everyone keeps track of  their stuff because many people have bought things two or three times!  Some use Excel, others Word or other text document and of course the question arose about pictures to identity dies that don't have numbers or the number wore off.  I eventually chimed in with my little database application which raised many questions as most members (9.5K+) don't know me or that I write software for fun; crazy eh??  

Some people asked if I would give them "my app" but when I questioned if they knew how to use MS Access (or if they used a Windows PC) I got crickets!

Over the next week I thought about it and I realized that there was a need for an application so others could keep track of their stuff too. I put several polls in the group regarding what devices (desktop, laptop, phone, tablet) and operating system (Winx, Mac OS, Linus, iOS, Android) and oh the confusion that resulted was amazing.  I decided that this application would have to be web-based otherwise I would be spending most of my time providing installation support; upgrades would be a nightmare.

Since I work mostly with Microsoft technology the tech stack I chose is MS SQL Server 2019 with MS SQL Server Management Studio, Visual Studio 2022 as the IDE for coding with the following: .net (Core) 6; ASP.NET with Razor Pages; Entity Framework (for db operations); Bootstrap for the styling; jQuery/javaScript for front end stuff; and various other packages for all sorts of functionality. 

It took about 2 weeks to all this out and then I sat down and created a clean Virtual Machine (VM) on my  development laptop so I could then begin installing all the software I would need. 

To cut a very, very, long story down to just a long story; I resurrected a framework I built 2 years about and upgraded the various backend software to be the most recent. Then I started the real building of the database tables, configuring the UI with a menu, logo and other static pages; then on to the pages where all the user interaction would take place as well as pages for me, the admin/webmaster would manage the site. I also had to make it so a user would only see their stuff - including adding, editing, deleting, viewing and printing. 

This week, the majority of the code was complete so I bought a domain and setup an account with a hosting provider; configured the email system; setup PayPal, Buy Me a Coffee, and Stripe for donations. Oh, I guess I forgot to mention that the application is DonationWare - I am hoping to cover operating costs. I also have it so sample data is seeding into each user account so a user can see how it would work. 

It's now been 3.5 weeks, I have been working on it EVERY DAY of the week, since I started and I just pushed the Alpha version to the remote server and I have been working on/with it to find things that need to fixed. 

During this time I have posted pictures of what the app will look like, in the Facebook group and I have some very excited people looking forward to it. I have a long list of things yet to do to make some parts of administration easier but that can be worked on after I do the first release which I hope will be next week. 
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    About Laurie

    Laurie lives in central Texas with the memory of Erich, a.k.a. "the shop elf", who was her hubby of 35+ years and Cowboy Boots, the cat; her metals studio including 100+ hammers and 300+ chasing tools; her sewing studio which has a sewing machine, a closet filled with fabric, hundreds of skeins of embroidery floss and perle cotton, silk and other materials, and Mrs. King the dress dummy; one weaving loom, assorted knitting needles, tubs of yarn; assorted art supplies of pencils, colored pencils, water color pencils, water color paints, acrylic paints, markers, and pads of paper; lots of books; plus a plethora of geeky tech gadgets, computers, and more.

    Archives

    May 2025
    March 2025
    February 2025
    January 2025
    December 2024
    November 2024
    September 2024
    August 2024
    July 2024
    May 2024
    April 2024
    March 2024
    January 2024
    December 2023
    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    September 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    November 2017
    October 2017
    September 2017
    August 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    October 2016
    September 2016
    August 2016
    June 2016
    May 2016
    April 2016
    February 2016
    January 2016
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    July 2011
    June 2011
    May 2011
    April 2011
    March 2011
    January 2011
    December 2010
    November 2010
    August 2010
    July 2010
    June 2010
    May 2010
    April 2010
    March 2010
    February 2010
    January 2010
    December 2009
    August 2009

    Categories

    All
    42
    Android
    Bfa
    Boots
    Bunny Bravehart
    Codesmith
    Comic-Con
    Covid
    Day Job
    Family
    Fencing
    Fiber
    Gorge
    Health
    Hike
    Jewelry
    Knitting
    Laurie
    Metals
    Minecraft
    Pandemic
    Photography
    Quilting
    Retirement
    Road Trip
    Scotland
    Sources
    Spinning
    Temari
    Texas
    The Big Walk
    Weaving
    Web
    Yubinuki

Kernology, Kernology.com, Laurie Jane Kern © 1998 - 2020 | All Rights Reserved