Video Timeline
00:00 Video Bumper
00:06 Introduction
00:17 Description of pre-requisites: Homebrew video
Visit http:/http://www.ch-werner.de/sqliteodbc/
00:45 Go to the Spotlight search in top right
00:50 Type Terminal in spotlight search to open Terminal
00:59 Install the homebrew package for unixodbc
01:30 Install the homebrew package for sqliteodbc
02:20 View driver configuration required for the SQLite Driver on the Posit's solution page: https://solutions.posit.co/connection...
02:45 Overview of required configuration files on Posit's solution page.
03:32 Creating the ~/.odbcinst.ini file in the home directory using vi
03:58 Copying the SQLite driver configuration for ~/.odbcinst.ini from Posit's connection page using ⌘ + C
04:06 Switching to the INSERT mode to paste text
07:20 Out roll
---
Links
ODBC Driver Install Commands for Homebrew: https://solutions.posit.co/connection...
ODBC Driver Configuration Files: https://solutions.posit.co/connection...
----
Summary
We installed the unixodbc and sqliteodbc homebrew package using Terminal
We added two local configuration files to recognize the odbc driver for SQLite following:
https://solutions.posit.co/connection...
Lastly, we verified the drivers by creating an in-memory SQLite database using RStudio's Connections Panel.
---
Socials
👨💻 https://github.com/coatless
🐘 https://mastodon.social/@coatless
🦋 https://bsky.app/profile/coatless.bsk...
🕸️ https://thecoatlessprofessor.com
📋 / jamesbalamuta
🕊️ / axiomsofxyz