[sqlite] Newbie question INSERT INTO on joined tables

2007-11-10 Thread mkaratha
Asume we have three tables: CREATE TABLE ARTIST (Artistname TEXT UNIQUE) CREATE TABLE SONG (SongTitle TEXT UNIQUE) CREATE CHART(Artist INTEGER, Song INTEGER) CHART.Artist should hold ARTIST.ROWID CHART.Song should hold SONG.ROWID Is it possible to do something like INSERT INTO CHART(Artist,

[sqlite] SQLite website

2007-11-10 Thread James Darpinian
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 (4)

[sqlite] Re: Newbie question INSERT INTO on joined tables

2007-11-10 Thread Igor Tandetnik
mkaratha [EMAIL PROTECTED] wrote: Asume we have three tables: CREATE TABLE ARTIST (Artistname TEXT UNIQUE) CREATE TABLE SONG (SongTitle TEXT UNIQUE) CREATE CHART(Artist INTEGER, Song INTEGER) CHART.Artist should hold ARTIST.ROWID CHART.Song should hold SONG.ROWID Is it possible to do

Re: [sqlite] SQLite website

2007-11-10 Thread Alberto Simões
I like (2), but I do not like much the dropdown menus. Cheers On Nov 10, 2007 8:49 AM, James Darpinian [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/

Re: [sqlite] Suggests for improving the SQLite website

2007-11-10 Thread John Stanton
Extend that to Chardonnay and Brie and you will be in business. Fred Williams wrote: Great idea! Why don't we give them little printable chits for free chips and beer as well?! Just the facts m'am. -- Jack Webb -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent:

Re: [sqlite] Problem creating extension for use with load_extension

2007-11-10 Thread Nuno Lucas
On Nov 9, 2007 10:19 PM, Bob Dankert [EMAIL PROTECTED] wrote: First off, I would like to say that although I have a lot of experience with programming, most of it is in C#/Java and I do not have a lot of experience with C++, although I have been working with SQLite for years. I am attempting

Re: [sqlite] SQLite website

2007-11-10 Thread drh
James Darpinian [EMAIL PROTECTED] wrote: I decided to try turning the page into a pure CSS layout with no tables. The result is available at http://www.cs.hmc.edu/~jdarpini/sqlite.html I tested it in IE6; 3 hopefully unobtrusive hacks were needed for it to render decently. When you click

Re: [sqlite] SQLite website

2007-11-10 Thread drh
[EMAIL PROTECTED] wrote: James Darpinian [EMAIL PROTECTED] wrote: I decided to try turning the page into a pure CSS layout with no tables. The result is available at http://www.cs.hmc.edu/~jdarpini/sqlite.html I tested it in IE6; 3 hopefully unobtrusive hacks were needed for it to

Re: [sqlite] SQLite website

2007-11-10 Thread Guy Hachlili
[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: James Darpinian [EMAIL PROTECTED] wrote: I decided to try turning the page into a pure CSS layout with no tables. The result is available at http://www.cs.hmc.edu/~jdarpini/sqlite.html I tested it in IE6; 3 hopefully unobtrusive hacks were

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

2007-11-10 Thread Don Lavelle
Hello, all, First, I apologize if the list has received multiple copies of e- mails from me. I'm using gmail, and gmail does strange things to e- mails when receiving through a POP client an e-mail that is from your own account. If anyone at all gets this, please reply to me personally,

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

2007-11-10 Thread Gerry Snyder
Don Lavelle wrote: Hello, all, First, I apologize if the list has received multiple copies of e-mails from me. I'm using gmail, and gmail does strange things to e-mails when receiving through a POP client an e-mail that is from your own account. Your email made it to the list. I also

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

2007-11-10 Thread Igor Tandetnik
Don Lavelle [EMAIL PROTECTED] wrote: Second, my question is about SQLite and multi-threading. Basically, the snippet below means that if I have multiple threads executing SQL statements, and I want at least one thread to execute multiple SQL statements as a single unit, I need to make sure only

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

2007-11-10 Thread Don Lavelle
Hey, all. Thanks Gerry and Thomas for your replies. Now I know that my e-mails are being sent and are being received. This seems like a very knowledgeable and supportive mailing list. I'm really looking forward to participating. On Nov 10, 2007, at 11:18 AM, Thomas Fjellstrom wrote:

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

2007-11-10 Thread Michael Hooker
1. tell my email client to add a copy of the sent message to the folder it belongs That is the most brilliant idea I've ever seen in my entire life. Forgive me for saying how sad. Surely there must have been something more inspiring than an e-mail trick? Or maybe you are very young :) If

Re: [sqlite] Suggests for improving the SQLite website

2007-11-10 Thread Don Lavelle
Hi, As a developer who is new to SQLite, I'll say that my initial experience with the web site was that it was very busy and confusing. The available documentation seems to have a great deal of useful content, but I think would be more useful if it were organized, say into