Okay, but is there a simple answer for me, like getting a different build (eg the standard windows build)?
I'm confused about the windows builds. There's a "sqlite-shell-win32 command-line shell", which looks like an executable, but it doesn't in fact work from the command line. I can only open a database with it through the windows GUI. I have to configure windows to "Open files of this type with [sqlite3.exe]", then rename the sqlite file to end in .sql or whatever you designated, then click on it. Just typing /path/to/sqlite3.exe db.sqlite on the command line just hangs. The other build available is a DLL, and I don't know how to use a DLL. On Fri, Jun 7, 2013 at 1:48 PM, Warren Young <war...@etr-usa.com> wrote: > On 6/6/2013 21:56, Philip Goetz wrote: >> >> >> I think the problem is that the Cygwin distribution has the wrong >> version of SQLite, one built for unix. > > > Nope. And even if true, it wouldn't be the right explanation. > > There are two major ways to build SQLite on Cygwin: > > 1. By default, building SQLite under Cygwin gets you a special Cygwin-aware > mode, where SQLite bypasses the Cygwin DLL for some things, calling the > Win32 API directly. This is how the current[*] official binaries in the > Cygwin distro are built. Such a build still uses POSIX APIs for opening > files, though, so the paths go to the Cygwin DLL first, and then after > translation, to the Win32 API. Since such a built knows its running on > Windows, it shouldn't be using illegal characters in generated file names. > > 2. You can also build SQLite in a pure POSIX mode, with no direct calls to > Win32 at all. This mode is more compatible with other POSIX programs > running under Cygwin, but less compatible with native Win32 builds of > SQLite. This distinction is irrelevant, however, because the file opening > path is the same as with the Cygwin-aware build. > > > [*] (You can find test builds of SQLite for Cygwin built in Unix mode > instead of Cygwin mode, but there hasn't been an official one in many > months, which was quickly replaced due to the problems it caused. We may be > switching the official builds back to Unix mode soon, providing we can fix > those problems, since the special Cygwin mode of SQLite causes its own > problems. It's one of those "having your cake and eating it too" kinds of > things.) > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
