On Wed, Aug 20, 2008 at 6:03 AM, cstrader <[EMAIL PROTECTED]> wrote:
> Well it turns out that the db created this way (including the index) is no
> smaller than the one with 2400 tables, and the read is no faster! Does that
> make any sense?
Do you often pull your data one stock at a time? If so
On Mon, Jul 7, 2008 at 7:07 PM, Akbar Anderson <[EMAIL PROTECTED]> wrote:
> Is there a command to clear the screen, or will there be one?
> when line wrapping happens at the bottom of the screen, it looks as
> if it wraps over on the same line. just would like to see a .clear
> or .windex
On Mon, Jun 2, 2008 at 8:12 AM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi Keith,
>
> Your observation is correct. I did not know that when selecting a table a
> shared lock is aquired by the reader and writes are locked out until the
> last row is read or stmt is finialized. This is true even
On Sun, Jun 1, 2008 at 2:19 PM, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have a in-memory database with some tables. Each table has a single
> record writer and multiple readers.
> Readers and writes prepare their own sqlite3_stmt for the db. Everyone
> operates within a single
On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote:
> Here's a more basic example. This is really just a shell script formatting
> problem and it must be really simple. I'm trying to use \n as new line. The
> result I want from the echo statement is as follows but I can't
On Sat, May 31, 2008 at 8:57 PM, Keith Goodman <[EMAIL PROTECTED]> wrote:
> On Sat, May 31, 2008 at 8:30 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote:
>> An example of how to do this with the shell would be helpful.
>>
>> Oddly enough I can do it with applesc
On Sat, May 31, 2008 at 8:30 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote:
> An example of how to do this with the shell would be helpful.
>
> Oddly enough I can do it with applescript; but I can't do it with some other
> shell tools I'm trying to use.
>
> My problem has to do with how to pass
On Fri, May 23, 2008 at 12:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote:
> I'm sorry if this is an obvious question - I'm new to databases. I have
> an application where the database is used to log a large number of
> simulation events. The database is written once and read many times
> (i.e.,
On Tue, May 20, 2008 at 8:59 PM, Carlo S. Marcelo <[EMAIL PROTECTED]> wrote:
> That means I save space right? Because the space all the original entries are
> still intact when I run the delete command? Whereas dropping table clears
> everything (since we are re-creating it)?
>
> I'm only
On Tue, May 20, 2008 at 8:40 PM, Carlo S. Marcelo <[EMAIL PROTECTED]> wrote:
> I run select * from list; and get loads and loads of entries:
>
>
> 81203|0|1|www.newwhitelistentry44994.com|0|0|0
> 81204|0|1|www.newwhitelistentry44995.com|0|0|0
> 81205|0|1|www.newwhitelistentry44996.com|0|0|0
>
On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> where do I find the latest sqlite2 tarball ?
If you have a cvs client:
(from http://www.sqlite.org/download.html)
All SQLite source code is maintained in a CVS repository that is
available for read-only access by
On Fri, May 9, 2008 at 10:27 AM, Beverly Seavey <[EMAIL PROTECTED]> wrote:
> Beverly Seavey wrote:
>> I have tried to import data from a file in the same directory. I
>> have tried leaving out the primary ley
>> value in the file, giving the complete path of the text file, quoting
>> the text
12 matches
Mail list logo