Re: [sqlite] Suggests for improving the SQLite website
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 "Non-Technical," "Using SQLite," and "Development of SQLIte." As for my impression of the home page, I found the quick feature list very useful. It told me everything I needed to know. As an improvement, I'd put the non-technical stuff higher up in the list, though. Even as a developer, until I saw that 1) it was free, 2) it was zero-config, and 3) it was well tested, I didn't really care that transactions were ACID or that it was written in ANSI-C. After I confirmed 1, 2, and 3, all that other stuff became a lot more interesting. The new home page seems to sparse to me. I also like a one-column approach similar to the new sample web pages. The two column approach seems very busy, and I'm not sure where to look. As a native English reader, my mind wants to start on the left of the existing web site, but the highly structured content of the right-most column draws me there. Those are my three pennies. Cheers, Don On Nov 9, 2007, at 6:51 PM, John Stanton wrote: How about having adding a social networking capability so that non- technical people will have a reason to use the website. You cannot expect to attract them with a frugal and highly functional embedded database library. That is hilarious. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?
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 you don't mind being patient all the list messages appear neatly sorted at the URL below in due course, and you'll see what has arrived as well as what has been sent: http://www.mail-archive.com/sqlite-users%40sqlite.org/ Michael Hooker On 10/11/2007 18:25:38, Don Lavelle ([EMAIL PROTECTED]) wrote: 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: > 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. I will look into figuring it out with my mail client. Regards, Don - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?
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: 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. I will look into figuring it out with my mail client. Regards, Don - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: is safe to use the same database connection at the same time in more than one thread?
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 one thread at a time is executing SQL, or the SQL statements that are outside of the thread may get lumped in with the transaction. As in, 10. thread 1: shut off auto commit 20. thread 1: SQL statement 1 succeeds 30. thread 2: independent SQL statement succeeds 40. thread 1: SQL statement 2 fails 50. thread 1: rollback, taking with it thread 2's effect This is correct, assuming both threads are using the same database connection. The behavior would be different if each thread opens its own connection (specifically, the second connection could not successfully commit a change at #30). Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?
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 have seen that gmail does not send to me a message I sent to the list. Looking into that is on my (long) list of things to do some day. Sorry I can't answer your SQLite question. Gerry PS You can look at one of the email archives (links at http://sqlite.org/support.html ) to see if a posted message was received. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?
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, even if to say, "yes, I got your e-mail, even though your copy from the mailing list isn't getting to you." I don't mind my inbox being flooded ;-) I had tried to post a multi-threading question before, but 1) I never got the e-mail back (gmail is strange), and 2) I never saw a reply (perhaps the e-mail never got to you.) 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 one thread at a time is executing SQL, or the SQL statements that are outside of the thread may get lumped in with the transaction. As in, 10. thread 1: shut off auto commit 20. thread 1: SQL statement 1 succeeds 30. thread 2: independent SQL statement succeeds 40. thread 1: SQL statement 2 fails 50. thread 1: rollback, taking with it thread 2's effect If that's the case, it also answers my previous, unposted question about sqlite3_changes, which was, "what would sqlite3_changes return if it were called at line 35 in the above sequence?" Regards, Don Lavelle On Nov 8, 2007, at 9:23 AM, Salles, Joaquim Campos wrote: I found two e-mails (bellow) that I think give the answer: yes is safe to use the same database connection, but is not work in the way that I imagined. "Transaction control is per connection, not per thread." (Igor Tandetnik) or "That connection can then be used across threads, but it is for all intents and purposes a single line of communication with a database (using it twice at the same time doesn't somehow multiply that relationship)". (Stephan Beal) - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite website
[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 needed for it to render decently.
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 should have said that this problem is in IE6 only
Add to the style sheet:
.toolbar A:visited {
COLOR: blue;
}
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] SQLite website
[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 render decently. > > > > 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 should have said that this problem is in IE6 only -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite website
"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 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? -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem creating extension for use with load_extension
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 to create my own extension to use with SQLite but am
> having problems. Using the command line interface, when I load the
> extension I get the following:
>
> SQLite version 3.5.2
> Enter ".help" for instructions
> sqlite> select load_extension('mydblib.dll');
> SQL error: The specified procedure could not be found.
>
Seems like you didn't enable the extension loading mechanism. It
defaults to disabled for security reasons.
Check the wiki page about the SQLITE_OMIT_LOAD_EXTENSION define:
* http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Suggests for improving the SQLite website
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: Friday, November 09, 2007 5:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Suggests for improving the SQLite website James Dennett wrote: Joe Wilson wrote: --- "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 graphic designer hacking away at the SQLite engine, so isn't the reverse also true? Sam +1 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 primarily to such an audience? I'd think it would be best to present information in a way that appeals to its likely viewers. -- James How about having adding a social networking capability so that non-technical people will have a reason to use the website. You cannot expect to attract them with a frugal and highly functional embedded database library. -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite website
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/ CSS menus with rounded corners > >(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners > >(4) http://sqlite.hwaci.com/v4/ CSS font specification only > > I like option 2 the best; it looks modern and simple. However, I > don't think the menus are necessary; the toolbar is fine without them. > 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. > > James > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Alberto Simões - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: Newbie question "INSERT INTO" on joined tables
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 something like "INSERT INTO CHART(Artist, Song)
Values('Abba', 'Dancing Queen') + something to obtain the result
1. Insert (if not exists) 'Abba' into ARTIST
2. Insert (if not exists) 'Dancing Queen' into SONG
3. Insert into CHART with corresponding ROWID’s
sqlite3_changes() lets you know whether an insert has taken place.
sqlite3_last_insert_rowid() give you the ID of the most recently
inserted row.
Igor Tandetnik
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] SQLite website
> 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) http://sqlite.hwaci.com/v4/ CSS font specification only I like option 2 the best; it looks modern and simple. However, I don't think the menus are necessary; the toolbar is fine without them. 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. James - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Newbie question "INSERT INTO" on joined tables
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, Song)
Values('Abba', 'Dancing Queen') + something to obtain the result
1. Insert (if not exists) 'Abba' into ARTIST
2. Insert (if not exists) 'Dancing Queen' into SONG
3. Insert into CHART with corresponding ROWID’s
Michael from Sweden
--
View this message in context:
http://www.nabble.com/Newbie-question-%22INSERT-INTO%22-on-joined-tables-tf4781848.html#a13680160
Sent from the SQLite mailing list archive at Nabble.com.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
