Grab the source tree via tar.gz file or cvs and run:
./configure
make test
or
make fulltest
To run just a single test file:
make testfixture# if not already built by make test
./testfixture test/select1.test
--- Ken <[EMAIL PROTECTED]> wrote:
> Sorry if this has been asked, but
--- Ken <[EMAIL PROTECTED]> wrote:
> Doing this in oracle results in an error:
>
> SQL> select max(addr_id), emp_id from z_address;
> select max(addr_id), emp_id from z_address
> *
> ERROR at line 1:
> ORA-00937: not a single-group group function
As expected.
> I think an
> On 1/14/08, mark pirogovsky <[EMAIL PROTECTED]> wrote:
> > Some relational (PostgreSQL for example) databases allow you to store
> > arbitrary array as a field in on row.
I was not aware of Postgres arrays or that it is part of the
SQL:1999 standard:
ng. -- Darren Duncan"
> >
> >I'm not asserting that you have to agree with the rationale, but did you
> >see and read the discussion that Joe Wilson pointed out to you?
> >
> >=
> >This issue is de
This issue is debated from time to time on the list:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg17769.html
The only other database that I'm aware of that supports selecting
non-aggregates that are not listed in GROUP BY is MySQL:
-- valid in sqlite and mysql, invalid in postgres
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> Sorry for the confusion.
No problem.
For what it's worth, I am also curious as to the final form of the
VM opcode transformation. The number of opcodes generated by the various
SQL statements seems to be roughly the same as the old scheme. At
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> There are people on this mailing list (ex: Joe Wilson) who appear
> to read every line of every change that we make to SQLite, within
> minutes of making them, and complain if we so much as misspell a
> word in a c
> create table stuff(a,b,c,d);
> insert into stuff values(1,2,3,4);
> create temp view v1 as select random()%100,
> random()%100, random()%1000, random()%1
> from stuff x, stuff y;
> insert into stuff select * from v1;
> insert into stuff select * from v1;
> insert into
There seems to be an issue with the sqlite cost heuristic with
an INDEX present on GROUP BY with certain types of WHERE clauses.
Given the database formed by running these statements:
create table stuff(a,b,c,d);
insert into stuff values(1,2,3,4);
create temp view v1 as select
Did you link with libc and libdl (-lc -ldl)?
Perhaps these functions are found in other libraries on that platform.
--- Gal Guttman <[EMAIL PROTECTED]> wrote:
> I'm trying to port the SQLite to VxWorks, and I'm getting the following
> messages:
>
> __divdi3, _rtld_dlsym, __umoddi3, __udivdi3,
;op = TK_UNION;
++ p->op = TK_ALL;
@@ -329 +334 @@
-+p->op = TK_UNION;
++p->op = TK_ALL;
@@ -339 +344 @@
-+p->op = TK_UNION;
++p->op = TK_ALL;
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> The attached patch implements the WHERE clause &q
The attached patch implements the WHERE clause "OR to UNION"
optimization as described in this post:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg09004.html
If the computed cost of the rewritten WHERE clause is lower than
the original query when indexes are taken into account, then
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> That being said, I've run into a huge roadblock. I'm using flex which
> produces lex.yy.c which includes and .
Which errno/unistd functions are actually used by the generated flex code?
getc, ungetc?
Maybe you can supply work-alike functions and
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> 1. My non-terminal token destructors are not getting called. The
> terminal destructors work fine, but none of my terminal tokens need
> destruction. Two of my non-terminals definitely require destruction. I
> have properly defined the %destructor
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> I think the source of my confusion is the fact that parse.h does not
> appear in any of the sqlite source tree. I found it now that I've run
> lemon on parse.y. However, I still can't find definitions for COMMA,
> SEMI, etc. They appear in the
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> %type multiselect_op {int}
> multiselect_op(A) ::= UNION(OP). {A = @OP;}
> multiselect_op(A) ::= UNION ALL. {A = TK_ALL;}
> multiselect_op(A) ::= EXCEPT|INTERSECT(OP). {A = @OP;}
>
> 1. What does the '@' symbol mean? At
--- [EMAIL PROTECTED] wrote:
> The problem is when inserting into large database that is
> indexed, the values being indexed are randomly distributed.
> So with each insert, SQLite has to seek to a new random
> place in the file to insert the new index entry there.
> It does not matter that pages
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > The reason why I asked is that I haven't had much luck with sqlite3
> > performance for databases larger than the size of RAM on my machine
> > regardless of PRAGMA settings.
>
> This is
've never tried, but I don't see much reason why I
> couldn't. I was just trying to make the point that labeling SQLite as
> "good ... for smaller databases" was not a slight.
>
>-T
>
> > -Original Message-
> > From: Joe Wilson [mailto:[EMAIL PROTEC
--- Tom Briggs <[EMAIL PROTECTED]> wrote:
>For clarity, my definition of small is about 200GB, so I'm not
> selling SQLite short here...
Are you able to get decent performance out of sqlite3 for a 200GB database?
How much RAM do you have on such a machine?
Be careful about speculative comments.
For all anyone knows, said product could use SQLite internally with
a couple of proprietary optimizations here and there that may make it
faster in specific cases.
The sqlite public domain license would allow that sort of thing.
It appears that Postgres, DB2 and SQL Server CE have issues with
certain types of alias expresssions in GROUP BY, while MySQL does
not.
Postgres will allow column aliases in GROUP BY - even aliases overriding
table column names - as long as every table column component of that
alias'
--- [EMAIL PROTECTED] wrote:
> I think those exceedingly rare programs that need a larger
> SQL statement length limit can include their own copy of
> sqlite3.c. I does not take up that much space, after all.
It's easy enough to recompile with the new setting once you're
aware of it. But
--- [EMAIL PROTECTED] wrote:
> Yes, this does create problems for .dump/.load in the shell.
> But, as has been pointed out, you can work around it using
> a compile-time switch:
>
> gcc -DSQLITE_MAX_SQL_LENGTH=10 shell.c sqlite3.c -o sqlite3
>
> I should probably modify the makefile
--- [EMAIL PROTECTED] wrote:
> The current name resolution rules for SQLite are that it
> first tries to resolve names using just the tables in the
> join. If that fails, then it looks at result column aliases.
> I think that approach continues to work on WHERE. But I need
> to reverse the
--- Jim Correia <[EMAIL PROTECTED]> wrote:
> I notice that SQLite 3.4.0 and later impose hard limits on some
> sizes. I'm running into a problem where a .dump/.load cycle fails on
> a database with columns that have blobs which are about 2MB in size.
>
> Looking at the source for 3.5.3 (I
--- Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 12/10/07, Robert Wishlaw <[EMAIL PROTECTED]> wrote:
>
> > IBM DB2 9.5
> >
> > select a AS "foo" from t1 union select b from t1 order by foo
> > SQL0206N "FOO" is not valid in the context where it is used.
> > SQLSTATE=42703
>
> The problem
--- [EMAIL PROTECTED] wrote:
> Dennis Cote <[EMAIL PROTECTED]> wrote:
> > [EMAIL PROTECTED] wrote:
> > >
> > > Can you please tell me what
> > > other databases do with this:
> > >
> > >CREATE TABLE t1(a,b,c);
> > >INSERT INTO t1 VALUES(1,2,4);
> > >SELECT a+b AS c FROM t1 WHERE c==4;
> >CREATE TABLE t1(a,b,c);
> >INSERT INTO t1 VALUES(1,2,4);
> >SELECT a+b AS c FROM t1 WHERE c=4;
>
> SQL Server returns a 3.
> ORACLE 9 returns a 3.
PostgreSQL 8.1.5 also returns a 3
Never
--- Robert Wishlaw <[EMAIL PROTECTED]> wrote:
> > >CREATE TABLE t1(a,b,c);
> IBM DB2 9.5
>
> INSERT INTO t1 VALUES(1,2,4);
> SELECT a+b AS c FROM t1 WHERE c=4;
>
> returns
>
> C
>
>3
>3
>3
>
>CREATE TABLE t1(a,b,c);
>INSERT INTO t1 VALUES(1,2,4);
>SELECT a+b AS c FROM t1 WHERE c==4;
MySQL 5.0.45:
create table t1(a INT, b INT, c INT);
INSERT INTO t1 VALUES(1,2,4);
SELECT a+b AS c FROM t1 WHERE c=4;
+--+
| c|
+--+
|3 |
+--+
> In the WHERE clause,
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > So few lines of code are changed by the patch that one could easily
> > add a new PRAGMA to have the old compound SELECT behavior to be the
> > default. If a database is explicitl
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> On Dec 7, 2007, at 11:47 PM, Joe Wilson wrote:
> >
> > I believe it makes compound query behavior more compatible with other
> > popular databases. It is mostly backwards compatible with the previous
> >
The attached sqlite 3.5.3 patch addresses several different compound
query column naming and resolving issues in ORDER BY and the SELECT
expression list mentioned in this ticket:
http://www.sqlite.org/cvstrac/tktview?tn=2822
(The exception being it does not support expressions in the ORDER
Regarding the DOS-like name, it may be the canonical name on Windows
for FAT/VFAT file systems. Is that what you're using?
I wonder if there's a hash collision in trying to get the file name
down to DOS 8.3 file name format.
Do you have many sqlite_* files in that directory?
Since the file
> Not in principle. But I think changes that break backwards
> compatibility would be more trouble than they're worth for
> something like this. In the absence of clearer guidance
> from sql-92, it's probably more important to be compatible
> with earlier sqlite versions than with mysql and
--- Dan <[EMAIL PROTECTED]> wrote:
> The "b" in the ORDER BY does not match "x1.b" because it is
> not a simple identifier (according to matchOrderbyToColumn()).
> It does not match either "" or " as ".
>
> After failing to find a match for "b" in the leftmost SELECT,
> SQLite searches the next
--- Sander Marechal <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > --- Sander Marechal <[EMAIL PROTECTED]> wrote:
> >> I ran into a problem when using SQLite from PHP. It appears that SQLite3
> >> does not support multi-row inserts in the form:
> >
--- Dan <[EMAIL PROTECTED]> wrote:
> i.e., if we have:
>
>CREATE TABLE x1(a, b, c);
>CREATE TABLE x2(a, b, c);
>
> then the following pairs of statements are equivalent:
...
>
>SELECT x1.b, a FROM x1 UNION SELECT a, b FROM x2 ORDER BY b;
>SELECT x1.b, a FROM x1 UNION SELECT a, b
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> Starting from version 3.4.2 I receive errors with queries like:
>
> SELECT a.field FROM a UNION ALL SELECT b.field FROM b ORDER BY a.field
> or even
> SELECT a.field FROM a UNION ALL SELECT a.field FROM a ORDER BY a.field
>
> error is:
> ORDER BY
--- Sander Marechal <[EMAIL PROTECTED]> wrote:
> I ran into a problem when using SQLite from PHP. It appears that SQLite3
> does not support multi-row inserts in the form:
>
> INSERT INTO (col1, col2) VALUES (1, 2), (3, 4)
>
> Is that correct?
That's correct.
> Will if be implemented in the
--- "A.J.Millan" <[EMAIL PROTECTED]> wrote:
> Joe Wilso wrote:
> >I would not bother with make install on MinGW - too much hassle -
> >just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually
> >to wherever you want to put it.
> Joe:So, do is there a libsqlite3.a file?Where is it?Thanks--
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > The comment probably should read: "Needed to enable pthread
> > > recursive mutexes *on Linux*".
> >
> > Or more specifically, on
--- [EMAIL PROTECTED] wrote:
> The comment probably should read: "Needed to enable pthread
> recursive mutexes *on Linux*".
Or more specifically, on old versions of Linux/GNU LIBC.
Have you seen any recent Linux distros that need this macro defined?
If so, maybe you could define it only for
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > delete from table1 where rowid in (
> > select table1.rowid
> >from table2
> > where table1.id = table2.id
> > and table2.otherid = 1
> > );
>
> Why not just
>
This may be better:
delete from table1 where rowid in (
select table1.rowid
from table2
where table1.id = table2.id
and table2.otherid = 1
);
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> How about:
>
> delete from table1 where id in (
>select table1.id
How about:
delete from table1 where id in (
select table1.id
from table1, table2
where table1.id = table2.id
and table2.otherid = 1
);
or this:
delete from table1 where rowid in (
select table1.rowid
from table1, table2
where table1.id = table2.id
I would not bother with make install on MinGW - too much hassle -
just copy out sqlite3.exe, libsqlite3.a and sqlite3.h manually
to wherever you want to put it.
Or just use the sqlite3.[ch] amalgamation and don't use libsqlite3.a
at all.
--- Bob Rossi <[EMAIL PROTECTED]> wrote:
> However, when
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> > paragraph ::= PARA text.
>
> I observed the new PARA terminal token (the clear separator!?). Unfortunately
> the lexer does not
> generate such a token. Paragraph repeats are also removed.
It was just an HTML-like example. I just wanted to
I compiled your program with MinGW gcc 3.4.2 on Windows with
sqlite-amalgamation-3_5_3.zip.
gcc -I. ged.c sqlite3.c -o ged.exe
It runs fine. If another sqlite3 process issues a query like:
select * from test;
while ged.exe is running, then ged.exe will exit with:
Creating 10
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> article ::= blocks.
>
> blocks ::= block.
> blocks ::= blocks block.
>
> block ::= heading.
> block ::= paragraph.
>
> heading ::= HEADING_START text HEADING_END.
> heading ::= HEADING_START text.
> heading ::= HEADING_START.
>
> paragraph ::= text
the
new preset behavior of "PRAGMA legacy_file_format;"?
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> When I compare the database bytes before and after the 2nd
> process VACUUM these bytes differ:
>
> zero-basedvalue value
> byte offset befor
File change counter?
432 5 Schema cookie?
474 1 meta[1], file format?
Doesn't byte offset 47 correspond to meta[1], the file format
of the schema layer?
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> Regarding http://www.s
Regarding http://www.sqlite.org/cvstrac/tktview?tn=2804 ...
I'm confused by the explanation.
Ignoring the PRAGMA for the moment, I was surprised that DESC
indexes were not available after a reconnect and VACUUM, as shown
in the example:
$ rm -f foo.db
$ ./sqlite3-3.5.3.bin foo.db
SQLite version
See also sqlite3_sql() if sqlite3_prepare_v2() or
sqlite3_prepare16_v2() was used.
http://www.sqlite.org/cvstrac/chngview?cn=4543
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Evans, Mark (Tandem) <[EMAIL PROTECTED]> wrote:
> > Would I be the first person to wish there were a way for, say, a
--- [EMAIL PROTECTED] wrote:
> DESC indices requires a backwards-compatible file format
> changes. Older versions of SQLite (prior to 3.3.0) cannot
> read or write databases that make use of DESC indicdes.
> To preserve compatibility, SQLite generates databases in
> the old format by default.
--- [EMAIL PROTECTED] wrote:
> SQLite version 3.5.3 is now up on the website:
> As always, please report any problems.
http://www.sqlite.org/releaselog/3_5_3.html
* DISTINCT can now make use of an INDEX in some cases.
--- Cariotoglou Mike <[EMAIL PROTECTED]> wrote:
> I wish I could "make it for Unix", but it uses a lot of windows-specific
> things, plus it is done
> in Delphi, and since
> Kylix is practically dead, wlll...
I didn't realize it was written in Delphi.
Yes, that would be a difficult port to
> the address follows, obfuscated for the usual reasons. to e-mail me, remove
> any
> numeric digits and punctuation from the address that follows, and do the
> obvious substitutions.
> hopefully spammers will not...
>
> m6_i_ke$car(ampersand)(dot)s#i#n#g#u#l#a#r(dot)gr
Nevermind the spammers
Why not try benchmarking the pragmas yourself and posting your
findings to the list?
http://www.sqlite.org/pragma.html
--- Scott Krig <[EMAIL PROTECTED]> wrote:
> Q1)) PRAGMA: Does anyone have experience and good results optimizing
> sqlite performance using PRAGMA's? If so, which ones, how
ever execute a free your dynamic memory is essentially contiguous.
>
> Joe Wilson wrote:
> > --- John Stanton <[EMAIL PROTECTED]> wrote:
> >
> >>Malloc is a concept implemented in various ways, some more successful
> >>than others but all of them hidden fr
Step 1: [Edit]
--- P Kishor <[EMAIL PROTECTED]> wrote:
> I would like to put up step-by-step instructions that would make sense
> to some one not so developer-like as I. How do I add stuff to the
> wiki? or, how do I get a login for the wiki to do so?
he following to my Makefile.in
>
> #TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1
> TCC += -DSQLITE_CORE=1
> TCC += -DSQLITE_ENABLE_FTS3=1
>
> and then added all the fts3 .c and .h files in the appropriate places
> as documented by Joe Wilson in another email. Then I did the following
It's most likely your bug. Just add some debug prints in your grammar
and tokenizer to see what's going on.
See also: ParseTrace() in http://www.hwaci.com/sw/lemon/lemon.html
--- Téragone <[EMAIL PROTECTED]> wrote:
> I have a problem with a rule of a small calculator which accept variables :
>
--- Ken <[EMAIL PROTECTED]> wrote:
> SQLite documentation indicates that "!" is a unary prefix operator. Is this
> a bug?
Yeah, the docs seem to indicate that SQLite supports '!'.
http://sqlite.org/lang_expr.html:
Supported unary prefix operators are these:
-+!~NOT
If
> I believe SQLite uses the same operator precedence as the SQL standard
> requires. If I am wrong about that, please correct me and I will
> change it.
As I interpret the SQL92 standard (which I believe SQLite tries to
follow), I think all comparison operators should have the same level
of
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> I was wrong. Turns out the bug was in the SQLite grammar
> file parse.y. It was assigning the same precedence to the
> ones-complement ~ operator and the NOT operator. But
> ~ should have higher precedence, it seems. Fixed by
> check-in
> > sqlite> select ~1 - ~5;
> > -8
> > sqlite> select (~1) - (~5);
> > 4
> >
>
> That would be a bug in lemon...
I guess adopting the same operator precedence as MySQL or MS SQL Server
is out of the question?
http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html
BINARY,
I'm having difficulty with Lemon's operator precedence.
Given SQLite's operator precedence table where it's presumably
interpreted with lowest precedence tokens at the top to the
highest precedence tokens at the bottom:
%left OR.
%left AND.
%right NOT.
%left IS MATCH LIKE_KW BETWEEN IN
--- John Stanton <[EMAIL PROTECTED]> wrote:
> One of the ignored points about thread usage is just how expensive are
> the synchronization mechanisms. It is a good idea to apply Occam's
> Razor to your design and eliminate unnecessary features and have a
> result which provides a better level
Threads are very much in the C tradition - minimalistic.
If you code in C you must know what you're doing anyway.
C is by no means a high level or safe language.
But until an automatically parallelizing safe language with
good performance becomes popular - this is what we got.
You just have to
--- Ken <[EMAIL PROTECTED]> wrote:
> In general I'v found that Thread cancellation is very painful,
> a simpler paradigm to utilize is the lock timeout with a Global
> variable status check.
Rather than check a global variable you could simply pass a null
event to the queue which instructs the
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
>
> On Nov 13, 2007, at 10:55 PM, Joe Wilson wrote:
>
> > http://home.pacbell.net/ouster/threads.pdf
>
> JO and I reach a similar conclusion but by different
> reasoning, I think.
I like
http://home.pacbell.net/ouster/threads.pdf
--- Richard Klein <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > What? And encourage people to write multitheaded programs?
> > Not likely...
>
> I've been meaning to ask ... When you say that multiple threads
> are evil, do you mean "as
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > You might mention the library is multi-thread safe in the Features
> > section of http://www.sqlite.org/about.html
>
> What? And encourage people to write multitheaded programs?
> Not likely
You might mention the library is multi-thread safe in the Features
section of http://www.sqlite.org/about.html
Do you have a page that describes all the SQLITE_OMIT_* ifdefs
and compile options?
Never
Attached patch allows DISTINCT queries to take advantage of an appropriate
INDEX, if present.
For example, given:
CREATE TABLE foo(a, b);
CREATE INDEX foo_b on foo(b);
explain query plan select distinct b from foo;
sqlite 3.5.2 returns:
0|0|TABLE foo
and sqlite 3.5.2 + patch returns:
--- P Kishor <[EMAIL PROTECTED]> wrote:
> On 11/9/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- James Dennett <[EMAIL PROTECTED]> wrote:
> >
> > > Joe Wilson wrote:
> > > > Also, non-technical people would be a better judge of which webs
--- James Dennett <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > Also, non-technical people would be a better judge of which website
> > design is appealing.
>
> Appealing *to* non-technical people? Why would a website on an embedded
> database wish to appeal
--- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
>
> I hope this doesn't offend, but perhaps the best solution is to outsource
> the website to someone or a company that specializes in websites and design
> (with your stated simplicity goals in mind of course). We certainly
> wouldn't want a
o. There's a minor glitch on Firefox - increasing font size
> causes the right side of menu bar to be whited out but display when
> cursor hovers. Is this the bug Joe refers to below?
>
> Mark
>
> > -Original Message-
> > From: Joe Wilson [mailto:[EMAIL PROTECTED
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> >>(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
> >
> > In Firefox 2.0.0.8, press "CTRL +" a couple of times to see the render
> > problem. If I press &q
--- [EMAIL PROTECTED] wrote:
> I put up 4 variations. Please, everyone, offer your opinions:
>
>(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
>(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
>(3) http://sqlite.hwaci.com/v3/ CSS menus with square
--- [EMAIL PROTECTED] wrote:
> I don't think the extra bandwidth is an issue. Dan points out that
> if you put the CSS in a separate file, then sometimes a browser
> will render the page without CSS, then when the CSS arrives a
> fraction of a second later, everything shifts.
That's not the case
--- James Dennett <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > No need to say it's stable or recommended - it's assumed. Otherwise it
> > wouldn't appear on the home page.
>
> I disagree. 3.5.0 appeared, even though discussion was that it was
> relati
--- [EMAIL PROTECTED] wrote:
> There is a new look up on the demo site at
>
>http://sqlite.hwaci.com/
>
> It looks good on Firefox and Safari, but IE6 renders
The 'T' in 'SUPPORT' in the horizontal toolbar is cut off in my Linux
Firefox 2.0.0.8 browser. I have a screen resolution of
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > The font change to
> >
> > font-family: "Verdana" "sans-serif";
> >
> > makes a huge difference - much more professional looking.
> >
>
&g
--- bash <[EMAIL PROTECTED]> wrote:
> I am owner of web site with ~ 15k uniq visitors/day and I can say this
> is not really true.
> For example this is statistics from google analytics:
> 1.1024x76842.51%
> 2.1280x1024 27.73%
> 3.1280x80010.43%
> 4.1152x864
The font change to
font-family: "Verdana" "sans-serif";
makes a huge difference - much more professional looking.
--- [EMAIL PROTECTED] wrote:
> A rough prototype of what a revised website might look like
> can be seen at
>
> http://sqlite.hwaci.com/
> > One more thing, did raising the limit on the number of pages SQLITE
> > can cache internally have any effect?
>
> I just tried (hadn't noticed that option before) to go from 2000 to 4000
> and 8000, without noticing any difference. I might try next week to
> raise the page size to 50k and see
--- [EMAIL PROTECTED] wrote:
> A rough prototype of what a revised website might look like
> can be seen at
>
> http://sqlite.hwaci.com/
Instead of:
Current Status
As of 2007-11-05 20:49:21 UTC, version 3.5.2 of SQLite is stable.
There are no known issues effecting database
--- PokerAce <[EMAIL PROTECTED]> wrote:
> "Are you certain it's sqlite RAM, and not your application?"
>
> Yes, we are also testing PostgreSQL and MySQL and the application memory
> with those stays < 20 mb.
You're not using the sqlite3 API directly, are you?
If that's the case, I think your
--- [EMAIL PROTECTED] wrote:
> We are looking at renovating the design of the SQLite
> website and would love to have suggestions from the
> community. If you have any ideas on how to improve
> the SQLite website, please constribute either to the
> mailing list or directly to me.
Prize giveaway
--- PokerAce <[EMAIL PROTECTED]> wrote:
> I'm trying to see if SQLite is suitable for large databases ( > 1 gb,
> millions of rows in each of several tables). Initially, the memory usage
> was outrageous (~ 500 mb for a 1.3 gb db), but I got that down to < 30 mb by
> setting the cache size to 0
This disk cache effect is pretty well known on this list.
Mozilla/Firefox also uses a similar technique for its sqlite database:
http://developer.mozilla.org/en/docs/Storage:Performance#Priming_the_cache
They go to the extra step of populating the sqlite page cache with
some custom code:
--- Felix <[EMAIL PROTECTED]> wrote:
> I would use sqlite in an embedded DOS system ( intel 16 bits processor ) .
>
> Do you think that is possible or sqlite work only on 32/64 bits systems?
I could be wrong, but I think sqlite expects that int and pointers are
at least 32 bit.
See if you can
--- "Maxim V. Shiyanovsky" <[EMAIL PROTECTED]> wrote:
> Suppose I have simple table:
>
> CREATE TABLE [profile_data] (
> [profile_id] INTEGER,
> [version] INTEGER);
>
> CREATE INDEX [by_id] ON [profile_data] ([id]);
>
> Why
>
> sqlite> explain query plan
>...> select
It works in a Linux xterm.
There's probably some UTF or codepage issue with the Windows console.
Try using another command-line shell.
--- Robert Wishlaw <[EMAIL PROTECTED]> wrote:
> Using sqlite 3.5.2 on Windows XP, I have a textblob.csv file
>
> 192,C0,À0,À0
> 193,C1,Á0,Á0
> 254,FE,þ0,þ0
>
--- Aladdin Lampé <[EMAIL PROTECTED]> wrote:
> In other terms, which built-in functions can I safely remove (or rename)
> without getting
> internal errors?
> I hope I can remove or rename all of them without compilation or execution
> errors... What do you
> think?
It depends on your use.
Some
> I have some sql statement (for example Select col1, col2... from
> some_table left join some_table_2 on...
> where ...)
> and I want get information about this statement -- column's list, where
> clause, table's list etc in some structure (parse tree).
If you compile with
1 - 100 of 709 matches
Mail list logo