Skip to main content
Rob Conery

Rob Conery

269 posts published

Some Tips and Tools
Rails Revisited

Some Tips and Tools

Let's close out The Rewrite section with some tips and tools. Some of you might be using MongoDB, or just not dig the ActiveRecord pattern. This is OK.

· Rob Conery

The Full Rollover
The Imposter's Frontend Accelerator

The Full Rollover

In this video we finish rolling over to Supabase

· Rob Conery

Design Patterns: Behavioral
Computer Science Fundamentals

Design Patterns: Behavioral

Mediators, Decorators and Facades - this is the deep end of object-oriented programming and something you'll come face to face with as your application grows.

· Rob Conery

Ethical Considerations
PostgreSQL Fundamentals

Ethical Considerations

It's important to take a step back from time to time and consider just what it is you're doing and why. In our case, we're working with one of the most important scientific data sets of the last century - at least with respect to planetary studies.

· Rob Conery

Filtering Routes
Rails Revisited

Filtering Routes

Controllers have a set of hooks, if you will, called filters. You can run code before, after, or both.

· Rob Conery

Supabase Authentication
The Imposter's Frontend Accelerator

Supabase Authentication

In this video we roll our auth scheme over to Supabase

· Rob Conery

Design Patterns: Structural
Computer Science Fundamentals

Design Patterns: Structural

As your application grows in size you need to have a plan to handle the increase in complexity. The Gang of Four have some ideas that could work for you.

· Rob Conery

Spreadsheet Export
PostgreSQL Fundamentals

Spreadsheet Export

Excel is EVERYWHERE and for good reason - it's simple to use, you can visualize data and you can even write simple functions and macros. Excel is the powerhouse of the analytical world and we need to prepare our data to work with it.

· Rob Conery

A Look at Rails Tests
Rails Revisited

A Look at Rails Tests

Testing in Rails is extremely simple - the generators do a lot of it for you! In this video we'll have a look at what these generated tests look like.

· Rob Conery

Hello Supabase!
The Imposter's Frontend Accelerator

Hello Supabase!

Things went to hell in the last episode, let's get back on track.

· Rob Conery

Design Patterns: Creational
Computer Science Fundamentals

Design Patterns: Creational

Tried and true design patterns for creating objects in an object-oriented language.

· Rob Conery

Concept: Joins
PostgreSQL Fundamentals

Concept: Joins

Bias can creep in anywhere during the analysis process - even in the way you structure your query and the joins you use.

· Rob Conery

More Complex Many to Many
Rails Revisited

More Complex Many to Many

Some many to many relationships are a bit more complex, such as relating customers to products through invoices (for instance). Let's see how to do this in Rails using a 'has many through' relationship.

· Rob Conery

Authorization, Part 3
The Imposter's Frontend Accelerator

Authorization, Part 3

· Rob Conery

Graph Traversal: Dijkstra
Computer Science Fundamentals

Graph Traversal: Dijkstra

Bellman-Ford works well but it takes too long and your graph can't have cycles. Dijkstra solved this problem with an elegant solution.

· Rob Conery

Understanding What We're Looking For
PostgreSQL Fundamentals

Understanding What We're Looking For

The fun begins! We have the data we need isolated and we feel good about its integrity - now we're ready to let it tell us a story. But what story is that? This is where things get interesting.

· Rob Conery

Editing Many to Many Records
Rails Revisited

Editing Many to Many Records

Rails gives us some great helpers that save so much time, and you're about to meet one of them: collection checkboxes

· Rob Conery

Authorization, Part 2
The Imposter's Frontend Accelerator

Authorization, Part 2

We have most of our model build out, let's plug it in.

· Rob Conery

Graph Traversal: Bellman Ford
Computer Science Fundamentals

Graph Traversal: Bellman Ford

How can you traverse a graph ensuring you take the route with the lowest cost? The Bellman-Ford algorithm will answer this question.

· Rob Conery

INMS Loading Summary
PostgreSQL Fundamentals

INMS Loading Summary

That was fun work! We learned a lot of fun concepts and some new SQL!

· Rob Conery

Many to Many Associations
Rails Revisited

Many to Many Associations

Many to many associations are common in the database world, and working with them on forms (and with models) can be a pain. Rails makes this easy.

· Rob Conery

Authorization, Part 1
The Imposter's Frontend Accelerator

Authorization, Part 1

In this episode we'll dig in to Sequelize, the Node.js ORM that will power our API.

· Rob Conery

Calculating Prime Numbers
Computer Science Fundamentals

Calculating Prime Numbers

The use of prime numbers is everywhere in computer science... in fact you're using them right now to connect to this website, read your email and send text messages.

· Rob Conery

Troubleshooting
PostgreSQL Fundamentals

Troubleshooting

Wouldn't be any fun if we did everything right the first time, would it? Imposing rules during transformation is always problematic - which is great! We get to learn about our assumptions and also dig deeper into the data.

· Rob Conery

Scaffolding Everything
Rails Revisited

Scaffolding Everything

Now that we understand scaffolds, let's create some for the main tables in our database.

· Rob Conery

Authentication, Part 4
The Imposter's Frontend Accelerator

Authentication, Part 4

Going a little slower than I wanted, but that's how it goes innit?

· Rob Conery

Dynamic Programming and Fibonnaci
Computer Science Fundamentals

Dynamic Programming and Fibonnaci

Dynamic programming gives us a way to elegantly create algorithms for various problems and can greatly improve the way you solve problems in your daily work. It can also help you ace an interview.

· Rob Conery

Transformation, Part 2
PostgreSQL Fundamentals

Transformation, Part 2

Now that we understand constraints a little bit more, let's carry on and buff this table out completely. We'll add a timestamp with time zone so we know when the import happened and then we'll get into some weird stuff with generated columns!

· Rob Conery

Using Scaffold With Existing Data
Rails Revisited

Using Scaffold With Existing Data

Scaffolding is a major productivity booster with new applications - but you can also use it to speed up your rewrite with existing data.

· Rob Conery

Authentication, Part 3
The Imposter's Frontend Accelerator

Authentication, Part 3

We're finishing up the UI (I hope), ideally not getting stuck this time!

· Rob Conery