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 :)
>
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
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
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
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
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
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
>
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
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.
>
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
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
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
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
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
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
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
>
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
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.
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
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
>
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
>
>
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
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
>
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
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
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
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]
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
28 matches
Mail list logo