Summary
Sometimes, we're building an integration to a third party product that doesn't expose any APIs, but we do have access to the database itself. In this episode, we'll look at connecting to external databases and look into some of the considerations when doing so to maintain data integrity.rails database 23:03
Chapters
- Introduction (0:00)
- Installing gems (2:00)
- Important things to consider (2:42)
- Setting up PostgreSQL connection (4:19)
- Creating the model (7:14)
- Setting up the controller (9:40)
- Displaying the data (13:55)
- Warning about database schema consistency (15:13)
- MSSQL Setup (16:12)
- MSSQL Model (17:03)
- Setting up the controller (18:44)
- Explicit rescue (20:06)
- Updating and testing the view (21:22)
- Final Thoughts (22:34)
Pro Monthly
$
19
/mo
Access to Pro Episodes
Invite to Slack Channel
Priority Suggestions
Ad Free
Pro Annual
$
190
/yr
Access to Pro Episodes
Invite to Slack Channel
Priority Suggestions
Ad Free