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 been fine through v3.6.7
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/
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
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 create an
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
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
--enable-threadsafe
make
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
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/local/bin
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
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
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 believe
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.
[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 to get
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]
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,
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
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
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
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
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
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 \
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
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
code from an 11
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
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 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:
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
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
, 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.
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
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
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 few
.
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
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
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)
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
(via wget
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
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
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
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'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
[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
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
54 matches
Mail list logo