Actually SQLite does support X'...' literals for creating blobs.
-Ursprüngliche Nachricht-
Von: Dominique Devienne [mailto:ddevie...@gmail.com]
Gesendet: Dienstag, 13. Mai 2014 18:19
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] LIKE operator and collations
On Tue, M
These are the steps I had to perform:
Install Visual Studio 2005. I was unable to successfully create a new
solution platform based on another existing without VS2005 installed.
In VS2008 create a new solution platform based on existing platform
'Pocket PC 2003 (ARMV4)'. The new solution platfor
Ok,
Thanks.
On Tue, May 13, 2014 at 11:59 PM, Teg wrote:
> Hello Charles,
>
> Tuesday, May 13, 2014, 3:12:09 PM, you wrote:
>
> CS> Load it with sqlite3_value_int64 every time. If the number fits in a 32
> bit
> CS> integer, then you can store it in one.
>
> This is what I do. Everything is 64 b
the name that gets passed is the one you pass to sqlite_open... so just use
that as an indicator of which object to use and in the open callback,
result with the appropriate object... or don't use the name and ignore
it? snprintf( somebuf, sizeof( somebuf ) / sizeof( somebuf[0] ), "%p",
yo
On Tue, 13 May 2014 13:43:09 +0200
Ralf wrote:
> A "File" splits its content into several fixed-sized encrypted blocks
> and stores those blocks on some kind of storage.
> At any point in time, it is guaranteed, that no other process will
> interfere and use those blocks, so we don't need any loc
http://pubs.opengroup.org/onlinepubs/7908799/xsh/systime.h.html
http://pubs.opengroup.org/onlinepubs/7908799/xsh/flockfile.html
http://pubs.opengroup.org/onlinepubs/009695399/functions/fcntl.html
// IEEE Std 1003.1, 2004 Edition @!!= linux
On Tue, May 13, 2014 at 7:55 AM, Artur Deterer wrote:
Is something wrong with the configuration of this sqlite-users list?
A message of subject "Porting SQLite to plain C RTOS" was allowed and
distributed through it this morning with attachments.
Not only attachments, but about 5MB of attachments.
-- Darren Duncan
___
Hello,
I would like to use SQLite in my C++(11) project.
Assume that there is a class File which is able to store arbitrary data.
It provides basic IO functionality read() write() truncate() and sync().
Now I would like to use my File to store SQLite databases (persistently).
To understand my m
Hello Charles,
Tuesday, May 13, 2014, 3:12:09 PM, you wrote:
CS> Load it with sqlite3_value_int64 every time. If the number fits in a 32 bit
CS> integer, then you can store it in one.
This is what I do. Everything is 64 bits to be future proof.
CS> Charles
CS>
On Tuesday, May 13, 2014 12:02:27 PM gwenn wrote:
> Is there any way to differentiate one value persisted with
> sqlite3_bind_int from another persisted with sqlite3_bind_int64 ?
No, there's no difference
> How to know which method between sqlite3_value_int and
> sqlite3_value_int64 should be use
Hello,
Is there any way to differentiate one value persisted with
sqlite3_bind_int from another persisted with sqlite3_bind_int64 ?
How to know which method between sqlite3_value_int and
sqlite3_value_int64 should be used to retrieve the value back ?
Regards.
___
On 13 May 2014, at 5:21pm, Constantine Yannakopoulos wrote:
> This is very interesting Jan. The only way this could fail is if the
> collation implementation does something funny if it encounters this
> character, e.g. choose to ignore it when comparing.
That cuts out a very large number of co
Ok thanks a lot !
> Date: Tue, 13 May 2014 14:53:03 +0800
> From: m...@onghu.com
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Best compression for sqlite3 ?
>
> On 13/5/2014 2:45 PM, Simon Slavin wrote:
> >
> > There are two versions of your question: one for compression of a database
>
It works best to have a connection per thread.
On Tue, May 13, 2014 at 6:12 AM, d b wrote:
> Hi all,
>
>
>My application is multithreaded. It maintains only connection per
> application. Database accessed by single process only. ThreadA will do
> database write operations(bulk) in a transac
On Tue, May 13, 2014 at 5:50 PM, Jan Slodicka wrote:
> So one could replace "LIKE 'xxx%'" by "BETWEEN('xxx', 'xxx' + '\uDBFF\uDFFD').
make that
BETWEEN('xxx', 'xxx' + char(1114109))
I don't think SQlite supports \u literals, nor does it support hex
literals, so must use the decimal equivale
On Tue, May 13, 2014 at 6:50 PM, Jan Slodicka wrote:
> Any comments are welcome.
This is very interesting Jan. The only way this could fail is if the
collation implementation does something funny if it encounters this
character, e.g. choose to ignore it when comparing. Since most collations
e
I just realized that I'm missing a prerequisite for developing for the devices
I'm dealing with. They're running a stripped WinCE load that my company didn't
create, so I don't have the SDK that I need to compile for it. I'll have to
contact the manufacturer in hopes of getting my hands on it.
Constantine Yannakopoulos wrote
> On Mon, May 12, 2014 at 4:46 PM, Jan Slodicka <
> jano@
> > wrote:
> I understand that it is difficult to find the least greater character of a
> given character if you are unaware of the inner workings of a collation,
> but maybe finding a consistent upper limit
On 5/13/2014 9:12 AM, d b wrote:
My application is multithreaded. It maintains only connection per
application. Database accessed by single process only. ThreadA will do
database write operations(bulk) in a transaction. ThreadB will do single
write operation without transaction but same conne
On Tue, May 13, 2014 at 4:12 PM, d b wrote:
>My application is multithreaded. It maintains only connection per
> application. Database accessed by single process only. ThreadA will do
> database write operations(bulk) in a transaction. ThreadB will do single
> write operation without transact
Hi all,
My application is multithreaded. It maintains only connection per
application. Database accessed by single process only. ThreadA will do
database write operations(bulk) in a transaction. ThreadB will do single
write operation without transaction but same connection pointer.
Here, a
I finally managed to build SQLite using help from the following thread:
http://sqlite.1065341.n5.nabble.com/Building-SQLite-on-Windows-Embedded-Compact-7-WEC7-td64722.html
/Mattias
From: Mattias Kindborg
To: General Discussion of SQLite Database
Date: 2014-05-12 10:58
Subject:
> It can be implemented if the definition of a collation is extended to be
able to provide this information as Simon suggested.
Sure, this could be done. But I am not sure whether it would be that
usefull. For example I would not use it for my current application (C#).
--
View this message in
On 11 May 2014 00:01, Scott Robison-2 [via SQLite] <
ml-node+s1065341n75608...@n5.nabble.com> wrote:
> I suspect the primary use case it was designed and tested for (and in fact
> the way we use it at my place of employment) was more for "only growing
> datasets" and less for an environment where
24 matches
Mail list logo