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 bee
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/
> http://www.sqlite.org/
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"
I think later this year, I may be happy to take up this challenge. I've
always wanted to contribute to something like this. I cannot do it for
at least a few months. I'll need a lot of feedback from the true
database experts out there (as opposed to beginners like me.) Plus I
have 15,338 sqlite-use
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 can
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 var
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
> --
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 be
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
P
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 /usr/loc
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 fol
Ty wrote:
> Robert L Cochran <[EMAIL PROTECTED]> writes:
>
>
>> Is there open source PHP code (PHP 5.x compatible) that can store and
>> retrieve images from an SQLite 3.5.6 database?
>>
>>
>
> Here's a quick example I came up with... it
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 SQL
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?
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
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 be
[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.
H
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. -I../sr
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 minority
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]
> S
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, a
What version if DB2 is this? Is your DB2 engine storing data in EBCDIC
format? What platform is the SQLite database on, and you didn't mention
the SQLite version.
If your DB2 data is EBCDIC did you convert it to ASCII before putting it
in SQLite? I want to point out the difference between an
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 (intenti
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
Francesco Andrisani wrote:
Hi comunity,
i've a problem when i try to cross compile sqlite-3.3.8 for mipsel architecture.
I lauch configure file with follow params:
[EMAIL PROTECTED] sqlite-3.3.8]$ ./configure
--prefix=/home/frank/Router/OpenWRT/whiterussian/openwrt/staging_dir_mipsel
--host=mi
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
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 --en
Robert L Cochran wrote:
How do I fix my sqlite version mess so that I can have multiple
installed versions: the one used by yum (and possibly other modules)
and
the latest and greatest release, which I want to link into PHP for my
own purposes. (Yes I compile PHP on my own.)
With an up
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 b
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
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.
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 fact
I always keep a few books on SQL around me.
Bob
[EMAIL PROTECTED] wrote:
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
> The following statement works in other databases but fails in
SQLite with "SQL error: no such column: X.TeamID"
SELECT X.TeamID,
X.TeamName,
Y.TeamID,
Dr. Hipp,
Speaking as a professional programmer (IBM mainframes), I think your
development of SQLite is an awesome accomplishment. I am beginning to
use SQLite for my database needs that don't require security. Maybe you
should think of hosting an SQLite User Conference...
Bob Cochran
Greenb
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
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 warnings
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 \
$(TOP)/s
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 do
n. Armed with that knowledge, 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 c
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 expertise.
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', 6,
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 (
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
iv
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 error
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 snapsh
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.
I'm 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 instal
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
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
cod
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
in the
processing.
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
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 fe
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
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
imag
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
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)
th
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
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 3
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
I tried applying this to the sqlite 3.2.1 source with these results:
[EMAIL PROTECTED] sqlite-3.2.1]$ patch -p0 < patch
patching file src/btree.c
Hunk #1 succeeded at 1216 (offset -3 lines).
patching file src/build.c
Hunk #1 succeeded at 1510 (offset 68 lines).
patching file src/expr.c
patching f
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
structu
[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
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 questions
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 Athl
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
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 whe
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 'Winches
67 matches
Mail list logo