SQL / Geofun / HTML / C# and more...

Self described as "curious misfit with a few technical skills"

This github holds repos that demonstrate or "study" various skills/technologies I work with:

1. SQL snippets that include:

   1. random data for testing
   2. PIVOT
      https://github.com/gitberry/SQLSnippets
   3. deriving structure from JSON blurb
      https://github.com/gitberry/SQLSnippets/blob/main/CrudeJsonORM.sql

2. Hash a database structure to know immediately if any structures has changed
   https://github.com/gitberry/sqlHash

1. c# to convert get google KML into something else - VERY crude - for onetime tasks
   https://github.com/gitberry/KMLPoints

2. C# to convert Lat/Lon DMS Coordinates to D decimal - handy when geo data doesn't come the way you need it!
   https://github.com/gitberry/LatLonDMS2Dec

1. Mobile first HTML
   https://github.com/gitberry/MobileFirstHTMLexample
   https://github.com/gitberry/HTMLandJSSimpleSchedule

2. A simple experiment encrypting/decrypting using vuejs
   This concept of decrypting at the js client side is powerful - would like to know more about how apps like Bitwarden do it. In the meantime I must learn some basics - and I decided to try it in vuejs - which is one of my favourite frontend frameworks (so far..)
   https://github.com/gitberry/vuejsSimplyEncryptDecrypt

3. A study of vuejs routes in a SPA (plus IIS and subdirectories off of domains)
   https://github.com/gitberry/VuejsRoutingIISSubDirExample

4. a crude .net 4.7 API stub (no authentication, no SQL)
   https://github.com/gitberry/APIcrudStubExample

5. A study of vuejs using a simple API
   https://github.com/gitberry/StudyVuejsUsingsimpleAPI

6. a readonly .net 4.7 API using EF TSQL
   https://github.com/gitberry/StudySimpleAPIwSQL

7. tables in vuejs using tanstack
   https://github.com/gitberry/vue-tanstack-example

8. JSON Web Token (JWT) API
   The following two projects work hand in hand to provide both sides of the JWT action - the JWT token authentication/generation/validation between a server and a client. A lot of fun to do!

   1. Serve/Generate
      This example done with .net 4.7 - I'd like to repeat with other stacks..
      Source: [https://github.com/gitberry/jwt-demo-backend-net47]
      Working Exmple: [https://jwtdemo.northberry.ca/json/swagger/]
   2. Client/Consume
      This example was done with Vuejs3, Vite, Pinia stack - to adoringly paraphrase an old musical: "a very modern general.. framework for a very modern major dev stack..."
      Source: [https://github.com/gitberry/jwt-demo-frontend-vuevitepinia]
      Working Exmple: [https://jwtdemo.northberry.ca/]

9. CRUD - .net API and VueJs3 Frontend
   Similar to the JWT project above - but full crud (Create Read Update Delete) demo. I didn't like how I build the SQL and DTO (Data Transfer Object) code and noted it. I also want to leverage some tanstack tech I played with earlier - so this little demo project may get taken down and rewritten one of these days.
   Frontend: https://github.com/gitberry/crud-demo-frontend
   Backend: https://github.com/gitberry/crud-demo-api

1. A simple study to make a QR Code windows desktop app - in .NET CORE 5.0
   https://github.com/gitberry/QRcodeCreateWindowsForms
2. An older personal project I had done back in 2017 with an older version of iTextSharp
   it was built to do form populating and page copying and paste automation but it also could do QR code generation and image insertion into PDFs older but kind cool to look at that. I'll probably build my next stuff in a frontend tech.. stay tuned...
   https://github.com/gitberry/pdfTool

Below is some of the items on my interest list. In no particular order:

1. A full Authentication API (extra - is 2step extendable.. )
2. In Legacy .NET 4.7: Full CRUD JSON API using EF and MS SQL ( MySQL & sqlite too perhaps)
3. In .NET 6 or 7 : Full CRUD JSON API using EF and MS SQL ( MySQL & sqlite too perhaps)
4. Hyperspectral analysis
   1. Python
   2. ENVI
   3. ArcGIS
   4. ML
5. Python
   1. simple ML (ie character recog)
   2. transactional analysis - reproducing work done here:
      https://github.com/laurentran/sequence-labeling
6. Generic Collection app
   1. collecting words/phrases & meta
   2. voting
   3. scheduling notices (ie word of the day)
7. arduino - internet gateway power reset when threshold achieved.
8. raspberryPI, rechargable power source, QR of signed datetime - to fulfill a geo collecting objective.
   extra: tamper resistant regime (ie avoid theft of signing key)
9. rasberryPI security cam controller
10. rpi air traffic node
11. rasberryPI controller for watering plants, weather station sensors and more.
12. encryption
    1. PKI generate
    2. signing
    3. encrypting
    4. historical summary
    5. deep dive into bitwarden (https://github.com/bitwarden/)
    6. deep dive into 1password (https://github.com/dschuetz/1password)
13. QR codes:
    1. Generate (Windows (done)/Web server/browser JS client) (extra: OSX/Android using Xamarin/MAUI)
    2. extra: decode using camera
    3. extra: decode in a Xamarin/MAUI app
    4. authentication loopback
14. Generic Event organizer
    1. Multi user/type authentication (& public viewing)
    2. Schedule/Location coordination
    3. results output
15. SQL
    1. follow the same process the Credit Union project I collaborated with Lauren Tran – a Microsoft Data Scientist for using Machine Learning to process transactional (ie financial transactions) data.
       Challenges: (with what data? generated data?) (my nerves-induced bobble-headed interview here: https://www.youtube.com/watch?v=mn2Cy-0oiH8 - I think our cool Microsoft host vblogger could hardly keep from laughing out loud…) Lauren's Open source from that project: https://github.com/laurentran/sequence-labeling
    2. DNA sequence analysis
16. chatgpt / llm's
    1. Sql
    2. c#
    3. python
    4. js & frameworks