Category Archives: Software Development

Generate a Todo List in Standard (Rubocop)

The older I get the more I appreciate code linters. Something that can detect and often correct my formatting errors? Great! One less thing I have to worry about. Then I can spend my time on more important tasks such … Continue reading

Posted in Code Examples, Software Development | Tagged , , | Comments Off on Generate a Todo List in Standard (Rubocop)

A Rails 6 Template and Then Some

I appreciate people posting getting started examples and templates online. They are good for getting started and playing with a new technology. The problem is the templates are usually not production ready. They are also missing a bunch of the … Continue reading

Posted in Software Development | Tagged , | Comments Off on A Rails 6 Template and Then Some

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

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

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

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

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

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

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

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

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