Dear SQLIte developers,
Here is a small patch for the linked-list merge sorter in SQLite
to sort N items,
It will save about 2*N CPU instructions by eliminate unnecessary null
pointer check,
Regards
make test passed.
fossil diff
Index: src/pcache.c
Just in case what I was asking wasn't clear, I'd like to give an example.
If you look at the definition of "LSM_CONFIG_MMAP", if it is true, the entire
database file is memory mapped. If it's false, data is accessed using
ordinary OS file read and write primitives.
But if you look at flag
When I attempt to search the archives of this mailing list for the word:
LSM_CONFIG_AUTOFLUSH
Using http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/
I get no hits.
But when I search using http://sqlite.1065341.n5.nabble.com/
It does work:
See? -->
Hi, I've hit an issue with multiple line command.
Used SW:
- sqlite3 3.11.0
- bash 4.3-14
- gnome-terminal 3.18.3
- Ubuntu 16.04
Steps to reproduce:
- Copy these two lines into clipboard:
SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
FROM baked_goods;
-
On 2016-05-20 01:55, Gaurav Batra wrote:
> From where I can get the signed binaries?
I would suggest to compile SQLite and System.Data.SQLite yourself and
sign it yourself. It's not hard. It's likely also the most secure
solution. You will need a code signing certificate. If your employer has
On 2016-05-20 16:44, Steve Schow wrote:
> it seemed to detect it for me when I built on Debian 7
Are you sure? Was this using the sqlite-autoconf-313.tar.gz tarball?
Just to understand the issue better, can you post the output of running
"./configure" as well as the generated "config.log".
I had proposed (private email) some set of changes to shell.c to support
unicode as fully as possible, including keyboard handling and output display,
within the limits of the glyphs available in the unicode font selected for the
windows console.
I see the support of unicode in sqlite3.exe
On 2016/05/20 3:34 PM, Jason H wrote:
>
>> Sent: Friday, May 20, 2016 at 6:44 AM
>> From: "Richard Hipp"
>> To: "SQLite mailing list"
>> Subject: Re: [sqlite] Password Protect SQLite DB
>>
>> On 5/20/16, Agarwal, Rajesh wrote:
>>> Not encryption, to password protect the db file.
>> How is it
On Thu, 19 May 2016 22:12:48 -0500
"Kasajian, Kenneth" wrote:
> I am interested in using the LSM
> (https://www.sqlite.org/src4/doc/trunk/www/lsmusr.wiki)
>
> The characteristics of my application is that I would like to enable
> the memory-mapped file feature so that I can offload data in
> That's an interesting perspective. If you're dealing with genuine sets,
and
> you define your language in terms of second-order operations, then
something
> like LIMIT could be included. Would have to be, I guess.
Every aggregation function is at least second order: a function that applies
a
With SQLite 3.13.0 using the autoconf tarball, running ./configure
without arguments does not automatically check for readline. This used
to work in SQLite 3.8.4. The reason is that the default value for
"enable-readline" is set to "no" in configure.ac. The fix is easy:
diff -ru a/configure.ac
Kishore uddavolu wrote:
> Data is being retrieved using c# using system.data.sqlite-sqlitedatareader.
> We are able to retrive non German characters. Problem is with reading
> German characters. We tried with text and nvarchar types.but German
> characters are showing as question mark.
SQLite
Actually, one can code-sign things without re-compiling them. Just download
your certificate, create a key store, then get the tools.
You will also probably need to have a link to your CA, as well.
On Fri, May 20, 2016 at 10:58 AM, Matthias-Christian Ott
wrote:
> On 2016-05-20 01:55, Gaurav
The fundamental issue is that the SQLite database format is well known,
so while you can compile in the authentication extension to make the
program need to authenticate, a program without that extension included
has the ability to access the database without the password. Even if all
versions
On 5/20/16, Quan Yong Zhai wrote:
> Dear SQLIte developers,
>
> Here is a small patch for the linked-list merge sorter in SQLite
> to sort N items,
> It will save about 2*N CPU instructions by eliminate unnecessary null
> pointer check,
Thank you for the optimization suggestion.
The
Not encryption, to password protect the db file.
Thanks
Rajesh Agarwal
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Friday, May 20, 2016 4:11 PM
To: SQLite mailing list
True. Depending on the data sensitivity (Say a phone book) the restriction
may be to allow or deny access to modifying phone numbers, changing names,
or what have you. It may all be 'public knowledge' within the domain of
who has access, so reading the data may not be the security hotspot. But
it seemed to detect it for me when I built on Debian 7
I had the following packages installed via apt-get: readline-common
libreadline6-dev libreadline6
On May 20, 2016, at 6:07 AM, Jeroen Demeyer wrote:
> With SQLite 3.13.0 using the autoconf tarball, running ./configure without
>
On 5/20/16, Agarwal, Rajesh wrote:
> Not encryption, to password protect the db file.
How is it possible to "password protect" a file without encrypting it?
--
D. Richard Hipp
drh at sqlite.org
On 5/20/16, Agarwal, Rajesh wrote:
> Are there any extensions available
> to password protect the SQLite database?
The SQLite Encryption Extension (SEE): http://www.hwaci.com/sw/sqlite/see.html
--
D. Richard Hipp
drh at sqlite.org
Hi,
Is there a way to password protect the SQLite database files? I compiled the
following extension with DSQLITE_USER_AUTHENTICATION option. It worked with the
compiled version of SQLite but when I accessed the same password protected file
through JDBC or another SQLite console app (without
Hi, one of our cpp application is writing data into sqlite db using sqlire3 dll.
Data is being retrieved using c# using system.data.sqlite-sqlitedatareader. We
are able to retrive non German characters. Problem is with reading German
characters. We tried with text and nvarchar types.but German
Hi - I am using System.Data.SQLite.dll and SQLite.Interop.dll for one of my
project. For internal compliance reason, I am using v1.0.94 for both the
binaries. My company has a policy that we can only use signed binaries. From
where I can get the signed binaries?
Thanks
Gaurav
23 matches
Mail list logo