Re: [sqlite] Re: Performance tuning, and other (silly?) SQLite questions.

2007-11-19 Thread James Steward
On Mon, 2007-11-19 at 18:14 -0500, Igor Tandetnik wrote: > James Steward > wrote: > > db eval {CREATE TABLE position(\ > > position_id INTEGER PRIMARY_KEY, \ > > odo INTEGER, \ > > time CURRENT_TIMESTAMP);} > > You probably meant > > -- note no unders

Re: [sqlite] Where is sqlite3.h?

2007-11-19 Thread James Steward
On Tue, 2007-11-20 at 14:23 +1100, James Steward wrote: > Any hints? I answer my own question. I found it in the preprocessed source zip file. I hope this will do... Cheerio. JS. - To unsubscribe, send em

[sqlite] Where is sqlite3.h?

2007-11-19 Thread James Steward
Hi, I wanted to build a C app, copied the example C code from the Documentation on the web site, and downloaded the prebuilt binaries. There's no header in with the dll and def (for crummy windows). I tried building the source with MSYS/MinGW, but it didn't work out of the box. Any hints?

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

2007-11-20 Thread James Steward
> Michael Ruck <[EMAIL PROTECTED]> wrote: > > I know that a natural join exists, but it is not automatic as > it seems to be in MySQL. Thanks , and thanks to all who replied to my questions. I've been testing SQLite's speed, for inserting the type of data I gather from the field. I've tried

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

2007-11-20 Thread James Steward
Dennis Cote <[EMAIL PROTECTED]> wrote: Hi Dennis, > You haven't said what your system is, but to record your data in real > time you will need to insert about 70K records per second. That is high, > > but not impossible for SQLite, so I wouldn't give up yet. I have had > SQLite doing 60K

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

2007-11-20 Thread James Steward
> James Steward <[EMAIL PROTECTED]> wrote: > > Dennis Cote <[EMAIL PROTECTED]> wrote: > > > You have said you tried both the TCL and C APIs, but you didn't say if > > you were using prepared insert statements in the C API. If not, that > > will save t

Re: [sqlite] Performance tuning, and other (silly?) SQLitequestions.

2007-11-20 Thread James Steward
> Ken <[EMAIL PROTECTED]> wrote: > > Can you do a test load to a memory database. What is the performance > (row/sec) of your data using an in memory database? I tried a RAMDisk on Windows. I haven't tried at home on Linux. I'm not sure if I tried the C API to RAMDisk database combination,

Re: [sqlite] Seg fault after calling sqlite3_exec while running under cygwin

2007-12-10 Thread James Steward
On Mon, 2007-12-10 at 20:37 -0700, John Williams wrote: > Since I'm not really sure where the problem is I've attached a zip of my c > files. AptAssist.c is my main file and contains the full program. > Temp.cis a simple pull out of the problem function. I didn't get an attachment. Did anyone?

Re: [sqlite] DeviceSQL

2007-12-13 Thread James Steward
steveweick wrote: Richard has it right this time. Today DeviceSQL uses no SQLite code. One of the things we might consider is bolting the SQLite parser/front end to our table engine, in theory to get the both worlds. Just an idea at the moment. Such an interesting discussion to be

Re: [sqlite] DeviceSQL

2007-12-13 Thread James Steward
steveweick wrote: Do you need to read the code to verify reliability as your next few sentences seems to imply? For that to be true, the reader would have to be able to spot bugs through inspection. While that is certainly one way to spot bugs, I seriously doubt that any shop would rely on code

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread James Steward
On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: > A hundred or so Visual Basic programmers are cheaper to replace and > "maintain" than one good Delphi/C++ programmer. ;-) That is the reason > management likes "Visual ." Been there, learned that. Hire the > staff from the largest

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread James Steward
On Mon, 2007-12-17 at 19:22 -0500, John Elrick wrote: > John Elrick wrote: > > SNIP > > When you can hire a forklift operator to program (well, that is), > > > To avoid a misunderstanding...I mean - right off the forklift. I'm sure > anyone with the proper motivation can learn to program, but

RE: [sqlite] Encryption?

2007-12-19 Thread James Steward
On Wed, 2007-12-19 at 16:10 -0800, James Dennett wrote: > > -Original Message- > > From: Jason Tudor [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 19, 2007 4:06 PM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] Encryption? > > > > Is there any encryption functionality