Re: [sqlite] Copying Records from one table to another

2007-11-15 Thread jose isaias cabrera
From: "John Elrick"... jose isaias cabrera wrote: Greetings. I searched the mail archive and I can not find something related to this. I know it is easy, but... What I need is to copy a record from one Table1 to Table2 of the same DB. I tried, insert into LSOpenJobs select * where id

Re: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Darren Duncan
At 1:40 AM + 11/14/07, [EMAIL PROTECTED] wrote: The new look for the SQLite website is now in place, if you haven't already noticed: http://www.sqlite.org/ The feedback from this mailing list has so far been very helpful. Please don't stop offering suggestions. So I just looked at

[sqlite] Copying Records from one table to another

2007-11-15 Thread jose isaias cabrera
Greetings. I searched the mail archive and I can not find something related to this. I know it is easy, but... What I need is to copy a record from one Table1 to Table2 of the same DB. I tried, insert into LSOpenJobs select * where id = 530 from LSOpenSubProjects; I would like to copy

RE: [sqlite] Suggests for improving the SQLite website

2007-11-15 Thread Evans, Mark (Tandem)
Just visited the new front page. I like it a lot. But one of the crown jewel features (at least to me) is buried in the fine print: Virtual Tables. Is this an oversight? I would at least put a blurb on the Features or Distinctive Features page unless there's a motivation not to do so

Re: [sqlite] Copying Records from one table to another

2007-11-15 Thread John Elrick
jose isaias cabrera wrote: Greetings. I searched the mail archive and I can not find something related to this. I know it is easy, but... What I need is to copy a record from one Table1 to Table2 of the same DB. I tried, insert into LSOpenJobs select * where id = 530 from

RE: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Noah Hart
Richard, I like the new website and layout, but find the initial page much to wordy for an initial screen. Just a suggestion: Create lots of white space to the left of the Current Status/Common Links box and leave the exiting paragraphs, but move them down visually Something like the

Re: [sqlite] Suggests for improving the SQLite website

2007-11-15 Thread John Stanton
The latest sqlite page renders nicely on a wide screen and loads in 860mS on my machine and transfers a total of 16KB. It looks clean, terse, uncluttered and business-like and free of trivia. Just the presentation I relish when searching for information. Direct and to the point. Several

Re: [sqlite] Suggests for improving the SQLite website

2007-11-15 Thread Ken
Some suggestions: Under the SQL Language page, Split the page "expressions" into two, one for the sql expressions and one for SQL functions. It was not immediately obvious what sql functions were supported nor where to find them. Spelling/Grammar Home Page: second to last paragraph

Re: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread John Stanton
James Dennett wrote: Dennis Cote wrote: Dr Gerard Hammond wrote: The first few words sound incorrect to me. Shouldn't it be. "SQLite is an in-process" and even then I don't know what 'in-process' actually means. I agree with this completely. I can't say I have ever heard the term

RE: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread James Dennett
Dennis Cote wrote: > > Dr Gerard Hammond wrote: > > The first few words sound incorrect to me. > > > > Shouldn't it be. > > > > "SQLite is an in-process" > > > > and even then I don't know what 'in-process' actually means. > > > > > I agree with this completely. > > I can't say I have ever

Re: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Dennis Cote <[EMAIL PROTECTED]> wrote: 5) There is no link to the CVStrac home page on the navigation bar Developers Richard, OK. I see that now. When I saw the Developers link I thought it was a link to the bios and pictures etc. for you and the

Re: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Dennis Cote
Dr Gerard Hammond wrote: The first few words sound incorrect to me. Shouldn't it be. "SQLite is an in-process" and even then I don't know what 'in-process' actually means. I agree with this completely. I can't say I have ever heard the term in-process before. Perhaps it is database

RE: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Samuel R. Neff
The vast majority of database engines run as separate services on a machine and clients communicate with them through a network protocol. SQLite runs in the same process as the host application either as a statically linked or a dynamically loaded library and shares memory space of the client.

Re: [sqlite] BLOB data performance?

2007-11-15 Thread Dimitris Servis
Hi all, I don't want to drive anyone away from SQLite (don't think that I can anyway :-)) but a good solution for storing large amounts of data is HDF5. HTH -- ds 2007/11/15, Roger Binns <[EMAIL PROTECTED]>: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Asif Lodhi wrote: > >

Re: [sqlite] Request for help with the SQLite Website

2007-11-15 Thread Daniel Önnerby
I guess letting developers having opinions about the website is like to many chefs making a soup. Everyone have different opinions. I like the new design but have a small comment about the rounded corners in the menu. If there are rounded corners in the menu - the content below the menu