Installing unixodbc and sqliteodbc using Homebrew on macOS to setup SQLite for RStudio's Connections

Video Timeline

00:00 Video Bumper
00:06 Introduction
00:17 Description of pre-requisites: Homebrew video
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:45 Overview of required configuration files on Posit's solution page.
04:06 Switching to the INSERT mode to paste text
07:20 Out roll

---

Links


----

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:

- Lastly, we verified the drivers by creating an in-memory SQLite database using RStudio's Connections Panel.

---

Socials

[enknot]

I guess we're a weird lot, and there's not to many of us that need to know this. Maybe if you danced while you did it, or made someone keep their finger on a car or some junk.

thanks a zillion btw.