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
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
.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 free
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, it
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
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 day.
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
[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
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
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
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 to
--- 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
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 database in
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 at?
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 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
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 finally
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]
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 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 -- for
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 libraries
--- 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 default in
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
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 range of
24 matches
Mail list logo