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 it
On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon n...@gammon.com.au 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 it
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
.
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
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,
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
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
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
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
Barry1337 jmichiels...@gmail.com 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 does not
[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 also
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
.
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 (
Frank Missel i...@missel.sg 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 that
At 14:04 18/10/2011, Igor Tandetnik wrote:
Frank Missel i...@missel.sg 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
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
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 than
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
2011/10/16 Fabian fabianpi...@gmail.com:
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
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
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. Can't
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 dresche...@gmail.com
My biggest reason for wanting a mailing list versus a forum is
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
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
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 with
On Tue, Oct 18, 2011 at 9:46 AM, Simon Slavin slav...@bigfraud.org 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.
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 18 Oct 2011, at 2:52pm, Richard Hipp wrote:
On Tue, Oct 18, 2011 at 9:46 AM, Simon Slavin slav...@bigfraud.org 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 I'm
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
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
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
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
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
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
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 danny_sta...@hotmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent:
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
On Tue, Oct 18, 2011 at 8:04 AM, Igor Tandetnik itandet...@mvps.org wrote:
Frank Missel i...@missel.sg 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
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.
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 18/10/11 05:04, Igor Tandetnik wrote:
Frank Missel i...@missel.sg 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 noted
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
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 kit.sa...@gmail.com wrote:
2011/10/16 Fabian fabianpi...@gmail.com:
How can you limit a count-query? I tried:
SELECT COUNT(*) FROM table LIMIT 5000
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 delete all of
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 *
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
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 kit.sa...@gmail.com wrote:
2011/10/16 Fabian fabianpi...@gmail.com:
How can you limit a
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
On Tue, 18 Oct 2011 12:21:50 +, Jean-Denis MUYS
jdm...@kleegroup.com 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 threads with
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 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!
___
Igor Tandetnik wrote:
Barry1337 jmichiels...@gmail.com 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).
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-3070701sqlite3 this_is_a_new_db.db
SQLite version 3.7.7.1 2011-06-28 17:39:05
Enter .help for
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
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
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 18 October 2011 22:09, Fabian fabianpi...@gmail.com 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
WHERE
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
ORDER BY
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 fabianpi...@gmail.com wrote:
From: Fabian fabianpi...@gmail.com
Subject:
2011/10/19 Fabian fabianpi...@gmail.com
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
JOIN
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
On
On Tue, Oct 18, 2011 at 4:35 AM, Frank Missel i...@missel.sg 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 can be
On Tue, Oct 18, 2011 at 7:41 AM, John Drescher dresche...@gmail.com 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 I
63 matches
Mail list logo