Re: [sqlite] New word to replace "serverless"

2020-01-27 Thread David Baird
Edit, that last part should say "skim server" :D On Mon, Jan 27, 2020, 10:54 PM David Baird wrote: > How about "skim server"? So if, "server" means a whole server, then like > whole milk versus skim milk, a fraction of a server becomes severless :) >

Re: [sqlite] New word to replace "serverless"

2020-01-27 Thread David Baird
How about "skim server"? So if, "server" means a whole server, then like whole milk versus skim milk, a fraction of a server becomes severless :) On Mon, Jan 27, 2020, 9:57 PM Stephen Chrzanowski wrote: > I'd stick with "serverless". The marketing teams that make "serverless" > mean that

[sqlite] INSERT OR IGNORE consuming too many rowids

2015-12-09 Thread David Baird
On Dec 9, 2015 7:14 PM, "Simon Slavin" wrote: > > > On 9 Dec 2015, at 9:10pm, David Baird wrote: > > > My cocnern is that: the database engine shouldn't > > needlessly waste/discard perectly good chunks of rowids > > Please don't think of them as 'ch

[sqlite] INSERT OR IGNORE consuming too many rowids

2015-12-09 Thread David Baird
On Dec 9, 2015 8:06 AM, "Richard Hipp" wrote: > > On 12/9/15, David Baird wrote: > > > > Looks like it's fixed, as long as I stick to new versions. *cross fingers* > > Bisecting shows that the change in behavior occurred here: > https://www.sqlite.org/src/t

[sqlite] INSERT OR IGNORE consuming too many rowids

2015-12-09 Thread David Baird
On Wed, Dec 9, 2015 at 7:14 AM, Clemens Ladisch wrote: > David Baird wrote: > > # INSERT INTO "StringIntern" VALUES(5,'c'); <-- undesired behavior > > # INSERT INTO "StringIntern" VALUES(3,'c'); <-- desired behavior > > Works for me. Are

[sqlite] INSERT OR IGNORE consuming too many rowids

2015-12-09 Thread David Baird
Hi, I have a use case in which a table is being used to associate integers to unique strings. When loading the strings, it's possible there may be some redundancies, which INSERT OR IGNORE successfully ignores. However, redundant values that should have been ignored _sometimes_ have a side effect

Re: [sqlite] SQlite C API screwing port access?

2010-03-24 Thread David Baird
On Wed, Mar 24, 2010 at 11:19 AM, Martin Sigwald wrote: > Problem Solved: As some one point out, it was MY fault. > When allocating memory for my ICMP packets I wasnt doind a bzero to fill all > fields with 0, so some "garbage" generated by Sqlite use of memory was >

Re: [sqlite] SQlite C API screwing port access?

2010-03-24 Thread David Baird
On Wed, Mar 24, 2010 at 11:09 AM, Martin Sigwald wrote: > Doing N pings after a _close or a query has the same result as doind one: > not one of them works. Do 2 pings work ever? For example, how about each of these scenarios? open_db ping ping close_db or ping ping or

Re: [sqlite] SQlite C API screwing port access?

2010-03-24 Thread David Baird
On Wed, Mar 24, 2010 at 9:42 AM, Martin Sigwald wrote: > I meant socket. I know sockets are FDs. My mistake, sorry. > Yes, I tried putting the call before Sqlite calls and it works perfectly. If > I put it between open and close it works, provided I dont do anything else. >

Re: [sqlite] SQlite C API screwing port access?

2010-03-24 Thread David Baird
On Wed, Mar 24, 2010 at 9:24 AM, David Baird <dhba...@gmail.com> wrote: > On Wed, Mar 24, 2010 at 9:05 AM, Martin Sigwald <msigw...@gmail.com> wrote: >> While I could gather, both the open system called generated by the DB and >> the socket() syscall are returning a FD=3

Re: [sqlite] SQlite C API screwing port access?

2010-03-24 Thread David Baird
On Wed, Mar 24, 2010 at 9:05 AM, Martin Sigwald wrote: > While I could gather, both the open system called generated by the DB and > the socket() syscall are returning a FD=3. > That is, they are both trying to use the same filedescriptor. My guess is > packets get sent to

Re: [sqlite] Changing Table Contents

2009-07-01 Thread David Baird
On Wed, Jul 1, 2009 at 9:50 PM, Rick Ratchford wrote: > From what I understand, ANYTIME you do a SQL statement, such as "SELECT...", > you are doing this to a TABLE and returning the result in a sort of > 'recordset'. > > So then, the table is this sqlite_master, the

Re: [sqlite] Changing Table Contents

2009-07-01 Thread David Baird
On Wed, Jul 1, 2009 at 6:05 PM, Rick Ratchford wrote: > I'm using a VB wrapper, and so I run this by... > >    Cnn.Execute "Select count(*) FROM sqlite_master WHERE tbl_name = > 'DeltaGrid'" > > Thing is, I don't know where to check for the return value. I'm afraid I

Re: [sqlite] Changing Table Contents

2009-07-01 Thread David Baird
On Wed, Jul 1, 2009 at 5:29 PM, Rick Ratchford wrote: > 1. Determine if the table has already been created due to a prior run. > > 2. If so, to remove the information currently in that table and replace it > with new information. > > I'm not sure how to determine whether

Re: [sqlite] sql statement to concatinate two rows.

2009-02-17 Thread David Baird
No problem. As a side note, it appears that you might also want to use group_concat on either hostName or remoteWXType too, but I can't quite tell 100%. As it stands right now, if there are multiple distinct values in the group, sqlite will arbitrarily choose one single value to represent the

Re: [sqlite] sql statement to concatinate two rows.

2009-02-17 Thread David Baird
On Tue, Feb 17, 2009 at 11:16 PM, Joanne Pham wrote: > Hi All, > I have the select statement as below > sqlite> select remoteId, hostName , remoteWXType from remoteWXTable order by > hostName; > and the output is below: > > 1|HostName1-T432|2 > 2|HostName2-T421|2 >

Re: [sqlite] SQLite3 to SQLite2?

2008-06-16 Thread David Baird
On Mon, Jun 16, 2008 at 6:18 PM, Gilles Ganault <[EMAIL PROTECTED]> wrote: > We have an application that can only read SQLite2 databases. Is there > an easy way to convert a SQLite3 database file into the SQLite2 > format? This might work: echo .dump | sqlite3 input.db | sqlite output.db

Re: [sqlite] graph question

2008-06-09 Thread David Baird
On Mon, Jun 9, 2008 at 3:49 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >> select f || ' ' || group_concat(t, ' ') >> from w >> where f in (1, 2, 3); >> group by f; >> >> HTH >> Dennis > > Can you explain that? > > What's the || ' ' || part? || is the string concat operator. e.g.

Re: [sqlite] graph question

2008-06-09 Thread David Baird
On Mon, Jun 9, 2008 at 11:40 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > David Baird wrote: >> >> Okay, just built SQLite 3.5.9 and group_concat does in fact work: >> >> select group_concat(t, ' ') from w where f=1; > > You forgot the parent value

Re: [sqlite] graph question

2008-06-09 Thread David Baird
On Mon, Jun 9, 2008 at 11:19 AM, David Baird <[EMAIL PROTECTED]> wrote: > On Mon, Jun 9, 2008 at 11:09 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: >> Wilson, Ron P >> <[EMAIL PROTECTED]> >> wrote: >>> select t from w where f=1; >>> 2 >

Re: [sqlite] graph question

2008-06-09 Thread David Baird
On Mon, Jun 9, 2008 at 11:09 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Wilson, Ron P > <[EMAIL PROTECTED]> > wrote: >> select t from w where f=1; >> 2 >> 3 >> 4 >> 5 >> 6 >> 7 >> >> I would like the output to look like this: >> >> 1 2 3 4 5 6 7 >> >> i.e. parent child1 child2 ... childN > >

Re: [sqlite] Select TOP n

2008-04-20 Thread David Baird
On Sun, Apr 20, 2008 at 5:07 PM, James Dodd <[EMAIL PROTECTED]> wrote: > Hi, > > (Newbie to sqlite, some experience with SQL Server 2000). I tried to do a > "SELECT TOP 10 * FROM tab1" and sqlite3 complained. Then I looked at the SQL > syntax page and indeed TOP doesn't seem to be there. Is

Re: [sqlite] Performance.....

2008-03-05 Thread David Baird
On Wed, Mar 5, 2008 at 8:21 AM, <[EMAIL PROTECTED]> wrote: > My main concern is performance. Has anyone had any similar application > experience they could comment on? I want to be able to insert data arriving > on the SPI bus and then query the data to update a GUI at a very high rate >

Re: [sqlite] indexing

2008-02-13 Thread David Baird
On Feb 13, 2008 1:01 PM, Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote: > Thank you for a clear and precise answer. > > I seem to recall that it is possible to have in-memory databases with > sqlite. But perhaps that is only possible with alot of tinkering and > using the C functions. Is that

Re: [sqlite] Innovative examples / user stories

2008-02-13 Thread David Baird
On Feb 11, 2008 10:51 AM, Lars Aronsson <[EMAIL PROTECTED]> wrote: > Is there any documentation of how people use SQLite in odd ways in > their everyday activities? I used to work with the NS-2 network simulator as an undergrad at NMT for some experiments we were doing in wireless power control

Re: [sqlite] Why attach databases?

2008-02-07 Thread David Baird
On Feb 7, 2008 3:21 PM, Jason Tudor <[EMAIL PROTECTED]> wrote: > In general, what is the benefit of attaching databases verses maintaining > multiple connections? Well, let's say that you don't have the same schema in both databases. Attaching two databases allows you to do queries across

Re: [sqlite] Broken links to "sqlite3" on website

2008-01-31 Thread David Baird
On Jan 31, 2008 1:45 PM, <[EMAIL PROTECTED]> wrote: > Tnx. Please try it again now. Great, seems to be working now, even for other pages that I didn't list. Thanks! - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Broken links to "sqlite3" on website

2008-01-31 Thread David Baird
Hi, I'm not complaining (I love SQLite), but I just wanted to point out that the "sqlite3" link is broken from multiple web pages: http://www.sqlite.org/c3ref/objlist.html http://www.sqlite.org/c3ref/intro.html Also, links to "sqlite3_stmt" are broken. It seems that any link containing