[sqlite] Problem with Read/Write concurency

true and I have only One writer how can I get busy? Without the command line doing selects, the writes never fail. Thanks Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

an of worms :) I don't wish to cause controversy here, but could you explain exactly what you mean by this? What is there about this tool that is problematic? TIA and rgs, Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-user

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

> Thanks. I was prepared to receive alternate suggestions :) > I wanted to have hands on and control over a browser with which > can follow sqlite versions quicker. If you want something that works on Linux as well as Windows, try the Firefox SQLite extension - it's the dog&#x

Re: [sqlite] Proper way to escape table name and column name

small table as well" Or, what you can also do is use table names such as no_special_chars and/or do_not_distinguish_between_caps_and_lower_case_in_designing_system ? Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users maili

[sqlite] Testing for a null string

I am sure tihs is basic but. I have a database with a text column and i want to return all rows where the column has no value I have tried select * from db where f = NULL select * from db where f = "" select * from db where f = '' all return 0 records when I knopw that most fields are empty -

[sqlite] fts virtual table questions

I didn't get an answer to my earlier question on fts. I guess it's difficult area. Should an fts virtual table always be re-created from scratch when the database is opened by the application before you start using fts commands? I see that the fts tables are not deleted when the database is closed

[sqlite] Can you add rows to fts virtual table?

Some basic questions: I have been creating the fts virtual table at the start of my program like this: CREATE VIRTUAL TABLE ItemFts USING FTS3(ItemId, ItemName, Description); INSERT INTO ItemFts (ItemId, ItemName, Description) SELECT ItemId, ItemName, Description FROM Item"; As rows are added t

[sqlite] Compound primary key problem

This is a mapping table or descriptor table or whatever you want to call it, between 2 tables (about 120,000 rows). I'm finding that operations are very slow (delete, select, etc.) even within transactions. Foreign keys = ON. I tried a different design with an integer primary key (which in this cas

Re: [sqlite] Best JDBC driver for SQLite?

problems, since all the SQLite team supplies is the source code for > the > function library. I'm doing this for my Java as much as anything else, so the platform must support that too, which is fine for Linux, *BSD and Windows. > If you need more details, ask more

Re: [sqlite] Best JDBC driver for SQLite?

; What platforms? Linux, FreeBSD, Solaris and Windows. > Do you want it to use JNI to an existing SQLite library or be > bundled with one? I don't know - what should I be doing? > Does documentation matter? Good to have - but not critical. Rgs, Paul... > Roger --

Re: [sqlite] Best JDBC driver for SQLite?

ed a single reply. Is this not the correct forum for such a question? Can anybody even see this post? TIA and rgs, Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Best JDBC driver for SQLite?

ages and disadvantages of the various offerings. Any advice, opinions, references, URL's, ideas and discussion much appreciated. Rgs, Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] :Re: sqlite3_bind_blob CHOPS off at first NULL char

_text will add a zero character and if your database uses UTF16 encoding will give you an interesting result. Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] :Re: sqlite3_bind_blob CHOPS off at first NULL char

On Sun, Apr 3, 2011 at 2:46 PM, Lynton Grice wrote: > char* from SQLite? You say that SELECT treats message as TEXT which is > fine, but then how can I get the FULL payload back into a char* so that > I can write it to a file? > > SELECT doesn't treat the BLOB as text, the command line client (and

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi Lynton, What is the value of msg.num_bytes_in? Is it fsize? And what do you get when you SELECT Length(raw_stream_in) FROM test ? Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Unique index versus unique constraint

> > Automatic indexes have no "SQL" entry in the SQLite_Master table, so you > can use that to see if you can drop it. eg: > > select Name from SQLite_Master where type = 'index' and SQL is null > > will give you the name of all the automatic indexes, which can't be > dropped. > Thanks Tom, It ac

[sqlite] Unique index versus unique constraint

like it has a "notnull" column, but only for unique constraints on single fields. Or if pragma index_list had a "constraint" (or "cantdrop" or something) column that would indicate that the index cannot be dropped. Am I missi

Re: [sqlite] Source code for system.data.sqlite

gt; System.Data.SQLite - probably something along the lines of > http://www.fossil-scm.org/fossil/doc/trunk/www/copyright-release.html > used for Fossil. > > You need to login to the Fossil site, even if only as "Anonymous", to > be able to add a ticket. > > -Shane >

[sqlite] Fwd: Fwd: Fwd: fts virtual table questions

My problem is the term "virtual" I guess. I think of virtual as in-memory only or something. Once they are created in a SQLite database they seem to be as real as the other tables. >> I had an API problem, and I now think that the virtual table does not need >> to be created each time. I can't fi

[sqlite] Source code for system.data.sqlite

Since sqlite has taken on system.data.sqlite for .net you will be seeing issues on this until a forum is set up for it. Please try to make sure the entire source tips are available for download. The last time I checked 1.0.68 (or ?) did not compile due to missing linq related files. Hopefully ther

[sqlite] Fwd: Fwd: fts virtual table questions

this issue. Original Message Subject: Fwd: fts virtual table questions Date: Mon, 28 Feb 2011 22:48:58 -0700 From: Paul Shaffer To: General Discussion of SQLite Database Edit: with doing a create virtual call --> without doing a create virtual call Original Message

[sqlite] Fwd: fts virtual table questions

Edit: with doing a create virtual call --> without doing a create virtual call Original Message Subject: fts virtual table questions Date: Mon, 28 Feb 2011 22:46:32 -0700 From: Paul Shaffer To: General Discussion of SQLite Database I am still testing my results and am new

[sqlite] fts virtual table questions

I am still testing my results and am new to fts. To use fts, is "create virtual table" required every time my program runs and opens the sqlite database? I see that the table (plus a few other related fts tables) is physically present in the database after my program closes. I would prefer to not

[sqlite] compile warning in tclsql 3.7.5

paul@paul-suse:~/build/TRUNK/external/build/sqlite-tea-3070500> make gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.7.5\" -DPACKAGE_STRING=\"sqlite\ 3.7.5\" -DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE

Re: [sqlite] forcing flush of journal

Thats what I thought, thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] forcing flush of journal

I have an sqlite database and an assocaiated .journal file that I need tolook at. I have estalished that there is data in the journal that seems relevant and want flush the journal (if that is the correct term) and to then view the tables with the updated data. Is there a way to do this? Thanks __

Re: [sqlite] Question

As said off topic - but I have never heard of a cell ID being recorded with an SMS message. You can find more info on the SMS message format by search for "sms pdu" (protocol description unit) you can see from this somewhat complex structure that the cell ID is not part of the transmitted message f

Re: [sqlite] Reducing time to create indexes

le to split the table into two with the main fields in one and all of the remainder (including the text fields) in the other. I'll have a play and see what I come up with On 25 November 2010 10:20, Max Vlasov wrote: > On Wed, Nov 24, 2010 at 1:13 AM, Paul Sanderson < > sanderson

Re: [sqlite] Reducing time to create indexes

Stuck with a 32 bit Windows set up as the lowest common so in memory is not feasible - I have seen some of my DB's in excess of 2GB - users might object even if I could nick that much memory ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] Reducing time to create indexes

Thanks All Simon, I'll try that and see what difference itmakes ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reducing time to create indexes

Unfortunately all of the columns are represented in a grid that users can choose to sort on any column, although they are less likely to sort on certain columns, if they do chose to do so then an excessive delay is not really acceptable. Currently I create ascending and descending indexes for each

[sqlite] Reducing time to create indexes

I have a table with over 1 million rows and 20+ columns all of which are indexed, I reasonably regularly recreate the table with new data and find that the indexing process takes about 30 minutes. Are there any settings/tweaks that I can use to reduce the time required to create the index? The col

Re: [sqlite] query help

Thank You. On 26 October 2010 13:14, Igor Tandetnik wrote: > Paul Sanderson wrote: >> I have two tables, table b is a subset of table a. both tables have >> the same primary key >> >> I want to update the rows from table a with a single column from table >>

[sqlite] query help

I have two tables, table b is a subset of table a. both tables have the same primary key I want to update the rows from table a with a single column from table b, what sql command would be most efficient for this? Thanks ___ sqlite-users mailing list sq

Re: [sqlite] WHERE Clause Not Working On Database

es(state char(2), name char(10)); sqlite> insert into companies values('OR','one'); sqlite> insert into companies values('OR','two'); sqlite> insert into companies values('ID','three'); sqlite> select * from companies where

Re: [sqlite] WHERE Clause Not Working On Database

On 14 September 2010 14:45, Rich Shepard wrote: > sqlite> select * from Companies where state = 'OR'; What do you get from: select distinct state from companies; Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] implementing a row cache

Not a huge issue - if the record I want is not in the cache then I can go and get it. for the record I have checked my code just doing the sql queries and it is too slow - hence the additional work here. Initial implementatio is faster and looks workable (although it does introduce additional prob

Re: [sqlite] implementing a row cache

Thanks for the input SELECT * FROM table WHERE id BETWEEN (currentid-100) AND (currentid+100) is rather obvious and I should have thought of it - an SQL newbie working late at night and then getting up early with the problem running around my head Howver although that works for the primary co

[sqlite] implementing a row cache

I need very fast access to various subsets of data from a table so I am trying to write a cache for a subset of the rows. The cache must be “sort” aware. The table is read only do I dfont need to worry about keeping the cache upto date. The table itself has about 30 columns and I need to cache al

Re: [sqlite] SQL script help.

urn every row and stop at the end. Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database is locked

I expect that this has been asked before but I cant find anything useful via google. I am updating about 20 rows in a table and setting a particular value to a particular value. The first time I do this all is OK, if I try again a few seconds later I get a database is locked error. The code is (u

Re: [sqlite] copying only new rows from one table to another

Thanks igor - ill give that a go. On 6 August 2010 16:36, Igor Tandetnik wrote: > Paul Sanderson wrote: >> I have two tables and I want to copy (occasionally) a few thousand >> columns that have been added to table1 into table2, both tables have >> the same unique key but

[sqlite] copying only new rows from one table to another

Newbie question I have two tables and I want to copy (occasionally) a few thousand columns that have been added to table1 into table2, both tables have the same unique key but otherwise the columns are different. table2 will be initially populated from table1 using INSERT into table table2 SELEC

Re: [sqlite] Inserting a large amount of data into a large indexed table

Thanks Oliver that is what I am doing at the moment. I was wondering whether there might be a quicker way maybe using temporary tables for similar - just exploring ideas On Tuesday, August 3, 2010, Oliver Peters wrote: > Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sander

[sqlite] Inserting a large amount of data into a large indexed table

Hi I have a table that contains 6 columns of integers, 2 of these columns are indexed. There are about 10 Million rows of data in the table. every now and again I need to add more rows, between about a thousand and a million at a time. I want the process to be as quiick as possible (although I kno

[sqlite] indexing speed

I have a table with just a few columns, one is a SHA1 hash and the second an MD5, there are about 17 Million rows in the table if I create an index on the SHA1 column using "create index if not exists sha1index on hashtable(sha1)" the process takes about 3 minutes, if I follow this immediately by

Re: [sqlite] EXTERNAL:Re: Sqlite Insert Speed Optimization

.html#using-por t-forwarding and also section 4.18.3 in that manual. We do use ssh port-forwarding but not for Oracle. However as my firewall says that Ora only needs 1521/tcp then I don't see why it wouldn't work. But this is starting to go off-t

Re: [sqlite] EXTERNAL:Re: Sqlite Insert Speed Optimization

ing a compressed ssh tunnel between the oracle server and the client, port-forwarding 1521/tcp over it and changing your tnsnames to point at the client machine? Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/

Re: [sqlite] Sqlite Insert Speed Optimization

On 14 July 2010 11:56, Werner Smit wrote: > 3. I'm saving to a network drive. Is this a one-off data import into a new clean sqlite db? If so have you considered writing to a db file on a local drive and then copying the whole file to the network drive afterward

Re: [sqlite] SQLite datatypes

HEre's the doc: http://www.sqlite.org/datatype3.html <http://www.sqlite.org/datatype3.html>Cheers, Paul On Mon, May 3, 2010 at 12:17 PM, Alan Harris-Reid < aharrisr...@googlemail.com> wrote: > Hi there, > > When creating a table in SQLite, I often get confused when

Re: [sqlite] FTS3 stop words/chars

On Fri, Apr 30, 2010 at 2:18 PM, Richard Hipp wrote: > > > On Fri, Apr 30, 2010 at 4:43 PM, Paul Rigor (uci) wrote: > >> Hi, >> >> What are the default stop words and characters for the FTS3 simple >> tokenizer? >> >> > The tokenizers built

[sqlite] FTS3 stop words/chars

Hi, What are the default stop words and characters for the FTS3 simple tokenizer? Thanks, Paul -- Paul Rigor Pre-doctoral BIT Fellow and Graduate Student Institute for Genomics and Bioinformatics Donald Bren School of Information and Computer Sciences University of California, Irvine http

Re: [sqlite] CHECK constraints and type affinity

gt; > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Paul Rigor Pre-doctoral BIT Fellow and Graduate Student Institute for Genomics and Bioinformatic

Re: [sqlite] SQlite trigger issues

Checkout: http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler <http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler>Goodluck, Paul On Thu, Apr 29, 2010 at 6:05 AM, Paul Rigor (uci) wrote: > Hi, > > There's should be a call back to a progress handler. I ha

Re: [sqlite] SQlite trigger issues

is called after 10e6 machine opcodes. Goodluck, Paul On Thu, Apr 29, 2010 at 5:04 AM, Simon Slavin wrote: > > On 29 Apr 2010, at 1:01pm, Serdar Genc wrote: > > > What about trigger on a view? Does SQLite support trigger on a view? > > See the section 'INSTEAD OF trigger&

Re: [sqlite] CHECK constraints and type affinity

hat was going on. I though I made it clear - I even show that > negative values slip through this check ('q' would pass the original check, > too). I can only assume you haven't actually read my message before jumping > in to respond. > -- > Igor Tandetnik > > ___

Re: [sqlite] Install multiple versions of Sqlite?

That sounds about right, but you should ensure that LD_LIBRARY_PATH is set to reflect the appropriate sqlite lib folder each time you run something that requires this, eg, your latest subversion install. Goodluck, Paul On Mon, Apr 26, 2010 at 1:30 PM, Forrie wrote: > We are using Redhat, wh

Re: [sqlite] Question on the VdbeCursor structure changes

a risk I took, and it works so far. > > Best regards, > Sylvain > > On Sat, Apr 17, 2010 at 8:07 PM, D. Richard Hipp wrote: > >> >> On Apr 17, 2010, at 1:02 PM, Paul Shaffer wrote: >> >> > Due to changes in VdbeCursor structure, this code for 3.6.16

[sqlite] Question on the VdbeCursor structure changes

Due to changes in VdbeCursor structure, this code for 3.6.16 won't compile anymore: else if(pC->pseudoTable) { *prowid = pC->iKey; } and for 3.6.23 would have to be replaced by something like this: else if(pC->pseudoTableReg>0) { //*prowid = } My problem is that after about an hour of

Re: [sqlite] INSERT failing.

> unrecognized token: ""Man weiss es nicht, aber es war ein Feiertag.")" The character after the . is not a double-quote, plus you should be using single quotes anyway. Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.6.23 - date.c

dividual C code files into this STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] BLOBs' affect on DB performance

en searching, most of the BLOB performance posts I've seen are about storing / retrieving the blobs. We're not so worried about the time to retrieve / store the blobs as much as time to access the main tables. Thanks! Paul ___ sqlite-users m

Re: [sqlite] Writing and reading a csv using sqlite3

de csv" before the ".import" makes things better but doesn't fix it. Do you need to read the csv data back in to a sqlite database? If not, then the file you've got should be ok. If you do then I think you will need to either alter shell.c or create your own program to re

[sqlite] Foreign keys and Temp Tables

x27;s key?) Couldn't find anything about this one way or another in the docs. Thanks -Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Multi-process read_uncommited equivalent?

cularly attractive to me, so is there a better way? Typical db files (with other tables) are in the region of 50Mb, typical datasets in the order of 100,000 rows. Using Linux if that makes any difference; currently with sqlite 3.6.14.2, but I don&#x

[sqlite] Updating blob columns from files by command-line

Given table texts(filename text, contents blob) and a directory of plain text files, is it possible (using the command line interface alone) to populate the table with the names and contents of all the text files, one file per record? Thanks in advance, Paul Craven

[sqlite] sqlite, php, and Mac OS X 10.6.1

Trying to write a test web page using php and sqlite. I have a Mac with OS X 10.6.1 (Snow Leopard). Maybe this is a php problem, Im not sure. I have enabled web sharing, so I guess Apache is up and running. I have un-commented out the line in /etc/apache2/httpd.conf which reads LoadModule php5_

Re: [sqlite] Better example of fk mismatch problem

Thanks. Typo is only in my post edit, not in the actual software. Your edit is correct. Question still stands. > On Sun, 06 Dec 2009 00:05:28 -0700, Paul Shaffer > wrote: > >> I found where I was getting a 'foreign key mismatch' error, but I don't >> know w

[sqlite] Better example of fk mismatch problem

I found where I was getting a 'foreign key mismatch' error, but I don't know why. There are 2 versions of the last table below. They look like they are about the same to me, but one causes the error. The error occurs when I am doing a cascading delete in unrelated tables, and the problem table has

Re: [sqlite] "foreign key mismatch" error

Original Message > On Dec 4, 2009, at 12:31 PM, Paul Shaffer wrote: > >> Below are 3 tables. When I delete a row in Item with related rows in >> Item_attribute I get the dreaded "foreign key mismatch" error. I've >> read >> thr

[sqlite] "foreign key mismatch" error

Below are 3 tables. When I delete a row in Item with related rows in Item_attribute I get the dreaded "foreign key mismatch" error. I've read through the documentation and don't see what I'm doing wrong. sqlite v 1.6.20 CREATE TABLE [Item_attribute] ( "ItemID"integer NOT NULL, "At

Re: [sqlite] Disk activity on Linux

Bret Patterson writes: > > We're seeing a lot more disk activity than expected on Linux when using > sqlite3. We've run this same series of test on windows and the disk IO is > much lower, which is the opposite of what I really expected. Below is > my scenario and perhaps someone can point out

Re: [sqlite] Trouble running sqlite3 in ubuntu linux 9.04

the shared libraries from the glibc version used for linking but I have not had any problems running sqlite3 (including using it to access and edit the firefox cookies which is very handy for development purposes). Thanks again, Paul Whipp www.paulwhippconsulting.com.au Tel: +61 410 545 357

Re: [sqlite] Trouble running sqlite3 in ubuntu linux 9.04

anyone know what I should investigate or where I should look next to solve this problem? Regards, Paul Whipp www.paulwhippconsulting.com.au Tel: +61 410 545 357 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Trouble running sqlite3 in ubuntu linux 9.04

Hi there, I just installed sqlite3 using synaptic. Install went fine but: ~$ sqlite3 test.db Segmentation fault Can anyone point me to the relevant documentation/solution? Regards, Paul Whipp www.paulwhippconsulting.com.au Tel: +61 410 545 357

[sqlite] Leading spaces in columns

I have a number of leading spaces in one of my sqlite columns, but SELECT result suppresses them. Yet I see that the SqliteManager add-on for Firefox displays them quite nicely. What is the secret of retrieving those leading spaces? Kind regards, ~ Paul Claessen

Re: [sqlite] What is a Relation?

So .. would anyone know a good book for seasoned programmers, who are new to databases, that addresses all these issues? ~ Paul Claessen > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon > Slavin &g

Re: [sqlite] .lib file?

iles. > > Probably you must disable the use of precompiled headers also. > > HTH. > > A.J.Millan > > > > -Original Message- > > From: Paul Claessen paul at claessen.com > > Sat Jul 25 15:48:37 GMT 2009 > > To: paul at claessen.com; Gener

Re: [sqlite] .lib file?

Actually, I was able to generate a .lib file from the DLL using Doug's suggesting (link /lib /def:sqlite3.def). Works fine now! Thanks all! ~ Paul Claessen > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On

Re: [sqlite] .lib file?

lternative way of using DLL's from a windows console app, that I'm not aware of. Kind regards, ~ Paul Claessen > -Original Message- > From: Pavel Ivanov [mailto:paiva...@gmail.com] > Sent: Saturday, July 25, 2009 11:31 AM > To: p...@claessen.com; General Discussion

[sqlite] Sqlite from ASP?

Greetings, Does anyone have any (simple) examples on how to use sqlite from .ASP scripts for me? Or C# code, for that matter? ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

[sqlite] .lib file?

app, using the dell, in Visual Studio? Kind regards, ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] large db performance considerations

d forward, I ended up not using it at this point, although future enhancements do call for using full text search. For this iteration, if there is a better way, without using FTS, I could certainly remove it and use a regular table. Thanks. Paul On Sun, Jun 7, 2009 at 11:00 PM, Simon Slavin wrote:

[sqlite] large db performance considerations

), and used the same table schema, and added an index on Author, Content and Category. However, I did not notice any change in time, and the database size grew from 11MB to 15MB. Any suggestions would be greatly qppreciated. Thank you, Paul ___ sqlite-users

Re: [sqlite] Problem with SQLite3

2009/6/5 Ann Shipley : > I am trying to install Google Adwords Editor and when it attempts to open I > receive a message "AdWords Editor has stopped working.  A problem has caused > it to stop working correctly.  Windows will notify if there is a solution." > Then a window opens stating "Solve a pr

Re: [sqlite] First Program using sqlite3.dll - Linker Errors

Add the lib file you generated with lib.exe into your project. Just pointing to the directory is not enough. That should fix up your link errors. On Sat, Mar 28, 2009 at 10:53 AM, Neil Jeffery wrote: > > Hi All, > > > > I am attempting to write a program which will use the sqlite3.dll file.

Re: [sqlite] Formatted text with fts3

ent source code and add a filter. I read that some folks from Google did some of the work on the fts3 module. They probably drop all tags when they search for text, and that allows for a more reliable search. I'm just guessing. Thanks again, Paul On Tue, Mar 10, 2009 at 11:22 AM, Scott Hess

Re: [sqlite] Formatted text with fts3

are html before insert is more simple. You can transform > html into "right" format for fts3 parser. I would actually like to retain the tagged (html) formatting in the database, thereby, when it is retrieved it can be displayed as rich text. Thanks, Paul On Tue, Mar 10, 2009 at 4:32

[sqlite] Formatted text with fts3

rting and ending character it applies to. That does get more complicated, especially when preparing the text. I would really prefer having the tags intermixed with the text, that is if I can prevent them from being in the full text search. Any ideas would be loved. Cheers,

[sqlite] Import a CSV file

I use an excellent piece of software called AutoIT (http://www.autoitscript.com). AutoIt is a very flexible easy to use programming language which supports SQLite. I used it to write a csv import program for SQLite. Took me 10 minutes. If you would like to see the source as an example just say. Ch

Re: [sqlite] import a CSV-File

I use an excellent piece of software called AutoIT (http://www.autoitscript.com). AutoIt is a very flexible easy to use programming language which supports SQLite. I used it to write a csv import program for SQLite. Took me 10 minutes. If you would like to see the source as an example just say. Ch

[sqlite] Sqlite thread safety on iPhone

cture) Thanks Paul Clarke * Notice: This email is confidential and may contain copyright material of Ocado Limited (the "Company"). Opinions and views expressed in this message may not necessarily reflect the opinions a

[sqlite] Incorrect results from SELECT DISTINCT

t didn't manage to turn up anything. Can anyone give me any pointers? Jean-Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite concurrency problem

Thanks I think that may be the problem. So one can share one open raw database connection across multiple threads can you? I had (wrongly) assumed that one had to open one such connection for each thread Many thanks Paul Clarke Project LastMile IT Location: Level B offices, Hatfield CFC

[sqlite] Sqlite concurrency problem

insert is attempted, SQLITE_BUSY is returned Waiting is obviously no use because the conflicting operation is in the outer loop Is this expected or am I doing something silly? Thanks Paul Clarke * Notice: This

Re: [sqlite] Questions about "analyze"

Clodo wrote: > Many thanks, it's a good news that resolve my problem. > > But still remain "a trick", i think the behaviour descripted in my > original feedback is "strange".. i understand, if all fields have the > same value, an index on that have a zero "height" in computing the best > indexes

Re: [sqlite] sqlite on flash devices

ming is to compile SQLITE with -DSQLITE_TEMP_STORE=3 to keep sqlite temporary files in memory. - -Paul On Thu, 2008-10-02 at 13:36 -0600, J Glassy wrote: > Paul, > here are a few odd thoughts on this: > --Flash memory devices in general are subject to 'finite' numbers of &

Re: [sqlite] sqlite on flash devices

wear levelling which of course will prolong life. - -Paul On Thu, 2008-10-02 at 17:44 -0400, Matthew L. Creech wrote: > On Thu, Oct 2, 2008 at 4:20 AM, Paul McMahon <[EMAIL PROTECTED]> wrote: > > What's the consensus on using sqlite with flash based storage such as sd >

Re: [sqlite] sqlite on flash devices

I thikn you mean supplying a sqlite3_vfs to the sqlite3_open_v2 call; will look into it. Anyone know where there are examples of this? - -Paul On Fri, 2008-10-03 at 01:03 +0400, Alexey Pechnikov wrote: > Hello! > > I'm using SQLIte on a few dozens winmobile devices a few ye

Re: [sqlite] sqlite on flash devices

-- -Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<    1   2   3   4   5   6   7   8   >