[sqlite] Connection string

On 8/12/2015 4:27 AM, faizel williams wrote: > I would like to create a link table in MS Access to a SQLite database. (Not > using ODBC driver) This can't possibly work. Access doesn't have any built-in knowledge of SQLite - by what magic do you expect it to acquire the ability to understand

[sqlite] Lawyers, encryption, and RC4

Thanks to everyone for their contributions on this topic. I sent Dr. Hipp's explanation to our legal team, and that was good enough for them. (This is a US company, for those who wondered.) I agree with Simon that if that explanation could be added to the comment in random.c about the use of

[sqlite] How to enable shared cache mode?

I'm looking for a way to enable the shared-cache locking model in system.data.sqlite. http://www.sqlite.org/sharedcache.html I've looked through the source, and see there is a method in UnsafeNativeMethods.cs that exposes this internally to the assembly, but nothing that's public. E.g.

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

> Actualy (maybe I wrong) but it leads to the same result in that case > that using `reinterpret_cast` > > my problem about doing that is I don't know if it's safe... > I mean, should I not get some mess with some char code > (UTF8)? > You could create a new unsigned string type typedef

[sqlite] Lawyers, encryption, and RC4

On 12 Aug 2015, at 2:45pm, Brian Willner wrote: > If you point out to your lawyers that SQLite is not doing anything that > Apple's OS X is doing, you may get some traction as well. Sorry to have to tell you that OS X /is/ registered for a US export licence, mostly for its incorporation of

[sqlite] Lawyers, encryption, and RC4

On 11 Aug 2015, at 3:00pm, Rob Willett wrote: > I recall that it used to be that 40 bit RC4 was OK and I *think* that the bit > length is now longer (128bit?) as it has been shown that 40 bit RC4 is as > much use as a chocolate fireguard. While it is allowable to export software

[sqlite] Using SQLite in a multi-threaded environment

Dear all, I have a (probably) very basic question regarding the usage of SQLite in an multithreaded environment. I use a compiled version of SQLite with SQLITE_THREADSAFE 0. Inside my application exists one thread that is the exclusive user of the SQLite interface. So from my point of view I am

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

thx Andy, I'll keep that one close. When my program will be ready to perform some tests with UTF8 encoding, I'll try your solution. regards, Nicolas Le Wed, 12 Aug 2015 16:02:54 +, Andy Ling a ?crit : > > Actualy (maybe I wrong) but it leads to the same result in that case > > that using

[sqlite] Small bug in ".dump", ".schema" and ".fullschema"

I tried your example. '.schema' and '.fullschema' do show the problem you describe. However, for me, '.dump' worked correctly placing the semicolon on a line by itself right after the comment. - Original Message - From: "sqlite-mail" To: Sent: Wednesday,

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

Hi, Actualy (maybe I wrong) but it leads to the same result in that case that using `reinterpret_cast` my problem about doing that is I don't know if it's safe... I mean, should I not get some mess with some char code (UTF8)? I was expecting some people already did a such cast in the past and

[sqlite] Connection string

Hi, I would like to create a link table in MS Access to a SQLite database. (Not using ODBC driver) The following code works in MS Access, but link table are in another MS Acces database Private Sub CreateAccessLinkTable(ByVal stmtHandle As Long, newTableName As String) Dim td As DAO.TableDef

[sqlite] Lawyers, encryption, and RC4

"Several operating systems include arc4random, an API originating in OpenBSD providing access to a random number generator originally based on RC4. In OpenBSD 5.5, released in May 2014, arc4random was modified to use ChaCha20.[11][12] As of January 2015, implementation of arc4random in

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

On Tue, Aug 11, 2015 at 9:06 PM, Nicolas J?ger wrote: > Hi, > I have some basic problem, but I didn't found the solution so far... > maybe some people are using C++ and already deal with that problem : > > conversion from ?const unsigned char*? to non-scalar type ?std::string > > I got the

[sqlite] Lawyers, encryption, and RC4

Just speaking as a cantankerous old cynic, I wonder how much of this is being driven by a real concern and how much is being driven by someone with an agenda to use a "more favored" product. I've been pushed even further in the latter direction, in general, when I learned from a person who was

[sqlite] Fwd: Problem with SQLite in C++. DB is BUSY (Multithread)

We tried already, still fail without correct recovery. > From: slavins at bigfraud.org > Date: Tue, 11 Aug 2015 03:43:59 +0100 > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Fwd: Problem with SQLite in C++. DB is BUSY > (Multithread) > > > On 11 Aug 2015, at 2:28am,

[sqlite] SQLite crash

On 08/12/2015 02:15 AM, Robert Weiss wrote: > The bug seems to be repeatable. At least, it happened again today. > I haven't used gdb in a long time. Here's my first crack at it; what else > should I do? > $ gdb sqliteGNU gdb (GDB) 7.8Copyright (C) 2014 Free Software Foundation, > Inc.License

[sqlite] Site unavailable.

In Russia when I'm trying to visit sqlite.org site, I'm getting conection timeout. Also, sqlite.org doesn't pinged.

[sqlite] Site unavailable.

On 12 Aug 2015, at 12:18am, ??? ??? wrote: > In Russia when I'm trying to visit sqlite.org site, I'm getting conection > timeout. > > Also, sqlite.org doesn't pinged. The web site is accessible from western Europe. And I can reach Moscow State University so it doesn't seem to be

[sqlite] Small bug in ".dump", ".schema" and ".fullschema"

Hello ! Working with sqlite3 I noticed that sqlite3 ".dump", ".schema" and ".fullschema" outputs the contents of the field "sql" stored in "sqlite_master" and if the sql statement ends with a comment the resulted dump will be invalid see example: === valid sql statement stored on

[sqlite] Patch that add ".dumpdata" and "BEGIN TRANSACTION; " command to shell.c

Hello again ! After sending the first patch I also realized that when sqlite3 dumps ".schema" or ".fullschema" it doesn't surround the dump with a transaction and that takes longer and makes the hard disk work hard. So I also surrounded ".schema" and ".fullschema" with a transaction with this