Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-30 Thread John Stanton
Why not implement a simple index file system like one of the DBase derivatives? If you have no OS you will find porting something like Sqlite or Berkely DB a challenge. If you are not looking for SQL then you can achieve your goal in maybe 20K of memory. [EMAIL PROTECTED] wrote: P

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-30 Thread rhurst2
[EMAIL PROTECTED] wrote: > <[EMAIL PROTECTED]> wrote: > > > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > > Using SQL is a little bit overkill > > > > > > why bother with SQLite then? Use the right tool for the job > > > -- use BerkeleyDB. > > > > >

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-30 Thread drh
<[EMAIL PROTECTED]> wrote: > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > Using SQL is a little bit overkill > > > > why bother with SQLite then? Use the right tool for the job > > -- use BerkeleyDB. > > > > Size is a constraint for me. > I see that SQLite

Re: [sqlite] PLSQL

2007-03-30 Thread John Stanton
Thanks for the comments. JS Ken wrote: John, I've used PL/SQL on Oracle. I think it was derived from another language, maybe PL/1. I think its an excellent language, my main usage was geared at PL/SQL for DBA usage that managed internal oracle objects. Pros: Packages / Procedures/

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-30 Thread rhurst2
P Kishor <[EMAIL PROTECTED]> wrote: > On 3/29/07, Ludvig Strigeus <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm looking at using Sqlite as a storage backend for a program. Using SQL is > > a little bit overkill and much more than we need. How complicated would it > > be to interface to the

Re: [sqlite] in-memory database bound to a named buffer

2007-03-30 Thread Ken
short answer is no. The memory structures are not identical to disk structures. Ryan Underwood <[EMAIL PROTECTED]> wrote: Is it possible to bind an in-memory sqlite database (in read-only mode, naturally) to an existing named memory buffer that contains exactly the contents of a sqlite

[sqlite] in-memory database bound to a named buffer

2007-03-30 Thread Ryan Underwood
Is it possible to bind an in-memory sqlite database (in read-only mode, naturally) to an existing named memory buffer that contains exactly the contents of a sqlite database file? What I want to do is maintain a database as usual, but then take an occasional snapshot, bin2c it and include it in

RE: [sqlite] PLSQL

2007-03-30 Thread Dusan Gibarac
I've used both PL/SQL and PL/1. They are not related at all. P(rogramming) L(anguage) could be used for anything. PL/1 was IBM language for mainframes, similar to COBOL for developing application software and PL/SQL is Oracle procedural extension of their SQL. Dusan Gibarac -Original

Re: [sqlite] Changing column data type

2007-03-30 Thread P Kishor
add "col4 text" and UPDATE foo SET col4 = col2 keep in mind, other than a few limitations, SQLite doesn't really give a rip about your data types and what you store in it. It is about as free-for-all as it gets. On 3/30/07, Sandeep Suresh <[EMAIL PROTECTED]> wrote: I have a table : Table

Re: [sqlite] PLSQL

2007-03-30 Thread Ken
John, I've used PL/SQL on Oracle. I think it was derived from another language, maybe PL/1. I think its an excellent language, my main usage was geared at PL/SQL for DBA usage that managed internal oracle objects. Pros: Packages / Procedures/ Functions have a really nice hierarchy.

Re: [sqlite] multiple request handling

2007-03-30 Thread Cesar Rodas
YEah... but every thread need to have its connection. Is not a good idea to have a global connection and use in deferents threads. On 30/03/07, Pavan <[EMAIL PROTECTED]> wrote: Hi, Does SQLite handle multiple request handling ? Thanks, Pavan. --

Re: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Leonardo Mateo
On 3/30/07, Reber Douglas-ra7758 <[EMAIL PROTECTED]> wrote: That works just fine. It does find the file in the right directory. The full error is : Error in startup script: invalid command name "sqlite3" While executing "sqlite3 db Gem.db" Maybe is a dumb question, but are you sure sqlite3

Re: [sqlite] multiple request handling

2007-03-30 Thread Martin Jenkins
Pavan wrote: Does SQLite handle multiple request handling ? Yes. Martin - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Reber Douglas-ra7758
That works just fine. It does find the file in the right directory. The full error is : Error in startup script: invalid command name "sqlite3" While executing "sqlite3 db Gem.db" Does this mean some option needed to be set before the .so was created? Thanks, Doug -Original

Re: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Cesar Rodas
Can you do the next commands into your bash or you have errors?: cd /_TOOLS/plat/lib/ ls tclsqlite-3.3.13.so On 30/03/07, Reber Douglas-ra7758 <[EMAIL PROTECTED]> wrote: I have tried it on sun sparc and on linux with the same identical results. Thanks, Doug -Original Message- From:

[sqlite] Changing column data type

2007-03-30 Thread Sandeep Suresh
I have a table : Table foo( col1 integer primary key, *col2 int*, col3 text ) And I want to be able to change this to : Table foo( col1 integer primary key, *col2 text*, col3 text ) I want to do this, because I have an "enum" in col2 and want to be able to use custom collate function and

RE: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Reber Douglas-ra7758
I have tried it on sun sparc and on linux with the same identical results. Thanks, Doug -Original Message- From: Cesar Rodas [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 12:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] invalid command name "sqlite3" what OS are

Re: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Cesar Rodas
what OS are you using? On 30/03/07, Reber Douglas-ra7758 <[EMAIL PROTECTED]> wrote: Noah, Thanks for the input. I tried changing the case on both lines first with the load command and then with the db access line and both times I get the same error. Any other suggestions? Thanks, Doug

RE: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Reber Douglas-ra7758
Noah, Thanks for the input. I tried changing the case on both lines first with the load command and then with the db access line and both times I get the same error. Any other suggestions? Thanks, Doug -Original Message- From: Noah Hart [mailto:[EMAIL PROTECTED] Sent: Friday, March

RE: [sqlite] invalid command name "sqlite3"

2007-03-30 Thread Noah Hart
Is your operating system case sensitive? Try sqlite3, rather than Sqlite3 Regards, Noah -Original Message- From: Reber Douglas-ra7758 [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 9:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] invalid command name "sqlite3" I

[sqlite] invalid command name "sqlite3"

2007-03-30 Thread Reber Douglas-ra7758
I continue to get an invalid command name "sqlite3" with the following code: Load /_TOOLS/plat/lib/tclsqlite-3.3.13.so Sqlite3 Sqlite3 db Gem.db The source object exists correctly but it appears the API is not working. Your help is greatly appreciated. Doug Reber

[sqlite] PLSQL

2007-03-30 Thread John Stanton
I am looking for advice experienced DBMS users please. I am currently implementing an application server using Sqlite as an embedded RDBMS and have a need for expanded function capability. My server provides support for AJAX style WWW applications. I have not used PLSQL to any significant

Re: [sqlite] SQLite v/s SQLite3 Performance Assay

2007-03-30 Thread Dennis Cote
Nitin Kashyap wrote: I have tried to verify for any test artifact as suggested by you; but still the result were same. Requesting for further guidance as to what can cause the slow responnce from SQLite3 compared to SQLite2. Also, I had sent the snippet from the test driver in previous

[sqlite] multiple request handling

2007-03-30 Thread Pavan
Hi, Does SQLite handle multiple request handling ? Thanks, Pavan. -- ' Always finish stronger than you start *

Re: [sqlite] Re: Java wrapper for both windows and linux

2007-03-30 Thread Xavier RAYNAUD
McDermott, Andrew a écrit : Hi, Can you elaborate on how you make this selection, and how you package the fragment? => Since fragments are host-specific, only the fragment you need will be loaded. (If you use an update site, only the fragment you need will

RE: [sqlite] Re: Java wrapper for both windows and linux

2007-03-30 Thread McDermott, Andrew
Hi, > > Can you elaborate on how you make this selection, and how > you package > > the fragment? > > > > => Since fragments are host-specific, only the fragment you > need will be loaded. > (If you use an update site, only the fragment you need > will be downloaded). > > Note:

Re: [sqlite] Re: Java wrapper for both windows and linux

2007-03-30 Thread Xavier RAYNAUD
Steven E. Harris a écrit : Xavier RAYNAUD <[EMAIL PROTECTED]> writes: I use native JNI libraries, and choose at runtime the native library to open. (on eclipse, with OS-dependant fragments, it's easy to do) Can you elaborate on how you make this selection, and how you package the

Re: [sqlite] Java wrapper for both windows and linux

2007-03-30 Thread BardzoTajneKonto
> Hello All > iam java starter and love sqlite . when i download java wraper for sqlite > this is good work in windows but it cant work in linux .i have this > exception "not found libraryjsqlite.so" Althought, i download sqlite.so and > rename to it .where is solution export

Re: [sqlite] SQLite v/s SQLite3 Performance Assay

2007-03-30 Thread Nitin Kashyap
"Nitin Kashyap" <[EMAIL PROTECTED]> wrote: > > My Intentions are towards exploring the reason behind these differences; > and what can be done to counter these performance differences. I'm > seeking some pointers from the Community. > I'm guessing that the poor performance you are getting

Re: [sqlite] Java wrapper for both windows and linux

2007-03-30 Thread mohsen ahmadian
Hello All iam java starter and love sqlite . when i download java wraper for sqlite this is good work in windows but it cant work in linux .i have this exception "not found libraryjsqlite.so" Althought, i download sqlite.so and rename to it .where is solution On 3/30/07, [EMAIL PROTECTED]

Re: [sqlite] Re: Python-Sqlite Unicode characters

2007-03-30 Thread Kostas5904
This is how I solved the problem (in case somebody else face it in the future): ... item=dialog.GetValue() cols="id,attr,type" table="names1" v="(%s, '%s', %s)" % ("null",item,3) #the whole job is done by the ' %s' a="insert into