Page 4 Table Joins? - Form and List

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

6/5/2007 6:37 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Table Joins?

sorry, but I do not understand the content of your post.

Next version of UDT has been rescheduled several times, because we are still adding features. We now plan to submit it to the issue tracker in about 2-3 weeks.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/5/2007 6:41 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Table Joins?

Vincent_ohare@hotmail.com wrote

I am investigating whether DNN can be used as the basis of a multi-tenanted, business application in which each tenant (company) can create/modify their own user defined database tables and fields. From an initial look, it seems like DNN may be able to support multi-tenancy. I am now investigating the UDT to see to what extent it can support user defined databases.

Since a database is a collection of joined tables, a 'join' facility is probably required in my application, supporting things like 'parent/child' relationships. Perhaps the 'User Defined Table' project could be extended to a 'User Defined Database' project?

Over the next few days, I do intend to draw up a specification for the 'User Defined Database' facilities that I need. I will be happy to share the specification with you when it is finished, hopefully, in a week from now.

this sounds interesting, and we already discussed this enhancement, but decided to implement other enhancements first.

Next UDT version will add search, filtering, extended row settings and xsl editor/generator (as well as many minor enhancements).

Afterwards the module shall be migrated to DNN4 and some parts reworked, before adding other features.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/5/2007 6:58 AM

Stefan Cullmann

Joined: 1/6/2005

Posts: 2867

Re: Table Joins?

hz_yang wrote

I'm making my own UDT module too, and now what I did is allow user to add attach for each row, UDT's download control cannot fit me, because it's just refer a file on UDT's design mode. I extend a new table to store each row's attachments, user who have right can upload one or more. If you want it to be like a SharePoint, I think attachments management will be important.

Your statement is difficult to understand if the reader doesn't know Sharepoint. Sharepoint lists are able to add mulltiple files as attachments to every row, even without adding a "download" column. I think this is a quite interesting uses case, though we are not currently working on it and this is the first time I read this kind of request.

6/5/2007 7:07 AM

Stefan Cullmann

Joined: 1/6/2005

Posts: 2867

Re: Table Joins?

leupold wrote

sorry, but I do not understand the content of your post.

Next version of UDT has been rescheduled several times, because we are still adding features. We now plan to submit it to the issue tracker in about 2-3 weeks.

I have asked for the last deferment. We are currently dogfooding UDT 3.4.0 at our company. This step revenues a lot of feedback. We are actually still improving the usability of the new enhancements.

6/5/2007 5:18 PM

ThatEmeraldGuy

Joined: 5/7/2007

Posts: 7

Re: Table Joins?

Hello again,

I have now completed my initial asessment of what i need in the way of a user definable database.

If anyone is interested in seeing the outline specification document please email me at vincent_ohare@hotmail.com and i will send a copy.

Basically, my requirement is to have a database containing tables comprising fields of three types:-

Category 1. - Plain Field

Category 2. - Field with Pick List

Category 3. - Field with a lookup relationship to another database table

My initial asessment of the UDT is that it might not be suitable for my requirement for the following reasons:

a) It looks like it is a highly generic/convoluted 'three (or 4?) table' solution, capable of handling many 'tables' and 'records', but without actually having any physical tables or records (if you know what I mean?). I am concerned that this might present challenges to both developers and users (System Administrators) trying to query and report from the system.

b) I can't work out where the UDT tool stores its data and i suspect it is not in SQL Server, but may be in XML files. As my application could easily contain 50,000 records, i feel that i need the indexing and resilliance of SQL Server.

So, I think i am a bit off course, looking at UDT.

I have therefore widened the search for a suitable user definable database component and have come across www.cookDNN.com and the Universal List tool. Universal List creates physical SQL Server Tables and also supports links between tables and indexing of large tables. It seems to be more in line with my requirement. So I plan to invesigate Universal List, moving forward.

Regards

Vince.

Page 4 of 5

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)