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 EX
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 co
P Kishor wrote:
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
band
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 P
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 Oa
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()
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 trigge
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 with Vizaweb. They have
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 Rese
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 s
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: suitable web host (was Re: [sq
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 use
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 work-arou
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, February 28, 2007 12:07 PM
Subjec
-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 k
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 appr
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 retr
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:
sqlite-2.8.17.b
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
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 - sqlit
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 is
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]
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 triv
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 quest
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 2/28
On Wed, 2007-02-28 at 13:13 +0100, Pavan wrote:
> Hi Lucas,
>
> >Shouldn't it be "sqlite3_open16(L"test.db",&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
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( "t\0e\0s\0t\0.\0
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;
fo
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 i
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:
http
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.
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]
--
Hi Lucas,
Shouldn't it be "sqlite3_open16(L"test.db",&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
Could i make to insert 10 000 row in my table with a loop ?
thx
On 2/28/07, Pavan <[EMAIL PROTECTED]> wrote:
Hi,
When i tried to create the db file using API sqlite3_open16("test.db",&db)
it creats the file name with some junk
characters.
Shouldn't it be "sqlite3_open16(L"test.db",&db)" ?
Regards,
~Nuno Lucas
The file name is correct if i use sqlite3_op
Hi,
When i tried to create the db file using API sqlite3_open16("test.db",&db)
it creats the file name with some junk
characters.
The file name is correct if i use sqlite3_open("test.db",&db). Does it mean
sqlite3 does not support
UTF16 encoding ?
or
Am i missing some package ?
Thanks,
Pavan.
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
37 matches
Mail list logo