[sqlite] Is this an in-memory database too

I was trying to find info for the same, but couldn't. Do let me know.

[sqlite] ANN: SQLite ODBC Driver 0.65

Hi all, a new version of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc An unoptimized driver version supporting SQLite 3.0.7 is included. Best regards, Christian

Re: [sqlite] Is this an in-memory database too

nope, runs entirely off disk. On Wed, 6 Oct 2004 23:18:12 -0700, R S <[EMAIL PROTECTED]> wrote: > I was trying to find info for the same, but couldn't. Do let me know. > -- Cory Nelson http://www.int64.org

[sqlite] in memory database

Hello, I try to use sqlite for an 'in memory' database. I wrote some C code which does what I expected. The problem I have now is that reaching a size of ~80 MB it seems SQLite starts to save parts of the database on disk, but I would like to keep the whole thing in memory. Is there any

Re: [sqlite] Is this an in-memory database too

Cory Nelson wrote: nope, runs entirely off disk. On Wed, 6 Oct 2004 23:18:12 -0700, R S <[EMAIL PROTECTED]> wrote: I was trying to find info for the same, but couldn't. Do let me know. Ummm actually SQLite can be an in-memory database. Check this out:

Re: [sqlite] Is this an in-memory database too

R S wrote: I was trying to find info for the same, but couldn't. Do let me know. SQLite normally operates off of disk. It reads a little from the disk as it can get by with, but once it reads from the disk it caches information in memory in case it has to reuse it later. The size of the memory

[sqlite] sqlite3_temp_directory

Is there any way to change the sqlite3_temp_directory global? I'm running sqlite under iis and the user doesn't have write access to their temp directory. I've made my own little function and exported it through the def file. Is it possible to include something like this in a future release,

RE: [sqlite] sqlite3_temp_directory

Changing a process wide variable like that seems a bit drastic. I'd be concerned about what effect that might have on all the other things running under iis. For example, some of them might be running as different users who might not have access to the path. Thanks. -Original Message-

[sqlite] SQL Lite version 3.0.7 not reconizing sqlite databases While version 2.8.15 does

The same databases that are recognized and work in Sqlite version 2.8.15 are not recognized in Sqlite version 3.0.7. When the sqlite function sqlite3_get_table is called using version 3.0.7 the result is 26 which is: File opened that is not a database file When the same function is used in

[sqlite] Single-file databases: how do they do it?

How do single-file databases handle multi-table databases? Do they simply pack separate physical table files into a single file, or have they found a way to store in one table all the definition and data values of a database? Can someone un-curious-ify me? Thanks. > -Original Message-

Re: [sqlite] SQL Lite version 3.0.7 not reconizing sqlite databases While version 2.8.15 does

On Oct 7, 2004, at 16:00, Steve Frierdich wrote: The same databases that are recognized and work in Sqlite version 2.8.15 are not recognized in Sqlite version 3.0.7. When the sqlite function sqlite3_get_table is called using version 3.0.7 the result is 26 which is: File opened that is not a

Re: [sqlite] sqlite3_temp_directory

Thursday, October 7, 2004, 9:17:28 AM, Kenneth wrote: > Changing a process wide variable like that seems a bit drastic. I'd be > concerned about what effect that might have on all the other things running > under iis. For example, some of them might be running as different users > who might not

[sqlite] sqlite3_get_table fails in SQL Lite version 3.0.7, sqlite_get_table works in SLQ Lite Version 2.8.15 -

In the Sqlite version 2.8.15 I used the sqlite_get_table function that works with a return value of SQLITE_OK. In the Sqlite version 3.0.7 I used the sqlite3_get_table function that fails with a return value of 26, which is: "File opened that is not a database file ". Both version used the

Re: [sqlite] sqlite3_get_table fails in SQL Lite version 3.0.7, sqlite_get_table works in SLQ Lite Version 2.8.15 -

Steve Frierdich wrote: In the Sqlite version 2.8.15 I used the sqlite_get_table function that works with a return value of SQLITE_OK. In the Sqlite version 3.0.7 I used the sqlite3_get_table function that fails with a return value of 26, which is: "File opened that is not a database file ".

Re: [sqlite] Is this an in-memory database too

Another novice question: Does this run in its separate process or is directly linked into the application requiring access to the stored data. I don't want a crash in any of my embedded modules to crash the database as well. On Thu, 07 Oct 2004 07:44:43 -0400, D. Richard Hipp <[EMAIL

[sqlite] For Attn of Richard Hipp

Hi Richard I apologize profusely for using the SQLite General Mail List in this way but I can not think of any other way to solicit a reply. I have sent two emails to your private email address concerning paid technical support and some far I have not received a reply. Please believe me this

Re: [sqlite] For Attn of Richard Hipp

John Dean wrote: Hi Richard I have sent two emails to your private email address concerning paid technical support and some far I have not received a reply. Please believe me this is not a time waster it is a genuine enquiry I never saw them. Sorry. To all: Your emails are guaranteed to make

Re: [sqlite] Single-file databases: how do they do it?

Cena, Resty wrote: How do single-file databases handle multi-table databases? Do they simply pack separate physical table files into a single file, or have they found a way to store in one table all the definition and data values of a database? Can someone un-curious-ify me? Thanks. To see how

Re: [sqlite] Single-file databases: how do they do it?

On Thu, 7 Oct 2004, Cena, Resty wrote: >How do single-file databases handle multi-table databases? Do they simply >pack separate physical table files into a single file, or have they found >a way to store in one table all the definition and data values of a >database? Can someone un-curious-ify

Re: [sqlite] Is this an in-memory database too

- Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 7:10 PM Subject: Re: [sqlite] Is this an in-memory database too > Yes. As many different processes as you want can read the database > at the same time. Only one

RE: [sqlite] Single-file databases: how do they do it?

So it is purely a storage 'trick". There is no magical data modelling technique used that requires or suggests to use a single physical file. I'll take a look at the suggested sqlite page. Thanks and cheers. > -Original Message- > From: Christian Smith [SMTP:[EMAIL PROTECTED] >

[sqlite] Upgrading version 2 databases to version 3 databases - what is meant by “have ready the command-line shells for both version 2.8 and 3.0. "

Can anyone give me a step-by-step instruction on how to update databases to a version 3 database sqlite version 3 can be used? I referenced the website http://www.sqlite.org/version3.html ,as indicated by Tito Ciuro, but when I ran the sqlite.exe program from a command prompt with the

Re: [sqlite] Is this an in-memory database too

mike cariotoglou wrote: > - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: > <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 7:10 PM Subject: > Re: [sqlite] Is this an in-memory database too > >> Yes. As many different processes as you want can read the database

Re: [sqlite] Upgrading version 2 databases to version 3 databases - what is meant by “have ready the command-line shells for both version 2.8 and 3.0. "

Steve Frierdich wrote: Can anyone give me a step-by-step instruction on how to update databases to a version 3 database sqlite version 3 can be used? I referenced the website http://www.sqlite.org/version3.html ,as indicated by Tito Ciuro, but when I ran the sqlite.exe program from a command

[sqlite] Improving text search using LIKE '%string to search%'

I use SQLite 2.8.14 for a documentation application which needs a lot of text search. Text searchs are done using somethink like: SELECT * FROM Texts WHERE CurrentText LIKE '%string to search%'; I use index on every searchable columns. Response time are acceptable until about 10 texts stored

[sqlite] Upgrading databases from sqlite2 and sqlite3 failed when new database same name, sqlite version 3 databases not able to view in sqlite explorer HELP

I downloaded sqlite3.exe to perform an upgrade of a database from version 2 to version 3. When I upgraded a version 2 database to a version 3 database with the same name the operation failed.The upgrade failed because the application kept saying SQL error: file is encrypted or is not a

[sqlite] Does the Sqlite explorer program not view version 3 sqlite databases?

Does the sqlite explorer program not view version 3 sqlite databases? I tried to open a sqlite version 3 database with the sqlite explorer program and the program said that the database is malformed. Is there a new sqlite explorer program to download to view sqlite version 3 databases? Thanks

Re: [sqlite] Upgrading databases from sqlite2 and sqlite3 failed when new database same name, sqlite version 3 databases not able to view in sqlite explorer HELP

On Thu, 07 Oct 2004 16:13:48 -0400, Steve Frierdich <[EMAIL PROTECTED]> wrote: > I downloaded sqlite3.exe to perform an upgrade of a database from > version 2 to version 3. > When I upgraded a version 2 database to a version 3 database with the > same name the operation failed.The upgrade failed

[sqlite] new Ticket 949: add user-level test for file validity

FYI, I added the following ticket today. A copy is also here on the list in case any discussion is necessary. (No replies may be taken as consensus.) -- Darren Duncan - Type: new Version: 3.0.7 Status: active Created: 2004-Oct-07 20:28 Severity: 3 Last Change:

Re: [sqlite] Does the Sqlite explorer program not view version 3 sqlite databases?

Steve Frierdich wrote: Does the sqlite explorer program not view version 3 sqlite databases? I tried to open a sqlite version 3 database with the sqlite explorer program and the program said that the database is malformed. Is there a new sqlite explorer program to download to view sqlite

Re: [sqlite] Improving text search using LIKE '%string to search%'

Op donderdag 7 oktober 2004 21:50, schreef Patrick Peccatte: > I use SQLite 2.8.14 for a documentation application which needs a lot of > text search. > Text searchs are done using somethink like: > SELECT * FROM Texts WHERE CurrentText LIKE '%string to search%'; > I use index on every searchable

[sqlite] problems using DBD::Sqlite2

I put in a ticket, but I thought I'd also throw this question out to you guys. I'm having some problems with a script that is using sqlite. I'll cut and paste from the ticket: POE::Component::EasyDBI Got STDERR from child, which should never happen ( <- errstr= ( 'no such table: trapdlog(1) at

[sqlite] Sqlite explorer

I have a new version of sqliteExplorer, which handles v3 databases, and has some other enhancements as well, for some time now. The problem is, I dont have a web server to put it on. DRH, is there some place on the site where I can upload it ? question to all: how many people use sqlite with

RE: [sqlite] Sqlite explorer

If Richard is unable to provide the space for you, I should be able to host the files for you (and I would be sure to give you fair warning if it got to the point where I couldn't). Just let me know if I can help. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/

Re: [sqlite] Is this an in-memory database too

> Yes, I was a trifle optimistic with my estimates > > On an operating system with a sensible I/O scheduler (I cannot say > whether or not windows qualifies) it should normally take about > two complete rotations of the disk platter to complete a write. > Obviously a large change would take

Re: [sqlite] problems using DBD::Sqlite2

On Thursday 07 October 2004 5:11 pm, Freeman, Michael wrote: > I put in a ticket, but I thought I'd also throw this question out to you > guys. I'm having some problems with a script that is using sqlite. I'll > cut and paste from the ticket: > > > > POE::Component::EasyDBI Got STDERR from child,

Re: [sqlite] Is this an in-memory database too

> It would usually make more sense to do the following: > > BEGIN TRANSACTION; > ... inserts,updates,deletes > COMMIT; > > You get pretty much the same affect, but it is safe. Setting yes, I am aware of this, of course. what I am saying is : since there *is* a cache, and since we *can* modify its

Re: [sqlite] temp_store assumptions

> > - set the pragma "temp_store" to MEMORY > - CREATE TEMPORARY VIEW temp_table AS () > > I am assuming that temp_table is completely in memory, and any queries > against it will not go back to the disk. Since the table itself is > small, I am hoping that the overhead of reading the entire table

[sqlite] sqlite3_get_table_printf, sqlite3_exec_printf not available anymore?

Hi, We have been using sqlite3_get_table_printf, sqlite3_exec_printf functions in our C application to execute the queries. I find that these APIs are not available in v3.0.7 though it was available in v3.0.3. May I know why these APIs are not available in the stable sqlite 3.0.7 and may I

Re: [sqlite] new Ticket 949: add user-level test for file validity

At 12:22 PM +1000 10/8/04, [EMAIL PROTECTED] wrote: Darren, Are you asking for a pragma integrity_check (which already exists) or are you just wanting to verify the magic string at the beginning of the file? The magic string. I want an elegant way for a user to explicitly check the magic string,

Re: [sqlite] sqlite3_get_table_printf, sqlite3_exec_printf not available anymore?

you can either use sqlite3_mprintf() or create prepared statements that use the sqlite3_bind_* functions. On Fri, 8 Oct 2004 10:45:45 +0530, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > We have been using sqlite3_get_table_printf, sqlite3_exec_printf functions > in our C application