Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On Tue, Oct 18, 2011 at 7:41 AM, John Drescher wrote: > My biggest reason for wanting a mailing list versus a forum is that I > subscribe to 20+ mailing lists that all go to my gmail account with > gmail rules to organize the content. If these mailing lists all were > forums

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On Tue, Oct 18, 2011 at 4:35 AM, Frank Missel wrote: > I think that the sqlite-users e-mail list has enough traffic to warrant a > proper forum. > > Has this been considered? I know of no better forum than a mailing list for this sort of thing. Mailing lists have archives that

Re: [sqlite] Column headers include subselect alias if column is from a subselect

> I would expect a column header of a for all of these queries, and all> other > databases I've tested with use a column header of a.  Is this a> bug in > SQLite? Column name in the result set is undefined unless you define alias in the query. So SQLite can name it whatever it wants. Pavel

Re: [sqlite] Fast JOIN

2011/10/19 Fabian > > > Maybe there is just no easy way to do what I want, I will take a good night > sleep about it ;) > > I think the correct query would be: SELECT table1.data1, table2.data2 FROM ( SELECT table1.rowid, table1.data1 WHERE table1.data1 = 10 ) AS table1

Re: [sqlite] Fast JOIN

you will need an inner select that selects everything and orders that, then an outside select that pages from the inner select. Woody Wizard, at large "I'm in shape, round is a shape!"   --- On Tue, 10/18/11, Fabian wrote: From: Fabian

Re: [sqlite] Fast JOIN

> > > Assuming that is a typo, does the following not do what you want? > > SELECT table1.data1, table2.data2 > FROM > ( > SELECT table1.rowid, table1.data1 > WHERE table1.data1 = 10 > ORDER BY table1.rowid DESC > OFFSET 0 LIMIT 250 > ) AS table1 > JOIN table2 > ON table1.rowid = table2.rowid >

Re: [sqlite] Fast JOIN

On 18 October 2011 22:09, Fabian wrote: > I'm working on a pagination system where two tables need to be joined. . . . > > I got very good advice on this mailing-list, to change the query into this: > > SELECT table1.data1, table2.data2 > FROM > ( > > SELECT table1.data1 >

Re: [sqlite] UPDATE question

Hi, Barry, Regarding: "Could you please explain me why the indexing is so important? (for future reference)." If you're asking just in *general* why indexes can speed up searching a database table, you might want to look at most any sql tutorial, or resources such as:

Re: [sqlite] Fast JOIN

On Oct 18, 2011, at 11:09 PM, Fabian wrote: > Is there any solution for this? Perhaps this is not a technical issue, but rather a design one, as you seem to be, hmmm, tilting at windmills. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Fast JOIN

I'm working on a pagination system where two tables need to be joined. At first my query looked like this: SELECT table1.data1, table2.data2 FROM table1 JOIN table2 ON table1.rowid = table2.rowid WHERE table1.data1 = 10 ORDER BY table1.rowid DESC OFFSET 0 LIMIT 250 I got very good advice on this

[sqlite] Unexpected behavior when renaming a virtual table (rtree) in a UTF-16 database

This behavior seems to happen in both stock standard 3.7.7.1 on 32-bit Windows XP and my customized 3.7.8 on Solaris 9 (Sparc).  Here's the capture from Windows: D:\peter\sqlite-shell-win32-x86-3070701>sqlite3 this_is_a_new_db.db SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for

Re: [sqlite] UPDATE question

Igor Tandetnik wrote: > > Barry1337 wrote: >> So I need, for every record in STAYSPEC, to find another record in >> STAYSPEC >> that has the same STAYNUM field and an ORDER_SPEC field that is 1 more. I >> want to replace the date_out from STAYSPEC with that date (in

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On Oct 18, 2011, at 9:21 PM, Jos Groot Lipman wrote: >> Yes, go install your forum and leave us in peace :P > > Who said mail-lists get less flame-wars ;-) Flame warriors roster: http://redwing.hutman.net/~mreed/ Take the personality test! ___

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

> Yes, go install your forum and leave us in peace :P Who said mail-lists get less flame-wars ;-) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On Tue, 18 Oct 2011 12:21:50 +, Jean-Denis MUYS wrote: >On 18 oct. 2011, at 11:47, Frank Missel wrote: > >> I see several advantages to having a forum: >> >> 1. Several subject forums as mentioned >> > Mail can have as many subjects as desired > >> 2. Better view of

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On Oct 18, 2011, at 11:57 AM, Mark Schonewille wrote: > However, if you really want a forum, install one on your web server and find > out how many people use it. Yes, go install your forum and leave us in peace :P ___ sqlite-users mailing list

Re: [sqlite] Limit COUNT

> boun...@sqlite.org] On Behalf Of Bart Smissaert > > That seems to be the answer and after some quick testing it looks it makes it > more efficient as well! > > On Tue, Oct 18, 2011 at 1:36 PM, Kit wrote: > > 2011/10/16 Fabian : > >> How can you

[sqlite] SQLIte compilation error on AIX 6.1 - Undefined symbol: .__gcc_qsub

Hi all, I am running AIX 6.1, and GCC 4.2 and when I try compile SQLite (I think version 3.7.5) using the following commands: gcc -maix64 -D_FILE_OFFSET_BITS=64 -c -fPIC -DHAVE_USLEEP ./sqlite/sqlite3.c -o ./sqlite/sqlite3.o gcc -maix64 -shared -L/usr/lib/threads -o ./sqlite/libsqlite3.so

Re: [sqlite] UPDATE question

Because your query was fairly complex, to help everyone debug it, I simplified it using simple names (tables are a, b, c; fields are m, n, x, y, z) and much simpler use of whitespace / indentation: UPDATE a SET x = CASE WHEN EXISTS ( SELECT *

Re: [sqlite] How about a proper forum rather than an e-mail list

Definitely I would like to have the SQLite mail list in a fashion as StackOverlow. > > Original Message > From: epank...@comcast.net > Sent: Tue, 18 Oct 2011 16:23:11 +0200 > > > >I'll say one thing - a forum would have saved me the wasted time of having to >download and then

Re: [sqlite] Limit COUNT

That seems to be the answer and after some quick testing it looks it makes it more efficient as well! RBS On Tue, Oct 18, 2011 at 1:36 PM, Kit wrote: > 2011/10/16 Fabian : >> How can you limit a count-query? I tried: >> SELECT COUNT(*) FROM table

Re: [sqlite] Changing the data type of an existing table

Hi Marshall, A good suggestion. The reason I chose to "transform" the schema instead was that there are a number of databases with similar structure on different sites which has the same declared data types. Also there will be several more in the future. This is supported by a framework of some

Re: [sqlite] How about a proper forum rather than an e-mail list

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/10/11 05:04, Igor Tandetnik wrote: > Frank Missel wrote: >> I think that the sqlite-users e-mail list has enough traffic to >> warrant a proper forum. > > For what it's worth, I'm using GMane (http://gmane.org/), It should be

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Sorry folks, but it does not matter who is right or wrong, if you want to open a forum... go ahead, you can even announce it here; those interested will follow your idea, but for the time being you are taking a lot of bandwidth, time and creating distraction. Please, I encourage you to open the

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi Mark, I started this thread with a suggestion of having a forum for SQLite rather than a mailing list. That is the subject line. All posts have been related to that. I wished to see what the consent or lack thereof was in the community. Possibly it would then also be noted by those that

Re: [sqlite] How about a proper forum rather than an e-mail list

On 18 Oct 2011, at 3:22pm, epank...@comcast.net wrote: > I'll say one thing - a forum would have saved me the wasted time of having to > download and then delete all of this discussion about forums :) 'man killfile' Or, since we're now in the 21st century, create a rule for your mail app.

Re: [sqlite] How about a proper forum rather than an e-mail list

On Tue, Oct 18, 2011 at 8:04 AM, Igor Tandetnik wrote: > Frank Missel wrote: >> I think that the sqlite-users e-mail list has enough traffic to warrant a >> proper forum. > > For what it's worth, I'm using GMane (http://gmane.org/), which is a mailing >

Re: [sqlite] Changing the data type of an existing table

I think you've already found a good solution to your problem by directly modifying the master table, so this is mostly an academic curiosity, but would it be a viable alternative to use a VIEW? In other words, rather than messing with the TABLE that holds the data, could you simply create a

Re: [sqlite] How about a proper forum rather than an e-mail list

I'll say one thing - a forum would have saved me the wasted time of having to download and then delete all of this discussion about forums :) - Original Message - From: "Danny Staten" To: "General Discussion of SQLite Database"

Re: [sqlite] How about a proper forum rather than an e-mail list

People might think that nothing will change if we move to a forum; Yet there is a great difference between a letter (though its email, not paper) and a forum post; Letters are usually more formal, more tidy, without spam and trolling; A forum post and a forum itself is completely different

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi Frank, If you want to discuss the pros and cons of a forum, I think you should ask your question on a mailing list or forum about mailing lists and forums. Your question is very off-topic if you don't intend to start a SQLite forum yourself, but I think you could ask the members of this

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi Mark, Well, perhaps you are right. But I am not going to take on that. I am a user of SQLite and can perhaps help with some posts and suggestions now and then. So I am just going to throw in the idea and state the pros vs. cons as I see them . Best regards, Frank > -Original

Re: [sqlite] Bug in using overloaded functions for virtual tables?

I experience the same situation on the following query: select offsets(pasta_text), snippet(pasta_text), DataPasta from pasta_text WHERE pasta_text match 'andamento*' group by DataPasta order by DataPasta Which desired output would be all matches grouped by date (the full query is joined from

Re: [sqlite] How about a proper forum rather than an e-mail list

I for one would love a forum, and disagree about it being the same as an email list. I would love to not see 40+ emails in my inbox every day from this mailing list, but I do find the available resource handy to have when I need it. A forum would allow us to be more active because we can

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

> boun...@sqlite.org] On Behalf Of Eugene N > Mailing list is the one true way; Look what IT forums turn into eventually... This is a generality and not really an argument. Which forums do you mean? I have followed several forums which work exactly as one would hope for. Two examples comes to

Re: [sqlite] What's the default busyTimeout ?

On 18 Oct 2011, at 2:52pm, Richard Hipp wrote: > On Tue, Oct 18, 2011 at 9:46 AM, Simon Slavin wrote: > >> If I don't call sqlite3_busy_timeout() what is it set to ? > > zero. The default is to not delay at all. Thanks for the fast reply. That makes sense given what

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi, I know from experience that there really is no point whatsoever in discussing whether a forum is better than mail or not. People are just not going to agree. Just set up your forum and find out whether you're going to have subscribers. -- Best regards, Mark Schonewille Economy-x-Talk

Re: [sqlite] What's the default busyTimeout ?

On Tue, Oct 18, 2011 at 9:46 AM, Simon Slavin wrote: > If I don't call sqlite3_busy_timeout() what is it set to ? > zero. The default is to not delay at all. > > If it matters, I'm actually using the PHP SQLite3 interface calling SQLite > 3.7.3. > > Simon. >

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

> boun...@sqlite.org] On Behalf Of Jean-Denis MUYS > > > 1. Several subject forums as mentioned > > > Mail can have as many subjects as desired Well, so can forum posts. The point is that the forum is divided into main categories above the subject of the post > > 2. Better view of threads

[sqlite] What's the default busyTimeout ?

If I don't call sqlite3_busy_timeout() what is it set to ? If it matters, I'm actually using the PHP SQLite3 interface calling SQLite 3.7.3. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Very slow processing of some SELECT statements

On 18 Oct 2011, at 6:46am, Sylvain Pointeau wrote: > Is it normal that fromuid of the table exits is STRING ? > I think it should be TEXT to be surely processed as text and not float If you're writing your database especially for SQLite you should specify 'TEXT' not 'STRING'. However, SQLite

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Mailing list is the one true way; Look what IT forums turn into eventually... The only way to maintain high level of responsibility and seriousness of discussion is, alas, a mailing list 2011/10/18 John Drescher > My biggest reason for wanting a mailing list versus a forum

Re: [sqlite] How about a proper forum rather than an e-mail list

> boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: 18 October 2011 20:05 > For what it's worth, I'm using GMane (http://gmane.org/), which is a mailing > list-to-NNTP gateway and happens to carry this list. I'm old-fashioned enough > to believe that an NNTP newsgroup *is* the proper forum.

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

My biggest reason for wanting a mailing list versus a forum is that I subscribe to 20+ mailing lists that all go to my gmail account with gmail rules to organize the content. If these mailing lists all were forums I would not bother with most of them since that would be a lot of work to check

Re: [sqlite] Limit COUNT

2011/10/16 Fabian : > How can you limit a count-query? I tried: > SELECT COUNT(*) FROM table LIMIT 5000 SELECT min(COUNT(*),5000) FROM table; -- Kit ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How about a proper forum rather than an e-mail list

Hi Teg, > I love forums and consider them far superior to email if only because it's > easier to follow a topic with less quoting needed. The downside is that > someone has to manage the forum. I've managed a forum for the past 10 > years and there's a daily spam cleanup process and constant

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

On 18 oct. 2011, at 11:47, Frank Missel wrote: > I see several advantages to having a forum: > > 1. Several subject forums as mentioned > Mail can have as many subjects as desired > 2. Better view of threads with several levels being immediately displayed > My mail client threads far better

Re: [sqlite] How about a proper forum rather than an e-mail list

Hello Frank, I love forums and consider them far superior to email if only because it's easier to follow a topic with less quoting needed. The downside is that someone has to manage the forum. I've managed a forum for the past 10 years and there's a daily spam cleanup process and constant

Re: [sqlite] How about a proper forum rather than an e-mail list

At 14:04 18/10/2011, Igor Tandetnik wrote: Frank Missel wrote: > I think that the sqlite-users e-mail list has enough traffic to warrant a > proper forum. For what it's worth, I'm using GMane (http://gmane.org/), which is a mailing list-to-NNTP gateway and happens to carry

Re: [sqlite] How about a proper forum rather than an e-mail list

Frank Missel wrote: > I think that the sqlite-users e-mail list has enough traffic to warrant a > proper forum. For what it's worth, I'm using GMane (http://gmane.org/), which is a mailing list-to-NNTP gateway and happens to carry this list. I'm old-fashioned enough to believe

[sqlite] How to make SQLite run safely on CIFS mounted file system?

Hi, I have mounted a CIFS share like this (cat /proc/mounts)://192.168.0.1/test2 /var/spool/storage/Share cifs rw,relatime,unc=\\192.168.0.1\test2,username=sune,uid=123,forceuid,gid=123,forcegid,addr=192.168.0.1,file_mode=0770,dir_mode=0770,nobrl,rsize=16384,wsize=114688 0 0 My CIFS options (

[sqlite] How about a proper forum rather than an e-mail list

I think that the sqlite-users e-mail list has enough traffic to warrant a proper forum. Has this been considered? A proper forum also can contain several subject forums, e.g. USER FORUMS: Announcements General Help with SQL News DEVELOPERS CORNER: News General OS specific .

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mark Schonewille > I prefer mailing lists because I can read and write e-mails while I'm online > (.e.g while travelling) and I can easily flag important messages, copy text and > syntax in plain format or print (part of) an e-mail and I can

Re: [sqlite] UPDATE question

Barry1337 wrote: > So I need, for every record in STAYSPEC, to find another record in STAYSPEC > that has the same STAYNUM field and an ORDER_SPEC field that is 1 more. I > want to replace the date_out from STAYSPEC with that date (in text format). > > If such a record

[sqlite] UPDATE question

I have the following query: Code: UPDATE STAYSPEC SET date_out = CASE WHEN EXISTS (SELECT * FROM STAYSPEC AS STAYSPEC2 WHERE (STAYSPEC2.STAYNUM = STAYSPEC.STAYNUM) AND (STAYSPEC2.ORDER_SPEC = STAYSPEC.ORDER_SPEC+1)) THEN (SELECT date_in FROM STAYSPEC AS

Re: [sqlite] Problem with FTS4 - Floating point error.

On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

yap, I agree with you, email better. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mark Schonewille Sent: Tuesday, October 18, 2011 5:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] FW: How about a

[sqlite] Problem with FTS4 - Floating point error.

Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select statement gives floating point error in both

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi, I prefer mailing lists because I can read and write e-mails while I'm online (.e.g while travelling) and I can easily flag important messages, copy text and syntax in plain format or print (part of) an e-mail and I can also organise the message in the wy I see fit. A true geek uses e-mail,

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

I see several advantages to having a forum: 1. Several subject forums as mentioned 2. Better view of threads with several levels being immediately displayed 3. Preview of entries and editing of them even after they are posted (by the author) 4. Formatted rather than plain text 5. No need for

[sqlite] FW: How about a proper forum rather than an e-mail list

I think that the sqlite-users e-mail list has enough traffic to warrant a proper forum. Has this been considered? A proper forum also can contain several subject forums, e.g. USER FORUMS: Announcements General Help with SQL News DEVELOPERS CORNER: News General OS specific .

Re: [sqlite] Very slow processing of some SELECT statements

On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon wrote: > > On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > > > Is it normal that fromuid of the table exits is STRING ? > > I think it should be TEXT to be surely processed as text and not float > > That was an error. However

Re: [sqlite] Very slow processing of some SELECT statements

On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > Is it normal that fromuid of the table exits is STRING ? > I think it should be TEXT to be surely processed as text and not float That was an error. However it shouldn't take SQLite 2.5 seconds to handle *any* numeric literal. Especially as