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

2013-07-19 Thread Israel Lins Albuquerque
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

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

2013-07-19 Thread Sqlite Dog
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

Re: [sqlite] Query on sqlit3_malloc()

2013-07-19 Thread Ashok Pitambar
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

[sqlite] Query on sqlit3_malloc()

2013-07-19 Thread Ashok Pitambar
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

Re: [sqlite] Query on sqlit3_malloc()

2013-07-19 Thread Igor Tandetnik
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

Re: [sqlite] Query on sqlit3_malloc()

2013-07-19 Thread Simon Slavin
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?

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

2013-07-19 Thread Sqlite Dog
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

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

2013-07-19 Thread 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 easily and I don't know of

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

2013-07-19 Thread Ralf Junker
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

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

2013-07-19 Thread 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 open is an encrypted database file or just a file > of >

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

2013-07-19 Thread Sqlite Dog
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: > >

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

2013-07-19 Thread Sqlite Dog
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

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

2013-07-19 Thread kyan
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

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

2013-07-19 Thread Richard Hipp
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 _

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

2013-07-19 Thread Sqlite Dog
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

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

2013-07-19 Thread Niall O'Reilly
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:

Re: [sqlite] Integer data type

2013-07-19 Thread Igor Tandetnik
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

Re: [sqlite] Integer data type

2013-07-19 Thread Paolo Bolzoni
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

Re: [sqlite] Integer data type

2013-07-19 Thread Simon Slavin
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

Re: [sqlite] Integer data type

2013-07-19 Thread Paolo Bolzoni
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

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

2013-07-19 Thread Simon Slavin
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

Re: [sqlite] Integer data type

2013-07-19 Thread Paolo Bolzoni
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

Re: [sqlite] Integer data type

2013-07-19 Thread Hick Gunter
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

Re: [sqlite] Integer data type

2013-07-19 Thread Richard Hipp
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

2013-07-19 Thread Paolo Bolzoni
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

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

2013-07-19 Thread sqlite . 20 . browseruk
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

2013-07-19 Thread Loren Keagle
>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

Re: [sqlite] Integer data type

2013-07-19 Thread Simon Slavin
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

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

2013-07-19 Thread 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: * Create your own sqlite.dll and com

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

2013-07-19 Thread 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. You can ship it as a DLL and use a spe

Re: [sqlite] Integer data type

2013-07-19 Thread Paolo Bolzoni
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

Re: [sqlite] SQLite3 : Corrupt/IO Error

2013-07-19 Thread Paolo Bolzoni
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

[sqlite] Integer data type

2013-07-19 Thread techi eth
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

2013-07-19 Thread techi eth
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

2013-07-19 Thread 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 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

[sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
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