I have the same issue here!
I have an replication system using sqlite where:
- I have 2 databases: one for output* and other for input*;
- I have 2 process accessing booth:
The first is the replicator:
- Get the data on remote server and write on input database;
- Get the data on output da
OK. Thank you.
2013/7/19 Richard Hipp
> On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog wrote:
>
> > >
> > > There is no way to detect which encryption algorithm is used. Indeed,
> > the
> > > encryption is so thorough that there is no way to tell whether or not
> the
> > > file you are trying to
Thanks Simon and Igor for the reply.
On Fri, Jul 19, 2013 at 11:26 PM, Simon Slavin wrote:
>
> On 19 Jul 2013, at 6:50pm, Ashok Pitambar wrote:
>
> > I am using SQLite in my application, Is sqlite mandates or
> is
> > it necessary
> > to use Sqlite provided memory allocation(sqlit
Hi All,
I am using SQLite in my application, Is sqlite mandates or is
it necessary
to use Sqlite provided memory allocation(sqlit3_malloc()) functions instead
for native allocators(malloc())in applications? If yes why it is necessary?
Is there any harm for not using them.
Ex: Here I
On 7/19/2013 1:50 PM, Ashok Pitambar wrote:
I am using SQLite in my application, Is sqlite mandates or is
it necessary
to use Sqlite provided memory allocation(sqlit3_malloc()) functions instead
for native allocators(malloc())in applications? If yes why it is necessary?
Is there an
On 19 Jul 2013, at 6:50pm, Ashok Pitambar wrote:
> I am using SQLite in my application, Is sqlite mandates or is
> it necessary
> to use Sqlite provided memory allocation(sqlit3_malloc()) functions instead
> for native allocators(malloc())in applications? If yes why it is necessary?
2013/7/19 RSmith
> Being a Delphi Developer (mostly) and using SQLite quite often, I can tell
> you some things about it:
>
> You can easily wrap an SQLite DLL in Delphi, there are many free
> implementations of this, if you dont have one, send me a mail and I will
> supply one. SEE will work as
Being a Delphi Developer (mostly) and using SQLite quite often, I can tell you
some things about it:
You can easily wrap an SQLite DLL in Delphi, there are many free implementations of this, if you dont have one, send me a mail and I
will supply one. SEE will work as easily and I don't know of
On 19.07.2013 15:27, Sqlite Dog wrote:
>> * Statically link SQLite to your Delphi application. My DISQLite3
>> enables you to do just that and has numerous extensions: One is a
>> custom encryption algorithm. This is not compatible with SEE,
>> but if you like I can replace it with your orig
On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog wrote:
> >
> > There is no way to detect which encryption algorithm is used. Indeed,
> the
> > encryption is so thorough that there is no way to tell whether or not the
> > file you are trying to open is an encrypted database file or just a file
> of
>
2013/7/19 Ralf Junker
> On 19.07.2013 09:21, Sqlite Dog wrote:
>
> > Our database manager is developed using Delphi (Pascal). Thus it is
> > not possible to statically link SQLite library, SQLite.dll is used.
> > Is there some other way to support SEE in our project?
>
> You have two options:
>
>
2013/7/19 Richard Hipp
> On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog wrote:
>
> >
> > Our database manager is developed using Delphi (Pascal). Thus it is not
> > possible to statically link SQLite library, SQLite.dll is used. Is there
> > some other way to support SEE in our project?
> >
>
> Yes
On Fri, Jul 19, 2013 at 3:49 PM, Sqlite Dog wrote:
> That's interesting. What about pas file with function declarations to
> SQLite API? Should it be modified somehow?
>
>
If you use static dll loading and linking, Instead of declaring API
functions as external 'sqlite3.dll' you declare them as p
On Fri, Jul 19, 2013 at 8:49 AM, Sqlite Dog wrote:
> That's interesting. What about pas file with function declarations to
> SQLite API? Should it be modified somehow?
>
No need to. The SQLite Encryption Extension is controlled using PRAGMA
statements.
--
D. Richard Hipp
d...@sqlite.org
_
That's interesting. What about pas file with function declarations to
SQLite API? Should it be modified somehow?
2013/7/19 kyan
> On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog wrote:
>
> >
> > Our database manager is developed using Delphi (Pascal). Thus it is not
> > possible to statically lin
On 19 Jul 2013, at 09:36, sqlite.20.browse...@xoxy.net wrote:
> Anyone here using SQLite via Perl & DBI & DBD::SQLite?
Yes, but not with an in-memory database.
Niall O'Reilly
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:
On 7/19/2013 8:29 AM, Paolo Bolzoni wrote:
Interesting problem, can you add a new comparison
operator to sqlite3?
Yes, but only for strings, not for ints.
http://sqlite.org/c3ref/create_collation.html
--
Igor Tandetnik
___
sqlite-users mailing list
Or just use a BLOB.
On Fri, Jul 19, 2013 at 2:29 PM, Simon Slavin wrote:
>
> On 19 Jul 2013, at 1:20pm, Paolo Bolzoni
> wrote:
>
>> True, I was thinking as follow up of what I
>> mentioned in the first message.
>> -11 is the result of the cast of 4294967285
>> from unsigned int to int in a mach
On 19 Jul 2013, at 1:20pm, Paolo Bolzoni wrote:
> True, I was thinking as follow up of what I
> mentioned in the first message.
> -11 is the result of the cast of 4294967285
> from unsigned int to int in a machine
> where int are 32 bits long.
Then don't cast. If you think your numbers are goi
Interesting problem, can you add a new comparison
operator to sqlite3?
On Fri, Jul 19, 2013 at 2:19 PM, Hick Gunter wrote:
> It might change the sort order...
>
> -Ursprüngliche Nachricht-
> Von: Paolo Bolzoni [mailto:paolo.bolzoni.br...@gmail.com]
> Gesendet: Freitag, 19. Juli 2013 14:11
On 18 Jul 2013, at 8:26pm, Loren Keagle wrote:
> It definitely seems to be related to having the same database attached
> multiple times with different names.
Okay. I have absolutely no idea how well SQLite copes with that. I'm not
saying it's bad, I just have no idea at all. I hope one of
True, I was thinking as follow up of what I
mentioned in the first message.
-11 is the result of the cast of 4294967285
from unsigned int to int in a machine
where int are 32 bits long.
On Fri, Jul 19, 2013 at 2:16 PM, Richard Hipp wrote:
> On Fri, Jul 19, 2013 at 8:11 AM, Paolo Bolzoni <
> paol
It might change the sort order...
-Ursprüngliche Nachricht-
Von: Paolo Bolzoni [mailto:paolo.bolzoni.br...@gmail.com]
Gesendet: Freitag, 19. Juli 2013 14:11
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Integer data type
After all do you really care if the unsigned int 4
On Fri, Jul 19, 2013 at 8:11 AM, Paolo Bolzoni <
paolo.bolzoni.br...@gmail.com> wrote:
> After all do you really care if the unsigned
> int 4294967285 is stored as -11?
>
To be pedantic: SQLite stores 4294967285 as 4294967285. It is
18446744073709551605 that gets stored as -11.
--
D. Richard
After all do you really care if the unsigned
int 4294967285 is stored as -11?
On Fri, Jul 19, 2013 at 1:13 PM, Simon Slavin wrote:
>
> On 19 Jul 2013, at 11:02am, techi eth wrote:
>
>> Definition of integer data type will talk for signed integer. What about
>> unsigned integer ?Are they also be
Hi all,
Anyone here using SQLite via Perl & DBI & DBD::SQLite?
Thanks, buk.
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
Check it out at http://www.inbox.com/earth
>Date: Wed, 17 Jul 2013 17:21:15 +0100
>From: Simon Slavin
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Sqlite locking issue with ATTACH'ed databases
>Message-ID:
>Content-Type: text/plain; charset=us-ascii
>On 16 Jul 2013, at 11:24pm, Loren Keagle wrote:
>> Begin EXCLUS
On 19 Jul 2013, at 11:02am, techi eth wrote:
> Definition of integer data type will talk for signed integer. What about
> unsigned integer ?Are they also be part of same data type.
Yes. SQLite has no special type for an unsigned integer. Just store them as
integers.
The page you were lookin
On 19.07.2013 09:21, Sqlite Dog wrote:
> Our database manager is developed using Delphi (Pascal). Thus it is
> not possible to statically link SQLite library, SQLite.dll is used.
> Is there some other way to support SEE in our project?
You have two options:
* Create your own sqlite.dll and com
On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog wrote:
>
> Our database manager is developed using Delphi (Pascal). Thus it is not
> possible to statically link SQLite library, SQLite.dll is used. Is there
> some other way to support SEE in our project?
>
Yes. You can ship it as a DLL and use a spe
As far as I know there is no unsigned integer in
sqlite3. If you need cast to a signed integer of the
same size before using sqlite3.
On Fri, Jul 19, 2013 at 12:02 PM, techi eth wrote:
> Definition of integer data type will talk for signed integer. What about
> unsigned integer ?Are they also be
By default sqlite3 is fairly safe, so when you change a pragma
ensure that you are not disabling a safety feature.
To get an idea, check this thread where I had the opposite need
(more speed, less safety)
http://sqlite.1065341.n5.nabble.com/What-pragma-to-use-to-get-maximum-speed-at-expense-of-saf
Definition of integer data type will talk for signed integer. What about
unsigned integer ?Are they also be part of same data type.
*INTEGER*. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8
bytes depending on the magnitude of the value.
http://www.sqlite.org/datatype3.html
Bye
_
Thanks for answer.
I can do integrity check by PRAGMA integrity_check.Please correct me if i
wrong.
Here backup means copying database file OR we can create query to SQLite
for backup or copy.
Cheers-
Techi
On Wed, Jul 17, 2013 at 4:42 PM, Paolo Bolzoni <
paolo.bolzoni.br...@gmail.com> wrote:
On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog wrote:
>
> Our database manager is developed using Delphi (Pascal). Thus it is not
> possible to statically link SQLite library, SQLite.dll is used. Is there
> some other way to support SEE in our project?
>
It is possible to compile the SQLite amalga
Hi,
documentation on SEE (http://www.hwaci.com/sw/sqlite/see.html) states that
"You can ship as many compiled, binary copies of SQLite with your
commercial product as long as each copy is attached to your product in such
a way that it cannot be separated from your product. Normally this means
tha
36 matches
Mail list logo