Re: [sqlite] Using the Sqlite Btree Backend directly

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 Kisho

Re: [sqlite] Using the Sqlite Btree Backend directly

[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

<[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] in-memory database bound to a named buffer

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 database file? > > What I want to do is maintain a database as usual, but then take a

Re: [sqlite] PLSQL

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/ Func

Re: [sqlite] Using the Sqlite Btree Backend directly

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

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 datab

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

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 m

RE: [sqlite] PLSQL

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 Message

Re: [sqlite] Changing column data type

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 foo

Re: [sqlite] PLSQL

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

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"

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 i

Re: [sqlite] multiple request handling

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

RE: [sqlite] invalid command name "sqlite3"

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 Message---

Re: [sqlite] invalid command name "sqlite3"

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: Ce

[sqlite] Changing column data type

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 s

RE: [sqlite] invalid command name "sqlite3"

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 yo

Re: [sqlite] invalid command name "sqlite3"

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"

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 3

RE: [sqlite] invalid command name "sqlite3"

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 continue

[sqlite] invalid command name "sqlite3"

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

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 de

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

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 post

[sqlite] multiple request handling

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

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 be

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

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: the

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

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 fra

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

> 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 LD_LIBRARY_PATH=di

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

"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 from

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

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] <[EMAIL

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

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