Re: [sqlite] file system interface?

2008-07-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Dyer wrote: > While discussing possible sqlite applications today, it occurred to > me that you could present a sqlite database as a mountable file > system. That is relatively trivial to do using FUSE on systems that support it. > One of the

Re: [sqlite] file system interface?

2008-07-30 Thread Dave Dyer
While discussing possible sqlite applications today, it occurred to me that you could present a sqlite database as a mountable file system. Some BLOB objects would be presented as files, with attributes such as directory names and file dates stored as ancillary fields. One of the major impedimen

Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Shane Harrelson
would appreciate any confirmation that it works for you :) On 7/30/08, Jeremy Spiegel <[EMAIL PROTECTED]> wrote: > > Shane, > > Just saw the checkin for the fix. Thanks! > > :) Jeremy > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shane Harrelson

Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Jeremy Spiegel
Shane, Just saw the checkin for the fix. Thanks! :) Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shane Harrelson Sent: Wednesday, July 30, 2008 8:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] winDelete retry-on-failure

Re: [sqlite] Sqlite bug with aggregate counts query that excludes null values?

2008-07-30 Thread D. Richard Hipp
On Jul 30, 2008, at 7:14 PM, Tim Dao wrote: > I ran into strange behavior in dealing with Sqlite 3.5.9 on a 6 > million > record table I was using in development and wanted to see if I could > duplicate the error in an entirely separate instance so I tried it > from > Firefox 3.0 + SqliteMana

[sqlite] Sqlite bug with aggregate counts query that excludes null values?

2008-07-30 Thread Tim Dao
I ran into strange behavior in dealing with Sqlite 3.5.9 on a 6 million record table I was using in development and wanted to see if I could duplicate the error in an entirely separate instance so I tried it from Firefox 3.0 + SqliteManager Plugin much to the same effect. Basically when running a

[sqlite] Shared cache question

2008-07-30 Thread Robert Simpson
What should be the expected behavior of existing connections when sqlite3_enable_shared_cache() is enabled, and then another database is ATTACH'ed to the pre-cache-enabled connection? And further complicate things by saying that the attached database is using vtables and the original connection

Re: [sqlite] ANN: sqliteman 1.2.0

2008-07-30 Thread Alexey Pechnikov
Hello! В сообщении от Wednesday 30 July 2008 20:21:53 Christophe Leske написал(а): > Hi Petr, > > > I'm glad I can announce new stable version of Sqliteman - the GUI for > > developers and admins: > > http://sqliteman.com/ > > I gave it a try, and it seems as if SQLiteman can´t handle extensions >

Re: [sqlite] ANN: sqliteman 1.2.0

2008-07-30 Thread Christophe Leske
Hi Petr, > I'm glad I can announce new stable version of Sqliteman - the GUI for > developers and admins: > http://sqliteman.com/ > I gave it a try, and it seems as if SQLiteman can´t handle extensions for databases, is this right? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] h

Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Shane Harrelson
GetFileAttributes() returns INVALID_FILE_ATTRIBUTES with an error of ERROR_ACCESS_DENIED if the file is in a "pending delete" state. I'll update the retry logic in os_win.c in winDelete() to add this additional check. I believe that should improve the situation (as long as the other application

Re: [sqlite] SQLITE_CORE use for ??

2008-07-30 Thread Marco Bambini
Thanks a lot for the clarification. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jul 30, 2008, at 4:28 PM, D. Richard Hipp wrote: > > On Jul 30, 2008, at 10:22 AM, Marco Bambini wrote: > >> Can someone clarify this point please? >>

Re: [sqlite] ANN: sqliteman 1.2.0

2008-07-30 Thread John Stanton
I can access your home page but time out on the links. Petr Vanek wrote: > hello all sqlite users, > > I'm glad I can announce new stable version of Sqliteman - the GUI for > developers and admins: > http://sqliteman.com/ > > Sqliteman introduction: > http://sqliteman.com/index.php/page/2.html >

Re: [sqlite] SQLITE_CORE use for ??

2008-07-30 Thread D. Richard Hipp
On Jul 30, 2008, at 10:22 AM, Marco Bambini wrote: > Can someone clarify this point please? > I mean, if I want to compile sqlite in a way that it should be able to > load extensions, SQLITE_CORE could be defined or not? > Or if it doesn't matter, what is its role? > A developer using SQLite in

Re: [sqlite] SQLITE_CORE use for ??

2008-07-30 Thread Marco Bambini
Can someone clarify this point please? I mean, if I want to compile sqlite in a way that it should be able to load extensions, SQLITE_CORE could be defined or not? Or if it doesn't matter, what is its role? Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sq

Re: [sqlite] SQLITE_CORE use for ??

2008-07-30 Thread Mihai Limbasan
Kevin Tang wrote: Dear all, After I upgrade to SQLite 3.6.0, I found that I must add "SQLITE_CORE" in PreProcessor to build my program. What is the "SQLITE_CORE" use for?? Thanks, Kevin Tang. When defined, SQLITE_CORE prevents the redefinition of some API functions in sqlite3ext.h. From t

Re: [sqlite] About file name encoding under Linux

2008-07-30 Thread D. Richard Hipp
On Jul 30, 2008, at 6:54 AM, 宋浩 wrote: > I've got a problem here regarding file name encoding under Linux: > when you > say that file names feed to sqlite3_open() functions should be > encoded in > UTF-8, do you really mean that? > > I mean, as far as I can tell, under Linux, the file name su

[sqlite] SQLITE_CORE use for ??

2008-07-30 Thread Kevin Tang
Dear all, After I upgrade to SQLite 3.6.0, I found that I must add "SQLITE_CORE" in PreProcessor to build my program. What is the "SQLITE_CORE" use for?? Thanks, Kevin Tang. -- Kevin Tang. - CEO秘笈: http://superceo.blogspot.com/ 職青區Blo

Re: [sqlite] Convert the CURRENT_TIMESTAMP

2008-07-30 Thread Chris Wedgwood
On Tue, Jul 29, 2008 at 02:03:01PM -0700, Joanne Pham wrote: > I still have the problem to set the result of the below statement to > variable so I can print out mulitple times without the executing the > select statement over and over again. create a view? >  select '#device local time = ' || >

Re: [sqlite] About file name encoding under Linux

2008-07-30 Thread Igor Tandetnik
"??" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've got a problem here regarding file name encoding under Linux: > when you say that file names feed to sqlite3_open() functions should > be encoded in UTF-8, do you really mean that? > > So if I convert the file name from current

[sqlite] OS X precompiled command line binary

2008-07-30 Thread Tim Streater
The precompiled binary of the command line program for OS X appears not to have been built with a readline library. Is there any particular reason for this? (the version supplied with OS X Leopard (3.4.0), is so complied. Thanks, -- Tim ___ sqlite-us

[sqlite] About file name encoding under Linux

2008-07-30 Thread 宋浩
I've got a problem here regarding file name encoding under Linux: when you say that file names feed to sqlite3_open() functions should be encoded in UTF-8, do you really mean that? I mean, as far as I can tell, under Linux, the file name submitted to program by the user should be the one directly

[sqlite] ANN: sqliteman 1.2.0

2008-07-30 Thread Petr Vanek
hello all sqlite users, I'm glad I can announce new stable version of Sqliteman - the GUI for developers and admins: http://sqliteman.com/ Sqliteman introduction: http://sqliteman.com/index.php/page/2.html Your oppinions and suggestions are welcomed. all the best Petr Vanek P.S.: the full anno