Re: [sqlite] Documentation - Downloadable?

A project for you. Pick up the documentation, transform it to PDF and make it an Sqlite contribution on sqlite.org. Olaf Beckman Lapré wrote: Hi, I second this request. I've been wondering for a long time why the documentation isn't available off-line. How about making the documentation

Re: [sqlite] trigger a non-database event in sqlite

d_maniger06 wrote: ok..i have this sample code: [code] void printIfInsert() { printf( "Insertion was done in t1\n" ); } void createTrigger( sqlite** db, sqlite_vm** pvm ) { char* errMsg; const char** psql = NULL; const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2

Re: [sqlite] Documentation - Downloadable?

Hi, I second this request. I've been wondering for a long time why the documentation isn't available off-line. How about making the documentation available as a PDF file? Kind regards, Olaf - Original Message - From: "Andrew Wiley" <[EMAIL PROTECTED]> To:

[sqlite] unsigned integer, text, tutorial, and keys

Hello, I have few questions on SQLite3, i'm using it through pdo with php5. - is unsigned int available? - can we insert a row with an autoinc primary key, so I don't need to provide it when I insert a new row? - if NULL values are possible for primary keys, then autoinc key can't have this

Re: [sqlite] trigger a non-database event in sqlite

ok..i have this sample code: [code] void printIfInsert() { printf( "Insertion was done in t1\n" ); } void createTrigger( sqlite** db, sqlite_vm** pvm ) { char* errMsg; const char** psql = NULL; const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2 BEGIN

Re: [sqlite] Documentation - Downloadable?

Andrew Wiley wrote: I've been using SQLite on several minor projects now (it makes File IO so easy), and the one suggestion I would make would be to make the documentation (api reference) downloadable. It would be very handy for myself and probably many others to be able to download the API

[sqlite] Documentation - Downloadable?

I've been using SQLite on several minor projects now (it makes File IO so easy), and the one suggestion I would make would be to make the documentation (api reference) downloadable. It would be very handy for myself and probably many others to be able to download the API reference and keep it with

Re: [sqlite] How to implement xLock()?

Joe Wilson wrote: --- Richard Klein <[EMAIL PROTECTED]> wrote: Joe Wilson wrote: --- Richard Klein <[EMAIL PROTECTED]> wrote: I should be able to use your test suite s/your/the/ Sqlite and its test suite are drh's work. Hmm ... Somehow I got the impression

[sqlite] tool to compare two database(content and schema)

Hi All, Do you know any tool to compare two databases both schema and content of the tables. Thanks, Jodie __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] LIKE operator syntax for white space

How do I filter out records that contain WHITE SPACE in a field or have this field empty? For example: select * from mytable where fld <> "" and fld LIKE . Do you mean "contain ONLY white space"? Are you after this? select * from mytable where trim(fld) <> ""

[sqlite] LIKE operator syntax for white space

How do I filter out records that contain WHITE SPACE in a field or have this field empty? For example: select * from mytable where fld <> "" and fld LIKE . - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

Same problem, just a different thought process. The .dump format could me made to use a CSV making it more compact. A new command ".imp" command could be made to use my proposed array based processing. And also use DRH's recommendation to use a TXN Unfortunately, .dump is generic for

Re: [sqlite] How to implement xLock()?

--- Richard Klein <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > --- Richard Klein <[EMAIL PROTECTED]> wrote: > >> I should be able to use your test suite > > > > s/your/the/ > > Sqlite and its test suite are drh's work. > > Hmm ... Somehow I got the impression that the team of SQLite >

Re: [sqlite] How to implement xLock()?

Joe Wilson wrote: --- Richard Klein <[EMAIL PROTECTED]> wrote: I should be able to use your test suite s/your/the/ Sqlite and its test suite are drh's work. Hmm ... Somehow I got the impression that the team of SQLite core developers had expanded to include a few folks in addition to drh,

[sqlite] sqlite3_changes and multithreading

Hey all, I'm new to sqlite3, but it seems really cool, and I'm excited to be using it in a project. I'm also new to database programming in C. I've got a question, though. (I'm using SQLite 3.5.1 and C.) If I've got my database pointer, sqlite3 *database, and I have two threads that

[sqlite] [ot] Free formatter?

Does anyone know of a good sql formatter that's compatible with sqlite3's syntax? I'm looking for a command line-based tool with sources that can be cross-compiled to the usual suspects (Win32, Unix, Mac OS X). - To

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

You're solving a different problem. Better to stick with the existing API for what you're proposing. I just want a faster, more compact and flexible SQL INSERT command from the command-line without resorting to custom programming. --- Ken <[EMAIL PROTECTED]> wrote: > Joe, > > that is quite

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > FYI: When this multi-row-insert patch is combined with today's CVS > > OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), > > the multi-row ASCII INSERT statements are as much as 25% faster than > >

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

Joe Wilson <[EMAIL PROTECTED]> wrote: > FYI: When this multi-row-insert patch is combined with today's CVS > OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), > the multi-row ASCII INSERT statements are as much as 25% faster than > the equivalent number of traditional

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

Joe, that is quite interesting performance gain... One thing that might help with this "multi row" insert is the concept of binding address variables. IMHO, the binding functions (sqlite_bind_int etc) should allow one to permanently bind an address to a placeholder. Then you multi row insert

Re: [sqlite] SQLite 3.5.1 linking issues due recent changes

2007/10/23, Joe Wilson <[EMAIL PROTECTED]>: > --- Klemens Friedl <[EMAIL PROTECTED]> wrote: > > 2007/10/23, Joe Wilson <[EMAIL PROTECTED]>: > > > --- Klemens Friedl <[EMAIL PROTECTED]> wrote: > > > > Has someone already used mingw to build > > > http://www.sqlite.org/cvstrac/tktview?tn=931 > > the

Re: [sqlite] Virtual Table questions

"Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > Hi All, > > I am exploring the use of the Virtual Table capability of SQLite 3.5.1 > for implementing alternative backing store and have a couple of > questions for virtual table gurus: > > Say I define a virtual table module registered as

[sqlite] Virtual Table questions

Hi All, I am exploring the use of the Virtual Table capability of SQLite 3.5.1 for implementing alternative backing store and have a couple of questions for virtual table gurus: Say I define a virtual table module registered as "custom" and then define virtual table T as follows: CREATE VIRTUAL

Re: [sqlite] SQLite 3.5.1 linking issues due recent changes

--- Klemens Friedl <[EMAIL PROTECTED]> wrote: > 2007/10/23, Joe Wilson <[EMAIL PROTECTED]>: > > --- Klemens Friedl <[EMAIL PROTECTED]> wrote: > > > Has someone already used mingw to build > > > > http://www.sqlite.org/cvstrac/tktview?tn=931 > > the makefile looks outdated (2006-Dec-28). Not sure

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

FYI: When this multi-row-insert patch is combined with today's CVS OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), the multi-row ASCII INSERT statements are as much as 25% faster than the equivalent number of traditional individual ASCII INSERT statements within a

Re: [sqlite] trigger a non-database event in sqlite

I that case you need to implenment a custom function and launch it from a trigger. d_maniger06 wrote: im sorry but i havent get your point..im rather new in sqlite and i just need to make a c program, that when i insert on a table in my database, something is written on a file, or even just be

[sqlite] SQLite 3.5.1 linking issues due recent changes

I have compiled and used SQLite 3 up to 3.4.2 without problems, but recent changes on SQL 3.5.x introduced some issues, see below. I am using mingw (gnu compiler for w32): gcc version 4.1.3 20070829 NASM version 0.99.04 GNU ld (GNU Binutils) 2.17.50.20070806 GNU Make 3.81 The used this source

Re: [sqlite] winLock() in SQLITE 3.5.1...

On Mon, 2007-10-22 at 12:10 -0700, Mark Spiegel wrote: > Thanks Dan. How about the second part. Should the PENDING_LOCK be > taken en route from the SHARD_LOCK to EXCLUSIVE_LOCK? Which is right, > the code or the function header? Doesn't really matter as far as I know. Which I guess means

[sqlite] what extension do you recommend

Hi all! I have developed a small windows application that use a SQLite database as it's main format. The file is NOT a kind of document, it's more of a settings-file stored in the users "Application data"-directory and the extension will not be associated with the application. I know I can

Re: [sqlite] How to implement xLock()?

Richard Klein schrieb: Joe Wilson wrote: --- Richard Klein <[EMAIL PROTECTED]> wrote: Joe Wilson wrote: Just implement it and run the test suite. It's easier to respond to a specific problem than a hypothetical. Is the test suite available only in Tcl? Or is there a C version as well?

Re: [sqlite] Re[sqlite] garding converting .db files in SQLite2.1 to SQLite3 version

On 23/10/2007, Vijaya Lakshmi <[EMAIL PROTECTED]> wrote: . > sqlite.org and used the command line > > sqlite>sqlite old.db .dump | sqlite 3 new.db > but after this nothing happens it just shows as below... > > Type the command at the operating system prompt, not whilst sqlite is already