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
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
> 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
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
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
>
>
> 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
>
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
>
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:
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
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
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
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
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!
___
> 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
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
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
> 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
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
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 *
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
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
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
-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
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
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
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.
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
>
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
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"
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
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
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
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
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
> 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
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
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
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.
>
> 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
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
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
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
> 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.
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
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
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
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
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
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
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
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 (
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
.
> [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
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
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
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
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
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
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,
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
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
.
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
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
63 matches
Mail list logo