RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

I am using a fully patched/updated VS 2003 and have never had an issue with sqlite on any OS, including Win 2003 (SP1 and pre-SP1). I am still using a slightly older 3.x build, however, and have not tested the newest build. Also, I have some code modifications in my sqlite dll but I doubt it

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

Yeah, :) I just found those. Don't quite have it hooked in yet. But we shall see. I spoke with MS, they are saying that what is happening with the gcc gened dll is that when the dll loads it has to get relocated, when the dll tables get fixed up there are a couple of entries that point outside

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

I followed these instructions for VS 2003 http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -Original Message- From: Derek Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12,

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

Peerrrfect. I will give that a shot, I was trying to figure out if the preprocessed files might get in the way of the dll config. But perhaps not. I am using VS.NET 2003. I'll let you know what happens, thanks. ~derek. -Original Message- From: Tim McDaniel [mailto:[EMAIL PROTECTED]

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

Which version of VC++ do you have? I'm using VS.NET 2003. In any case, it isn't diffcult. You can download the "pre-processed" source for Windows from sqlite.org. Create a dll project, and add the source files, including sqlite3.def, and excluding shell.c. I specify the NO_TCL macro to omit

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

That would be great for me... How are you building it? Just down load the source and point a project at it? I can imagine its going to be that easy? I could not find any documentation on building with VC++. I am working on upgrading to 3.2.2, I doubt its going to make a difference, but you never

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 12, 2005 1:20 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working > > On Tue, 2005-07-12 at 11:01 -0700, Derek Shaw wrote: > > SQLite 3

Re: [sqlite] Multi-thread support

On 7/12/05, Alex Chudnovsky <[EMAIL PROTECTED]> wrote: > Gé Weijers wrote: > > > No, sqlite3 uses database-level locking, either one process can > > write, or many processes can read. Good enough for most embedded uses. > > Any plans for internal queueing of queries waiting for their turn to >

RE: [sqlite] Ticket 923 status (missing quotes in 2.8.15 .dump...)

Does anyone have a work around for ticket 923 (described below)? Is this perhaps not considered a bug? When dumping an Sqlite 2.8.16 database, the data in the dump file is enclosed in single quotes except for fields containing only digits [0-9]. This is the case even if the fields are

Re: [sqlite] Multi-thread support

Gé Weijers wrote: No, sqlite3 uses database-level locking, either one process can write, or many processes can read. Good enough for most embedded uses. Any plans for internal queueing of queries waiting for their turn to write rather than just return database locked? I did implement

Re: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

On Tue, 2005-07-12 at 11:01 -0700, Derek Shaw wrote: > SQLite 3 relocates 2 addresses out of its memory bounds when it > loads. Can you explan in more detail what this means? -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Multi-thread support

Roushan, No, sqlite3 uses database-level locking, either one process can write, or many processes can read. Good enough for most embedded uses. Gé On Jul 12, 2005, at 3:12 AM, Roushan Ali wrote: Hi all, Can anybody tell me how to handle concurrent write using sqlite3 database ?

[sqlite] sqlite 3.x and Win Server 2003 SP1 not working

Hi There, After quite a bit of work and the involvement of Microsoft (tunneling through support) I have been told that the problem with our product is that SQLite 3 relocates 2 addresses out of its memory bounds when it loads. Windows 2003 Server SP1 now requires dll's to relocate. The bad

Re: [sqlite] Saving "Unsigned Long"s in database

On Tue, 2005-07-12 at 18:28 +0200, Gotzon Astondoa wrote: > This is the number that i don´t understand. Because: > (28.672 - 12.288)/510 = 31 bytes per row. > I think it will be: > 4 bytes for the group_id > 4 bytes for the domain > 4 bytes for the idx_domain > -- > 12

Re: [sqlite] Saving "Unsigned Long"s in database

> I create the database in this way: > > PRAGMA page_size=4096; > CREATE TABLE domains (group_id NUMERIC, domain NUMERIC); > CREATE INDEX idx_domain ON domains (domain ASC); > > I create an index in domain because i want to make sentences where the WHERE > clause will appear in this

Re: [sqlite] Saving "Unsigned Long"s in database

OK, OK: i correct my bad programing style. And... forget the use of length. I´m new in this ;-). But the problem remains. I will explain in in another way. I create the database in this way: PRAGMA page_size=4096; CREATE TABLE domains (group_id NUMERIC, domain NUMERIC); CREATE

Re: [sqlite] Saving "Unsigned Long"s in database

Jay Sprenkle <[EMAIL PROTECTED]> writes: > On 7/12/05, Gotzon Astondoa <[EMAIL PROTECTED]> wrote: >> ... >> struct hostent *hep; >> ... >> hep=gethostbyname(DomainTxt); >> ... >> strcpy(txtIP, inet_ntoa(*((struct in_addr *)hep->h_addr_list[i]))); >>

Re: [sqlite] Saving "Unsigned Long"s in database

On 7/12/05, Gotzon Astondoa <[EMAIL PROTECTED]> wrote: > Hi all: > > I need to make an IP database. They will be stored like "unsigned long" > variables, so, their size will be 4 bytes. > > The IP will be stored in the "domain" field. > The "field type" of domain is NUMERIC. > > I save

Re: [sqlite] Saving "Unsigned Long"s in database

> SELECT avg(length(domain)) from domains; > > The response is 10 and not 4. >From : length(X) Return the string length of X in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is

Re: [sqlite] beginnings with sqlite

Ok I found my error, when I launched the application with the Terminal, the executable and the data base were at the same place whereas with XCode there were no data base at the place of the executable. The application thus created a data base with the name which I passed in parameter but this DB

[sqlite] Saving "Unsigned Long"s in database

Hi all: I need to make an IP database. They will be stored like "unsigned long" variables, so, their size will be 4 bytes. The IP will be stored in the "domain" field. The "field type" of domain is NUMERIC. I save the data from a C program. This is part of the code: (Note that

Re: [sqlite] update statements inside select...case inside triggers

> CREATE TRIGGER trigger_name AFTER UPDATE ON table > BEGIN > SELECT CASE > WHEN a_condition THEN > UPDATE another_table SET a_field=a_value WHERE yet_another_condition > WHEN another_conditon THEN > UPDATE another_table SET a_field=another_value WHERE >

[sqlite] Multi-thread support

Hi all, Can anybody tell me how to handle concurrent write using sqlite3 database ? Does sqlite3 use table level locking ? Regards, Roushan

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

On Tue, Jul 12, 2005 at 01:26:19PM +0530, Siddharth Vijayakrishnan wrote: > On 7/11/05, Henry Miller <[EMAIL PROTECTED]> wrote: > > For full text search I find the lucene/clucene > > http://lucene.apache.org/ > > http://sourceforge.net/projects/clucene/ > > > > to be good solutions. The

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

On 7/11/05, Henry Miller <[EMAIL PROTECTED]> wrote: > For full text search I find the lucene/clucene > http://lucene.apache.org/ > http://sourceforge.net/projects/clucene/ > > to be good solutions. The licenses isn't quite as easy as sqlite, but > they should be good enough for everyone.

Re: [sqlite] beginnings with sqlite

Hello, Thanks for replied ! I am sure that XCode loads the good name of the DB. I tried with another name for my DB and with XCode I have the same problem. With the Terminal, when I try with the name without extention I receive the error message but a file with the name of the DB without

Fwd: [sqlite] beginnings with sqlite

Hi all, no ideas for my problem ? Please, help me ;-) . Regards, Denis Lurkin.