Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] Query on sqlit3_malloc()

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 >

[sqlite] Query on sqlit3_malloc()

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

Re: [sqlite] Query on sqlit3_malloc()

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

Re: [sqlite] Query on sqlit3_malloc()

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?

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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'

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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).

Re: [sqlite] Using in-memory DBs of the form: "file:memdb1?mode=memory=shared" (via Perl, DBD::SQLite & DBI)

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

Re: [sqlite] Integer data type

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

Re: [sqlite] Integer data type

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

Re: [sqlite] Integer data type

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.

Re: [sqlite] Integer data type

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,

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

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

Re: [sqlite] Integer data type

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,

Re: [sqlite] Integer data type

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

Re: [sqlite] Integer data type

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

Re: [sqlite] Integer data type

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

[sqlite] Using in-memory DBs of the form: "file:memdb1?mode=memory=shared" (via Perl, DBD::SQLite & DBI)

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

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

>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:

Re: [sqlite] Integer data type

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] A few questions about SQLite Encryption Extension

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

Re: [sqlite] Integer data type

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

Re: [sqlite] SQLite3 : Corrupt/IO Error

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)

[sqlite] Integer data type

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

Re: [sqlite] SQLite3 : Corrupt/IO Error

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:

Re: [sqlite] A few questions about SQLite Encryption Extension

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

[sqlite] A few questions about SQLite Encryption Extension

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