Re: [sqlite] How to interleave calls to sqlite3_prepare_v2 and sqlite3_step?

On Thu, 2007-03-01 at 05:35 +0100, daan wrote: > I'm compiling a SQL statement (consisting of multiple statements separated > by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt > pointers, later to be executed with sqlite3_step(). > > A statement such as: > > DROP TABLE IF

[sqlite] How to interleave calls to sqlite3_prepare_v2 and sqlite3_step?

I'm compiling a SQL statement (consisting of multiple statements separated by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt pointers, later to be executed with sqlite3_step(). A statement such as: DROP TABLE IF EXISTS test; CREATE TABLE test (id INTEGER, name TEXT); is

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

That is what I do. You then have complete control. Tom VP wrote: Thank you, John. The problem with shared servers is the real and extensive restrictions on running apps and scripts - I'm considering hosting my own web server. Tom :} - Original Message - From: "John Stanton" <[EMAIL

Re: [sqlite] developers mailing list, ignored patches

Adam Megacz <[EMAIL PROTECTED]> wrote: > > I also printed out and signed the copyright papers and mailed them in. > Your copyright release and your patches arrived in today's post. The postmark is smeared somewhat but it does appear to say "2? DEC 2006" (where the ? is illegible.) So from

Re: [sqlite] How fast is the sqlite connection created?

Samuel R. Neff wrote: Some of this performance gain is probably related to caching data and query plan, not just opening the connection, but still that caching is connection related and is lost when you close the connection so it's a very real-world valid comparison. no surprise that connect()

Re: [sqlite] How fast is the sqlite connection created?

Samuel R. Neff wrote: One last set of performance numbers for opening a connection. :-) All points on the curve. ;) So the impact of open/closing connections on a real-world db really is huge. You're right, that's a huge difference. Good bit of benchmarking there. These tests with

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

Thanks for the info., Clark. I will consider. Dr. Tom - Original Message - From: "Clark Christensen" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 28, 2007 4:50 PM Subject: Re: [sqlite] Installing & Running Sqlite on Linux Webserver? I've had good results

RE: [sqlite] How fast is the sqlite connection created?

One last set of performance numbers for opening a connection. :-) This is after adding in check constraints for types and foreign key triggers (which may only be used during development anyways). Non-Pooled: 17,515.6 ms Pooled with Reset :562.5 ms Pooled without

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

I've had good results with Vizaweb. They have PHP, and Perl by default, as well as MySQL and Postgres. Plus, they've expressed their willingness to consider installing other stuff. My guess is your part of the site runs in its own VM of some kind, so the impact to the host system, and other

Re: [sqlite] OT: suitable web host (was Re: [sqlite] Installing & Running Sqlite on Linux Webserver?)

Hi Puneet, Thank you for the tip - I will definitely look into it - will let you know if I decide to change. Regards, Dr. Tom - Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 28, 2007 2:29 PM Subject: [sqlite] OT:

[sqlite] OT: suitable web host (was Re: [sqlite] Installing & Running Sqlite on Linux Webserver?)

On 2/28/07, Tom VP <[EMAIL PROTECTED]> wrote: Thank you, John. The problem with shared servers is the real and extensive restrictions on running apps and scripts - I'm considering hosting my own web server. I am happy with Dreamhost. For $8 a month, I get more space and bandwidth than I can

[sqlite] String concatenation disallowed within a RAISE function?

It seems I can't use string concatenation within a RAISE call. This code: SELECT RAISE(ROLLBACK, 'test'); Works fine but this code SELECT RAISE(ROLLBACK, 'test' || 'ing'); Gives an error SQL error: near "||": syntax error Is this correct behavior? I found a

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

Thank you, John. The problem with shared servers is the real and extensive restrictions on running apps and scripts - I'm considering hosting my own web server. Tom :} - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Wednesday,

RE: [sqlite] Importing data without a primary key

-Original Message- From: Sebastian Tennant [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 12:56 PM To: sqlite-users@sqlite.org Subject: [sqlite] Importing data without a primary key Hi all, I have a CSV file of data that doesn't include a column suitable to be the primary

[sqlite] Importing data without a primary key

Hi all, I have a CSV file of data that doesn't include a column suitable to be the primary key. Should I edit the CSV data file before importing it (a pain to do), or is there an easy way to create (and populate) a primary key column once the data has been imported? Any suggestions much

Re: [sqlite] UTF16 Encoding

On 2/28/07, Pavan <[EMAIL PROTECTED]> wrote: >But I'm thinking you really want to do this anyway: Well, I have a requirement to store/retrieve UTF16 strings. The current discussion thread is based on that. Pls let me know if my understanding of using sqlite3_open16 is correct to store and

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

Sqlite is a library which is linked into your application. Write your application using the Sqlite API and then load that program onto the web server. Tom VP wrote: I would like to install and run sqlite on my host web server. Does anyone know how I can do this? I downloaded:

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

On 2/28/07, Tom VP <[EMAIL PROTECTED]> wrote: Dear Puneet, Thanks for your response. I don't have compile capability on my shared webserver. Therefore, I'd like to install pre-compiled/executable sqlite (much as on a pc) - is there a download that has the precompiled code that will execute on a

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

Dear Puneet, Thanks for your response. I don't have compile capability on my shared webserver. Therefore, I'd like to install pre-compiled/executable sqlite (much as on a pc) - is there a download that has the precompiled code that will execute on a Unix server? Is the one I mentioned -

Re: [sqlite] Installing & Running Sqlite on Linux Webserver?

On 2/28/07, Tom VP <[EMAIL PROTECTED]> wrote: I would like to install and run sqlite on my host web server. Does anyone know how I can do this? I downloaded: sqlite-2.8.17.bin.gz and gunzipped it to: sqlite-2.8.17.bin. Is this what I would install and how. My website is on a shared server, so

Re: [sqlite] Insert

Why not ? Christian POMPIER a écrit : Could i make to insert 10 000 row in my table with a loop ? thx - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] how to insert and select a date column

Rafi Cohen wrote: Hi, I apologize in advance for the probably very basic question as I'm a newbie to sqlite and integrating sql in C applications. One of my tables in my database requires a date column. I understand from a tutorial not related to C/C++ api that insering date columns is not

Re: [sqlite] Insert

On 2/28/07, Christian POMPIER <[EMAIL PROTECTED]> wrote: Could i make to insert 10 000 row in my table with a loop ? Christian, This kind of a question is likely to either not result in an answer, or in an answer that is unsatisfactory to you -- either way, bandwidth wasted. Ask better

Re: [sqlite] UTF16 Encoding

But I'm thinking you really want to do this anyway: Well, I have a requirement to store/retrieve UTF16 strings. The current discussion thread is based on that. Pls let me know if my understanding of using sqlite3_open16 is correct to store and retrieve utf16 strings. Thanks, Pavan. On

Re: [sqlite] UTF16 Encoding

On Wed, 2007-02-28 at 13:13 +0100, Pavan wrote: > Hi Lucas, > > >Shouldn't it be "sqlite3_open16(L"test.db",)" ? > > I tried this call. It works. But, the db file is created only with the first > character name > and the extenstion is also missing. (its like 't') > > Also, can you point to me

Re: [sqlite] UTF16 Encoding

I tried this call. It works. But, the db file is created only with the first character name and the extenstion is also missing. (its like 't') I think that your compiler's wchar_t is 32bit. But sqlite3_open16() requires 16bit characters. Try the following code. sqlite3_open16(

RE: [sqlite] How fast is the sqlite connection created?

I implemented connection pooling in the .NET wrapper and using the pool it takes 90ms for 1,000 connections or 500ms if I clear out attached databases and temp tables each time. Is there a really quick way to reset attached/temp tables on a connection? Right now I do a pragma database_list;

RE: [sqlite] Singular Sqlite3Explorer 2.0 question

suppose you have a text file that contains : Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname Myname,yourname hisname notice that this is an irregular format, because the first column delimiter

[sqlite] Re: Re: Insert

Christian POMPIER <[EMAIL PROTECTED]> wrote: De : Igor Tandetnik [mailto:[EMAIL PROTECTED] Christian POMPIER <[EMAIL PROTECTED]> wrote: Could i make to insert 10 000 row in my table with a loop ? Yes. But what is the good syntax ? The syntax of the INSERT statement is described here:

RE: [sqlite] Re: Insert

But what is the good syntax ? -Message d'origine- De : Igor Tandetnik [mailto:[EMAIL PROTECTED] Envoyé : mercredi 28 février 2007 13:37 À : SQLite Objet : [sqlite] Re: Insert Christian POMPIER <[EMAIL PROTECTED]> wrote: > Could i make to insert 10 000 row in my table with a loop ? Yes.

[sqlite] Re: Insert

Christian POMPIER <[EMAIL PROTECTED]> wrote: Could i make to insert 10 000 row in my table with a loop ? Yes. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] UTF16 Encoding

Hi Lucas, Shouldn't it be "sqlite3_open16(L"test.db",)" ? I tried this call. It works. But, the db file is created only with the first character name and the extenstion is also missing. (its like 't') Also, can you point to me at some documentation which explains what does the 'L' mean in

[sqlite] Insert

Could i make to insert 10 000 row in my table with a loop ? thx

Re: [sqlite] UTF16 Encoding

On 2/28/07, Pavan <[EMAIL PROTECTED]> wrote: Hi, When i tried to create the db file using API sqlite3_open16("test.db",) it creats the file name with some junk characters. Shouldn't it be "sqlite3_open16(L"test.db",)" ? Regards, ~Nuno Lucas The file name is correct if i use

[sqlite] UTF16 Encoding

Hi, When i tried to create the db file using API sqlite3_open16("test.db",) it creats the file name with some junk characters. The file name is correct if i use sqlite3_open("test.db",). Does it mean sqlite3 does not support UTF16 encoding ? or Am i missing some package ? Thanks, Pavan. --

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

Jakub Ladman wrote: But there is not tcl library at the time and when I tried to build sqlite without -DNO_TCL it failed. I think you will have fewer problems building Tcl than you did building SQLite because the automake code will be more up to date. You'v ebuilt SQLite so you're an expert