Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
On Mon, 2005-06-20 at 10:34 +1000, [EMAIL PROTECTED] wrote: > I too would be happy to pay for DVDs if they were to be made available. > Tyranny of distance prevents me from attending (Sydney, Australia based). > The same talk has been proposed for AUUG in Sydney in October. It has not yet been accepted, though. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
On Sun, 2005-06-19 at 20:15 -0400, Paul G wrote: > i have other obligations which will prevent me from being able to travel to > oregon at that time. > Essentially the same talk will likely be repeated at other venues. I will keep you posted. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
> I wonder if we need to talk to the O'Reilly's people about getting a > video made or at least allowing an attendee to make one. If someone has > a contact there, could they find out? Disclaimer: I don't work for O'Reilly, but I've written for them and will be at the OSCON as a presenter this year. They've taken to doing a lot more video-recording of sessions, but I don't know about tutorials. I can't find anything about it on the site, but there were cameras all over in 2003, when I last attended. I'll ask a friend at ORA and see what he says. Randy -- """ Randy J. RayCampbell, CAhttp://www.rjray.org [EMAIL PROTECTED] Silicon Valley Scale Modelers: http://www.svsm.org
Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
On Mon, 20 Jun 2005 10:34:05 +1000, [EMAIL PROTECTED] wrote: > I too would be happy to pay for DVDs if they were to be made available. > Tyranny of distance prevents me from attending (Sydney, Australia based). > > rayB At least you get staff discount and are already in sydney :-( ARM to SYD ~$300 SYD to LA ~$2000 LA to OR $??? fingerprinted at the airport for going to a 3hr tutorial - priceless But that's another story. I wonder if we need to talk to the O'Reilly's people about getting a video made or at least allowing an attendee to make one. If someone has a contact there, could they find out? klint. +---+-+ : Klint Gore: "Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---+-+
[sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
I too would be happy to pay for DVDs if they were to be made available. Tyranny of distance prevents me from attending (Sydney, Australia based). rayB |-+> | | "Paul G" | | | <[EMAIL PROTECTED]| | | rge.com> | | || | | 20/06/2005 10:15 | | | Please respond to| | | sqlite-users | | || |-+> >--| | | | To: | | cc: | | Subject: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite| >--| - Original Message - From: "Robert L Cochran" <[EMAIL PROTECTED]> To: Sent: Sunday, June 19, 2005 8:19 PM Subject: Re: [sqlite] Training opportunity: The Inner Workings Of SQLite > I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd > like to go to OSCON but the costs involved make it tough for me, > especially with 2 kids in university. ** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING * *** Confidentiality and Privilege Notice *** This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
- Original Message - From: "Robert L Cochran" <[EMAIL PROTECTED]> To: Sent: Sunday, June 19, 2005 8:19 PM Subject: Re: [sqlite] Training opportunity: The Inner Workings Of SQLite > I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd > like to go to OSCON but the costs involved make it tough for me, > especially with 2 kids in university. i'll second that. financial considerations are not an issue in my case, but i have other obligations which will prevent me from being able to travel to oregon at that time. -p
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd like to go to OSCON but the costs involved make it tough for me, especially with 2 kids in university. Bob Cochran Klint Gore wrote: On Sun, 19 Jun 2005 15:04:19 -0400, "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: I will be giving a 3-hour lecture on how SQLite works at the O'Reilly Open Source Conference in Portland, OR on 2005-Aug-01. Is there any chance that this will be webcast or recorded (slides/audio/video)? I found presentation notes on O'Reilly's website from previous events but can't see any from tutorials (and no audio yet). klint. +---+-+ : Klint Gore: "Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---+-+
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
On Sun, 19 Jun 2005 15:04:19 -0400, "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > I will be giving a 3-hour lecture on how SQLite works at > the O'Reilly Open Source Conference in Portland, OR on > 2005-Aug-01. Is there any chance that this will be webcast or recorded (slides/audio/video)? I found presentation notes on O'Reilly's website >from previous events but can't see any from tutorials (and no audio yet). klint. +---+-+ : Klint Gore: "Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---+-+
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
At 3:04 PM -0400 6/19/05, D. Richard Hipp wrote: I will be giving a 3-hour lecture on how SQLite works at the O'Reilly Open Source Conference in Portland, OR on 2005-Aug-01. Yep. Already signed up for your tutorial a couple weeks ago. Looking forward to it, and meeting you in person. On a separate note, anyone who plans to go to OSCON, try hard to register by June 20th (tomorrow) because after that all the prices go up by about 15% (you lose early reg prices) and you lose certain other things. Also, if any of you are from around south-west BC (eg, Victoria, Vancouver), please email me privately. -- Darren Duncan
[sqlite] Reading German Umlauts correct
Hello :) I'm reading Information from a SQLite database. But this Information contains German umlauts like ä, ö, ü. When I get these Information back in my Programm, these umlauts are unreadable. The ü for example is ü. The umlauts are stored in the Database correctly. Can somebody tell me, what I have to do, that the umlauts are displayes correctly exept a string manipulation after data-reading? Thanks in advance :) Daniel
Re: [sqlite] errors compiling with MS VC++ 6.0
Msvc 6 can do this if you use some features of c++, you have an early version, and haven't applied the service packs. You could test for memory errors using memtest86 or something similar (i believe it's memtest86.org?). On 6/18/05, Nuno Lucas <[EMAIL PROTECTED]> wrote: > [18-06-2005 0:54, Randall Fox escreveu] > >> When I then try to build the project, I get internal compiler errors. > >> Here are the first few lines of 35 errors it has: > > > > I have built v3.08 and v2.x using VC++ 6 and 7.x > > You do get a lot of casting warnings (which you can turn off/ignore), > > but I never got a compiler error. > > Same with me. > > > I would suspect it is something to do with your setup.. In fact I have > > only once seen an INTERNAL COMPILER ERROR when using VC++, and it was my > > fault. >
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
On Sun, 2005-06-19 at 21:29 +0200, Marcel Strittmatter wrote: > > http://conferences.oreillynet.com/oscon2005/ > > > > http://conferences.oreillynet.com/os2005/ is the correct url, isn't it? > Yes it is. Sorry for the typo. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Training opportunity: The Inner Workings Of SQLite
http://conferences.oreillynet.com/oscon2005/ http://conferences.oreillynet.com/os2005/ is the correct url, isn't it? Regards, Marcel
[sqlite] Training opportunity: The Inner Workings Of SQLite
I will be giving a 3-hour lecture on how SQLite works at the O'Reilly Open Source Conference in Portland, OR on 2005-Aug-01. This lecture will go into detail on how SQLite is put together and how SQL database work in general. The aim is to make attendees comfortable enough with the SQLite code base that they will know immediately where in the code to look for answers to questions about how the database operates and can confidently make any desired customizations and enhancements. The lecture is appropriate for: * Staff programmers at companies that use SQLite in their products and that want to be able to better support SQLite internally rather than relying on external support contracts or the good will of the community. * System architects who are considering the use of SQLite and who want a detailed under-the-hood look at SQLite to help them make an informed decision about whether SQLite is appropriate for their designs. * System programmers who want to be able to use SQLite more effectively by understanding what it does behind the scenes. * Developers of other database engines looking for ideas to help improve their own products * Anyone who is just curious about how SQL database engines work. For additional information visit http://conferences.oreillynet.com/oscon2005/ I hope to see many of you there. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Poor performance searching from multiple DBs
> > I have to search for field5 in some DB files (30 or more for a total of 50 GB > of space and 150 M of records ). > > The DBs have the same structure. > > I want to find the string (if exist) in all DBs. > > The query is like this: > > > > select * from main where field5= "AABBCCDD"; Did you put an index on field5?
[sqlite] Question on sqlite3_transfer_bindings()
Hi, This concerns SQLite3.2 I noticed that there's a function in the C API: int sqlite3_transfer_bindings(sqlite3_stmt*, sqlite3_stmt*); How does one use it? A comment in vdbeapi.c notes that "If the two statements contain a different number of bindings, then an SQLITE_ERROR is returned." Unfortunately, the implementation of the function is rather opaque to me at this point, so I really have no idea how to use it, and would like to find out. Thanks, Eugene Wee
