Re: [sqlite] INSERT several rows

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 03/04/14 14:37, David King wrote:
> ... because of the author's opinions of the standard Python ways to
> require packages

As said author, the problem is that pip etc authors chose to make it
impossible to provide arguments to parts of the install process[1].  APSW
uses those arguments to control things like fetching SQLite source, which
extensions to enable and things affecting SQLite like if extension loading
is supported.

I could pick some defaults but they will always be wrong for some subset
of people.  It is also fairly hairy to make this all work from a build
perspective.  I'll likely end up hacking some defaults at some point.

Also for the record I haven't seen a patch from you to fix the issue in a
way you deem acceptable :-)

When I distributed Python applications in the past (eg BitPim) I bundled
everything up so Python being used was not visible (nor relevant) to the
user.  This approach worked fine on Windows, Linux and Mac.

[1] distutils - a standard part of python - is used under the hood which
has multiple subcommands each of which can be given flags.  pip etc
ultimately call into that.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlM93bkACgkQmOOfHg372QTx4wCgss8x7+Vymm7pZZDQ4X9+pLH5
D6IAoKF39KgDU95UesVtiFESluNGHv9s
=+r3t
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[Roman Fleysher]

Thank you for the links, Richard!

I am part of the Einstein Aging Study. The software (in internet years) should 
be as old as the people we study (in calendar years).


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Richard Hipp [d...@sqlite.org]
Sent: Thursday, April 03, 2014 5:03 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] INSERT several rows

On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher <
roman.fleys...@einstein.yu.edu> wrote:

> OK, thank you, Igor! I presume there is no way to get documentation for
> older versions -- no point in keeping.
>

The source code to the historical documentation is online:
http://www.sqlite.org/docsrc/timeline?y=ci

Legacy documentation is not available online.  You would have to download
it and compile it yourself.

An archive of the documentation for 3.7.2 is available at
http://www.sqlite.org/sqlite_docs_3_7_2.zip

Wouldn't it be easier just to upgrade to SQLite 3.8.4.3?  Why do you feel
like you need to stick with 3.7.2 which is 3.5 years old (what is that in
internet years? 100?)

--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[David King]

> Wouldn't it be easier just to upgrade to SQLite 3.8.4.3?  Why do you feel
> like you need to stick with 3.7.2 which is 3.5 years old (what is that in
> internet years? 100?)

I can't speak for Roman, but the biggest thing that keeps me from using newer 
sqlite features is that I write desktop apps in Python and have to run on 
whatever version of Python happens to be installed on my target machines. It's 
python's sqlite3 module's version that I have to rely on, which I can't control 
(and is generally 3.7 or so)

I'd actually prefer to depend on APSW (a Python sqlite library that doesn't try 
to wrap sqlite in Python's database standard, so you get more direct access to 
sqlite), but there's no easy way for my app to do so because of the author's 
opinions of the standard Python ways to require packages 
(http://rogerbinns.github.io/apsw/download.html#easy-install-pip-pypi)

So unless I can control the entire compilation process of Python or of some 
external utilities, I have to use 3.7.



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[Richard Hipp]

On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher <
roman.fleys...@einstein.yu.edu> wrote:

> OK, thank you, Igor! I presume there is no way to get documentation for
> older versions -- no point in keeping.
>

The source code to the historical documentation is online:
http://www.sqlite.org/docsrc/timeline?y=ci

Legacy documentation is not available online.  You would have to download
it and compile it yourself.

An archive of the documentation for 3.7.2 is available at
http://www.sqlite.org/sqlite_docs_3_7_2.zip

Wouldn't it be easier just to upgrade to SQLite 3.8.4.3?  Why do you feel
like you need to stick with 3.7.2 which is 3.5 years old (what is that in
internet years? 100?)

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[Roman Fleysher]

OK, thank you, Igor! I presume there is no way to get documentation for older 
versions -- no point in keeping.

Roman



From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Igor Tandetnik [i...@tandetnik.org]
Sent: Thursday, April 03, 2014 4:48 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] INSERT several rows

On 4/3/2014 4:23 PM, Roman Fleysher wrote:
> Is ability to insert multiple rows in one go a feature of a newer versions:
>
> INSERT INTO myTable (designation) VALUES ('LoResFA_only'), ('HiResFA_only');

Support for this syntax was introduced relatively recently. I don't
remember which version exactly, but likely 3.8.something .
--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[Richard Hipp]

On Thu, Apr 3, 2014 at 4:48 PM, Igor Tandetnik  wrote:

> On 4/3/2014 4:23 PM, Roman Fleysher wrote:
>
>> Is ability to insert multiple rows in one go a feature of a newer
>> versions:
>>
>> INSERT INTO myTable (designation) VALUES ('LoResFA_only'),
>> ('HiResFA_only');
>>
>
> Support for this syntax was introduced relatively recently. I don't
> remember which version exactly, but likely 3.8.something .
>
>
Version 3.7.11, 2012-03-20.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT several rows

[Igor Tandetnik]

On 4/3/2014 4:23 PM, Roman Fleysher wrote:

Is ability to insert multiple rows in one go a feature of a newer versions:

INSERT INTO myTable (designation) VALUES ('LoResFA_only'), ('HiResFA_only');


Support for this syntax was introduced relatively recently. I don't 
remember which version exactly, but likely 3.8.something .

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users