Using SQLite3 with Cygwin

Solution 1:

Interactive non-Cygwin program often don't work correctly in Cygwin terminals such as mintty that are based on pseudo terminal ("pty") devices. That's because Cygwin uses Windows pipes to emulate ptys, so native console program see a pipe where they expect to see a console. Among other issues, that often causes them to enter non-interactive mode. See here for lots more on this:

http://code.google.com/p/mintty/issues/detail?id=56

You might be able to get it to work tolerably using the -interactive switch, but the real solution is to install the Cygwin version of sqlite3 through Cygwin setup.exe.

Solution 2:

Start Cygwin with command

C:\cygwin\Cygwin.bat

instead of

C:\cygwin\bin\mintty.exe