Re: [sqlite] Quick FTS3 question: partial matches

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 seve

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

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 BNF

Re: [sqlite] Quick FTS3 question: partial matches

> 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, > 'helloThisIsATest'... and I do: > > select * from myTable where myTable match '*This*'; You can only use wildcards as a suffix - this is due to the nature of

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

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

[sqlite] Quick FTS3 question: partial matches

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, 'helloThisIsATes

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

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

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

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

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 Database

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

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 s

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

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 i

Re: [sqlite] howto setup SQLite with Powershell ?

It's very possible you're the first one. How about adapting something like this: http://theessentialexchange.com/blogs/michael/archive/2008/01/07/multi-p latform-database-access-with-powershell.aspx Even closer to what you want: http://mcmanus.typepad.com/grind/2007/09/data-driven-asp.html Goog

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

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 pro

Re: [sqlite] concurrent users?

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 shor

[sqlite] malloc.c compile error on Fedora 9

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?

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

Re: [sqlite] howto setup SQLite with Powershell ?

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 elsewhe

Re: [sqlite] howto setup SQLite with Powershell ?

> 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 ...\Sy

Re: [sqlite] howto setup SQLite with Powershell ?

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

Re: [sqlite] howto setup SQLite with Powershell ?

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 15:06:41

Re: [sqlite] howto setup SQLite with Powershell ?

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 ge

Re: [sqlite] howto setup SQLite with Powershell ?

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? Original-Na

Re: [sqlite] howto setup SQLite with Powershell ?

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

Re: [sqlite] howto setup SQLite with Powershell ?

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 ?

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 ca

Re: [sqlite] howto setup SQLite with Powershell ?

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 to

[sqlite] ATTACH problem

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

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

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 s

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

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; > > > 0|Trace|0|0|

[sqlite] Why is the VDBE testing for NULL?

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| 1|Integer|5|1

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

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 d

Re: [sqlite] howto setup SQLite with Powershell ?

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

[sqlite] sqlite3_open() problem for ARM

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

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 to

Re: [sqlite] howto setup SQLite with Powershell ?

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 ?

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: "Jeffrey

Re: [sqlite] howto setup SQLite with Powershell ?

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 a

[sqlite] howto setup SQLite with Powershell ?

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 error

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

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 wi

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

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 magnitude

[sqlite] sqlite3_step and column name

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 really

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

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

Re: [sqlite] visual basic and sqlite

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

[sqlite] visual basic and sqlite

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

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

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

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

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