[sqlite] playing with sqlite3

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

Re: [sqlite] playing with sqlite3

e'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 <mikee...@me.com> wrote: > > Hi, > > > > I'm curious how sqli

Re: [sqlite] playing with sqlite3

e'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 <mikee...@me.com> wrote: > > Hi, > > > > I'm curious how sqli

Re: [sqlite] playing with sqlite3

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

Re: [sqlite] playing with sqlite3

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 compile SQLit

Re: [sqlite] Query Optimization Help

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 >

Re: [sqlite] Best GUI?

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

Re: [sqlite] import a CSV-File

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

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

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

Re: [sqlite] SELECT DISTINCT bug in SQLite 3.6.0?

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,

Re: [sqlite] Explanation

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

Re: [sqlite] Does sqlite3 have variables like Oracle?

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.

Re: [sqlite] Does sqlite3 have variables like Oracle?

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