Can't open Sqlite on Git Bash

Question

I'm trying to access my sqlite database on my current directory at /c/wamp/www/laravel5 on my local project folder, with windows as my OS. I added the sqlite3 executable on the directory.

The database doesn't seem to open using git bash. When using the default command in windows command prompt it works seamlesly. sqlite3.exe storage/database.sqlite

Tried on Git Bash:

$ ./sqlite3.exe

and

$ ./sqlite3.exe storage/database.sqlite

These didn't work. The error message is:

bash: sqlite3.exe: command not found

Here's a snapshot:

I'd like to see the database tables and schema using git bash since it has cooler font colors compare with the windows cmd.

Any help would be greatly appreciated.

And what exactly do you mean with "didn't work"? Nothing? An error message? Your computer exploded? — CL.
– CL., Commented Oct 22, 2015 at 7:55

Community · Accepted Answer · 2017-05-23 10:31:34Z

19

if you have the same problem I had, then see my question here.

In short, using "winpty" to start sqlite3 worked:

$ winpty sqlite3

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered May 20, 2016 at 17:13

user172431

3263 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

kimbaudi Over a year ago

still very useful! also works with mysql (i.e., winpty mysql)

Nikki Over a year ago

This works, but then I can't Ctrl+C to exit sqlite anymore.

AJM Over a year ago

This is true. It gets into a state where I need /bin/kill to exit it if I issue any SQL commands other than sqlite3's own "begins with a dot" ones. I suspect any line I type that doesn't begin with a . will put it into this state.

ammonvictor · Accepted Answer · 2017-05-03 18:48:33Z

6

Building on the previous answer by @user172431, add the following alias to your .bashrc

alias sqlite3="winpty sqlite3.exe"

This will make the workflow a tad quicker and feel like a ninja rock-star in the process. I use this shortcut via Git Bash

answered May 3, 2017 at 18:48

ammonvictor

952 silver badges8 bronze badges

Collectives™ on Stack Overflow

Can't open Sqlite on Git Bash

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related