Re: [sqlite] sqlite and regexp on debian squeeze
prad <p...@towardsfreedom.com> writes: > REGEXP requires definition of regexp() > we seem to require C to do this: > http://www.sqlite.org/lang_expr.html#regexp > > or > > apparently there is a sqlite3-pcre which adds > /usr/lib/sqlite3/pcre.so > and that does the trick. > > however, sqlite3-pcre doesn't seem to exist on debian. > > what is the recommended way of getting regexp to work? > well that was fast! what i did was download the sqlite3-pcre from ubuntu here: http://mirror.corbina.net/pub/Linux/ubuntu/pool/universe/s/sqlite3-pcre/ (i needed the amd64) then since it was a deb file: dpkg -i sqlite3-pcre_0~git20070120091816+4229ecc-0ubuntu1_amd64.deb in sqlite you simply: .load /usr/lib/sqlite3/pcre.so and it all works! -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite and regexp on debian squeeze
REGEXP requires definition of regexp() we seem to require C to do this: http://www.sqlite.org/lang_expr.html#regexp or apparently there is a sqlite3-pcre which adds /usr/lib/sqlite3/pcre.so and that does the trick. however, sqlite3-pcre doesn't seem to exist on debian. what is the recommended way of getting regexp to work? -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite shell tab autocompletion SOLVED
prad <p...@towardsfreedom.com> writes: > what tools are available to provide a decent console experience on sqlite? > thanks to the personal assistance provided by roger my problems are solved! i was using ver 3.6 and he suggested upgrading to the most recent version not only took away the woes, but produced nicely colored printouts! the info on what to do is in the doc folder of the zipped download or right here: http://apidoc.apsw.googlecode.com/hg/index.html see building: http://apidoc.apsw.googlecode.com/hg/build.html i used python setup.py install --user there were a lot of horrible syntax errors, but my son pointed out that i didn't have the python-dev package and so was missing some essential files! many thx again roger! -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite shell tab autocompletion
Roger Binns <rog...@rogerbinns.com> writes:
> On 06/07/2011 08:02 PM, prad wrote:
>> apsw gives a decent completion but runs into issues with python2:
>> see roger binns post 16 aug 03:24 here:
>> http://comments.gmane.org/gmane.comp.python.db.sqlite.user/187
>> (a solution is provided too in this post though i haven't tried it)
>
> As far as I know the issue is fixed and I just tested and didn't encounter
> it. If you contact me via email we can diagnose what is happening and get a
> fix into the next release.
>
well hello roger!
i recall reading that there is no issue with python3, but i'm on
python2.6 (debian squeeze) so that might be why i'm having difficulties.
i'll try your workaround as per post later:
>>> shell=apsw.Shell(stdout=codecs.open("/dev/stdout", "w", "utf8"),
stderr=codecs.open("/dev/stderr", "w", "utf8"))
>>> shell.cmdloop()
and if it still doesn't work, then i'll send you an email.
many thx!
--
in friendship,
prad
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite shell tab autocompletion
apsw gives a decent completion but runs into issues with python2: see roger binns post 16 aug 03:24 here: http://comments.gmane.org/gmane.comp.python.db.sqlite.user/187 (a solution is provided too in this post though i haven't tried it) what tools are available to provide a decent console experience on sqlite? -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] correct extension to use for sqlite3
i've seen .db and .sqlite and both work. however, is there a rational for one or the other (eg firefox sqlite plugin looks for .sqlite)? -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] completion of sql words
does the sqlite3 interface have completion of sql key words? in postgresql you can type SEL and press tab to complete. is there such a thing for sqlite3? -- in friendship, prad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] accessing php produced db from shell
On Wed, 18 Mar 2009 10:04:59 + (GMT) Swithun Crowe <swit...@swithun.servebeer.com> wrote: > Or, maybe $db should be $base, as in your example above? > yes that was one of my silly oversights :D there were several others, but they essentially boiled down to trying to follow the tutorial and not realizing that i needed pdo statements, so eventually i went to the pdo manual: http://ca3.php.net/pdo and figured it out from there. thanks for your help, swithun! -- In friendship, prad ... with you on your journey Towards Freedom http://www.towardsfreedom.com (website) Information, Inspiration, Imagination - truly a site for soaring I's ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] accessing php produced db from shell
On Wed, 18 Mar 2009 08:17:56 + (GMT)
Swithun Crowe <swit...@swithun.servebeer.com> wrote:
> php -i | grep -i sqlite will tell you the versions that are being
> used on your machine.
>
ok thanks!
i couldn't do php -i (bash: php: command not found), may be i have to install
the cli php?
however,
dpkg -l | grep -i sqlite
gives
ii libsqlite0 2.8.17-4
ii libsqlite3-0 3.5.9-6
ii php5-sqlite5.2.6.dfsg.1-1+lenny2
ii sqlite3 3.5.9-6
which would suggest that we have a version problem.
so instead of
$base = new SQLiteDatabase($dbname, 0666, $err)
i use
$base = new PDO("sqlite:$dbname", 0666, $err)
the db file gets written, but if i try to create a table i get
Fatal error: Call to a member function query() on a non-object
for the line with
$db->query()
the permissions are set for www-data ownership so it's not like the thing can't
be written to which is one of the problems that came up for this error on the
net.
it's like the db hasn't been created properly, perhaps?
--
In friendship,
prad
... with you on your journey
Towards Freedom
http://www.towardsfreedom.com (website)
Information, Inspiration, Imagination - truly a site for soaring I's
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] accessing php produced db from shell
i'm working through one of the php-sqlite tutorials: http://www.scriptol.com/sql/sqlite-table.php it works fine, but when i try going in with sqlite3 from the shell and try to do anything, i get SQL error: file is encrypted or is not a database i'm using sqlite3, but with php5 i had to install php5-sqlite. is the sqlite i'm using with php5 on debian version 2? could this be the problem? or is it something else? -- In friendship, prad ... with you on your journey Towards Freedom http://www.towardsfreedom.com (website) Information, Inspiration, Imagination - truly a site for soaring I's ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] httpd server ???
On Tue, 17 Mar 2009 16:42:04 -0700 Tito Ciuro <tci...@mac.com> wrote: > ... or you can try Cherokee: > or even lighttpd may be http://www.lighttpd.net/ -- In friendship, prad ... with you on your journey Towards Freedom http://www.towardsfreedom.com (website) Information, Inspiration, Imagination - truly a site for soaring I's ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
