Re: [sqlite] Documentation in PDF

Luuk wrote, On 11/09/2011 05:29 AM: On 08-11-2011 14:04, Arbol One wrote: Any one knows where I can get the documentation in http://www.sqlite.org/download.html, but in PDF format? The main problem with this is that PDF is so much baes on a page layout, and HTML is not I tried to

Re: [sqlite] Indirect Referencing

with prepare? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Konrad J Hambrick

Re: [sqlite] Indirect Referencing

Bertus -- The only way to reference a Variable Table Name would be to create a Dynamic SQL Statement at runtime, prep the Dynamic Statement then exec. This would be true for all implementations of SQL that I am aware of ... -- kjh Stander, Bertus (Pretoria) wrote, On 11/01/2011 05:25 AM:

Re: [sqlite] Lack of "decimal" support

All -- This page has a lot of info about Decimal Number support, including a set of libraries: http://speleotrove.com/decimal/ -- kjh Black, Michael (IS) wrote, On 03/27/2011 06:29 AM: > Base 10 multiplication is needed. Although money is the main reason for > doing BCD due to cumulative

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

LacaK wrote, On 03/22/2011 08:53 AM: >>> / Problem will be solved if SQLite will store such values as text ... so Laco -- Problem will be solved when you teach SQLite to store such values as text. This library might help your project: http://speleotrove.com/decimal/ -- kjh

Re: [sqlite] Loss of Binary Data in Dump File

Art Age Software wrote: > With Roger's help I have gotten to the bottom of this issue, and I > wanted to post the resolution to the list in case anyone else bumps > into it. > > There is a bug in PHP versions prior to PHP 5.3 that makes it > impossible to reliably create/store BLOB columns. My

Re: [sqlite] Importing csv to SQLite

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/13/2010 04:06 PM, BareFeetWare wrote: >> All this talk of replacing multiple commas with pipes, then replacing pipes >> and so on, though clever and helpful is problematic, cumbersome and even >> comical for a

Re: [sqlite] Importing csv to SQLite

BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. > > On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > >> This is true. You

Re: [sqlite] Importing csv to SQLite

Rich Shepard wrote: On Mon, 13 Sep 2010, Mithun Nair wrote: When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found 1". Later i found that importing a comma separated file into SQlite wont work because a comma is considered as a delimiter by

Re: [sqlite] "Bad CPU type in executable"?

Jim -- I agree with your sentiments. But as Dr. Kirkby is alleged to have once said ... Jim Showalter wrote: > I really really hate top-posting. > > - Original Message - > From: "Dr. David Kirkby" > To: "General Discussion of SQLite Database"

Re: [sqlite] ANN: SQLite 3.6.16.C#

forums/t/1642.aspx > > - Original Message - From: "Konrad J Hambrick" <kon...@payplus.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Sunday, August 02, 2009 12:19 PM > Subject: Re: [sqlite] ANN: SQLite 3.6.1

Re: [sqlite] ANN: SQLite 3.6.16.C#

Noah -- This is a wonderful accomplishment ! However, I have a question ... Doesn't C# support native function calls ? If so, other than scratching an itch, what does a native port to C# do ? Thanks. -- kjh Noah Hart wrote: > Richard sent me a gentle reminder that read in part: > >

Re: [sqlite] general question

There are Free and Commercial ODBC Drivers for Text / CSV files out there. -- kjh On 07/08/2009 07:06 AM, P Kishor wrote: > On Wed, Jul 8, 2009 at 2:00 PM, _h_ wrote: >> Hi Kishor, >> Thank your pointing out perl db module. >> Is the same things are avaiable as C/C++

Re: [sqlite] Database inserts gradually slowing down

ate fragmentation? > > - Jeff > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Konrad J Hambrick > Sent: Tuesday, June 16, 2009 1:43 PM > To: General Discussion of SQLite Database > Subject:

Re: [sqlite] Database inserts gradually slowing down

boun...@sqlite.org] On Behalf Of Matthew L. Creech > Sent: 16. júní 2009 15:51 > To: kon...@payplus.com; General Discussion of SQLite Database > Subject: Re: [sqlite] Database inserts gradually slowing down > > On Tue, Jun 16, 2009 at 11:31 AM, Konrad J Hambrick<kon...@payplus.com> wr

Re: [sqlite] Database inserts gradually slowing down

Hmmm ... Is there a way to replace step 5 (delete everything from the table) with a System-Level rm / unlink and a sqlite CREATE TABLE ? -- kjh On 06/16/2009 10:06 AM, Jim Wilcoxson wrote: > You are doing transactions here, which is a very different thing from > normal disk I/O. Your CPU is

Re: [sqlite] sqlite3 hangs

On 11/05/2008 03:35 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >>> I guess I'm not making my myself clear. I only have one installed >>> version. > > That is not true. If it was true then you wouldn't have ended up with > 3.3.6 being

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

On 10/08/2008 05:50 PM, James Pringle wrote: > Hi- > > I am new to sqlite, and am having a puzzling problem. I have read > that adding an INDEX to a sqlite table can never make a SELECT > statement slower. However, in my case, it seems to be making the > select statement an order of

Re: [sqlite] How to specify regular expression in a query?

On 01/29/2008 11:16 PM, Bharath Booshan L wrote: How can I instruct GLOB function to perform case-insensitive search similar to LIKE. Can I? Bharath -- A lot depends on the character set you choose to use. If you use US ASCII, there is a collation (COLLATE NOCASE) that could handle this

Re: [sqlite] How to specify regular expression in a query?

On 01/26/2008 02:40 AM, Bharath Booshan L wrote: > Hello list, I have to perform a search something similar to this ID FilePath 1 /Volumes/Backup/MyMovies/MyMovie.mp4 2 /Volumes/Backup/MyMovies/Hello.mp4 3 /Volumes/Tiger/MyMovie.mov Search for file name

Re: [sqlite] Sqlite3 3.5.3 Makefile.in patch for MINGW

Bob -- Oops. I have had my head down in my tty porting a linux app to MinGW / MSYS and missed your post yesterday. Dang ! I would have saved myself an hour or so this morning ;-) -- kjh On 12/01/2007 08:46 AM, Bob Rossi wrote: On Sat, Dec 01, 2007 at 08:25:22AM -0600, Konrad J Hambrick

[sqlite] Sqlite3 3.5.3 Makefile.in patch for MINGW

All -- Attached is a patch for the sqlite3 version 3.5.3 install target in Makefile.in ... The 'make install' target works much better now in the MinGW environment ;-) Thanks for sqlite3 ! It is an awesome program. -- kjh *** makefile~01.in Fri Nov 23 10:05:48 2007 --- Makefile.in Sat

Re: [sqlite] wrong version number when compiled

hmmm ... Maybe try hash -r (man bash) HTH -- kjh On 11/23/2007 04:47 PM, Jonathan Otsuka wrote: On Nov 23, 2007, at 4:31 PM, Xabriel J Collazo Mojica wrote: Guys: Thank you all for your quick replies! As P Kishor suggested, I restarted the mac and guess what? It now reports the