Introduction to ORMs for DBAs: Part 0 - Setup

SQL Saturday LogoI gave a presentation at SQL Saturday 710 that didn’t go as well as I liked (i.e. I had trouble getting my demo working).  For those that attended thank you for patience.  Hopefully it was still worth attending and the discussion without the live coding was worth while.

Since the demo didn’t work live I thought I would show you what was supposed to happen during the demo.  The source code for the demo is here.

[Read More]

Chris, have you created that Ruby on Rails 5 project? What Does it Look Like I'm Doing!

In the above video you can replace the question with:

Chris, have created that Ruby on Rails 5 project?

What dose it look like I’m Doing!

Scene 1: Create new Ruby on Rails project using Ruby Mine.

New Ruby Mine Project

Scene 2: Try to install the Gems find out I need Ruby 2.5.

[Read More]

Today I Learned how to Install PostgreSQL in Ubuntu

For an upcoming project I’m thinking of using PostgreSQL.  I’ve heard lots of great things about PostgreSQL in the past but have been too scared lazy busy to try it.

What changed my mind was JetBrains DataGrip database client.  I’m sure there are other PostgreSQL clients but DataGrip is included in my JetBrains subscription so why not give it a try.   I’m a sucker for GUI database clients.  As a generalist it’s too hard to remember all the command lines for each individual database.  Plus it’s really hard to view more then a few rows or columns of data in the command line.

[Read More]

Introduction to Object-Relational Mapping for DBAs – Part 3

Why Developers Use ORMs (i.e. their Strengths)

This is the third and final part of a lighting talk I’m giving at the SQL Saturday Edmonton Speaker Idol Contest.   Imagine I’m actually speaking the words below and showing some of the images on slides and/or doing a demo.

If you don’t want to read Part 1 or Part 2 the basically give an example of a developer using ORM, panic over indexes, and then show more ORM examples.  I don’t think it will all fit in a 15 minute talk.

[Read More]

Introduction to Object-Relational Mapping for DBAs – Part 2

This is part two of a lighting talk I’m giving at the SQL Saturday Edmonton Speaker Idol Contest.   Imagine I’m actually speaking the words below and showing some of the images on slides and/or doing a demo.  Code can be found here.

If you don’t want to read Part 1 it basically started the ORM example and ended in a panic over indexes.  

This is a rough draft so constructive feedback at chris.cumming@saturdaymp.com is much appreciated.

[Read More]