Re: [sqlite] Quick FTS3 question: partial matches

2008-10-09 Thread Jonathon
Thanks for the reply. I was just curious if anyone has found a viable workaround for this issue? Using the dreaded "Like" is a bit too slow for what I need. Jon On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: > > I would like to look up partial strings across

Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15

2008-10-09 Thread D. Richard Hipp
On Oct 9, 2008, at 9:11 PM, dcharno wrote: >> If you have issues or concerns with any aspect of the upcoming >> release, now would be a good time to raise them. > > Is there any way to have both the BNF and syntax diagrams in the SQL > Syntax? Not really. Explain to me again why you want

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread Ken
Sure post it data and the website for download. I'd like to see if it's reproducible on other systems. Thanks, Ken --- On Thu, 10/9/08, James Pringle <[EMAIL PROTECTED]> wrote: > From: James Pringle <[EMAIL PROTECTED]> > Subject: Re: [sqlite] Adding index to table makes SELECT much slower.

[sqlite] Quick FTS3 question: partial matches

2008-10-09 Thread Jonathon
Hello all, I've looked through the archived mailing list and although I am sure my question is common, for some reason, I couldn't find an answer. I would like to look up partial strings across several columns using FTS3 and MATCH. For example, if I have a column that has data,

Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15

2008-10-09 Thread dcharno
> If you have issues or concerns with any aspect of the upcoming > release, now would be a good time to raise them. Is there any way to have both the BNF and syntax diagrams in the SQL Syntax? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] assert() in sqlite3_initialize() when SQLITE_DEBUG is defined

2008-10-09 Thread D. Richard Hipp
On Oct 9, 2008, at 7:42 PM, Dave Toll wrote: > > I noticed that similar tests elsewhere in the code check that the size > of u64 is either 8 or 4. I'm building SQLite 3.6.3 with the following > defines: -DSQLITE_INT64_TYPE=long -DSQLITE_32BIT_ROWID=1 There are various #defines such as the above

Re: [sqlite] Sqlite3 command line Up Arrow Not Working

2008-10-09 Thread Mark Easton
I see that others have had this probkem in the past: Ie http://www.mail-archive.com/[EMAIL PROTECTED]/msg03398.html > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, October 10, 2008 11:27 AM > To: [EMAIL PROTECTED]; General Discussion of SQLite

Re: [sqlite] Sqlite3 command line Up Arrow Not Working

2008-10-09 Thread Mark Easton
Ok, will take a look at that - but I just used the standard makefile that came with sqlite3 when I built it. Why would it not be linked in? My old version of sqlite3 worked fine. Did it also use readline or is readline something new for sqlite3? I see that readline is standard on most GNU/Linux

[sqlite] assert() in sqlite3_initialize() when SQLITE_DEBUG is defined

2008-10-09 Thread Dave Toll
Hello list I'd like to define SQLITE_DEBUG to help trace some problems I am seeing, but this causes sqlite3_initialize() to assert on a 32-bit system. Does SQLite support 32-bit systems? /* The following is just a sanity check to make sure SQLite has ** been compiled correctly. It is

Re: [sqlite] Sqlite3 command line Up Arrow Not Working

2008-10-09 Thread John Stanton
Looks like you do not have readline linked into sqlite3. Mark Easton wrote: > Hi everyone, > > Since I have installed the new version of sqlite3, I have found that when I > am in command line (sqlite3) I can no longer use up arrow to search through > my command history. > > An up arrow just

Re: [sqlite] concurrent users?

2008-10-09 Thread John Stanton
Sqlite works well as the DBMS core of a WWW server. It is not a competitor for Oracle. DB2 or PostGreSQL but can support a large number of users and has the advantage of being embedded. It is not a good idea to use it for a large number of concurrent long queries. Sqlite works best with

[sqlite] malloc.c compile error on Fedora 9

2008-10-09 Thread Robert L Cochran
While attempting to compile sqlite 3.6.3 on a Fedora 9 system which was freshly built (the system is based on the 20081004 Fedora Unity respin), I got this error in malloc.c. Can anyone suggest a fix? I'm wondering if I forgot to install a needed RPM package? I installed the "software development"

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread [EMAIL PROTECTED]
SELECT lat, lon, depth FROM hydro WHERE depth>= 49.01 AND depth <=50.99; The SELECT may be faster still if you use this index instead: CREATE INDEX hydro_indx2 ON hydro (depth, lat, lon); as the query can find all the information in the index without hitting the pages of the main

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Wilson, Ron P
I think it would be cool to use System.Data.SQLite with powershell; I'm waiting until you figure it out before I try it. I don't have a compelling reason to try it myself yet, but the neato factor has me paying attention. Some of the readers seem to think you should ask these questions

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread HLachmann
> access ... dll from PowerShell ... PowerShell docs the procedure given there is to register the dll with installutil. When I first ran it, it looks ok. As I rerun it during my efforts I got an error: No public installers with the RunInstallerAttribute.Yes attribute could be found in the

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Brad Stiles
> The original problem is given in the topic. > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. You mentioned the System.Data.SQLite provider in every message you posted, and presented it in such a way that I interpreted you to have asked

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread HLachmann
I have no idea of unix shell scripts. Is there a startup guide? But it's hard to imagine to use a cmdline-tool in an object-orientated manner. @Jeffrey: which steps have you performed before your LoadWithPartialName succeeds? Original-Nachricht > Datum: Thu, 9 Oct 2008

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
Technically there's nothing stopping you from using sqlite3.exe in the same way you'd use it in a unix shell script. On Thu, Oct 9, 2008 at 2:54 PM, Helga Lachmann <[EMAIL PROTECTED]> wrote: > The original problem is given in the topic. > The System.Data.SQLite provider (which I currently can't

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Helga Lachmann
The original problem is given in the topic. The System.Data.SQLite provider (which I currently can't get running) is hopefully only one solution. Do you have an answer to the original question? SQLite provides sqlite3.exe and sqlite3.dll. How can I use that with powershell?

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Brad Stiles
> btw: if I rerun InstallUtil I now get a message: > No public installers with the RunInstallerAttribute.Yes attribute could be > found in the ...\System.Data.SQLite.dll assembly. You should really be asking these questions on the forum/list dedicated to the support of the product you are

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread HLachmann
If I run it I get... nothing So I would like to know which steps you have done before. btw: if I rerun InstallUtil I now get a message: No public installers with the RunInstallerAttribute.Yes attribute could be found in the ...\System.Data.SQLite.dll assembly. Original-Nachricht

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
As for the code being 'bad' I saw a lot of blog posts that said it caused problems but very few that had reasonable replacements. There was one post that gave a hundred lines or so of code to do the same thing. On Thu, Oct 9, 2008 at 11:25 AM, <[EMAIL PROTECTED]> wrote: > if that is "bad" how

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
When I run the LoadWithPartialName I get: GACVersionLocation ------ True v2.0.50727 C:\WINDOWS\assembly\GAC_32\System.Data.SQLite\1.0.60.0__db937bc2d44ff139\System.Data.SQLite.dll printed on my console. Does this happen for you? If not that would lead me

[sqlite] ATTACH problem

2008-10-09 Thread rrrado2
Ok it seems last time I've posted too many errors so I'll try to ask about this one. Maybe other are just consequences of this. I've finally received this error also on my computer, but only in release build. - windows XP, sqlite 3.6.3, VS 2005 - sqlite3_threadsafe() -> 1 - 20 worker threads,

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread James Pringle
Hi all- Thanks for your many suggestions. I have tried many of your suggestions, and found the following: 1. If I create the database with depth ordered from least to greatest, and then create an index, the searches run an order of magnitude faster than without an index. I.e. the

Re: [sqlite] Why is the VDBE testing for NULL?

2008-10-09 Thread D. Richard Hipp
On Oct 9, 2008, at 11:46 AM, Ken wrote: > DRH, > I noticed that the VDBE is doing a check for null Can this be removed? > > test script to show output: > create table t (id integer not null, id2 integer); > create index t_idx on t (id); > explain select id from t where id = 5; > > >

[sqlite] Why is the VDBE testing for NULL?

2008-10-09 Thread Ken
DRH, I noticed that the VDBE is doing a check for null Can this be removed? test script to show output: create table t (id integer not null, id2 integer); create index  t_idx on t (id); explain select id from t where id = 5; 0|Trace|0|0|0|explain select id from t where id = 5;|00|

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread Ken
Id suggest running a  explain query plan  SELECT lat, lon, depth FROM hydro WHERE depth>= 49.01 AND depth  <= 50.99 ; Both with and without the index. That will give you an idea of what is going on. Maybe watch the IO statistics while running with and without the index as well and see if it

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread HLachmann
if that is "bad" how can it be done correct/better? [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite") itself produces no error, but also [System.Reflection.Assembly]::LoadWithPartialName("thisDoesntMatter") produces no error, but the following $conn = New-Object

[sqlite] sqlite3_open() problem for ARM

2008-10-09 Thread Leandro Ribeiro
Hello Guys. I have a problem with running SQLite. I am running linux 2.6.17 on *ARM* and basically problem is that my application is crushing on *sqlite3_open*() function while the sqlite3 command shell is running without problems. I added the sqlite3.h file to my project. /**/

[sqlite] SQLite version 3.6.4 planned for 2008-10-15

2008-10-09 Thread D. Richard Hipp
We are planning to release SQLite version 3.6.4 at approximately 2008-10-15 12:00:00 UTC. Additional information can be found on the draft website: http://www.sqlite.org/draft/index.html If you have issues or concerns with any aspect of the upcoming release, now would be a good time

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
Oh I see. System.Data.SQLite doesn't provide a Snap-in so Add-PSSnapin wont work. You could use: [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite") But from what I see this method is considered 'bad' because this could lead to versioning issues. Since the System.Data.Common

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Helga Lachmann
I don't know. How should I do this? I think that's the point. As I mentioned I tried manually with Add-PSSnapin, but that doesn't work. (... PowerShell-Snap-In "System.Data.SQLite" is not installed ...) Original-Nachricht > Datum: Thu, 9 Oct 2008 10:03:07 -0400 > Von:

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
IIRC powershell doesnt automatically load every assembly in the GAC. How are you loading the System.Data.SQLite assembly? On Thu, Oct 9, 2008 at 8:51 AM, <[EMAIL PROTECTED]> wrote: > Hello, > > I looked unavailingly around for hours to get SQLite and Powershell working > together. > > Is there

[sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread HLachmann
Hello, I looked unavailingly around for hours to get SQLite and Powershell working together. Is there any little installation/configuration guide for this? The problem seems to be how to get SQLite available to PS. I used installutil, which reported "successful". AddPSSnapin failed with

Re: [sqlite] END TRANSACTION failed with "database is locked"

2008-10-09 Thread Manoj M
Hi, Thanks for your replies. Actually I have only one thread writing to the table and there can be 'n' number of threads reading the table. I am not yet found why this "database locked" error came in my application. Since the database is locked even "End TRANSACTION" also won't help, right? I

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread Konrad J Hambrick
On 10/08/2008 05:50 PM, James Pringle wrote: > Hi- > > I am new to sqlite, and am having a puzzling problem. I have read > that adding an INDEX to a sqlite table can never make a SELECT > statement slower. However, in my case, it seems to be making the > select statement an order of

[sqlite] sqlite3_step and column name

2008-10-09 Thread Shaun R.
I'm trying to understand a bit how this works. For my example i just simply want to set a column value to a char. If i know the name of the column how can id o this. For example the column name i want is 'fname'. I know the section below with setting myname and then printing it doesnt

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread Daniel Önnerby
Have you tried running VACUUM and ANAYZE on the indexed table? Not that I think it will matter, but who knows :) Daniel James Pringle wrote: > Hi- > > I am new to sqlite, and am having a puzzling problem. I have read > that adding an INDEX to a sqlite table can never make a SELECT >

Re: [sqlite] visual basic and sqlite

2008-10-09 Thread Gilles Ganault
On Thu, 9 Oct 2008 18:05:25 +0800, "Raziedahanin KASIM" <[EMAIL PROTECTED]> wrote: >I want to develop a simple application using VB 6.0 and sqlite Where should >i start? www.sqlite.org/cvstrac/wiki?p=SqliteWrappers ___ sqlite-users mailing list

[sqlite] visual basic and sqlite

2008-10-09 Thread Raziedahanin KASIM
I want to develop a simple application using VB 6.0 and sqlite Where should i start? I want to craete a embedded database into this small application. Anyone can advice and guide me. Thank you in advance -- Hanni ONYX Enterprise Sdn Bhd ___

[sqlite] Performance - SQLite ODBC against SQLite C API on SLES10

2008-10-09 Thread Darko Filipovic
Hello, I'm doing some performance tests comparing SQLite ODBC and SQLite C API (both 3.5.2 version) on SLES10 (64bit). I'm inserting 1000 rows into 4 columns table (int, int64, double, int64) out of transaction and I'm getting much lower performance using SQLite API (about 10 seconds

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

2008-10-09 Thread [EMAIL PROTECTED]
When used with the index, the query may be producing too many random (slow) disk seeks into your 2GB+ database table. Increasing the page cache substantially may help. But if the rows of the main table were accessed in order it might also reduce the number of page seeks. Out of curiosity,