Thanks, Simon, Trey, and Dan, this is really helpful and has got me
back on track. -CM
On 9/2/07, Trey Mack <[EMAIL PROTECTED]> wrote:
>
> > I want to have queries that will match dates but not care about times.
> > The date might be today, anything within the last week, month, year,
> > or a
Hi,
Does sqlite offer the ability to connect to a sqlite db file on a
remote machine? I've been using it locally for awhile and it's great.
Wanted to see if it could be used remotely for some simple tasks.
Thanks,
Mark
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> In 3.5, cache can be shared between
> all threads, but shared cache is still disabled by default. You have to
> invoke sqlite3_enable_shared_cache() to turn it on. I put a comment in
> the documentation that we might turn shared cache on by
> In our tests, the overhead of mutexing is not negligible. It slows
> down the
> database by about 8%. Nevertheless, we recognize that many people want
> to run multiple threads (despite my heartfelt pleas to abstain from
> that dreadful
> practice) so we probably will make the prebuilt
On 3/09/2007 1:00 AM, RaghavendraK 70574 wrote:
Hi,
create table test (column text);
Please try pasting in SQL that actually runs. "column" is a reserved word.
create index idx on text(column);[IN uses index]
Please try pasting in SQL that actually runs. You need "test", not
"text". Use
Sharing cache is a great feature and thankyou for shedding the sweat
necessary to implement it. I do have a suggestion for V3.5. How about
changing the name to Sqnotsolite?
D. Richard Hipp wrote:
On Sep 2, 2007, at 11:40 AM, Joe Wilson wrote:
In sqlite 3.5 they've changed the design to
On Sep 2, 2007, at 1:13 PM, Miguel Fuentes wrote:
I didn't know .lib were much larger =\
I always use .a files, so my bad
I just linked it into my exe and got a final 420kb exe.
See also http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite
D. Richard Hipp
[EMAIL PROTECTED]
I didn't know .lib were much larger =\
I always use .a files, so my bad
I just linked it into my exe and got a final 420kb exe.
Thanks for the info =)
On 9/2/07, Cory Nelson <[EMAIL PROTECTED]> wrote:
>
> .lib files are generally always much larger than the machine code you
> get when you
On Sep 2, 2007, at 11:40 AM, Joe Wilson wrote:
In sqlite 3.5 they've changed the design to share a single file
descriptor
for all connections to the same database. Also, connections to the
same
database in 3.5+ will share the same database page cache resulting
in less
overall memory
On Sep 2, 2007, at 10:18 AM, Christian Smith wrote:
Is it not worth simply making the library threadsafe by default?
There is basically no platform supported today that doesn't have
some form of thread abstraction, the overhead of mutex locking is
probably negligible,
See ticket
On 9/2/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
> select * from test where column in
> ('98451234','9845123','984512','98451',
> '9845','984','98','9','-1') limit 1;
>
> even when limit 1 is provided it continues to search.
Continues to search in what way? What exactly are you looking
On Sun, 2007-09-02 at 11:13 -0400, Trey Mack wrote:
> > I want to have queries that will match dates but not care about times.
> > The date might be today, anything within the last week, month, year,
> > or a range of dates. I'm using Python's datetime function, so the
> > dates enter the
--- Aviad Harell <[EMAIL PROTECTED]> wrote:
> Regarding only to select statements, is there a known limit of number of
> concurrent connections to Sqlite DB?
>
> What about concurrent connections to the same table in the sqlite DB?
In sqlite 3.4.2 and earlier, each connection - even to the same
I want to have queries that will match dates but not care about times.
The date might be today, anything within the last week, month, year,
or a range of dates. I'm using Python's datetime function, so the
dates enter the database in this format 2007-09-01 12:00:02.
So far, < or > queries seem
Hi,
create table test (column text);
create index idx on text(column);[IN uses index]
insert into test values ('9');
insert into test values ('98');
insert into test values ('985');
My Query: see if u have any record
98451234 which has a similar pattern.
select * from test where column in
Once you get your first row back (corresponding to (a==1), simply halt
there and sqlite3_finalize() or sqlite3_reset the statement. You control
the execution and how many rows you want back.
RaghavendraK 70574 uttered:
Hi,
Ok.
Is there any way to tell the VDBE to stop execution moment it
[EMAIL PROTECTED] uttered:
[EMAIL PROTECTED] wrote:
Ken <[EMAIL PROTECTED]> wrote:
Recompiled with:
gcc -DSQLITE_THREADSAFE -I. -I../src
^^^
Should be -DSQLITE_THREADSAFE=1
The =1 is important in this case.
This problem will likely come up again. To try and work
Hi,
Ok.
Is there any way to tell the VDBE to stop execution moment it gets a record
from the IN list rather than continue to query for all the parameters?
I mean can it work like the C if clause
a = 1;
b = 100;
if( a == 1 or b == 10)
{
}
in the above case a is evauated but not b. Is this
On 02/09/07, C M <[EMAIL PROTECTED]> wrote:
> Hi, I'm very new to SQLite, and I'm using it with Python.
>
> I want to have queries that will match dates but not care about times.
.
.
.
Hi,
If your dates are stored in julian day (real) format, then the
fractional part will indicate the time of
Hi,
Regarding only to select statements, is there a known limit of number of
concurrent connections to Sqlite DB?
What about concurrent connections to the same table in the sqlite DB?
Regards,
Aviad
Scott Hess wrote:
>Unfortunately, the reason fts2 couldn't be "fixed" was because you
>can't perform the necessary ALTER TABLE if the column you're adding is
>a primary key.
Sure, I was aware of this problem.
>Since the only alternative would be to build a new
>table and copy everything over,
.lib files are generally always much larger than the machine code you
get when you finally link it into an exe. what is the problem here?
On 9/2/07, Miguel Fuentes <[EMAIL PROTECTED]> wrote:
> Hi everyone,
> I just managed to compile Sqlite 3.4.2 under VC++(Visual C++ 2005 Express
> Edition, the
Hi everyone,
I just managed to compile Sqlite 3.4.2 under VC++(Visual C++ 2005 Express
Edition, the free one). My problem is that I've been trying to shrink the
size of the .lib file generated with no luck.
Currently the size of my .lib file is 1445kb with the compile options /O1
/Os /Oy and no
Hi, I'm very new to SQLite, and I'm using it with Python.
I want to have queries that will match dates but not care about times.
The date might be today, anything within the last week, month, year,
or a range of dates. I'm using Python's datetime function, so the
dates enter the database in this
24 matches
Mail list logo
