I'm actually memory limited, which is why I am looking at moving infrequently needed object to persistent store with sqlite3. I like the idea of using the asynchronous i/o module so that the writing can be done in a background thread, but still allow the main thread to retrieve data that has been written or is in queue to be written.
My main questions are about that module. I am a bit confused about it since it is not distributed in the main amalgamations. I wanted to make sure that I can just pull the 2 files from the source tarball, or if there are other files I would also need. Additionally, since asynchronous i/o seems to sit apart from the main sqlite3, I was wondering if it would be possible to use with an older (3.5.9) version of sqlite3 that we already use in house. Ray -----Original Message----- From: D. Richard Hipp [mailto:d...@hwaci.com] Sent: Wednesday, June 17, 2009 7:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Asynchronous I/O Module For SQLite On Jun 17, 2009, at 7:18 PM, Rizzuto, Raymond wrote: > I am interested in using sqlite3 for an application where I don't > have a requirement that data persists after the using process ends. > The db is used as a backing store for infrequently used records. So use an in-memory database. Open with sqlite3_open(":memory:", &db). Or if your content is too big for memory, use a temporary database whose name is the empty string: sqlite3_open("", &db). D. Richard Hipp d...@hwaci.com IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
