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 doe

[sqlite] sqlite and regexp on debian squeeze

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 a

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 >

[sqlite] sqlite shell tab autocompletion

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

[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

Re: [sqlite] accessing php produced db from shell

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

Re: [sqlite] accessing php produced db from shell

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, Insp

[sqlite] accessing php produced db from shell

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

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.toward