[sqlite] sqlite driven web-site

Dear SQLite community- I want to develop a dynamic web-site (for small group of people < 5-10). For this I am thinking of using SQLite. Couple of questions: * Are there some docs and/or package available to do something like this? * I would like to use perl as the programming interface - this

Re: [sqlite] XML to SQLite upload

Hi Vivek, * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 06:40]: > Sorry, I was not clear in my previous email. I do know the > structure of the for the XML - I was wondering if there was a > direct upload capability, once I know the structure of the XML. well, you can map generic XML to a

RE: [sqlite] XML to SQLite upload

Thanks for answers. Sorry, I was not clear in my previous email. I do know the structure of the for the XML - I was wondering if there was a direct upload capability, once I know the structure of the XML. Vivek >-Original Message- >From: A. Pagaltzis [mailto:[EMAIL PROTECTED] >Sent:

Re: [sqlite] XML to SQLite upload

* John Stanton <[EMAIL PROTECTED]> [2006-05-05 05:45]: > We feed XML into an SQLITE database, but the XML DTD maps the > database in structure and names. To get general XML data and > load it into any database requires a program of some > description to translate names and structures. That was

Re: [sqlite] XML to SQLite upload

We feed XML into an SQLITE database, but the XML DTD maps the database in structure and names. To get general XML data and load it into any database requires a program of some description to translate names and structures. JS A. Pagaltzis wrote: * Rajan, Vivek K <[EMAIL PROTECTED]>

Re: [sqlite] XML to SQLite upload

A. Pagaltzis wrote: > * Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 02:20]: >> Does someone have XML to SQLite upload utility in perl/C++? > > Thats like asking if someone has an ASCII to CSV upload > utility. It doesnt make any sense. > He is probably looking for a utility which will

[sqlite] XML to SQLite upload

Hi, you could be you profit this example: FLTK + SQLite + TinyXML = rubrinive, an alternative rubric that allows to store for every identity N addresses, N telephone numbers and N e-mails or Web Links.

Re: [sqlite] Some advanced questions

Sqlite3_complete does no syntax checking other than to see if the SQL statement is terminated with a semi-colon. It is used to split multiple SQL statements in the same string, not verify syntax. Why not use the Sqlite SQL syntax checker by running sqlite3_prepare on your statement? You

Re: [sqlite] XML to SQLite upload

* Rajan, Vivek K <[EMAIL PROTECTED]> [2006-05-05 02:20]: > Does someone have XML to SQLite upload utility in perl/C++? That’s like asking if someone has an ASCII to CSV “upload utility”. It doesn’t make any sense. Regards, -- Aristotle Pagaltzis //

[sqlite] XML to SQLite upload

Does someone have XML to SQLite upload utility in perl/C++? Vivek

[sqlite] means for explicitly escalating a transaction from RESERVED to PENDING/EXCLUSIVE

Is there a means for explicitly escalating an existing transaction from RESERVED to EXCLUSIVE (either through issuing sql statements or the C API)? I'm using the following locking strategy: * Read only transactions start with a BEGIN and allow sqlite to escalate to SHARED on read. * Transactions

Re: [sqlite] SQLite disk performance

<[EMAIL PROTECTED]> wrote: > > The main reason seems to be that inserting in the btree is very slow (even > using transactions) because a lot of data has to be moved around in the file. No. I think the reason is that the database file is too big to fit in your operating systems disk cache and

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

On 5/4/06, Dennis Cote <[EMAIL PROTECTED]> wrote: It seems *really* strange that deleting the file would reduce the average run time of the 1 loop case by more than 60 seconds. Neither overwriting the file or deleting the file should take anywhere near this long. These are small files of

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

Doug Currie wrote: Add the line: DeleteFile("test.txt"); in front of the CreateFile() call... Doug, This does make a difference. I thought that the CREATE_ALWAYS flag to CreateFile would delete any existing file, but upon further investigation I found out that what it does is open

RE: [sqlite] Cannot load sqlite3.dll

You can not use it directly in .Net as it is not a .Net module - you need to reference it's API using PInvoke (platform invoke). You can look at some of the .Net wrappers in the wiki at http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Bob Bob -Original Message- From: Paul Hunnisett

[sqlite] Cannot load sqlite3.dll

I'm trying to add sqlite3.dll ot my application in VS 2005. I downloaded the dll from the sqlite home page. VS simply says that it is not a valid assembly and can't be loaded. I have no idea what to do next... Can anyone point me in the right direction? Cheers Paul Hunnisett

Re: [sqlite] Some advanced questions

--- [EMAIL PROTECTED] wrote: > ... > Most of the interfaces in bind.test are > special-purpose > testing hacks that are only available if you build > the "testfixture". They are not a part of the > standard > TCL API. > > ... > Three things to take away from this overview: > > (1) The TCL

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

Hi, - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Thursday, May 04, 2006 2:27 PM Subject: Re: [sqlite] SQLite :memory: performance difference between v2 and v3? > All, > > More mysteries. To investigate this low insert performance

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

Thursday, May 4, 2006, 1:27:49 PM, Dennis Cote wrote: > More mysteries. To investigate this low insert performance under WinXP I > wrote a simple test program that loops writing one character to a file > and then flushing the file. The strange thing is that it seems to > alternate between two

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

This program is almost completely I/O bound. It spends all its time sleeping so its CPU usage is nearly zero. There might be some disk contention from other programs, but I would think that should be fairly constant. I am re-testing with longer run times to check this. You give up your time

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

Jay Sprenkle wrote: Initially performance is good but the degrades? Some other processes must be sucking up cpu time? Jay, This program is almost completely I/O bound. It spends all its time sleeping so its CPU usage is nearly zero. There might be some disk contention from other programs,

Re: [sqlite] Some advanced questions

Dennis Cote <[EMAIL PROTECTED]> wrote: > > I pulled the following from the bind.test file. It shows how > sqlite_prepare is used to test the parameter binding, and how the > sqlite_column_count and sqlite_column_name APIs are used. > Most of the interfaces in bind.test are special-purpose

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > All, > > More mysteries. To investigate this low insert > performance under WinXP I > wrote a simple test program that loops writing one > character to a file > and then flushing the file. The strange thing is > that it seems to > alternate between

Re: [sqlite] Some advanced questions

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > I pulled the following from the bind.test file. It > shows how > sqlite_prepare is used to test the parameter > binding, and how the > sqlite_column_count and sqlite_column_name APIs are > used. > > HTH > Dennis Cote Dennis, This is great! These

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

On 5/4/06, Dennis Cote <[EMAIL PROTECTED]> wrote: All, More mysteries. To investigate this low insert performance under WinXP I wrote a simple test program that loops writing one character to a file and then flushing the file. The strange thing is that it seems to alternate between two

Re: [sqlite] Some advanced questions

Unit 5 wrote: Thank your very much for your answers! It looks like sqlite3_prepare() is what I need. I have gone through the tcl api and did not find any mappings to it or any command that matched its functionality. Do you have the reference or the command name handy? Unit, I don't

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

All, More mysteries. To investigate this low insert performance under WinXP I wrote a simple test program that loops writing one character to a file and then flushing the file. The strange thing is that it seems to alternate between two different run times as shown below. This is for 6

Re: [sqlite] Detecting table scan

Doug Nebeker wrote: So does that mean if I get "TABLE xyz" in the 'detail' column back and it does NOT mention an index that a full table scan is taking place? I found some info about EXPLAIN QUERY PLAN (http://www.sqlite.org/cvstrac/wiki?p=QueryPlans) but haven't found out exactly what the

Re: [sqlite] Some advanced questions

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > What you probably want to do is use > sqlite3_prepare() to check if the > statement is syntactically valid. If it is you will > get a success return > code, if not you will get an error return code. > > I understand you are using TCL but I believe

Re: [sqlite] Some advanced questions

Hi 'Unit 5', 3) I would like to test the validity of sql statements before executing them. So I thought I could use "db complete" command. But now I am not sure what "db complete" command does. In my tests, it returns 0 (false) regardless of the sql statement. In fact the only times I have

Re: [sqlite] Some advanced questions

Unit 5 wrote: 1) If I have a statement that includes "WHERE 0 = 1", does sqlite optimize the query and return right away or would it execute the query anyway? It will be executed. 2) Is there a way to get column names form a statement without (or before) executing the statement? For

Re: [sqlite] Detecting table scan

Thanks Dennis. So does that mean if I get "TABLE xyz" in the 'detail' column back and it does NOT mention an index that a full table scan is taking place? I found some info about EXPLAIN QUERY PLAN (http://www.sqlite.org/cvstrac/wiki?p=QueryPlans) but haven't found out exactly what the response

[sqlite] Some advanced questions

Hello, I started with Sqlite just a few days ago and gievn how simple its api is, I think I am ready to do some more complex things with it. I am primarily using it from the tcl api so far. I have a few questions: 1) If I have a statement that includes "WHERE 0 = 1", does sqlite optimize the

[sqlite] Re: sqlite puzzle

JP wrote: Thanks all. Actually I was just looking for the position of a single name. Based on your feedback, this one works to get the results: SELECT count(*) FROM clients WHERE name<'foo'; but its performance is directly proportional to the position of the name in the table. For example,

Re: [sqlite] Temporary or regular table?

Unit 5 wrote: It seems that you cannot create a temporary table in a database other than "temp". In other words, the following is an error: % CREATE TEMP TABLE temp_db.temp_table ... temporary table name must be unqualified But this is not: % CREATE TEMP TABLE temp.temp_table ... Neither is

Re: [sqlite] More columns vs. several tables

Am 02.05.2006 um 18:46 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: I'm wondering whether there is a big performance hit for a simple SELECT binarydata FROM entries WHERE somehash = 27817298; when I use CREATE TABLE entries( entry_id

Re: [sqlite] sqlite puzzle

Thanks all. Actually I was just looking for the position of a single name. Based on your feedback, this one works to get the results: SELECT count(*) FROM clients WHERE name<'foo'; but its performance is directly proportional to the position of the name in the table. For example, searching