Hello!
The problem is only with virtual tables. With ordinary tables "IN (...)" work
fine:
sqlite> explain query plan select count(*) from data_content where rowid in (1);
0|0|TABLE data_content USING PRIMARY KEY
CPU Time: user 0.004000 sys 0.00
sqlite> select count(*) from data_content
Hi,
I'd like to use a query like "select * from table limit 0,10" but I also need
the number of rows that would have been returned without a limit/offset being
in the query.
I tried select count( *),* from table but that only returns 1 row.
Thanks,
You can do this only by issuing 2 different queries - one with
count(*) and another selecting first 10 rows.
Pavel
On Tue, Apr 6, 2010 at 8:39 AM, David Hamm wrote:
> Hi,
>
> I'd like to use a query like "select * from table limit 0,10" but I also need
> the number of rows
cliff 2 wrote:
>
>
> Thanks very much for the quick response! Unfortunately, the android
> SQLiteDatabase class deletes the database when it hits this, so it doesn't
> give me a chance to do that. However I do have a channel to the android db
> developers, so I will forward this onto them, and
On Apr 6, 2010, at 9:15 AM, cliff 2 wrote:
>
>
> cliff 2 wrote:
>>
>>
>> Thanks very much for the quick response! Unfortunately, the android
>> SQLiteDatabase class deletes the database when it hits this, so it
>> doesn't
>> give me a chance to do that. However I do have a channel to the
>>
Thanks to those who replied on this topic, but no-one offered any repository of
SQLite template files. Does that mean there aren't any available?
Thanks,
Tom
BareFeet
From: BareFeet
Date: 27 March 2010 5:58:32 PM AEDT
To: General Discussion of SQLite Database
Hi there,
I've recently been struggling with concurrency for an in-memory
SQLite scenario. Basically, I want to be able to perform concurrent
reads against an in-memory SQLite database, thus using multiple CPUs
to good effect.
I've tried everything I could think of and find in various
Hi there,
When we use our custom SQLite function function_sparql_regex (lower in
this E-mail) together with bound values for the argvs of the function,
then sqlite3_reset nor sqlite3_clear_bindings are clearning the auxdata.
This makes it impossible to pass the regex as a sqlite3_bind_text (the
On 6 Apr 2010, at 10:49am, BareFeet wrote:
> Thanks to those who replied on this topic, but no-one offered any repository
> of SQLite template files. Does that mean there aren't any available?
I believe that by 'template files' you mean some example databases for common
applications, for
On Tue, 6 Apr 2010, BareFeet wrote:
> Thanks to those who replied on this topic, but no-one offered any
> repository of SQLite template files. Does that mean there aren't any
> available?
Tom,
That's because what you seek does not exist. User interfaces are separate
from the rdbms back end.
Hello,
I'm looking for a way to force sqlite to do its internal "phase one
commit", which apparently flushes dirty pages to disk without committing
the journal. This way I can minimize the time spent in the "phase two
commit", which is the point at which the journal is unlinked and the
> Can anyone confirm whether concurrent
> access to an in-memory database is supported?
No, SQLite doesn't support full concurrent access to any database. The
only concurrency you can earn is having on-disk database without
shared cache (so actually having several copies of the database in
BTW, beware of this thread
http://www.mail-archive.com/sqlite-users@sqlite.org/msg50640.html too,
although it wasn't understood what was the actual problem there.
Pavel
On Tue, Apr 6, 2010 at 11:03 AM, Pavel Ivanov wrote:
>> Can anyone confirm whether concurrent
>> access
Philip Van Hoof wrote:
> When we use our custom SQLite function function_sparql_regex (lower in
> this E-mail) together with bound values for the argvs of the function,
> then sqlite3_reset nor sqlite3_clear_bindings are clearning the
> auxdata.
>
> This makes it impossible to
> Currently if an interrupt
> arrives during a long commit I have no way to know whether the commit
> was successful, and thus whether to commit or roll back the filesystem
> journal.
Maybe you can read the database to see if the new data
is there in this scenario.
> If I could flush the dirty
> I believe that by 'template files' you mean some example databases for common
> applications, for instance invoicing, a list of the albums you have, a recipe
> database, etc..
Yes, that is correct.
> That's because what you seek does not exist.
Well, it does exist if people share their
On 6 Apr 2010, at 5:50pm, BareFeet wrote:
> If the logic is built into the SQL itself, then the other development
> language is not an issue. I can open my SQLite database files in a GUI tool
> written in Objective-C or the command line tool written in C, or a PHP front
> end to a web page,
Hi All.,
I have a SQLite application running just fine on Windows XP SP3. I am
attempting to move the application to Windows 2003
Enterprise Edition. However, the connection open method returns null.
The connection string is good. The database file is there.
I have the appropriate permissions on
On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:
> I have a SQLite application running just fine on Windows XP SP3. I am
> attempting to move the application to Windows 2003
> Enterprise Edition. However, the connection open method returns null.
> The connection string is good. The database file is
On 05/04/2010 22:04, Pavel Ivanov wrote:
Thank you for reply.
> Looking at this output from gdb:
>
>
>> #0 0x in ?? ()
>> #1 0x08058f8e in sqlite3_mutex_enter (p=0x90d98c0) at
>> 3rdparty/sqlite3/sqlite3.c:14549
>>
> I can say that you don't have any mutex module installed
Hey guys,
I'm using the Lemon parser and running into a methodological problem that I
wanted to ask the user base about. Is there a mailing list or forum
specifically for Lemon, or is this it? :)
Thanks,
-Chris
___
sqlite-users mailing list
Hi Simon,
Yes, I was able to open the DB file using the command line tool.
I am unable to do so programmatically using C# .NET 2008.
Thanks,
Joe
Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.0481
> I did consider this as the issue. However tracing through with gdb the
> sqlite3 "handle" (ie sqlite3*) is the same memory location from Qt calls
> and the returned handle from
Sure thing, it will be the same because you requested pointer from
inside Qt. But it's not a static object which I
> I'm using the Lemon parser and running into a methodological problem
that
> I
> wanted to ask the user base about. Is there a mailing list or forum
> specifically for Lemon, or is this it? :)
>
> Thanks,
> -Chris
There is no mailing list specifically for lemon. Some of us are
familiar to
Hehe, okay, here I go. :)
I'm trying to replace an existing flex/bison parser with an re2c/lemon
parser, but I'm running into a methodological problem. I have a
hypothetical grammar like this:
file ::= FOO str .
file ::= BAR str .
Where my keywords are FOO and BAR, and str is any ol'
Hello Joe,
UTF8? What's the filename? If it has any accent characters, you need
to convert the filename to UTF8 before you pass the filename to the
SQLite. At least in C++ you do.
C
Tuesday, April 6, 2010, 4:03:24 PM, you wrote:
BJ> Hi Simon,
BJ> Yes, I was able to open the DB file using the
Hi Teg,
UTF-8, no special characters in the file name WorkData.s3db.
Thanks,
Joe
Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.0481
-Original Message-
From: sqlite-users-boun...@sqlite.org
On 6 Apr 2010, at 9:03pm, Burnett, Joe wrote:
> Yes, I was able to open the DB file using the command line tool.
> I am unable to do so programmatically using C# .NET 2008.
Okay, there are some other steps in this test.
Rename that database file or move it somewhere safe.
Use the sqlite3
On Apr 7, 2010, at 3:23 AM, Chris verBurg wrote:
> Hehe, okay, here I go. :)
>
>
> I'm trying to replace an existing flex/bison parser with an re2c/lemon
> parser, but I'm running into a methodological problem. I have a
> hypothetical grammar like this:
>
> file ::= FOO str .
> file ::= BAR
29 matches
Mail list logo