Re: [sqlite] SQLite on RAM

At 16:19 10/10/2006, you wrote: Hi List, Is it possible to use SQLite on RAM (where there is no file system) i.e. directly on memory, (No Hard disk). I am planning to use it on RAM inside TV. How it will read and write on RAM. Yes is possible to run SQLite on RAM, we do it 24/7 on a device.

Re: [sqlite] PK and rowid

On Wed, 11 Oct 2006 00:19:28 -0700 (PDT), you wrote: >Hi, > > If I declare my column as, "uniqId integer primary key", > now if I say something like, > select * from tbl1 where uniqId=x; > > Will the uniqId be same as rowid, making my table look ups > faster as I am using row id

Re: [sqlite] new sqlite-based webserver

Gunter, I finally managed to get to your server and look at what you have done. It is interesting and ingenious to embed Javascript as an application server language and to integrate it with Sqlite. Your son has something to get his teeth into. I haven't looked closely enough at your code

Re: [sqlite] new sqlite-based webserver

This is very very sweet :) Many thanks for sharing Greschenz. I would love to see this project mature. Maybe something like a ThinClient webserver with Javascript as the backend so we could write lovely web apps with AJAX support that offers database like features? Could it also run on

Re: Re: [sqlite] wxSqlite- Long Insertion time

On 10/10/06, Lloyd <[EMAIL PROTECTED]> wrote: For me consistancy, atomicity...(ACID) are not a problem. But the speed of operation is major constraint. How can I achieve speed in insertion cases like this? Are you doing these insertions in a transaction?

Re: [sqlite] new sqlite-based webserver

Hi, the reasons why i did this: 1) i wanted to have a simple webserver to get my son involved in programming an online game, and he knows already a little bit javascript 2) my hobby is programming in c++ and javascript, but at work i have to code in c#, so i just wanted to have some fun :-)

[sqlite] Journal file and EFS space

Hi, We are using embedded flash file system, now we have catch22 situation. When the EFS is full (we seeing this when we have <13k on EFS, ofcourse out of that 13k some will go for system) , the users aren't able to delete any content from the EFS. sqllite3_step() is returning error. We

Re: [sqlite] new sqlite-based webserver

The multi-threaded application/www server I described requires no threading involvement from the application programmer. That programmer uses SQL, HTML, Javascript and the application language we call MUV. Think about it, when you use Apache you don't have to be aware of its internal

Re: [sqlite] new sqlite-based webserver

hi, its asymetric, its (seen from my home) 2mbit downstream and (i'm not sure) 384kbit upstream (but in any case less than 1mbit). the other direction wout be better for serving (now its better for surfing :-) but for my own purpose it is enough :-) at the end of the year 16mbit could be

RE: [sqlite] new sqlite-based webserver

Greetings, Günter, Regarding: "...my server is running at home ... and has a dsl-(2mbit) connection to the world." Do you know if your connection is symmetric? In the U.S. most all home DSL circuits are ADSL, with the upload maximum speed just a fraction of the download maximum. Places like

[sqlite] are there known software patents concerning sqlite?

Hello list, as software patents become a more and more important issue ( one could also call it a pain in the *ss) I would like to know if anyone has done a patent research for sqlite. Or does anyone know about people who claimed that sqlite would violate therir patens? kind regards, gunnar

Re: [sqlite] new sqlite-based webserver

Hi, normally i like multithreading, but in this case i like the simple approach (at least for rendering the pages), because as application programmer (the guy who will develop the apps in javascript) its much easier if you dont have to think about locks, racing conditions and other pitfalls.

Re: [sqlite] new sqlite-based webserver

Hi, my server is running at home (300mhz(?), linux (suse 9.3) and has a dsl-(2mbit) connection to the world. running inernally (my laptop connected directly via wlan) its really fast (look at the logfile: http://greschenz.dyndns.org/logsByPath.html), it could be a internal routing problem

AW: [sqlite] PK and rowid

uniqId is the same as rowid, so you will get the same execution plans for ...where rowid=x and ... where uniqId=x. - Ursprüngliche Mail Von: chetana bhargav <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Mittwoch, den 11. Oktober 2006, 09:19:28 Uhr Betreff: [sqlite] PK and

[sqlite] PK and rowid

Hi, If I declare my column as, "uniqId integer primary key", now if I say something like, select * from tbl1 where uniqId=x; Will the uniqId be same as rowid, making my table look ups faster as I am using row id only. If not whats the way to assign my uniqId to the row id so that