Join Sheeri Cabral for an in-depth discussion in this video Connecting to other databases with ODBC, part of MariaDB for MySQL Users.
…We have seen how to connect to remote MySQL servers.…As well as different type of text files.…One powerful feature of the CONNECT storage engine is that it…can connect to other database systems as well.…Like SQLite, Postgres, Oracle Microsoft, Access, and Microsoft SQL Server.…Any database that you can connect to via ODBC drivers.…I will connect to aN SQL Light database to show how it can be done, but…the same idea can be applied to any ODBC database.…
For this example, we will be using the Chinook sample database.…This is a standard database that you can download.…And is also included in the exercise files.…In SQLite each file is it's own database.…The file we will be using is called Chinook_SQLite.sqliteI, I…will not be covering how to troubleshoot issues with SQLite.…I assume if you are working with SQLite such that you need to…connect to it in RiaDB.…
These simple commands will be familiar to you.…First let's open up the database.…Which we do by typing sqlite3 and then the path to the file.…/var/tmp/Chinook_sqlite.slqite.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.