Re: [sqlite] Suggests for improving the SQLite website

2007-11-11 Thread Jarl Friis
Gerry Snyder <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> >> >> A rough prototype of what a revised website might look like >> can be seen at >> >> http://sqlite.hwaci.com/ > Short, simple, and sweet. I like it. > > My only specific comment was going to be a request to make the

Re: [sqlite] Suggests for improving the SQLite website

2007-11-11 Thread Jarl Friis
"A.J.Millan" <[EMAIL PROTECTED]> writes: >> Regarding the basic "look" of the site, we were considering >> using a style similar to the once found at ActiveState >> >> http://www.activestate.com/ >> > > However the tendency in computers screen is wider than until > now. Today the standard is abo

Re: [sqlite] Suggests for improving the SQLite website

2007-11-11 Thread Jarl Friis
[EMAIL PROTECTED] writes: > 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 corners >

Re: [sqlite] Suggests for improving the SQLite website

2007-11-11 Thread Jarl Friis
"Trevor Talbot" <[EMAIL PROTECTED]> writes: > (2) and (3) feel heavy/slow, and pulldown menus are irritating to > navigate. They also do not render correctly with larger font sizes. Agree, pulldown menus are irritating. Jarl

Re: [sqlite] Re: is safe to use the same database connection at the same time in more than one thread?

2007-11-11 Thread Don Lavelle
Hey everyone, Thanks for your reply, Igor! I've got two more questions, now. Is it also true that if a select statement executes (in any thread) before #50 in my example below, it could return data that aren't durable? My second question is more complicated. How expensive is opening a

Re: [sqlite] SQLite website

2007-11-11 Thread James Darpinian
On Nov 10, 2007 5:54 AM, <[EMAIL PROTECTED]> wrote: > When you click on one of the links on the menu bar, afterwards > the font color is almost identical to the background color > so you can no longer read the text. Can you suggest a fix > for this problem? I uploaded a new version with explicit

Re: [sqlite] Suggests for improving the SQLite website

2007-11-11 Thread Robert Wishlaw
Reduce the size of the logo. The proposed combined size of the logo and Navbar takes up too much of the page. I like frames so that the Navbar is always visible. This is a real convenience with long pages. If you don't like frames then another alternative is to have the Navbar at the top and bott

[sqlite] Odd behaviour on UPDATE

2007-11-11 Thread papillon
Hello everybody, I'm quite new to sqlite and I have a question about an odd behaviour. I'm using MSVC2003 and latest sqlite version. I update a record with the following code: rc = sqlite3_exec(waypoint_db, sqlstring, callback, 0, &zErrMsg); function return SQLITE_OK. I use a SELECT to

[sqlite] Re: Odd behaviour on UPDATE

2007-11-11 Thread Igor Tandetnik
papillon <[EMAIL PROTECTED]> wrote: I update a record with the following code: rc = sqlite3_exec(waypoint_db, sqlstring, callback, 0, &zErrMsg); function return SQLITE_OK. I use a SELECT to see the records and yes, the above records seems to be updated, it shows the new value. I quit the appl

Re: [sqlite] Odd behaviour on UPDATE

2007-11-11 Thread papillon
Hi Igor, I'm quite sure I did not. By the way, I even tried the following code (that should BEGIN and COMMIT changes), but result is the same. char * errors; sqlite3_exec( waypoint_db, "BEGIN", 0, 0, 0 ); int ret = sqlite3_exec( waypoint_db, sqlstring, 0, 0, &errors ); while( ret != SQLITE_OK

[sqlite] PATCH: allow DISTINCT queries to use an INDEX, if present

2007-11-11 Thread Joe Wilson
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:

[sqlite] One line batch file?

2007-11-11 Thread Owen Watson
I'd like to have a one line batch file: sqlite3 test 'insert into testable values ('value1','value2')' but the few variants of this I've tried don't work. I've seen and understood the batch file that calls another text file approach but I was wondering if I could avoid this overhead for a one-li