× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I hadn't thought of Google indexing. That's a pretty big deal.

You do have a good point about the code markup, but large sections of code
can be posted somewhere like Gist and linked to when necessary.

Agreed on big code snippets being put into gist, but that would/should also
be done in the other mediums. The thing I like about these new tools is I
can do markdown all throughout my post to make it really digestible.

A tool that works mostly how I want is GitHub/Bitbucket issues: operates on
email, Google indexed because it's public, allows for markdown, tagging,
priority, editing, etc.

At the end of the day I believe we will end up with the following for
opensource collab:
- opensource@xxxxxxxxxxxx as the grand standard for collaboration
- stackoverflow.com for pointed questions that are IBM i specific
- gitter/slack/Ryver for chat
- GitHub/Bitbucket Issues for project specific collaboration
- LinkedIn for giving us appreciation for all the other communication
mechanisms :-)


At the end of the day the biggest thing for me is having all the mediums
efficiently aggregated. We're never going to find a tool that facilitates
even most of what we need.

That actually might be a good first open source project for this group,
build an aggregator dashboard, a little like how the Google Dashboard
worked before Google killed it (loved that for my home page). This
wouldn't be IBM i specific but something EVERY geek community needs.


Aaron Bartell
litmis.com - Services for open source on IBM i


On Fri, Jun 24, 2016 at 8:31 AM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

Mostly because with chat style conversations, there is no archive of the
conversation. Working things out here on the list ensures that the lessons
learned are retrievable via Google next year when I need the info. Now I am
basing this on my experience with IRC, and the fact that I have never seen
a Google result point me to Ryver. In addition, the level of use here
doesn't warrant splintering the community. And I guess it is also a bit
selfish here because I am just not inclined to use other forums (even
though I am registered on several including those on Linked-in and
Code-400). I would not ever see this info if it were moved off the midrange
lists.

You do have a good point about the code markup, but large sections of code
can be posted somewhere like Gist and linked to when necessary.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Aaron Bartell <aaronbartell@xxxxxxxxx> wrote: -----
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
From: Aaron Bartell <aaronbartell@xxxxxxxxx>
Date: 06/24/2016 09:11AM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python


Hi Mark,

Do you have reasons for that opinion? I ask because I am undecided. I
like midrange.com forums because they are simple and always work, and I
frequently use the GMail "Mute thread" functionality to stop getting emails
for threads I don't intend to follow.

I am not a fan of chat (Gitter,Slack,Ryver) with large groups because it
can get chatty fast and there's a good chance the best nuggets will get
lost; but I REALLY like code markup in those tools to make things easier to
read.

Aaron Bartell
litmis.com - Services for open source on IBM i


On Fri, Jun 24, 2016 at 8:05 AM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

I would prefer things like this be worked out here.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Bill Gravelle <starbg@xxxxxxxxxxx> wrote: -----
To: "opensource@xxxxxxxxxxxx" <opensource@xxxxxxxxxxxx>
From: Bill Gravelle <starbg@xxxxxxxxxxx>
Date: 06/23/2016 02:20PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python


Sorry to interrupt - I know this is very complicated stuff y&#8217;all
are
working out here &#8230;

Since you&#8217;re both on the new community collaboration/communication
platform over on Ryver (and everyone else here in this list has been
invited), might this kind of interactive(ish) Q&A be more efficient and
effective within that interface?


On Jun 23, 2016, at 12:12 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

Do you have an older version of six installed?

If you've gotten to a recent PTF level of the Python 3 runtime it will
be
included by default.

What is the output of the following commands?

pip3 list | grep six

python3 -c 'import six; print(six.__version__); print(six.__file__);'

"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/23/2016
12:56:35 PM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/23/2016 12:56 PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I received the following trying ti pip3 install it:

[qsecofr@QLFI2]/QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db# pip3
install
ibm_db-2.0.5.4-cp34-cp34m-os400_powerpc.whl

Traceback (most recent call last):
File "/QOpenSys/usr/bin/pip3", line 7, in <module>
from pip import main
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/__init__.py",
line 13, in <module>
from pip.commands import commands, get_summaries,
get_similar_commands
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/__init__.py",
line 6, in <module>
from pip.commands.bundle import BundleCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/bundle.py",
line 6, in <module>
from pip.commands.install import InstallCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/install.py",
line 5, in <module>
from pip.req import InstallRequirement, RequirementSet,
parse_requirements
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/req/__init__.py",
line 3, in <module>
from .req_install import InstallRequirement
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/req/req_install.py",
line 35, in <module>
from pip.utils import (
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/utils/__init__.py",
line 100, in <module>
def rmtree(dir, ignore_errors=False):
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/_vendor/retrying.py",
line 47, in wrap
@six.wraps(f)
AttributeError: 'module' object has no attribute 'wraps'
[qsecofr@QLFI2]/QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db#

-Jim



On Thu, Jun 23, 2016 at 12:31 PM, Kevin Adler <kadler@xxxxxxxxxx>
wrote:

Oops, sorry gave you the wrong PTF number. Here's the Py3 PTF:
SI60563

All the Python PTFs are documented here:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/
wiki/IBM%20i%20Technology%20Updates/page/Python%20PTFs


"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/23/2016
09:26:58 AM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/23/2016 09:27 AM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I did not have SI60567 install. I've installed it now. It added a
.whl
file to /QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db, but only one
for
Python 2.7:

ibm_db-2.0.5.4-cp27-cp27m-os400_powerpc.whl

There is also an egg file, but that is for ibm_db v2.0.5.1 which I
think
is
what I already had installed. Is there a .whl file for ibm_db v
2.0.5.4
for Python 3?

-Jim

On Wed, Jun 22, 2016 at 10:29 PM, Kevin Adler <kadler@xxxxxxxxxx>
wrote:

connect/pconnect take implementation specific parameters, so they
aren't
in the PEP. We should probably document them somewhere. Here's the
function definitions from the ibm_db_dbi.py:

def connect(dsn=None, user='', password='', host='', database='',
conn_options=None):
def pconnect(dsn, user='', password='', host='', database='',
conn_options=None):

(Note, host is not supported on IBM i, since you have to specify
this
in
the RDB)


try this:


import ibm_db_dbi as dbi

conn = dbi.pconnect(dsn=None, database='*LOCAL', user=None,
password=None)


You can specify a DSN string like so:

dbi.pconnect("DATABASE=*LOCAL;UID=user;PWD=pass")


and this should be equivalent as above *LOCAL/None/None:

dbi.pconnect("DATABASE=*LOCAL")



Now that I'm looking at it again, it looks like I missed the
default
parameter for dsn on pconnect. Once that's there, you can do:

dbi.pconnect(database='*LOCAL', user=None, password=None)

(Already works on connect)



Make sure you're on the latest version of ibm_db. I'm not sure if
the
original shipped version of ibm_db_dbi actually worked. Since
2.0.5.1
it
should work, but I'd get to 2.0.5.4, which is shipped with
SI60567.



"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/22/2016
09:33:07 PM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/22/2016 09:34 PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I'm trying ibm_db_dbi but can't figure out the pconnect
parameters.
Trying
to connect to the local database. Any pointers?

Jim
On Jun 22, 2016 8:25 PM, "John Yeung"
<gallium.arsenide@xxxxxxxxx>
wrote:

On Wed, Jun 22, 2016 at 5:54 PM, Jim Steil
<jim@xxxxxxxxxxxxxxx>
wrote:
Hey John - where can I get some info on ibm_db? I tried out
the
itoolkit
on my IBM i today and was a bit disappointed in what I had
to do
to
access
the database. I'm guessing this is not going to be the
preferred
method
of
db access for Python. I'd appreciate pointers to any info
you
have
on
ibm_db for Python...

I agree with Kevin: Under normal circumstances, you should not
be
using ibm_db directly, but rather ibm_db_dbi, to get the
standard
Python database interface as laid out in PEP 249. If you're a
long-time Python user, you're probably already familiar with
this
interface. If not, I find the PEP is pretty good documentation
for
it.

To be completely honest, I have never had especially high
hopes
for
itoolkit, whether for accessing data or programs:

http://yips.idevcloud.com/wiki/index.php/XMLSERVICE/Python

The documentation for the underlying XMLSERVICE has been
around
for
quite some time now, as well as some of its wrappers in other
languages. It just seems fundamentally verbose and cumbersome,
by
Python standards. The Python version (judging by the
documentation
linked to above) is about as verbose as I was expecting. It
looks
almost as bulky as Java, but with a style reminiscent of Ruby.
Or
maybe JavaScript. (I only have a passing familiarity with
those
languages.) But I haven't given it a fair shake yet, so we'll
see.

If I do become a convert to IBM's Python (as opposed to the
third-party iSeriesPython which I'm using now), I may wind up
writing
my own wrapper for itoolkit, or my own fork of itoolkit.

To me, itoolkit seems to be mainly for calling native programs
and
service programs (mostly written by your own shop, mostly in
RPG),
or
IBM system APIs. Both of these uses are probably dwindling
niches,
as
more and more people write stored procedures and UDFs, and IBM
exposes
more and more system services to SQL. Eventually, you may be
able
to
just do everything with ibm_db_dbi. But I know our shop is far
from
that point.

John Y.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing
list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing
list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.



--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.



--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.



--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.