In the past, I've used the pager to secure data. This involved encrypting the
data before writing the data to disk and decrypting when loading from disk but
also optionally hashing the page and storing the hash in extra data reserved
for each page. If anyone tampered with the data, the hash
Having just glanced at the documentation for ZIPVFS (didn't even know it
existed)...
1) Perhaps using a real-time compression algorithm, something like lz4.
It's not clear to me which algorithm ZIPVFS uses by default.
2) Perhaps increasing the cache settings to cache more pages in memory.
3)
Simon, if the data in the database is sensitive, could you encrypt the database
(ala something like https://www.zetetic.net/sqlcipher/)?
That way if the file is left around for some reason, it's much less of a
concern. Your app could generate a new (random) key each time it creates a new
Some suggestions:
1) Check your temp folder and remove chaff.
2) Download CCleaner and check your registry integrity.
3) Review updates that have been applied and try removing them one at a time
or in a targeted fashion. You should be able to see what updates were
applied around the time you
As Dan said, the console app needs the read/write flag. The other app appears
to be using CStringW, but the api takes a const char *, not a wide char
pointer. I'd try CStringA and explicitly cast to LPCSTR.
Michael Stephenson
On Apr 5, 2013, at 11:01 AM, Dan Kennedy <danielk1...@gmail.
It's almost trivial to add per-page checksums at the page level. Here are
basic steps:
1) Define SQLITE_HAS_CODEC when building. This will cause 5 unresolved
externals (functions declared but not defined/implemented). You need to
provide implementations of these 5 functions:
a.
The Visual Studio debugger has a limitation of 64K lines in a source file for
code stepping. Well, actually the debugger is fine, it's a limitation of
Visual Studio itself that has been reported to Microsoft (maybe a decade ago)
but never fixed.
WinDbg is almost as good.
Another solution is
Assuming that you are calling reset after each use of a prepared statement
and/or that the error occurs on the very first bind...
This sounds like in the working case the statements are prepared, bound, and
then reset by the same thread each time these steps are done, but perhaps in
the
und no documentation about implementing the crypting api.
Kind Regards
Fabrizio
> -Ursprüngliche Nachricht-
> Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] Im Auftrag von Michael Stephenson
> Gesendet: Donnerstag, 15. Dezember 2011 20:40
>
A couple more questions:
1) Does "without encryption" mean still using System.Data.SQLite, just
without using a key?
2) Are you using WAL?
3) Do you also see the problem with a single process with two connections?
4) Any chance you could provide a small demo project that demonstrates the
Have a look at:
http://sqlcipher.net
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ashokkumar Gupta
Sent: Wednesday, September 14, 2011 1:53 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to : encrypt the data of
Just a guess, but you may have to use one of the Pager functions to examine
the buffer for database page 1, which is always pinned in memory and which
represents the first bytes of the database file.
-Original Message-
From: sqlite-users-boun...@sqlite.org
"It's rather pointless to use a LIKE operator with no wildcards."
Except that it performs a case-insensitive comparison, so a quick-and-dirty
way to accomplish that.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor
Well, in the first code example, yes you need to free your peekText pointer.
Since you passed SQLITE_STATIC for the destructor parameter to
sqlite3_bind_text, you should free it before you exit the function and not
before. If you use SQLITE_TRANSIENT, you can free it immediately after the
bind
Most likely, since you say only the first character is being compared, is
that you have an ANSI/Unicode issue. Specifically, it sounds like a Unicode
string is being passed to your collation function, which is expecting ANSI
and then finding a 0 at the second byte is determining that that is the
If your programming language is C or C++, it's trivial to register a
function with SQLite at runtime that can then be used in your queries. This
does not require hacking SQLite itself.
As noted, you can't return multiple rows per database row via a function.
That's not how SQL works; it is "set"
If you use INTEGER PRIMARY KEY, that column becomes your rowids; this does
not create a new, separate column in addition to the rowid column.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Abhinav Upadhyay
Sent: Thursday,
Add #include or #include "SomeHeader.h" to the top of the
amalgamation, then define them in SomeHeader.h?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Baruch Burstein
Sent: Tuesday, July 12, 2011 10:48 AM
To: General
What if you put a semicolon at the end of the query text?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th
Sent: Thursday, July 07, 2011 3:32 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Insert
I don't see something like a "create table tbl1(one, two);" statement.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th
Sent: Thursday, July 07, 2011 1:52 AM
To: General Discussion of SQLite Database
Subject:
You might want to check out various compilation options at:
http://www.sqlite.org/compile.html
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, July 04, 2011 7:28 AM
To: General Discussion of SQLite
Perhaps you could look at the code in shell.c and see how it does the .dump,
then copy paste or something similar into your own app. I'm not sure if
there might be issues with functions declared SQLITE_API vs SQLITE_INTERNAL,
which may require some additional working around, but hopefully not.
, on the end-user machine, to an error like
"System.DllNotFoundException: Impossible to load the DLL
'_SQLite.Interop.DLL_'"? (i.e. an error linked to a different DLL than
the one mentioned by Depends)
Thanks again very much :)
Best regards,
Cyrille
Le 19/06/2011 20:10, Michael
for their IE version to
see if there is a link with the issue.
Regards,
Cyrille
Le 19/06/2011 05:20, Michael Stephenson a écrit :
> If the IE folder is not on the path, yes, you have to either copy it
> somewhere on the path, copy it to your application folder, or add the
>
If the IE folder is not on the path, yes, you have to either copy it
somewhere on the path, copy it to your application folder, or add the IE
folder to the path. I believe that not having the IE folder on the path is
a mistake in the installer for the newer versions of IE. Back in the day, I
Well, it's pretty easy to add regex functionality, for example via PCRE.
You can add this to your custom build of SQLite, or you can add it to your
client application and register a regex function with SQLite after the
database is opened, then use it in your queries. I can provide an example
if
Wondering if anyone has a way to execute a query that selects rows based on
a list of rowids and returns the results in the order of the rowids passed
in.
Thanks,
~Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
NEW.timestamp < OLD.timestamp
(less than)?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Mellander
Sent: Wednesday, June 01, 2011 3:31 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Trigger help needed
I don't see anywhere a "sqlCmd.Execute()" or whatever the method is to
execute the command.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Don Ireland
Sent: Tuesday, May 31, 2011 11:21 PM
To: General Discussion of SQLite
If you change the page size after the database has been created and written
to, yes, you need to a vacuum to have SQLite reorganize the database pages.
Note that even this does not work if WAL is in use (if WAL is turned on,
then you can't change the database page size after the database has been
journal_mode = wal
Michael Stephenson, We want to thank you again for your excellent
suggestions regarding how to improve the speed of our Sqlite WAL reads and
our deduper prototype. We looked at the SQlite documentation for increasing
the Sqlite page size to 4K and an excerpt of our code is shown
Not an expert, but I doubt that WAL will have much of anything to do with
your read performance after you've populated the database and committed the
last insert transaction. WAL mostly deals with inserts
(http://www.sqlite.org/draft/wal.html). Once the last transaction is
written and you are
chine = 'machine2'
where a.machine = 'machine1';
or
select *
from test a left join test b
on a.component = b.component
where a.machine = 'machine1'
and (b.machine is null or b.machine = 'machine2');
I think the first syntax is preferable.
Pavel
On Wed, May 25, 2011 at 9:09 AM, Mich
Hi, I have a table as below. Note that machine1 has 3 components (1-3),
while machine2 has only 1 components (1).
Machine
Component
Version
machine1
component1
1
machine1
component2
1
machine1
component3
1
machine2
component1
1
create table test(Machine, Component,
34 matches
Mail list logo
