Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you use Induction to connect to a local SQLite database?

I'm trying to use Induction to connect to my local SQLite database however I've no idea of how to make the connection. In previous SQLite clients I've simply opened the database file.

Induction connection screen

What properties should I be putting into these fields? My database is simply development.db and located inside my Rails application

like image 438
Peter Nixey Avatar asked Jun 07 '12 15:06

Peter Nixey


People also ask

How do I connect to a SQLite database?

Select SQLite from the list. Give a Connection name for your own internal reference. For Database , click Choose a File and then select the database file on your local machine to which you want to connect. Hit Connect and you're all set!

Is SQLite a local database?

An sqlite database is just a file, stored locally in your device.

Where can I find SQLite database path?

The Android SDK provides dedicated APIs that allow developers to use SQLite databases in their applications. The SQLite files are generally stored on the internal storage under /data/data/<packageName>/databases.


1 Answers

This is how I open the sqlite3

Method 1: Fill in the first box file://path/to/file/db.sqlite3, select file adapter, fill in the Database column with: Path/to/yourdb.sqlite3

Method 2: You can drag-and-dropping the sqlite3 file on the app icon.

like image 127
Miffidy Avatar answered Sep 18 '22 00:09

Miffidy