I will roll my own (I hear the “don’t do its”.)
I have already built one for shell and I love it. I might have gone with
shunit2 but it didn’t look like it was being maintained at the time I built
mine. It is now. I am very particular about things. Probably a flaw.
Since I have a solid design in shell already porting to PL/SQL should not be
too hard and I might even just extend the shell framework to call into the DB.
From: Jacek Gębal <jgebal@xxxxxxxxx>
Sent: Wednesday, December 19, 2018 5:04 PM
To: post.ethan@xxxxxxxxx
Cc: Tim Hall <tim@xxxxxxxxxxxxxxx>; Niall Litchfield
<niall.litchfield@xxxxxxxxx>; ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Oracle Development on 18c XE
I heard unit testing, so side question:
What do you use for unit testing? Did you try utPLSQL v3?
Cheers
Jacek
On Wed, 19 Dec 2018, 05:09 <post.ethan@xxxxxxxxx <mailto:post.ethan@xxxxxxxxx>
wrote:
This is just for development of a automation/monitoring schema in the DB.
Performance, built in packages and so on. The issue is if the data is the same
in the views coming back from XE that it is from EE, especially for things like
multitenant. Can I expect roughly the same data/columns? Sounds like it is at
least good enough to get started and I can always test in SE/EE later. I build
unit tests so I will know pretty much right away if something is broken.
Thanks for the feedback.
-----Original Message-----
From: Tim Hall <tim@xxxxxxxxxxxxxxx <mailto:tim@xxxxxxxxxxxxxxx> >
Sent: Tuesday, December 18, 2018 10:41 AM
To: Niall Litchfield <niall.litchfield@xxxxxxxxx
<mailto:niall.litchfield@xxxxxxxxx> >
Cc: post.ethan@xxxxxxxxx <mailto:post.ethan@xxxxxxxxx> ; ORACLE-L
<oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx> >
Subject: Re: Oracle Development on 18c XE
The other concern, depending on your usage of course, is the lack of patches.
Depending on company policy this can be a show stopper.
Cheers
Tim...
On Tue, Dec 18, 2018 at 4:05 PM <niall.litchfield@xxxxxxxxx
<mailto:niall.litchfield@xxxxxxxxx> > wrote:
The only concern I'd have is that since you get essentially all the
added-cost features for free you might build them into whatever
development you do.
On Tue, Dec 18, 2018 at 3:07 PM <post.ethan@xxxxxxxxx
<mailto:post.ethan@xxxxxxxxx> > wrote:
Anyone know of any obvious reason to not do development on 18c XE? This
will mostly be data dict and V$ access. Are there significant differences
in these views between this and EE? I think in the past I avoided the free
edition of SE because of some issues but wondering if that might still be a
thing I need to be concerned about.
Thanks,
Ethan
https://twitter.com/poststop
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l