Re: sqlite-users Digest, Vol 114, Issue 23

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlite-users Digest, Vol 114, Issue 23

Paul J. McMillan, Sr.
Thanks Chris!  I'm using .Net 4.6 (VS 2017), which I don't think works with System.Data.SQLite yet, so I downgraded to .net 4.5.2.  Seems to be working fine.

Please tell me about your classes.  I'm using EF6.

-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of [hidden email]
Sent: Friday, June 23, 2017 8:00 AM
To: [hidden email]
Subject: sqlite-users Digest, Vol 114, Issue 23

Send sqlite-users mailing list submissions to
        [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
        http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
or, via email, send a message with subject or body 'help' to
        [hidden email]

You can reach the person managing the list at
        [hidden email]

When replying, please edit your Subject line so it is more specific than "Re: Contents of sqlite-users digest..."


Today's Topics:

   1. 3 fixes for 3.19.3 (Danny Couture)
   2. Could not load file or assembly error (Paul J. McMillan, Sr.)
   3. User Authentication Extension is broken in 3.19 branch
      (Thien, Christoph)
   4. Re: UTF8-BOM not disregarded in CSV import (Clemens Ladisch)
   5. Re: Could not load file or assembly error (Chris Locke)


----------------------------------------------------------------------

Message: 1
Date: Thu, 22 Jun 2017 13:30:46 -0400
From: Danny Couture <[hidden email]>
To: [hidden email]
Subject: [sqlite] 3 fixes for 3.19.3
Message-ID:
        <CAMBrY1EtGe6-SVQbnLV=p=[hidden email]>
Content-Type: text/plain; charset="UTF-8"

I’d like to submit 2 compilation fixes

https://github.com/dcou/sqlite/commit/be48df67c63d8db221c2ae3ac3b49b93760460e7.patch



https://github.com/dcou/sqlite/commit/3f8d8d9b743e247bba15dd2b82b5dc26ac915a44.patch



and one regression fix for 3.19.3



https://github.com/dcou/sqlite/commit/c93d35b54213049c86be76b8d0e74948fecfbf4b.patch


Thanks

Danny


------------------------------

Message: 2
Date: Thu, 22 Jun 2017 13:50:42 -0400
From: "Paul J. McMillan, Sr." <[hidden email]>
To: <[hidden email]>
Subject: [sqlite] Could not load file or assembly error
Message-ID: <009601d2eb80$122c7390$36855ab0$@gmail.com>
Content-Type: text/plain; charset="us-ascii"

Hi,

 

I'm new to SQLite.  I want to use it in my C# application.  I downloaded the tool SQLite/SQL Server Compact Toolbox.  Under Data Connections, I keep getting the error message in red: "Could not load file or assembly 'SQLiteScripting".  Does anyone have an idea of why I'm getting this error?

 

Thanks

Paul McMillan



------------------------------

Message: 3
Date: Fri, 23 Jun 2017 06:34:40 +0000
From: "Thien, Christoph" <[hidden email]>
To: "[hidden email]"
        <[hidden email]>
Subject: [sqlite] User Authentication Extension is broken in 3.19
        branch
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="us-ascii"

Hi all,

we are compiling and using the User Authentication extension (Windows, MSVC10 and MSVC14, x86 and amd64).

Problem:
In 3.19 branch one can access a database without authentication.


Example:
When using sqlite 3.12 series (e.g. 3.12.2) everything works like expected.
One can do:

sqlite3.exe db
.user add admin pwd 1
.user login admin pwd
create table mytable (col1 int);
insert into mytable values (1);
.quit

Starting again

sqlite3.exe db
select * from mytable;
Error: user not authenticated

This error message is expected.


In 3.19 branch (3.19.2 and 3.19.3) you get this:

sqlite3.exe db
select * from mytable;
1

Access without authentication.


Is this a regression?

The user authentication extension source code did not change so far.

Best regards,
Christoph Thien
Bruker Optik GmbH



------------------------------

Message: 4
Date: Fri, 23 Jun 2017 09:25:50 +0200
From: Clemens Ladisch <[hidden email]>
To: [hidden email]
Subject: Re: [sqlite] UTF8-BOM not disregarded in CSV import
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=utf-8

Mahmoud Al-Qudsi wrote:
> with `.import ……`, SQLite3 includes a BOM (UTF-8) as part of the first
> column of the first record.

The Unicode Standard 9.0 says in section 3.10:
| When represented in UTF-8, the byte order mark turns into the byte
| sequence <EF BB BF>. Its usage at the beginning of a UTF-8 data stream
| is neither required nor recommended by the Unicode Standard,

so you should not use it.

Treating this character as a zero width no-break space, and keeping it, is a correct interpretation of the file.

> IMHO, this is of particular importance since the latest versions of MS
> Excel default to “UTF-8 CSV” which includes a BOM.

That's wrong:
| When converting between different encoding schemes, extreme care must
| be taken in handling any initial byte order marks. For example, if one
| converted a UTF-16 byte serialization with an initial byte order mark
| to a UTF-8 byte serialization, thereby converting the byte order mark
| to <EF BB BF> in the UTF-8 form, the <EF BB BF> would now be ambiguous
| as to its status as a byte order mark (from its source) or as an
| initial zero width no-break space. If the UTF-8 byte serialization
| were then converted to UTF-16BE and the initial <EF BB BF> were
| converted to <FE FF>, the interpretation of the U+FEFF character would
| have been modified by the conversion. This would be nonconformant
| behavior according to conformance clause C7, because the change
| between byte serializations would have resulted in modification of the
| interpretation of the text. This is one reason why the use of the
| initial byte sequence <EF BB BF> as a signature on UTF-8 byte
| sequences is not recommended by the Unicode Standard.

And Google Docs also thinks it would be a good idea to act against this recommendation:
<https://productforums.google.com/forum/#!topic/docs/p_jCTwzuIqk>

> Would anyone be opposed to a patch to SQLite that disregarded a BOM
> when found during a csv import operation?

Well, being wrong doesn't mean that Microsoft or Google will change their behaviour ...


Regards,
Clemens


------------------------------

Message: 5
Date: Fri, 23 Jun 2017 10:13:43 +0100
From: Chris Locke <[hidden email]>
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] Could not load file or assembly error
Message-ID:
        <[hidden email]>
Content-Type: text/plain; charset="UTF-8"

I'd recommend the system.data.sqite.dll wrapper http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

This is a .Net component which works very well with SQLite databases.There are a plethora of downloads, which can seem daunting.  Depending on your .Net flavour you're working with (I assume 4.5.1) I recommend the '
*sqlite-netFx451-binary-Win32-2013-1.0.105.2.zip*' download.

If you're new to SQLite, I've written a number of SQLite classes which can be useful building a DB application... a wrapper around the wrapper, so to speak..... ;)


Thanks,
Chris


On Thu, Jun 22, 2017 at 6:50 PM, Paul J. McMillan, Sr. <[hidden email]>
wrote:

> Hi,
>
>
>
> I'm new to SQLite.  I want to use it in my C# application.  I
> downloaded the tool SQLite/SQL Server Compact Toolbox.  Under Data
> Connections, I keep getting the error message in red: "Could not load
> file or assembly 'SQLiteScripting".  Does anyone have an idea of why
> I'm getting this error?
>
>
>
> Thanks
>
> Paul McMillan
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


------------------------------

Subject: Digest Footer

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


------------------------------

End of sqlite-users Digest, Vol 114, Issue 23
*********************************************

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...