Re: [sqlite] row size limit

Greg Obleshchuk wrote: I know the MS is looking at replacing the file system with the SQL engine in Longhorn so they must have solved the issue. They're not replacing NTFS with a database. They're implementing a database layer (WinFS) on top of NTFS. It's not entirely clear what they're doing,

Re: [sqlite] row size limit

These disk access issues are why no database I know of actually stores large objects inline. It would be crazy to do so. mysql, postgres, and oracle all have support for blobs, and none of them store them inline. (btw, if you care about disk io performance for blobs, you can tune the fs

RE: [sqlite] Updating with a Cursor

Actually I just discovered that sqlite4delphi uses exactly the technique that I want. It parses the original query to extract the table name then constructs a new update statement. Turns out it isn't too hard. Regards, Chris. > -Original Message- > From: Chris Waters [mailto:[EMAIL

Re: [sqlite] row size limit

At 10:59 AM +1000 4/19/04, Greg Obleshchuk wrote: I guess it would depend on the system. I assume (and may ask) that MS SQL and Oracle use multi-threaded processes to access the information and that is the way they get around it. I know the MS is looking at replacing the file system with the

Re: [sqlite] row size limit

At 7:50 PM -0400 4/18/04, D. Richard Hipp wrote: Suppose you have a 1MB row in SQLite and you want to read the whole thing. SQLite must first ask for the 1st 1K page and wait for it to be retrieved. Then it asks for the 2nd 1K page and waits for it. And so forth for all 1000+ pages. If each

Re: [sqlite] row size limit

>>Indeed. But I wonder if most all databases do it the same way? Or do >>all file-based dbs do it the same way? etc. I guess it would depend on the system. I assume (and may ask) that MS SQL and Oracle use multi-threaded processes to access the information and that is the way they get around

Re: [sqlite] row size limit

On Apr 18, 2004, at 7:31 PM, Greg Obleshchuk wrote: Hi Richard, You know that is the first clear and concise explanation of why not to store large blobs in a database that I have heard anywhere. Indeed. But I wonder if most all databases do it the same way? Or do all file-based dbs do it the

Re: [sqlite] row size limit

Hi Richard, You know that is the first clear and concise explanation of why not to store large blobs in a database that I have heard anywhere. Greg - Original Message - From: D. Richard Hipp Cc: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 9:50 AM Subject: Re: [sqlite]

Re: [sqlite] row size limit

[EMAIL PROTECTED] wrote: According to the FAQ on sqlite.org, the row size is arbitrarily limited to 1MB, which can be increased to 16MB by changing a #define in the source code. My question is, why even limit the row size? Is there a way the code can modified so that there is no limit for the row

RE: [sqlite] Updating with a Cursor

Hi, I am replacing a non-SQL database engine and so I'm trying to match the existing DB API structure as closely as possible to minimize the required code restructuring. The type of structure I am aiming for is like Oracle's PL/SQL: cursor c_f is select a,b from f where length(b) = 5 for

Re: [sqlite] Updating with a Cursor

On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > I am building a C wrapper for sqlite that can abstract away the sqlite API Why? Are you trying to make it easier to port your application to multiple databases? If so you should look at the ns_db database API from AOLserver. It

[sqlite] Updating with a Cursor

Hi, I am building a C wrapper for sqlite that can abstract away the sqlite API and I am trying to work out the best way to deal with updating records using a cursor. So I want the API to look something like this when it is used: Cursor = Query("select foo from bar"); while (Cursor.MoreRecords())

[sqlite] Encodings question

Hi, I am a bit of a newbie with encodings... I know that sqlite supports 2 kinds of encodings natively at the moment. These encodings are ISO-8859-1 and UTF8. The choice of encoding is set at compile time. As far as I understand, UTF-8 will read 8859-1 without problem but ISO-8859-1 will not be

Re: [sqlite] Create a New Database?

Hmm, in mysql its not so ok, So, if I move the test.db database, into a another folder called db Then start sqlite ./sqlite and do this: .database /db/ this should show the databases in the db folder? or did I miss something.. please note: using Mac OS X Thanks Richard On Apr 18, 2004, at

Re: [sqlite] Create a New Database?

On Apr 18, 2004, at 7:42 AM, Richard wrote: Now all commands should be active, hence where the database "test.db" I can see it inside the folder, but sqlite can not see it, or is there another step I'm missing. It doesn't work that way. The sqlite command-line tool doesn't look for databases in

Re: [sqlite] Create a New Database?

Confused, I thought that .databases command would list all database, under sqlite? the you can choose which one you wanted to make active. ??? Once I start sqlite correctly, via the ./sqlite command Now all commands should be active, hence where the database "test.db" I can see it inside the

Re: [sqlite] Create a New Database?

Richard wrote: G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not found Hehe, take it you're new to OSX (I think) unix like intricacicies. Should you not type: ./sqlite test.db as you've probably got a setting somewhere to search system paths for binaries not including the

Re: [sqlite] Create a New Database?

On Apr 18, 2004, at 9:15 AM, Richard wrote: Well, I may of have spoken too, soon. G4:/applications/sqlite rnagle$ ls SQLite ReadMe.pdf libsqlite.a sqlite sqlite.htest G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not

Re: [sqlite] Create a New Database?

On Apr 18, 2004, at 8:56 AM, Richard wrote: I think, the problem is that, I did do that, sqlite test.db and did not get a correct reply... Hence, wondering if I'm did right.. Inside the SQLITE folder, is the following: libsqlite.a sqlite sqlite readme.pdf sqlite.h

Re: [sqlite] Create a New Database?

Well, I may of have spoken too, soon. G4:/applications/sqlite rnagle$ ls SQLite ReadMe.pdf libsqlite.a sqlite sqlite.htest G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not found G4:/applications/sqlite rnagle$ sqlite

Re: [sqlite] Create a New Database?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 18 April 2004 15:56, Richard wrote: > I think, > the problem is that, I did do that, > sqlite test.db > and did not get a correct reply... > > Hence, wondering if I'm did right.. > > Inside the SQLITE folder, is the following: >

Re: [sqlite] Create a New Database?

I think, the problem is that, I did do that, sqlite test.db and did not get a correct reply... Hence, wondering if I'm did right.. Inside the SQLITE folder, is the following: libsqlite.a sqlite sqlite readme.pdf sqlite.h I been clicking on ssqlite, which is the a

[sqlite] Create a New Database?

Okay, Newbie... When into SQlite folder, and click on terminal window app, and launch program... did a .database, shows 0 main 1 temp How does one create a new database...? tried: Create database contact; nope. Thanks- Rick - To

[sqlite] row size limit

According to the FAQ on sqlite.org, the row size is arbitrarily limited to 1MB, which can be increased to 16MB by changing a #define in the source code. My question is, why even limit the row size? Is there a way the code can modified so that there is no limit for the row size (other than the