Re: [sqlite] SQLite 3.6.8+ breaks YUM

2009-01-19 Thread Robert L Cochran
D. Richard Hipp wrote: > On Jan 19, 2009, at 2:59 PM, Tuan Hoang wrote: > > >> Tuan Hoang wrote: >> >>> Hi, >>> I've been back-porting SQLite 3.x to CentOS 4.7 for some >>> development work. I've been taking the SRPMS from >>> koji.fedoraproject.org and rebuilding them. >>> All has

Re: [sqlite] SQLite version 3.6.10

2009-01-15 Thread Robert L Cochran
Please keep up the great work. I appreciate your fixing major, identified bugs as fast as possible. Bob Cochran D. Richard Hipp wrote: > SQLite version 3.6.10 is now available on the website. Upgrading is > recommended for all users. > > http://www.sqlite.org/ >

[sqlite] malloc.c compile error on Fedora 9

2008-10-09 Thread Robert L Cochran
While attempting to compile sqlite 3.6.3 on a Fedora 9 system which was freshly built (the system is based on the 20081004 Fedora Unity respin), I got this error in malloc.c. Can anyone suggest a fix? I'm wondering if I forgot to install a needed RPM package? I installed the "software development"

Re: [sqlite] a suggestion to write tutorial for sqlite

2008-04-19 Thread Robert L Cochran
D. Richard Hipp wrote: > On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote: > >> This is a bit off-topic for the mailing list, so please feel free >> to send stuff directly to the address below. >> >> > > It would be good, I think, to have a public record of this > conversation. We

[sqlite] Where To Put SQLite3.exe or SQLite3.dll for Windows Version of PHP?

2008-04-16 Thread Robert L Cochran
Where exactly do I install the sqlite3.exe (or should I use sqlite3.dll) file for Microsoft Windows such that the Windows version of PHP 5.x will find it and make use of it? Is it sufficient to create a C:\Program Files\SQLite3 folder and put the SQLite 3.5.8 module(s) there, then edit my path

Re: [sqlite] 3.5.7 Compile Fails On sqlite3.c

2008-04-03 Thread Robert L Cochran
Robert L Cochran wrote: > Here is what I did: > > tar -xvzf sqlite-3.5.7.tar.gz > cd sqlite-3.5.7 > mkdir bld > cd !$ > ../configure --prefix=/usr/local/sqlite-3.5.7 --disable-tcl > --

[sqlite] 3.5.7 Compile Fails On sqlite3.c

2008-04-03 Thread Robert L Cochran
Here is what I did: tar -xvzf sqlite-3.5.7.tar.gz cd sqlite-3.5.7 mkdir bld cd !$ ../configure --prefix=/usr/local/sqlite-3.5.7 --disable-tcl --enable-threadsafe make -- (output of make is shown

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
That's funny to me...the only other person I know who used the word 'copacetic' was a former team leader in my office, in an email he wrote years ago. I had to check the dictionary to find out what 'copacetic' means. I think it's very funny to see the word used again in a software context. Bob

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
Zbigniew Baniewski wrote: > On Thu, Mar 13, 2008 at 01:03:01PM -0500, P Kishor wrote: > > >> why is it the I had to do the above? Why is LD_LIBRARY_PATH not set >> automatically? And, since it wasn't set, how come other programs were >> working fine (assuming that other programs in the

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
Did you change your path (in $HOME/.bash_profile) to point to /usr/local/bin, then log out and log back in again? I think the path setting may be the real issue. After changing /etc/ld.so.conf did you run `ldconfig` as root? Thanks Bob Cochran Greenbelt, Maryland, USA P Kishor wrote: > the

[sqlite] PHP Code That Can Store and Retrieve Images

2008-03-11 Thread Robert L Cochran
Is there open source PHP code (PHP 5.x compatible) that can store and retrieve images from an SQLite 3.5.6 database? For SQLite version 3.5.x, I need to use the PHP PDO functions if I am using PHP 5.2.5, right? I want to show a group of people about 45 photos which I would like to store on an

Re: [sqlite] Beginners bad luck

2008-03-09 Thread Robert L Cochran
When you call phpinfo(); do you see that the PDO functionality is enabled? Is SQLite listed as one of the databases? http://us.php.net/manual/en/function.phpinfo.php Also look at your /etc/php.ini file. Assuming your binary of php is using extensions, are the extensions for sqlite being loaded?

Re: [sqlite] Database Commoditization and SQLite

2008-01-07 Thread Robert L Cochran
I think SQLite is an epochal leap in the development, dissemination, use and support of databases in general. Richard has a product that moves the whole field ahead. Sometimes other players are kicking and screaming, but SQLite has still pushed them ahead because now their product is competing

Re: [sqlite] Compiling Problem With SQLite 3.5.4

2007-12-16 Thread Robert L Cochran
Zbigniew Baniewski wrote: On Sat, Dec 15, 2007 at 12:48:44PM -0500, Robert L Cochran wrote: I did a poor job of explaining this issue. GCC builds of 3.5.4 seem to fail. I've sent Richard a bunch of log files comparing source code builds of versions 3.5.3 and 3.5.4 showing what I believe

Re: [sqlite] Compiling Problem With SQLite 3.5.4

2007-12-15 Thread Robert L Cochran
[EMAIL PROTECTED] wrote: Robert L Cochran <[EMAIL PROTECTED]> wrote: While compiling version 3.5.4 using gcc, I got these messages from 'make' on my CentOS 5 host. It looks to me like the 'make' step failed. I can post the config.log if that would help. How can I fix this

[sqlite] Compiling Problem With SQLite 3.5.4

2007-12-15 Thread Robert L Cochran
While compiling version 3.5.4 using gcc, I got these messages from 'make' on my CentOS 5 host. It looks to me like the 'make' step failed. I can post the config.log if that would help. How can I fix this to get a successful compile? Bob Cochran ./libtool --mode=link gcc -g -O2 -I.

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Robert L Cochran
Trey Mack wrote: 3.6.0 in the next release? Or can we call the change a "bug fix" and number the next release 3.5.4? I guess I'm in the minority, but I'd find a change in the meaning of my queries surprising in a bug fix release. That sounds like a 3.6 to me. You may be in the

Re: [sqlite] SQLite 64-Bit

2007-07-04 Thread Robert L. Cochran
Of course, you also need a 64-bit capable processor. I've been compiling SQLite on AMD Athlon 64 boxes using Fedora Core and CentOS x86_64 operating systems (and that means the gcc toolchain) for ages. Bob Cochran > -Original Message- > From: Ahmed Sulaiman [mailto:[EMAIL PROTECTED] >

Re: [sqlite] Issue with trailing blanks

2007-03-27 Thread Robert L Cochran
Hi Joel, It's been a while since I've had to code DB2 and my memory might be faulty. But the SQL standard says char(n) has to be padded with trailing spaces, right? See this http://troels.arvin.dk/db/rdbms/ under the heading "The CHAR type". Thanks Bob Cochran Joel Cochran wrote: Hi Bob,

Re: [sqlite] Abuse of the SQLite website

2007-01-31 Thread Robert L Cochran
Peter James wrote: On 1/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Thoughts anyone? Are there less drastic measures that might be taken to prevent this kind of abuse? A couple of people here mentioned CAPTCHA's. This is sort of the standard for preventing automated abuse

Re: [sqlite] Abuse of the SQLite website

2007-01-30 Thread Robert L Cochran
I fix computers for customers during evenings and weekends and I have only have 2 customers (so far) using Windows 98. Nearly everyone, even the many seniors among my clients, use Windowx XP and/or OS X. I feel that banning Win 98 machines is therefore appropriate. Serious developers wouldn't

[sqlite] PHP 5.2.0 pdo_sqlite SQLITE Version

2006-11-02 Thread Robert L Cochran
I just did a compile of PHP 5.2.0 with (in part) this configure string: --with-pdo-sqlite=/usr/local/sqlite-3.3.8/lib \ on a Fedora Core 5 machine. Running phpinfo() lists the SQLite library version as 3.3.3 for PDO SQLite. That puzzles me. The path information I passed to PHP's configure is

[sqlite] Did I Corrupt My Fedora Core 5 Yum Database?

2006-10-31 Thread Robert L Cochran
I believe I overwrote my Fedora Core 5 version of sqlite (that's 3.3.3-1.2.x86_64) for the second time this year. I downloaded sqlite-3.3.8 and compiled it with this configure string: ../configure --prefix=/usr/local/sqlite-3.3.8 --libdir=/usr/lib64 --includedir=/usr/include --disable-tcl

Re: [sqlite] SQLite Path Problem On Fedora Core 5

2006-06-26 Thread Robert L Cochran
DJ Anubis wrote: Robert L Cochran a écrit : However, on Fedora Core 5, my path is set so that objects on /usr/local/bin are found before those on /usr/bin. I'm not sure how this is happening; perhaps /etc/profile? The result seems to be that even if sqlite 3.3.3 was installed by yum

[sqlite] SQLite Path Problem On Fedora Core 5

2006-06-25 Thread Robert L Cochran
For a long time, I've been playing with the Sqlite product from http://www.sqlite.org . I started doing this before Fedora Core 4, and would compile the source code to the default install directories of /usr/local/bin and /usr/local/lib, etc. This worked great until Fedora Core started packaging

Re: [sqlite] Fedora Core 4 RPM Version of SQLite And A Sad Tale of PHP Configure Error In v3.3.3

2006-02-07 Thread Robert L Cochran
Dan Kennedy wrote: configure:79872: checking for sqlite_open in -lsqlite It might be looking for sqlite version 2, not 3. Grep the configure script for the string "sqlite3_open", and then "sqlite_open". If you find the latter and not the former, it's version 2 you need to install.

[sqlite] Fedora Core 4 RPM Version of SQLite And A Sad Tale of PHP Configure Error In v3.3.3

2006-02-03 Thread Robert L Cochran
In one of my less-than-brilliant moments, I compiled and installed Sqlite 3.3.3 on my Fedora Core 4 (x86_64) system without checking whether an earlier version had been installed by the distro's anaconda installation program. It appears that SQLite 3.1.2 comes with Fedora Core 4. Ooops. In

[sqlite] Conversion of SQLite 3.2.5 database to 3.3.1

2006-01-18 Thread Robert L Cochran
I have a database I created in SQLite 3.2.5, then updated with subsequent versions up to 3.2.7. There are several tables. Version 3.3.1 has a new file format and I'd like to convert the database file to this new format. How do I do that? Thanks Bob Cochran Greenbelt, Maryland, USA

Re: [sqlite] SQLite 3.3.1

2006-01-17 Thread Robert L Cochran
Ken & Deb Allen wrote: Hmmm. The number of warnings compiling the 3.3.1 source is up to 10 from 6 in the 3.3.0 source. All of them appear to be related to inappropriate sign comparisons/assignments. -ken So your compiler is blowing smoke. GCC 4.02 which I use under Linux coughs up

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-16 Thread Robert L Cochran
You can search your Makefile to see if a module is set to compile an os.c. For example: [EMAIL PROTECTED] bld]$ egrep 'os' Makefile # This makefile is suppose to be configured automatically using the # same unless your are cross-compiling.) main.lo opcodes.lo os.lo os_unix.lo os_win.lo \

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-12 Thread Robert L Cochran
m christensen wrote: But, I'd presume the intent here is 'Experience' a software development process. Design and build in a vacuum and see what the users think after it's done, as suggested above, is an all too common and WRONG approach IMHO. I don't think you are INTENDING to 'ask us to

Re: [sqlite] Can't commit transaction - SQL statements in progress

2005-12-12 Thread Robert L Cochran
dge, I can probably fix my code fairly quickly. At this point, I don't have any reason to suspect that SQLite itself is failing. -Eric Robert L Cochran wrote: You really need to post specific code snippets, you can't expect a definitive solution including the complete diagnosis and corrected

Re: [sqlite] Can't commit transaction - SQL statements in progress

2005-12-12 Thread Robert L Cochran
You really need to post specific code snippets, you can't expect a definitive solution including the complete diagnosis and corrected code from an 11-word problem statement and then a 2-line guess as to the cause. Please show your code. Others on this forum will help you. (I lack the

Re: [sqlite] how can I import CSV file into SQLite quickly

2005-12-06 Thread Robert L Cochran
I create an SQL file that has contents like this: [EMAIL PROTECTED] elections]$ cat insert_precinct.sql BEGIN TRANSACTION; INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road', 3, 'Greenbelt', 'Maryland', 0); INSERT INTO "precinct" VALUES(2, 'Police Station 550 Crescent Road',

Re: [sqlite] problem with blobs (perl code)

2005-12-01 Thread Robert L Cochran
A very interesting discussion thread! Thanks to everyone who posted for adding to my knowledge. Bob Cochran [EMAIL PROTECTED] wrote: Matt Sergeant <[EMAIL PROTECTED]> wrote: Perl has no concept of blobs. A scalar variable can be one of: IV (integer) UV (unsigned integer) NV (double) PV

[sqlite] SQL For Producing Subtotaled Rows

2005-11-14 Thread Robert L Cochran
I have a simple table containing 3 columns: a political candidate code, a precinct code, and the number of votes that candidate recieved for that precinct. Here is a sample: sqlite> select rc_cd, rp_cd, votes from results order by rc_cd asc, rp_cd asc; ivy000|1|266 ivy000|2|252 ivy000|3|30

[sqlite] Group By Rollup and Build Date

2005-11-14 Thread Robert L Cochran
I tried using the 'group by rollup' clause like so: [EMAIL PROTECTED] elections]$ sqlite3 elections.db SQLite version 3.2.7 Enter ".help" for instructions sqlite> select rc_cd, rp_cd, votes from results where rc_cd in ('ivy000', 'put000') group by rollup (rc_cd) order by rc_cd, rp_cd; SQL

Re: [sqlite] Request for comment: Proposed SQLite API changes

2005-11-03 Thread Robert L Cochran
API changes for SQLite are fine with me as long as the PHP folks keep up with SQLite in terms of implementing SQLite hooks. I'm not real experienced with SQLite, but I'm starting to learn a lot. I use it with PHP 5.1 and PDOs. I find myself compiling the latest SQLite CVS and the latest

Re: [sqlite] Newbie Question

2005-10-15 Thread Robert L Cochran
, that it wouldn't be needed unless I wanted to use the TCL shell, which I don't. Thanks, John Robert L Cochran wrote: Post the error messages and someone will help you. I'll also check for messages after work tonight. There are others on this forum who are far more knowledgable than I.

Re: [sqlite] Newbie Question

2005-10-14 Thread Robert L Cochran
unable to compile on Linux and it appears as though I'm missing a dependency or two. Any idea where I can check those? Thanks, John Robert L Cochran wrote: I think sqlite3.h is generated for you automatically as part of the build process from source code and it will be later installed for you

Re: [sqlite] Newbie Question

2005-10-13 Thread Robert L Cochran
Compiling the CVS checkout is really the same -- just cd into the 'sqlite' directory and follow the instructions below from the 'mkdir' onwards. Bob Robert L Cochran wrote: I think sqlite3.h is generated for you automatically as part of the build process from source code

Re: [sqlite] Newbie Question

2005-10-13 Thread Robert L Cochran
I think sqlite3.h is generated for you automatically as part of the build process from source code and it will be later installed for you in the include directory. You must actually compile sqlite from the source code. For Linux, why not just download sqlite-3.2.7.tar.gz (the linux source

Re: [sqlite] Left Outer Joins

2005-10-07 Thread Robert L Cochran
Jay Sprenkle wrote: You might also consider NOT saving the image data in the database. I've always found it better to save a path or URL in the database and store the image in the file system. (Unless you're searching for things in the image data itself and not just searching for an image using

Re: [sqlite] Left Outer Joins

2005-10-07 Thread Robert L Cochran
. By the way, SQLite 3.2.7 does not support RIGHT or FULL joins. Bob Peter Wullinger wrote: In epistula a Robert L Cochran, die horaque Thu, Oct 06, 2005 at 10:56:03PM -0400: Hi -- I'm inexperienced with joining tables and need help. I'm using SQLite v3.2.7 and the tables discussed below

Re: [sqlite] Please Need Advice on 64 Bits Platform

2005-10-07 Thread Robert L Cochran
I have an AMD 64 machine myself. Do I need to pass any special to compile in 64 bit mode? Bob [EMAIL PROTECTED] wrote: Hamid Benhocine <[EMAIL PROTECTED]> wrote: I want just to know if the Engine is 64 bits ready SQLite is designed to work on 64-bit machines. There have been a

Re: [sqlite] wondering about sqlite and webhosts

2005-10-06 Thread Robert L Cochran
I have no experience with webhosts in this context, but I'm currently using beta snapshots of PHP 5.1, SQLite 3.2.7, and Apache server, and it is working great for me. I'm using the PHP Data Objects (PDO) functionality that comes with PHP 5.1, it has hooks for SQLite. So what is happening here

[sqlite] Left Outer Joins

2005-10-06 Thread Robert L Cochran
Hi -- I'm inexperienced with joining tables and need help. I'm using SQLite v3.2.7 and the tables discussed below are part of an SQLite database. There are 2 tables: A contains some text columns and an integer primary key. B contains an integer primary key and a LONGBLOB column to hold

Re: [sqlite] Speed Test Done !

2005-10-06 Thread Robert L Cochran
there data, however its huge. 175 MB text file. Richard On Thu, 06 Oct 2005 14:06:47 -0400, Robert L Cochran <[EMAIL PROTECTED]> wrote: select * from T where A = '32.0833'; (quote the 32.0833...'32.0833') If you happen to have the sqtest4.txt file available for downloading (vi

Re: [sqlite] Speed Test Done !

2005-10-06 Thread Robert L Cochran
select * from T where A = '32.0833'; (quote the 32.0833...'32.0833') If you happen to have the sqtest4.txt file available for downloading (via wget or http), I might try doing this myself. Bob Cochran Richard wrote: Well, Did the correction, and still the results text was nothing (zero)

[sqlite] Recognizing v3.2.6 In PHP Snapshots

2005-09-18 Thread Robert L Cochran
I'm playing with snapshots of PHP 5.1 from http://snaps.php.net. I have a build from 20050916 that doesn't recognize Sqlite 3.2.6 in phpinfo(). Does anyone know how I can get the snapshot to "see" the new Sqlite version? Thanks Bob Cochran

[sqlite] PHP 5.1 PDO Objects

2005-09-05 Thread Robert L Cochran
I compiled one of the snapshots of PHP 5.1 available at http://snaps.php.net/ and I notice that phpinfo() recognizes that I have Sqlite 3.2.5 installed for PHP Data Objects (PDO) purposes. I have not experimented to see whether it actually works for Sqlite databases. Is anyone using PDOs with

Re: [sqlite] Training opportunity: The Inner Workings Of SQLite

2005-06-19 Thread Robert L Cochran
I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd like to go to OSCON but the costs involved make it tough for me, especially with 2 kids in university. Bob Cochran Klint Gore wrote: On Sun, 19 Jun 2005 15:04:19 -0400, "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: I

[sqlite] Database File Structure

2005-02-27 Thread Robert L Cochran
I've been fooling with 3.1.3 tonight and hex dumped one of my database files: [EMAIL PROTECTED] itemlist]$ hexdump -C -n 16 wishlist 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 |SQLite format 3.| 0010 Only the first 16 bytes are shown here. Is there a published file

Re: [sqlite] SQLite Tutorial: Request For Comments

2005-02-21 Thread Robert L Cochran
[EMAIL PROTECTED] wrote: The html has been cleaned up on the tutorial: http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download Has this been updated recently for the 3.1.x series? Thanks Bob Cochran

Re: [sqlite] Version 3.1.0

2005-01-22 Thread Robert L Cochran
Yes -- this is what I'm talking about. Bob Roger Binns wrote: I think all this discussion has missed the original question. Quite simply, is there any way in which the SQLite *source code* could be changed in order to get better performance on 64 bit machines. If there is then following

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Robert L Cochran
I should have indicated in my earlier post that magazines which do side-by-side hardware testing are saying that the AMD Athlon 64 is indeed faster than the Pentium 4; for example look in the January issue of Maximum PC magazine. they have a followup test supplementing an earlier review of

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Robert L Cochran
D. Richard Hipp wrote: On Fri, 2005-01-21 at 20:56 -0500, Robert L Cochran wrote: Does this version take advantage of 64-bit cpu's like the AMD Athlon 64? I don't know. What do you mean by "take advantage of"? What does a 64-bit CPU do that you can't do with a 32-bit CPU? There

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Robert L Cochran
D. Richard Hipp wrote: Version 3.1.0 (alpha) of SQLite is now available on the website. Release notes are available from a link on the homepage. This released is labeled "alpha" but it is still very well tested. By being "alpha" it means that there is still a small window of opportunity during

[sqlite] Compiling 3.0.8 On AMD 64 Platform

2004-10-17 Thread Robert L Cochran
I have the source code for sqlite-3.0.8 and just compiled it on my AMD 64 3500+ machine. Are there any special configure options I can use to take advantage of the 64 bit addressing capabilities -- or will the configure script set all the needed options for me? I'm using a 90 nanometer