Category Archives: Software Development

Today I Learned Altering a SQL Column Removes it’s Default Value

Posted on January 12, 2020 by Chris C

This one I actually already knew but temporarily forgot about it so got to relearn it. In MySQL, and many other databases, updating the column with an ALTER statement will remove any properties not explicitly listed. For example, say you … Continue reading →

Posted in Today I Learned | Tagged , , | Comments Off on Today I Learned Altering a SQL Column Removes it’s Default Value

Today I Learned About GitHub’s Dependabot

Posted on June 24, 2019 by Chris C

Recently I created a CI build for the Introduction to ORM for DBAs presentation example code. One of the reasons I picked this code base was so I could try out Dependabot for the security alerts I’m getting. The security … Continue reading →

Posted in Today I Learned | Tagged , , , | Comments Off on Today I Learned About GitHub’s Dependabot

Today I Learned How to Setup Azure Pipelines CI

Posted on June 17, 2019 by Chris C

Our last EDMUG meetup was an excellent presentation about Azure DevOps. Azure DevOps reminds me of GitLab where it is more then just continuous integration (CI). It includes issues tracking, repositories, and continuous delivery. All pretty standard stuff. However, one … Continue reading →

Posted in Today I Learned | Tagged , | Comments Off on Today I Learned How to Setup Azure Pipelines CI

Introduction to ORMs for DBAs: Part 8 – Create Game Players CRUD – Part 1

Posted on May 27, 2019 by Chris C

I gave the Introduction to ORMs for DBAs presentation at SQL Saturday 710 but it didn’t go as well as I would have liked (i.e. I had trouble getting my demo working).  Since the demo didn’t work live I thought I would show you … Continue reading →

Posted in Introduction to ORMs for DBAs, Software Development | Tagged , , , , , , | Comments Off on Introduction to ORMs for DBAs: Part 8 – Create Game Players CRUD – Part 1

Introduction to ORMs for DBAs: Part 7 – Create GamePlayers Table

Posted on January 20, 2019 by Chris C

I gave the Introduction to ORMs for DBAs presentation at SQL Saturday 710 but it didn’t go as well as I would have liked (i.e. I had trouble getting my demo working).  Since the demo didn’t work live I thought I would show you … Continue reading →

Posted in Code Examples, Introduction to ORMs for DBAs, Software Development | Tagged , , , , , , | Comments Off on Introduction to ORMs for DBAs: Part 7 – Create GamePlayers Table

Today I Learned How to Create a React-Rails App

Posted on January 7, 2019 by Chris C

A working example can be found here in the Saturday MP Examples GitHub. First thing you need to do is create a basic Rails app as outlined in my previous post.  My setup is the same as creating Rails app: Ubuntu 18.04 LTS host … Continue reading →

Posted in Code Examples, Software Development, Today I Learned | Tagged , | Comments Off on Today I Learned How to Create a React-Rails App

Today I Learned how to Generate a ERD for Rails Application

Posted on November 18, 2018 by Chris C

Back in the day Rails apps didn’t add foreign keys to database tables.  Believe it or not this was a feature not a bug.  The idea was that you shouldn’t “repeat” the relationship between you models in the code and … Continue reading →

Posted in Code Examples, Software Development, Today I Learned | Tagged , , , | Comments Off on Today I Learned how to Generate a ERD for Rails Application

Introduction to ORMs for DBAs: Part 6 – Create GamesPlayed Table and CRUD

Posted on November 2, 2018 by Chris C

I gave the Introduction to ORMs for DBAs presentation at SQL Saturday 710 but it didn’t go as well as I would have liked (i.e. I had trouble getting my demo working).  Since the demo didn’t work live I thought I would show you … Continue reading →

Posted in Code Examples, Introduction to ORMs for DBAs, Software Development | Tagged , , , , , , | Comments Off on Introduction to ORMs for DBAs: Part 6 – Create GamesPlayed Table and CRUD

Introduction to ORMs for DBAs: Part 5 – Create GameResultTypes Table and CRUD

Posted on September 14, 2018 by Chris C

I gave the Introduction to ORMs for DBAs presentation at SQL Saturday 710 but it didn’t go as well as I would have liked (i.e. I had trouble getting my demo working).  Since the demo didn’t work live I thought I would show you … Continue reading →

Posted in Code Examples, Introduction to ORMs for DBAs, Software Development | Tagged , , , , , , | Comments Off on Introduction to ORMs for DBAs: Part 5 – Create GameResultTypes Table and CRUD

Today I Learned how to Create Rails Docker Container Without Ruby Installed

Posted on July 22, 2018 by Chris C

I was curious to see if I could create a Docker container for a new Rails project without having Ruby or Rails installed on the host machine.  To do this I created a new Ubuntu 18 virtual machine with the … Continue reading →

Posted in Code Examples, Software Development, Today I Learned | Tagged , , , , | Comments Off on Today I Learned how to Create Rails Docker Container Without Ruby Installed