Beware of incremental database Ids

Back in school when we were learning database fundamentals, we learned about keywords to build a database table. Known as data definition language. One thing that stood out to me was the IDENTITY column. It allows columns to auto generate an integer each time a new record is inserted. For Microsoft’s Transact-SQL it looks like this: IDENTITY(0,1) This takes two arguments. The first is the seed, meaning the starting value, and second is the increment amount....

December 21, 2021 · 5 min · Hubert Lin
UX Case Study Log In Sign Up Buttons

UX case study for log in and sign up buttons

If you’re like me, then you’ve tried to log into a website and got confused with which button to click. The placement, terminology and styling often throws me off. For authentication we often see log in, sign in and for registration words like sign up or create account. In this case study, I want to determine which terminology should be used as default for authentication and registration buttons. Then, identity common patterns of placement for these buttons when viewed on a personal computer (monitor) not a mobile device....

September 26, 2021 · 3 min · Hubert Lin

Reduce stress with max line lengths

Black Friday just passed and I’m sure there have been plenty of large TV and computer monitor purchases. I’ll be holding off for the ultra wide screen monitors to come down in price a little more before I get one for myself. With our monitors getting wider and wider, do we still need maximum line lengths in our code? My answer is yes. I don’t just mean there needs to be maximum line lengths in our code, but I’m crazy enough to suggest this should be implemented in all areas of a modern workplace....

December 3, 2019 · 2 min · Hubert Lin

Closing Bootstrap nav in Angular

Does your app use Bootstrap 4? Does your app use Angular 6+? Does navbar stay open even when navigating to different components? (Mobile) I fixed the problem using Angular attribute directive. How the bootstrap toggler works When the bootstrap toggler is clicked it calls the .collapse() from the ul.nav-list, adds .collapsing before the animation starts, adds .show and finally removes the .collapsing class. .show Try removing .show from the open navbar....

January 28, 2019 · 2 min · Hubert Lin

Decoupling Identity Core from .NET Core Api

During my quest to make my architecture “clean” there was a huge dependency that needed to be inverted Microsoft.AspNetCore.Identity. Even though many applications require authentication, we still shouldn’t be depending on any authentication frameworks. According to Robert C. Martin we shouldn’t depend on a framework because the business rules can change or the frameworks can change. We keep things loosely coupled so that in case we need to swap out an implementation we can do so without affecting our business rules....

November 30, 2018 · 3 min · Hubert Lin