Re: [sqlite] Lemon parser

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

Re: [sqlite] SQLite on Windows 2003

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

Re: [sqlite] SQLite on Windows 2003

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

Re: [sqlite] SQLite on Windows 2003

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

Re: [sqlite] Lemon parser

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'

Re: [sqlite] Lemon parser

> 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

Re: [sqlite] ?bug causing sigsegv

> 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

Re: [sqlite] SQLite on Windows 2003

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

[sqlite] Lemon parser

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

Re: [sqlite] ?bug causing sigsegv

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

Re: [sqlite] SQLite on Windows 2003

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

[sqlite] SQLite on Windows 2003

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

Re: [sqlite] SQLite template files

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,

Re: [sqlite] SQLite template files

> 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

Re: [sqlite] Exposing sqlite3BtreeCommitPhaseOne

> 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

Re: [sqlite] sqlite3_reset nor sqlite3_clear_bindings are clearing the auxdata when using sqlite3_set_auxdata

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

Re: [sqlite] Concurrency for in-memory scenarios

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

Re: [sqlite] Concurrency for in-memory scenarios

> 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

[sqlite] Exposing sqlite3BtreeCommitPhaseOne

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

Re: [sqlite] SQLite template files

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.

Re: [sqlite] SQLite template files

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

[sqlite] sqlite3_reset nor sqlite3_clear_bindings are clearing the auxdata when using sqlite3_set_auxdata

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

[sqlite] Concurrency for in-memory scenarios

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

Re: [sqlite] SQLite template files

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

Re: [sqlite] Android database corruption

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 >>

Re: [sqlite] Android database corruption

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

Re: [sqlite] paging with limit and offset

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

[sqlite] paging with limit and offset

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,

Re: [sqlite] Feature request: hash index

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