Windows && sqlite?

Miika Turkia miika.turkia at gmail.com
Tue Sep 22 22:48:14 PDT 2020


On Wed, Sep 23, 2020 at 2:18 AM Thiago Macieira <thiago at macieira.org> wrote:

> On Tuesday, 22 September 2020 11:58:04 PDT Dirk Hohndel via subsurface
> wrote:
> > > I suspect that parsing the samples fails, and that sql query might be
> > > something that the version of libsqlite on windows cannot handle...
> > We use libsqlite 3.32.2 on Windows.
> > I always wonder if this is a line end issue or something else where the
> > different character set conversions bite us...?
>
> The sqlite file format should be the same. It's binary, so line endings
> shouldn't be an issue. Only if the lines with CRLF are loaded into the
> database itself...
>

Line ending should not be an issue as the query does not have a new line
and the data returned for samples doesn't have any free texts in it.


> You can copy the file onto a Linux and use /usr/bin/sqlite to see if it
> can
> read.
>

It all works on Linux just fine. Subsurface on Linux imports the data
properly, and of course sqlite3 on command-line works with the DB as well.
The only thing not working (as far as I know) is trying to parse the DB on
Windows with Subsurface. Maybe I need to next find a command line db cli
for Windows and see if that works.

miika
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.subsurface-divelog.org/pipermail/subsurface/attachments/20200923/285534e1/attachment.html>


More information about the subsurface mailing list