[sqlite] sqlite

Hi, Is there any possibility to import files from the local file system to the sqlite DB.And Is there any export option is there just to check whether the loaded file and exported file consists of same data or not. Is it possible in sqlite? If possible,How it will stores files in tables?In which f

[sqlite] finding the groups which have some sort of mising transaction

HI, all The following 2 queries (have the same result) are about to find some groups which have some sort of missing transactions. Please advise which one would have better performance. Thank you in advance! SELECT docketno FROM cntt_sales2 GROUP BY docketno HAVING MAX(CASE WHEN datacmd = 'RC

Re: [sqlite] Resources required and Lock & recovery mechanisms

Sqlite requires few resources. Locking is achieved through regular file locks which lock the entire database since it is a file. Flow control is not applicable. You may use semaphores etc in your application for synchronization, but they are not used by Sqlite. Maintenance of an Sqlite data

[sqlite] Resources required and Lock & recovery mechanisms

Hi Everybody, I have the following doubt... 1. what are the resources required by SQLLite - they can be RAM/ROM, semaphores, mail boxes, task requirements; 2. How do we have flow control? 3. what are the Lock mechanisms provided by the engine (row lock, table lock..)? Any additional lock mech

[sqlite] Order of columns within a CREATE TABLE statement

Hi all, Just had a quick question with regards to the order of the columns within a create table statement I have a few tables that use the BLOB type for storing various lengths of binary data and I was wondering if its better (more efficient) to always declare columns of this type last withi

Re: [sqlite] Compress function

D. Richard Hipp... You are amazing!!! Thanks a lot for Sqlite and for help me! God save D. Richard Hipp! On Wed, 19 2006 17:44:46 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote: > I need a funcion from compress a row with Zlib and

Re: [sqlite] Compress function

"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote: > I need a funcion from compress a row with Zlib and I am wondering if SQLite > support or if someone did it and want to share him or her code. > Here some code that might help: /* ** SQL function to compress content into a blob using li

[sqlite] sqlite_master

Hi, What's the schema of sqlite_master? I'm trying to find trigger entries. Thanks, Raj

Re: [sqlite] count(*)

There are no deletes on this table though. On 7/19/06, Sripathi Raj <[EMAIL PROTECTED]> wrote: What does LIMIT 1 do? On 7/19/06, Brannon King <[EMAIL PROTECTED]> wrote: > > >> select rowid from table limit 1 offset -1; > > Two ways to do this: > > > >SELECT rowid FROM table ORDER BY rowi

Re: [sqlite] count(*)

What does LIMIT 1 do? On 7/19/06, Brannon King <[EMAIL PROTECTED]> wrote: >> select rowid from table limit 1 offset -1; > Two ways to do this: > >SELECT rowid FROM table ORDER BY rowid DESC LIMIT 1; >SELECT max(rowid) FROM table; Yes, but neither one of those would be as fast as this q

Re: [sqlite] Compress function

Cesar David Rodas Maldonado wrote: I compile SQLITE 3 source into my APP, but i will like to use like mysql uses ( the COMPRESS() function into the sql), understand? I understand. Unfortunately I haven't implemented that.

Re: [sqlite] Compress function

I compile SQLITE 3 source into my APP, but i will like to use like mysql uses ( the COMPRESS() function into the sql), understand?

Re: [sqlite] reg:sqlite usage

* sandhya <[EMAIL PROTECTED]> [2006-07-19 14:10]: > Also you wanna want to say that we shouldn't use this in Client > /Server applications.Like,Connecting to the Sqlite server > through the application and performing all the operations > through(application) it and updating the server. Not “should

Re: [sqlite] Compress function

Cesar David Rodas Maldonado wrote: I need a funcion from compress a row with Zlib and I am wondering if SQLite support or if someone did it and want to share him or her code. Thanks to all Do you want to have it as an Sqlite function or as a function in your application? In general you ju

Re: [sqlite] reg:sqlite usage

The way we use Sqlite in web applications is as part of the web server, creating an application server. We wrote our own webserver and application specific language processor and use Sqlite for storage. Sqlite is a great component for such a project and means that one multi-threaded process ru

Re: [sqlite] Compress function

On 7/19/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Do you know for how much money? On 7/19/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > The author of Sqlite also sells a version that compresses and encrypts > the database. from this page: http://www.hwaci.com/sw/sqlite/prosu

Re: [sqlite] Compress function

Do you know for how much money? On 7/19/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: The author of Sqlite also sells a version that compresses and encrypts the database. On 7/19/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > Thanks Hugh, i think it will be useful for me... > > On

RE: [sqlite] count(*)

>> select rowid from table limit 1 offset -1; > Two ways to do this: > >SELECT rowid FROM table ORDER BY rowid DESC LIMIT 1; >SELECT max(rowid) FROM table; Yes, but neither one of those would be as fast as this query, true? SELECT rowid FROM table LIMIT 1 I guess I was thinking to avoid

Re: [sqlite] Compress function

The author of Sqlite also sells a version that compresses and encrypts the database. On 7/19/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Thanks Hugh, i think it will be useful for me... On Wed, 19 Jul 2006 16:07 +0100 (BST), Hugh Gibson <[EMAIL PROTECTED]> wrote: > > You could tr

Re: [sqlite] Compress function

Thanks Hugh, i think it will be useful for me... On Wed, 19 Jul 2006 16:07 +0100 (BST), Hugh Gibson <[EMAIL PROTECTED]> wrote: You could try http://web.utk.edu/~jplyon/sqlite/code/sqaux-userfns.c but it's a little old now. Hugh

RE: [sqlite] Re: I need help making this code run faster

At 23:29 18/07/2006, you wrote: Thanks, Igor, you've inspired and saved me yet again. The subqueries you had used for the x/yEnd did not work, but the rest did and I have that maxim information beforehand anyway. Here's how it shook down: select cast(cast((xStart+xEnd) as double)/2/15518.5 as

Re: [sqlite] Compress function

You could try http://web.utk.edu/~jplyon/sqlite/code/sqaux-userfns.c but it's a little old now. Hugh

[sqlite] Compress function

I need a funcion from compress a row with Zlib and I am wondering if SQLite support or if someone did it and want to share him or her code. Thanks to all

Re: [sqlite] count(*)

On Wed, 19 2006 06:08:49 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Brannon King <[EMAIL PROTECTED]> wrote: > It's too bad you can't do an offset > of negative one so that it would start at the back. That should be darn > fast. Something like: > > select rowid from table limit 1 offset

Re: [sqlite] reg:sqlite usage

John, If u don't mind can you please explain me is it possible if i load /store any files as Large objects inside DB and open it via a webserver instead of storing it in a local system and opening.In that case what i have to do.Like my DB whether i should place in the Webserver applcaition and ac

Re: [sqlite] reg:sqlite usage

Sqlite is a wonderful tool. We use it with great success embedded in a custom application server for web applications, embedded in CGI processes and in some industrial process control applications. It is robust and very simple to use, and since it places all tables in one file, very easy to m

Re: [sqlite] reg:sqlite usage

ya..Thank you ver much John.Right now i am using Postgresql only.But just i want to find out the information abt Sqlite as i heard that it is having very small footprint and its good for Embedded systems app. Now i got it,Thanks a lot. -Sandhya - Original Message - From: "John Stanto

Re: [sqlite] reg:sqlite usage

Sandhya, You use Sqlite the same way you use a file in your application. You link in the runtime library containing the file handling API when you create your executable. Sqlite gives an embedded application the capability of using SQL for data management. If you are building a client serv

Re: [sqlite] reg:sqlite usage

You link Sqlite into your application...May i know what it mean? Please explain me. Also you wanna want to say that we shouldn't use this in Client /Server applications.Like,Connecting to the Sqlite server through the application and performing all the operations through(application) it and updatin

Re: [sqlite] reg:sqlite usage

Sandhya, You have not grasped the concept of Sqlite. It is a RDBMS LIBRARY, not a server. You link Sqlite into your application. As Dr Hipp points out it it an alternative to fopen, not Oracle. sandhya wrote: Hi, I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my win

Re: [sqlite] count(*) - maybe a 3rd

Hi, If a table has a primary key selecting count(*) using it maybe faster if there is a difference of the number of rows stored per page. A wide table will do more io than the index. The table names is not very wide but does consume more disk space than than the primary keys index. sql3>

Re: [sqlite] count(*)

Brannon King <[EMAIL PROTECTED]> wrote: > It's too bad you can't do an offset > of negative one so that it would start at the back. That should be darn > fast. Something like: > > select rowid from table limit 1 offset -1; > Two ways to do this: SELECT rowid FROM table ORDER BY rowid DESC

[sqlite] reg:sqlite usage

Hi, I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my windows system.I built lib and dll too. I tried the sample given in the documetation.The connection info i have given the DB name, the table name and the query.But the database name what ever i am giving it is getting stor