: 4582 | 108668 | 12353

SQL Interface for Notes Apps 
Use this IdeaSpace to post ideas about Domino Designer.

: 27
: 31
: 4
: Domino Designer
: SQL, agent, interface
: Sean Burgess5201 20 Sep 2007
:
: / Email
Notes "might" be taken a bit more seriously if developers could write standard SQL to get data out of it, especially for web applications. Don't bring up the NotesSQL driver, cause although it still works, requiring someone to install something to get to web data flies in the face of what the web is all about. I believe that the interface should be able to handle Select, From, Where, and Order commands and be able to do Joins across disperate data sets.



1) Kerr Rainey3860 (21 Sep 2007)
What's your target for this? Developers writing agents using SQL withing the agent to query the database? If it's restricted to working on the view indexes it might be interesting, but if it needs to go into docs, then you'd be just as well running and db search. Also if the query was hard coded, you would be MUCH better off just building a view that has the data you need.

Or am I missing something?
2) Sean Burgess5201 (21 Sep 2007)
My thoughts on this would be to pass a request to an agent via a GET or POST and have that agent return the result set. It should NOT require any views to be built to handle it. In addition, it could act much like the RSS database template in Domino 7 in that you could have 1 web service per server to gather the data. In addition to the normal SQL commands I mentioned above, there will also be an attribute to allow the user to determine the format of the data returned (CSV, JSON, XML, Word/Excel).
3) Tripp Black622 (25 Oct 2007)
Rather than a query, simply do a view getdocsbykey, you can either concatenate the "keys" into one column or pass an array. Also w/Domino8 you can store a Notes Database in DB2 natively. Then you can do DAVs as a "normal" view or a Query View which is basically what you are asking as you use a Query to create the views collection of data notes/documents. See the Notes Designer8 documentation on { Link } for more information.
4) Gavin Bollard1561 (12 Nov 2007)
Actually I'd like some way that our users could type an SQL command and get output to a console/window. Ideally they could save these for regular reporting, perhaps even have the results emailed to them automatically on a certain interval (daily/weekly?).
5) Peter LaComb682 (02 Dec 2007)
Eh...I think that as DB2 is now a native data store, this isn't so much an issue. I'd rather have access to use my iSeries db2 without weird workarounds.
6) Roland Reddekop4313 (30 Dec 2007)
An SQL interface to Notes data would be perfect for reporting as Bob Balaban noted in his blog about NSFDB2.
{ Link }

It just would be nice to have SQL against an NSF without the need to go full-blown to NSFDB2 which is not an option on platforms like System i anyway.
7) Mark Haller1118 (23 Feb 2008)
I totally buy this idea. If you try to implement a new application/database for any client and you know that in the requirements is reporting, it's the one thing avoided like the plague.

I'm faced with three options that I know of, and have been discussed here:

Native DB2 - why do I not see this being pushed by Lotus? I read all the blogs, I run the latest builds, etc, etc, but is it really being pushed as viable?

NotesSQL - I gave up on it years ago because it was so flakey and required desktop install. It was quicker to dissect the NSF with an Hex editor than wait for results sometimes. Is it really better now? If so, I'll give it a whirl.

Cross-storing data or writing relatively "slow" agents - yeah, we've all got great ways of getting out what we want, like views categorised on numerous elements and so on, but it's all workarounds to something that should be native, fast and efficient, for both "super users" in a community, or for developers

Step outside a moment, and picture going into a "report writer" module, where you pull disparate data together from across your database into one report, based upon prompted variables, SQL joins, and other very old and simple techniques ... man, that would ROCK MY WORLD! :-)










:
:




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 >>


23
Better control over horizontal outlines
18
Implement "Live Scrolling" in Mail Views
21
Develop and open source a high quality framework for new DBs
20
InViewEdit - option to show <Ctrl-click here to add new document> at top of view
7
AJAX Suggest to work off Full Text search
-13
Email Chaser View
24
Integrate Quickr Connectors into the Lotus Notes install, just as is done for Sametime
19
Fix the bug of @BrowserInfo
45
Push out Notes.ini parameters with a Desktop policy
34
Have Ctrl-T open a new browser tab in the Notes Client
15
Connect to more than one Sametime server in Notes client
34
Clear All Breakpoints
13
Include Request_Content in DocumentContext for Web Service Providers
17
Ability to detach and remove file attachments from multiple emails at once
21
Control integrated Sametime status settings
17
Extend options to set preferences for Rich Text
32
Add @DialogBox, @PickList and @Prompt for x-pages
24
HTML validation and accessibility for XPages
15
Add 'Move to My Contacts' button to the form
26
Stationary usable in reply and forward of emails
42
Copy text to the clipboard from the Properties dialog - especially the Replica ID
35
Publish API to work with calendar items, tasks and contacts






IdeaJam developed by

Elguji Software Logo