Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.c > #95304 > unrolled thread

SQLite and cursors

Started by"Mr. Man-wai Chang" <toylet.toylet@gmail.com>
First post2016-10-26 02:19 +0800
Last post2016-10-27 09:47 -0700
Articles 6 — 4 participants

Back to article view | Back to comp.lang.c


Contents

  SQLite and cursors "Mr. Man-wai Chang" <toylet.toylet@gmail.com> - 2016-10-26 02:19 +0800
    Re: SQLite and cursors Keith Thompson <kst-u@mib.org> - 2016-10-25 12:05 -0700
      Re: SQLite and cursors "Mr. Man-wai Chang" <toylet.toylet@gmail.com> - 2016-10-27 19:23 +0800
        Re: SQLite and cursors James Kuyper <jameskuyper@verizon.net> - 2016-10-27 12:17 -0400
        Re: SQLite and cursors Ken Brody <kenbrody@spamcop.net> - 2016-10-27 12:33 -0400
      Re: SQLite and cursors Keith Thompson <kst-u@mib.org> - 2016-10-27 09:47 -0700

#95304 — SQLite and cursors

From"Mr. Man-wai Chang" <toylet.toylet@gmail.com>
Date2016-10-26 02:19 +0800
SubjectSQLite and cursors
Message-ID<nuo7n2$1f4$1@dont-email.me>
Does SQLite has cursor adaptor or filesystem like Visual Foxpro?

The cursor system firsts use memory to create a SQL table. When the 
table exceeds certain sizes, it will start using disk storage.

-- 
   @~@   Remain silent! Drink, Blink, Stretch! Live long and prosper!!
  / v \  Simplicity is Beauty!
/( _ )\ May the Force and farces be with you!
   ^ ^   (x86_64 Ubuntu 9.10)  Linux 2.6.39.3
不借貸! 不詐騙! 不援交! 不打交! 不打劫! 不自殺! 請考慮綜援 (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa

[toc] | [next] | [standalone]


#95307

FromKeith Thompson <kst-u@mib.org>
Date2016-10-25 12:05 -0700
Message-ID<lntwc08d0y.fsf@kst-u.example.com>
In reply to#95304
"Mr. Man-wai Chang" <toylet.toylet@gmail.com> writes:
> Does SQLite has cursor adaptor or filesystem like Visual Foxpro?
>
> The cursor system firsts use memory to create a SQL table. When the 
> table exceeds certain sizes, it will start using disk storage.

As you've been repeatedly reminding others, this newsgroup is for
discussion of C programming.  I don't know whether there's a newsgroup
that discusses SQLite, but there are certainly appropriate forums,
including Stack Overflow.

(A side note: There's a convention of limiting signature blocks to 4
lines.  It's not enforced, but you might consider trimming yours.)

-- 
Keith Thompson (The_Other_Keith) kst-u@mib.org  <http://www.ghoti.net/~kst>
Working, but not speaking, for JetHead Development, Inc.
"We must do something.  This is something.  Therefore, we must do this."
    -- Antony Jay and Jonathan Lynn, "Yes Minister"

[toc] | [prev] | [next] | [standalone]


#95339

From"Mr. Man-wai Chang" <toylet.toylet@gmail.com>
Date2016-10-27 19:23 +0800
Message-ID<nuso35$7tj$1@dont-email.me>
In reply to#95307
On 10/26/2016 3:05 AM, Keith Thompson wrote:
> As you've been repeatedly reminding others, this newsgroup is for
> discussion of C programming.  I don't know whether there's a newsgroup
> that discusses SQLite, but there are certainly appropriate forums,
> including Stack Overflow.

It's hard to avoid 3rd-party libraries to write something useful these 
days. SO... :)

> (A side note: There's a convention of limiting signature blocks to 4
> lines.  It's not enforced, but you might consider trimming yours.)

Later...

-- 
   @~@   Remain silent! Drink, Blink, Stretch! Live long and prosper!!
  / v \  Simplicity is Beauty!
/( _ )\ May the Force and farces be with you!
   ^ ^   (x86_64 Ubuntu 9.10)  Linux 2.6.39.3
不借貸! 不詐騙! 不援交! 不打交! 不打劫! 不自殺! 請考慮綜援 (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa

[toc] | [prev] | [next] | [standalone]


#95343

FromJames Kuyper <jameskuyper@verizon.net>
Date2016-10-27 12:17 -0400
Message-ID<nut9a6$9vs$1@dont-email.me>
In reply to#95339
On 10/27/2016 07:23 AM, Mr. Man-wai Chang wrote:
> On 10/26/2016 3:05 AM, Keith Thompson wrote:
>> As you've been repeatedly reminding others, this newsgroup is for
>> discussion of C programming.  I don't know whether there's a newsgroup
>> that discusses SQLite, but there are certainly appropriate forums,
>> including Stack Overflow.
> 
> It's hard to avoid 3rd-party libraries to write something useful these 
> days. SO... :)

True - but it's trivial to find forums where experts in the hehaviour of
those libraries are available to talk with you. Going to a forum where
people are less likely to be familiar with the library makes sense only
if you want to get fewer correct answers, and more incorrect ones.
If you are, for some reason, deliberately seeking out incorrect answers
to your question, I recommend going farther afield, such as posting to a
newsgroup about religion (turn-about is fair play).

[toc] | [prev] | [next] | [standalone]


#95347

FromKen Brody <kenbrody@spamcop.net>
Date2016-10-27 12:33 -0400
Message-ID<nuta8k$buo$1@dont-email.me>
In reply to#95339
On 10/27/2016 7:23 AM, Mr. Man-wai Chang wrote:
> On 10/26/2016 3:05 AM, Keith Thompson wrote:
>> As you've been repeatedly reminding others, this newsgroup is for
>> discussion of C programming.  I don't know whether there's a newsgroup
>> that discusses SQLite, but there are certainly appropriate forums,
>> including Stack Overflow.
>
> It's hard to avoid 3rd-party libraries to write something useful these days.
> SO... :)

True.  But, you're more likely to get knowledgeable answers in a forum that 
discusses that particular 3rd-party library.

If every question about every 3rd-party library were to be on-topic here, 
just because you can access it from a C program, then you'd never be able to 
find anything you needed through the noise.  (There's enough noise as it is.)

-- 
Kenneth Brody

[toc] | [prev] | [next] | [standalone]


#95348

FromKeith Thompson <kst-u@mib.org>
Date2016-10-27 09:47 -0700
Message-ID<ln4m3x7n89.fsf@kst-u.example.com>
In reply to#95307
Keith Thompson <kst-u@mib.org> writes:
> "Mr. Man-wai Chang" <toylet.toylet@gmail.com> writes:
>> Does SQLite has cursor adaptor or filesystem like Visual Foxpro?
>>
>> The cursor system firsts use memory to create a SQL table. When the 
>> table exceeds certain sizes, it will start using disk storage.
>
> As you've been repeatedly reminding others, this newsgroup is for
> discussion of C programming.

Sorry, that was poorly phrased.  I should have said that this
newsgroup is for discussion of the C programming language.

This isn't just about reducing the noise level of this newsgroup,
though that's certainly part of it.  It's also about you getting
the information you need.  A lot of us here know C very well, but
most of us are not experts on SQLite.  I for one would have to do
some research just to understand what you're asking.

In the particular case of SQLite, the sqlite.org web site mentions
several mailing lists, one of which would undoubtedly be a good
place to ask your question -- though a well chosen Google search
might save you the trouble of posting your question anywhere.

[...]

-- 
Keith Thompson (The_Other_Keith) kst-u@mib.org  <http://www.ghoti.net/~kst>
Working, but not speaking, for JetHead Development, Inc.
"We must do something.  This is something.  Therefore, we must do this."
    -- Antony Jay and Jonathan Lynn, "Yes Minister"

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.c


csiph-web