Thanks. I didn't think of "CTEs" either. I need to read up on them.
Mike
> On Sep 12, 2016, at 08:49, Dominique Devienne wrote:
>
>> On Sun, Sep 11, 2016 at 11:48 PM, mikeegg1 wrote:
>>
>> I think Oracle (a long distant memory) has variables like @variable or
>> @@variable.
>
>
> Not reall
Duh. What a brilliant idea. Wish I had thought of it. :) Thanks.
Mike
> On Sep 12, 2016, at 08:02, David Bicking wrote:
>
> Sqlite doesn't have variable. While last row id is available other ways, a
> trick to emulate a variable is to create a temp table with one field. You put
> the value
On Fri, 28 Aug 2009, Marco Bambini might have said:
> Hello,
>
> today I made some test on a project I wrote some years ago.
> I upgraded sqlite library from version 3.4.2 to version 3.6.17.
> What I am really unable to understand is the time difference required
> to perform the same query usin
On Fri, 31 Jul 2009, Lennart Ramberg might have said:
> Hello,
>
> I'm new to this list and what prompted me to sign up was a SELECT
> DISTINCT problem I experience in REALbasic (Linux), which has SQLite
> built-in.
>
> REALbasic downgraded their latest version from SQLIte 3.6.3 to 3.6.0
> Now,
On Fri, 13 Mar 2009, Pierre Chatelier might have said:
> Hello,
>
> I am using SQLITE to store and retrieve raw data blocks that are
> basically ~300Ko. Each block has an int identifier, so that insert/
> select are easy. This is a very basic use : I do not use complex
> queries. Only "INSER
On Fri, 06 Mar 2009, Rich Shepard might have said:
> On Fri, 6 Mar 2009, Hans-Martin wrote:
>
> > It seems that there is no way to get rid of the embedded CR/LF without parse
> > the complete output.
>
>Use sed. That's what it's for.
>
> Rich
Or tr(1) if it's a single character.
Mike
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
> This is a bit of a religious question, but which are the mest/most
> popular *nix GUIs out there? I'm using a firefox plugin but not
> entirely happy with it. What do you use and why?
I prefer vi and sh.
Mike
On Wed, 11 Feb 2009, inZania might have said:
>
> Hello,
>
> I have a query that is slowing down my application significantly; in some
> cases, it takes 20+ seconds (this is in a SQLite database in an iPhone app,
> which is why it is so slow - the iPhone doesn't have as much system
> resources).
On Fri, 30 Jan 2009, D. Richard Hipp might have said:
>
> On Jan 30, 2009, at 8:42 AM, Mike Eggleston wrote:
>
> > This box is fedora core 5 with sqlite3 3.3.3.
>
> Version 3.3.3 will be three years old tomorrow. From this I'm
> guessing you didn't com
On Fri, 30 Jan 2009, John Machin might have said:
> On 30/01/2009 2:27 AM, Mike Eggleston wrote:
> > On Thu, 29 Jan 2009, Thomas Briggs might have said:
> >
> >>When you say the load "stops", what do you mean? Does the sqlite3
> >> pr
x27;s something weird about it.
>
>Also, have you done a line count on the file so you know exactly
> how many rows it should load?
>
>-T
>
> On Wed, Jan 28, 2009 at 5:33 PM, Mike Eggleston wrote:
> > Hi,
> >
> > I'm curious how sqlite3 may perfor
x27;s something weird about it.
>
>Also, have you done a line count on the file so you know exactly
> how many rows it should load?
>
>-T
>
> On Wed, Jan 28, 2009 at 5:33 PM, Mike Eggleston wrote:
> > Hi,
> >
> > I'm curious how sqlite3 may perfor
Hi,
I'm curious how sqlite3 may perform for some of my applications that
really don't need things like MySQL or larger. I am using bacula
(http://www.bacula.org) at work so I dumped the bacula data from MySQL
(mysqldump bacula > bacula.sql), wrote a perl script to massage the data,
and now I'm try
13 matches
Mail list logo