Sqlite database relative path

6 views (last 30 days)
ashish
ashish on 24 May 2016
Answered: Kanupriya Singh on 4 Jul 2020
Hi, I am connecting to a local database using absolute path. Is there a way to use relative path for the database function:
conn=database('/Users/ashish/Desktop/db1.sq3', ...
'','','sqlite.JDBC.jar','jdbc:sqlite://Users/ashish/Desktop/db1.sq3');
Thanks - Ashish

Answers (1)

Kanupriya Singh
Kanupriya Singh on 4 Jul 2020
If your MATLAB file is in the same directory as the SQLite database file, then you need to only specify the name of the database file and not the entire absolute path.
To connect MATLAB to SQLite, use the following function:
filename = "mock.db";
conn = sqlite(filename);

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!