: 4536 | 107843 | 12217

Data Connections - new class: Notes 
Use this IdeaSpace to post ideas about Domino Designer.

: -8
: 1
: 9
: Domino Designer
: @dbcolumn, @dblookup, connections
: Patrick Kwinten22008 25 Sep 2009
:
: / Email


a pain in the ass when giving support on a Notes application or when making modifications is that without a system description or a scan using third party tools it is hard to see which dependencies their are to other Notes systems.
 
@dbcolumn and @dblookup commands have the reference to other systems in their declaration.
 
in case data connections could be extended to define connections to other Notes systems and when they can be used in commands then it would be more clear to define dependencies...
 
@DbColumn( class : cache ; [data connection] ; columnNumber )



1) Rob Porter669 (25 Sep 2009)
This seems like a good idea but the thing that makes me uneasy, looking at your properties mock-up above, is the server field. This effectively hard codes the server name into the application which makes code portability non-existent. Think how this will affect moving an application from a development environment into a live environment or replicas spread across servers in different cities or countries. The last thing you would want is a replica in Hong Kong trying to do a @dblookup to a database in London.

I think this idea has merit if the server field could be blank which would force @dblookup and @dbcolumn formula using the Data Connection to use the current server.
2) Peter Presnell26511 (25 Sep 2009)
Sorry Patrick. I don't like this idea, at least not in the way it is proposed. By making the data connection a design element you are essentially consigning every database that inherits its design linking to the same physical database. In many cases the external databases needsto vary (e.g. Development v QA v Production).

With what we already have today is possible to define a Data Connection as a data document and then have the code refer to the data in the connection document. This allows every instance of a database to have its own defeinitions of where the external database reside and even allow the definition to specify the location using either replica ids or specific server/fileprarhs.
3) Starrow Pan4409 (29 Sep 2009)
I think your connection works as a layer between the program and the reference of other db. Even with this feature, you cannot expect all the programmers to take this extra effort. Moreover, if it is supposed to be a practice standard, you can actually do it with some profile views without introducing a new design element.
4) Ben Poole1705 (29 Sep 2009)
I agree that this is a hassle, and something to address it would be cool. I don't think that this is the solution though, sorry.










:
:

Welcome to IdeaJam™


You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>


4
Allow more than Database Icons on the Workspace?
36
Calendar current time visual indicator
-1
Allow more granular control of the Database Administrators security setting on the server document for roaming upgrade
6
Message Recall available to Administrators (SPR # Included)
3
Have the "Folder" column of the "All Docs" view also available in iNotes
6
Dynamic favicon
24
Option ExtendedSyntax False (or NotesDocumentExtended False)
22
Domino should fully support Windows Server shadow copy & VSS for backup
1
4.2.11 WSDL documentation Element for WebServices
1
Sametime Alert with a placehoder for topic
9
Save snoozed alarms
6
Add functionality in IdeaJam to Automatically create an SPR for the enhancement request with IBM
59
Please update Domino to fully support TLS (SSL v3.1)
3
I wish evaluate() would throw errors (again)
6
Replication and Sync Sametime contacts
216
Programmable embedded views
5
Allow predefined notifications to be sent automatically when a task is completed in an Activity
18
One-click way to add participants to a Lotus Notes Meeting Invite
4
I wish @Eval returned errors much like other @Functions
4
Bring sametime audio and video into the web browser using WebRTC
6
Improvements to Single Copy Template (SCT)
10
Add contact to multiple groups at one Go
18
When email comes in over SMTP via SSL/TLS, please set a field indictating that
4
NSD should collect web server log if logging enabled
4
Weekly/Monthly email of new Ideas and Comments from IdeaJam






IdeaJam developed by

Elguji Software Logo