Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

Wamiduku wrote: > > Here are the steps to reproduce the problem: > 1 - Start with a clean Windows machine (I've tried with both XP SP3 > and Windows 7 SP1) with nothing installed (I used virtual machines for > testing). > 2 - Install .NET 4. > 3 - Download

[sqlite] System.Data.SQLite won't work untill I install+uninstall it.

I've tried to create an install-free app (portable), but I can't get System.Data.SQLite to work unless I install it. Once installed, my app works and it keeps working even after I uninstall System.Data.SQLite. The same is true for the tests (test.exe and testlinq.exe) included in

Re: [sqlite] Error Message near ".": syntax error

On 10 Oct 2011, at 2:06am, James Brison wrote: > Very embarrassing ... I had a typo after doing a copy & paste. > > Thanks All! No problem. We'd rather have a problem we can solve than one we can't. Simon. ___ sqlite-users mailing list

Re: [sqlite] Error Message near ".": syntax error

Very embarrassing ... I had a typo after doing a copy & paste. Thanks All! From: Simon Slavin To: James Brison ; General Discussion of SQLite Database Sent: Saturday, October 8, 2011 7:06 PM

Re: [sqlite] Is it possible this optimize query on a very large database table

Florian Weimer, >>A better query needs support for DISTINCT ON, which SQLite lacks >>AFAIK. But speed will obviously be limited because you cannot avoid >>traversing the index for the whole table. I read your email and found it to be very interesting. PostgresSQL supports DISTINCT ON.

Re: [sqlite] Is it possible to optimize this query on a very large datatabase table

Igor Tandetnik, Here is a comparison of my query plan with your query plan on the latest version of sqlite. sqlite> explain query plan select FieldName, min(rowid) from BlobLastNameTest group by FieldName; 0|0|0|SCAN TABLE BlobLastNameTest USING COVERING INDEX claramary (~100 rows)

[sqlite] Three small patches for lemon

Attached are three small patches for lemon: lemon-remove-duplicate-prototype.patch - remove a duplicate prototype for SetNew(). lemon-two-typos.patch - fix a typo in a message and another in a comment. lemon-unused-parameter.patch - remove the errsym parameter to resolve_conflict() which is no

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?‏

On 10 Oct 2011, at 12:37am, Frank Chang wrote: > Simon Slavin, Here is the schema which I used. CREATE TABLE > [BlobLastNameTest] ([FieldName] CHAR (25), [Vertices] BLOB ) Okay. That's not what you posted originally. Okay so we have CREATE TABLE BlobLastNameTest (FieldName TEXT PRIMARY KEY,

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?‏

Simon Slavin, Here is the schema which I used. CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25), [Vertices] BLOB ) With this schema it is possible to have multiple rows with the same FieldName. This is intentional since I am writing a Windows and Linux C++ multithreaded application

Re: [sqlite] Can pre-sorted data help?

On Oct 9, 2011, at 10:46 PM, Black, Michael (IS) wrote: > create virtual table ftext using fts3(t text); Try this instead: create virtual table ftext using fts4(t text, prefix="1") http://www.sqlite.org/fts3.html#section_6_2 ___ sqlite-users mailing

Re: [sqlite] Can pre-sorted data help?

OK...here's the benchmark...First...let's build the shell (I'm using 3.7.5) cc -o shell -O -DHAVE_READLINE -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS sqlite3.c shell.c -lpthread -ldl -lreadline -lncurses The one thing you can do with the table method is make the left-most character

Re: [sqlite] pzTail parameter to sqlite3_prepare_v2()?

On Sun, Oct 9, 2011 at 10:27 AM, Igor Tandetnik wrote: > James Hartley wrote: > > From this, I assume that *pzTail will be set to NULL after compiling > > the stream's last statement? > > I suspect it'll point to the terminating NUL character. In any

Re: [sqlite] Statement failing

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/10/11 11:24, Tim Streater wrote: > But closer investigation of the SQLite3 interface does not reveal an > equivalent to the FetchAll method available under PDO. Note that SQLite itself (the C library) doesn't have it either. You call prepare

Re: [sqlite] Statement failing

On 09 Oct 2011 at 17:00, Simon Slavin wrote: > On 9 Oct 2011, at 4:52pm, Tim Streater wrote: > >> At present, I'm using PDO and setting it to throw exceptions. So I have a >> try/catch around all my $dbh->query and in there, log what happened and >> where, report to the

Re: [sqlite] pzTail parameter to sqlite3_prepare_v2()?

James Hartley wrote: > The documentation speaks that multiple SQL statements can be passed to > sqlite3_prepare_v2() which will only compile the first statement of the > stream. Upon return, pzTail points to the first character of the next SQL > statement which has not been

[sqlite] pzTail parameter to sqlite3_prepare_v2()?

I am needing some clarification. The documentation speaks that multiple SQL statements can be passed to sqlite3_prepare_v2() which will only compile the first statement of the stream. Upon return, pzTail points to the first character of the next SQL statement which has not been compiled. From

Re: [sqlite] Statement failing

On 9 Oct 2011, at 4:52pm, Tim Streater wrote: > At present, I'm using PDO and setting it to throw exceptions. So I have a > try/catch around all my $dbh->query and in there, log what happened and > where, report to the user and then give up. I haven't looked closely at the > SQLite3 interface

Re: [sqlite] Statement failing

On 09 Oct 2011 at 02:02, Simon Slavin wrote: > On 9 Oct 2011, at 1:39am, Tim Streater wrote: > >> On 08 Oct 2011 at 23:32, Simon Slavin wrote: >> >>> I'm not clear whether you're using the PDO or the sqlite3 extension to PHP. >> >> By the way, is one

Re: [sqlite] Can pre-sorted data help?

On 9 Oct 2011, at 3:49pm, Mohit Sindhwani wrote: > Maybe, I'm worrying about the wrong things :) I think perhaps you are. First, you are trying to reproduce SQLite's indexing mechanism with one that isn't even as good. Secondly you are worrying about indexing columns, instead of creating

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?

On 9 Oct 2011, at 4:13pm, Frank Chang wrote: > CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY, > [Vertices] BLOB ) This form CREATE TABLE BlobLastNameTest (FieldName TEXT PRIMARY KEY, Vertices BLOB) does exactly the same in SQLite. >

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?

* Frank Chang: > This table could potentially hold 10 to 40 million rows. We are > using the following query to obtain the minumum rowid for each > unique LastName: > > sqlite> explain query plan select t1.FieldName,t1.rowid from BlobLastNameTest > t1 > GROUP BY t1.FIELDNAME HAVING t1.rowid =

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?

Frank Chang wrote: > Hi, We are using the following schema : > CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY, > [Vertices] BLOB ) > > index|sqlite_autoindex_BlobLastNameTest_1|BlobLastNameTest|3| > > > This table could potentially hold 10 to 40

Re: [sqlite] Can pre-sorted data help?

On Oct 9, 2011, at 5:07 PM, Black, Michael (IS) wrote: > Your assumption is that it is. Why are you assuming that I'm assuming? Is that an assumption? 8^) In any case, looking forward for your benchmark :) ___ sqlite-users mailing list

Re: [sqlite] new user

No, not me! At least not at this stage -- will go through various options when (and if) I decide to develop something (right now am just learning for the sake of knowledge). Anyway thanks for the info! Thanks & Regards Taleeb Anwar *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!* On

[sqlite] Is is possible to optimize this query on a very large datatbase table?

Hi, We are using the following schema : CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY, [Vertices] BLOB ) index|sqlite_autoindex_BlobLastNameTest_1|BlobLastNameTest|3| This table could potentially hold 10 to 40 million rows. We are using the following query to obtain

Re: [sqlite] new user

On 09 Oct 2011 at 10:40, saeed ahmed wrote: > i am a new to sqlite. i want to know how can i make sqlite looking like > microsoft access? similar working environment, like making tables, queries > etc. actually i find it difficult to work in writing commands mode. any

Re: [sqlite] Can pre-sorted data help?

If I had the time right now I'd write a benchmark I find it really hard to believe that for prefix queries that FTS is going to be faster than a seperate table. Your assumption is that it is. Especially for the first character situation. And it's selectivity is one-to-one for the query he

Re: [sqlite] Can pre-sorted data help?

Thanks Petite! On 9/10/2011 10:58 PM, Petite Abeille wrote: On Oct 9, 2011, at 4:49 PM, Mohit Sindhwani wrote: Maybe, if we had a column called 'published_date' and we did a query for data within a date range.. the fastest way to get the information back would be to have an index on that

Re: [sqlite] new user

No I'm not from Pakistan; but that should not be a reason for not helping you out...And no I'm not an expert (not even near one). OK. Let me try to explain again. To use sqlite like we all use access/sql-server, we need to have some tool (management studio or IDE or whatever you call it). If you

Re: [sqlite] Can pre-sorted data help?

On Oct 9, 2011, at 4:49 PM, Mohit Sindhwani wrote: > Maybe, if we had a column called 'published_date' and we did a query for data > within a date range.. the fastest way to get the information back would be to > have an index on that column. Suppose we sorted all the data by date - would >

Re: [sqlite] new user

When I said advantages and limitations -- I meant philosophically and not literally. In today's technology there is always scope for improvement, irrespective of how great the product is. I must also "repeat" that I've not used sqlite much. Just read about it while browsing about .NET windows

Re: [sqlite] Can pre-sorted data help?

Hi Michael and Petite, Thanks for the replies. On 9/10/2011 10:08 PM, Petite Abeille wrote: On Oct 9, 2011, at 1:03 PM, Black, Michael (IS) wrote: For your example create a separate table with just the first letter and build an index on it. This is most likely pointless as the selectivity

Re: [sqlite] Can pre-sorted data help?

On Oct 9, 2011, at 12:15 PM, Mohit Sindhwani wrote: > create table titles (id integer primary key, title text, ...); > could we sort the records by title and use that in some way to restrict the > search space when searching titles starting with a specific letter? You might be better off

Re: [sqlite] new user

brother it seems you are from pakistan like me.help me if you are wxpert user.i want to use sqlite but i dont know where to start? 2011/10/9 Taleeb Anwar > If you don't want to work using command line - then you will have to > download some management tools. Visit >

Re: [sqlite] Can pre-sorted data help?

On Oct 9, 2011, at 1:03 PM, Black, Michael (IS) wrote: > For your example create a separate table with just the first letter and build > an index on it. This is most likely pointless as the selectivity of such index is going to be very low. Plus not point in reinventing a square wheel,

Re: [sqlite] new user

If you don't want to work using command line - then you will have to download some management tools. Visit http://www.sqlite.org/cvstrac/wiki?p=ManagementTools to see a list of tools. Personally I'm using sqlite expert. It has got its own advantages and limitations (but anyway I've not used

Re: [sqlite] Can pre-sorted data help?

For your example create a separate table with just the first letter and build an index on it. create table text(t string); create table first(textid int, first_char char); create trigger makefirst after insert on text begin insert into first values(new.rowid,substr(new.t,1,1)); end; insert into

Re: [sqlite] Error 14 - cannot open Database

Thanks for the reply Stephan. It transpires that the problem was not enough free hard drive space to create the journal file. Would be good if this was reported more verbosely. Thanks again, Ian On 09/10/2011 11:09, Stephan Beal wrote: On Sun, Oct 9, 2011 at 11:22 AM, Ian

Re: [sqlite] Can pre-sorted data help?

Thanks Richard and Petite, On 9/10/2011 1:05 AM, Richard Hipp wrote: On Fri, Oct 7, 2011 at 12:30 PM, Mohit Sindhwani wrote: Hi All, I have been trying to see how we can make one of our databases more space efficient. Have you tried increasing the page size? You seem to

Re: [sqlite] Error 14 - cannot open Database

On Sun, Oct 9, 2011 at 11:22 AM, Ian Hardingham wrote: > Woke up this morning to find my server unable to open our database file. > Is there anything I can do to diagnose or repair it? We have backups but > it would be good if it were possible to repair this one. > Some

Re: [sqlite] Statement failing

On Sun, Oct 9, 2011 at 3:02 AM, Simon Slavin wrote: > That is a great question, and I'd love to see answers from PHP programmers. > Personally, i prefer PDO. i like it's simplified model (unification of query and result set) and find it easy to work with. i like it so much

[sqlite] new user

i am a new to sqlite.i want to know how can i make sqlite looking like microsoft access?simmilar working environment,likemaking tables,queries etc.actually i find it difficult to work in writing commands mode.any help? ___ sqlite-users mailing list

[sqlite] Error 14 - cannot open Database

Hey guys. Woke up this morning to find my server unable to open our database file. Is there anything I can do to diagnose or repair it? We have backups but it would be good if it were possible to repair this one. Thanks, Ian ___ sqlite-users