Hello !
Every day is a day to learn something new !
It also have the command line -bail for my example "sqlite3 -bail a.db <
the.sql".
Interesting that how easy I can miss the basics "when everything else fail,
read the manual !".
Thank you !
Cheers !
> Tue Sep 08 2015 9:40:37 pm
On Sat, 5 Sep 2015 09:07:11 -0700
Darko Volaric wrote:
> I'm asking why the SQL standard restricts the use of aliases in this
> way and what the benefit of this restriction is.
Rationales in SQL are hard to come by. The language was promulgated by
a private firm, and the standard evolved under
Hello,
I have a virtual table that implements query perceptual hashing data[1]. Now
I'm thinking about converting the virtual table implementation in a collation
on a normal sqlite3 table, but collation requieres that '=','<' and '>' be well
defined by obeying the rules cited on create_colla
Hello !
It's nice that you shared this, probably if you also host/mirror the on
github you'll get an even broader audience and probably feedback and
enhancements.
I suggest to to fork this project https://github.com/mackyle/sqlite it's
almost daily updated with the https://www.sqlite.org and
On Thu, 03 Sep 2015 16:44:50 +
Peter Haworth wrote:
> The statement I'm using is:
>
> SELECT * FROM myTable WHERE myKey IN (:1)
>
> If the value I supply to be used as :1 is a single integer, the SELECT
> finds the correct rows. If the value is a comma separated list of
> integers, e.g 1,2
Perhaps of interest:
http://sqlite-libs.cis.ksu.edu
> Begin forwarded message:
>
> From: St?phane Faroult
> Subject: OT: Oracle functions for SQlite
> Date: September 8, 2015 at 2:30:24 AM GMT+2
> To: "Oracle-L (E-mail)"
> Reply-To: sfaroult at roughsea.com
>
> I don't know if there are man
Hello !
After seem several emails from a user asking about how to use sqlite3 through
shell scripts, I remember my experiences with sqlite3 but didn't mind to
report it, but now I think that it's worth mention it because it'll hurt
several users.
The bug/problem is that the sqlite3 command li
Hello !
Now I realize that in the function re_balanced I also need restore the
ReInput back in case of not matching:
___
static int re_balanced(
??? ReInput *p,
??? int cb, /* char that opens a balanced expression */
??? int ce? /* char that closes a balanced expression */
){
? int c =
Hello !
I'm trying to add a new option to ext/misc/regex.c it's "\p()" that's like
the LUA operator "%b"
%b/xy/, where /x/ and /y/ are two distinct characters; such item matches
strings that start with?/x/, end with?/y/, and where the /x/ and /y/ are
/balanced/. This means that, if one reads
On 9/8/15, Eduardo Morras wrote:
>
>
> Hello,
>
> I have a virtual table that implements query perceptual hashing data[1]. Now
> I'm thinking about converting the virtual table implementation in a
> collation on a normal sqlite3 table, but collation requieres that '=','<'
> and '>' be well defined
Hello !
Sqlite like any other project has developed a lot of cross platform/utilities
code but most of it remain locked down to sqlite3 alone.
Example the latest json1 functions, vfs, sqlite3_printf, thread/lock
management functions, ..., would be nice if they could also be used by the
sqlite
On 8 Sep 2015, at 1:43pm, Domingo Alvarez Duarte
wrote:
> Sqlite like any other project has developed a lot of cross platform/utilities
> code but most of it remain locked down to sqlite3 alone.
>
> Example the latest json1 functions, vfs, sqlite3_printf, thread/lock
> management functions,
The Command Line Interface has the command:
.bail on
which will do what you want.
HTH,
Gerry Snyder
---
On 9/8/2015 9:54 AM, Domingo Alvarez Duarte wrote:
> Hello !
>
> After seem several emails from a user asking about how to use sqlite3 thro
Hello !
I forgot to include this topics on my wish list:
Sqldiff is an amazing tool added to sqlite, but it can be even more useful if
it's integrated on sqlite itself, right know sqldiff needs two databases to
operate, but if included in sqlite3 somehow it could generate the diffs on
the go
Hello !
Sqlite is really a very nice piece of software and it could even be better,
here is things to add to the wish list:
- Implement sql "CREATE FUNCTION" even if it is as simple of only allowing a
limited set of operations, refactoring the actual trigger implementation to
allow it be call
Hello !
The create_collation functions have a signature similar to create_function
but no mention abount add SQLITE_DETERMINISTIC to then, they do not need it ?
Cheers !
> Tue Sep 08 2015 12:04:44 am CEST CEST from "Richard Hipp"
> Subject: Re: [sqlite] Function lower on index expressions
16 matches
Mail list logo