[sqlite] ShawnMilo intro

[Shawn Milochik]

Hi. I just joined the list. I'm a developer who mainly works on the Linux
command line with Makefiles, Perl one-liners, and some Perl and Python
scripts. Nearly 100% of what I do is processing tab-delimited files.

I live in Reading, PA. My main hobby is magic -- the art of illusion, not
the card game.

I have a couple of questions, but I am going to lurk a bit first. However,
is there an archive? I didn't receive one by e-mailing the automated help
address for this list. I'd like to see if the answers are there first.

Thanks,
Shawn

MiloCast.com

[sqlite] Sqlite in Python on Bluehost Web hosting

[Shawn Milochik]

I searched the archives, but couldn't find a way to fix this on my own.

I use Bluehost.com for Web hosting. I like Python. I like Sqlite. I'm trying
to use the three together.

Bluehost supports Python, and sqlite is installed. I have ssh access.
However, there is no pysqlite2 or apsw support built in to their Python
installation. I tried installing pysqlite2 myself (my preferred method), and
also apsw, but they error out for dependency reasons that I can't fix.

I have sent a help desk ticket into Bluehost asking for them to install
pysqlite2, but I'm not terribly hopeful. Does anyone know how to get sqlite
support in Python working within a home directory on Linux without having
root access?

Thanks,
Shawn

[sqlite] (Solution) Using sqlite from PHP on Bluehost (and maybe your Web host)

[Shawn Milochik]

I use Bluehost.com for Web hosting. Overall they're great, but every
once in a while there's a roadblock like this. Happily, this one was
solved (using their knowledge base, no less), and I thought I'd share it
in case others find it useful.

No matter what method I used to try to connect to a sqlite database in
PHP, I would receive an error, because PHP wasn't grokking sqlite or
PDO.

The procedure I followed (on Bluehost) is below. Adapt the steps as
necessary to suit yourself. This method requires ssh access (a feature
which is one of the main reasons I use Bluehost).

1. ls /usr/lib/php/extensions/no-debug-non-zts-*
This revealed pdo.so and pdo_sqlite.so files in the
directory /usr/lib/php/extensions/no-debug-non-zts-20060613.


2. Modify my local php.ini:

Add these lines:

extension=pdo.so
extension=pdo_sqlite.so

Change this line:
extension_dir = ./ 

to

extension_dir = /usr/lib/php/extensions/no-debug-non-zts-20060613

I hope this spares other people hours of frustration.

Shawn


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Adding data to the end of a column

[Shawn Milochik]

-Original Message-
From: jose isaias cabrera <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: [sqlite] Adding data to the end of a column
Date: Wed, 30 Jan 2008 14:34:17 -0500

Greetings.

Is there a way to add data to the end of a field?  I know I select that 
field, import the data into a variable and then add whatever to the end. 
What I am trying to do is exactly NOT that. :-)  So, instead, just add say a 
line or two of text to a field.

Is this possible?

thanks,

josé 





Try:

UPDATE tablename SET something = something + " addition";

Not sure of the exact syntax for contacenation -- could be + or . or something 
else.

Shawn




-
To unsubscribe, send email to [EMAIL PROTECTED]
-