RE: Stored Procedures

Hi all,

I would like to know where I can get hold of a list of SQL basies commands for a Forum.. I have a project that I intend on testing a forum with hte new intranet technologies my company has designed.

Am gonna just go for the big guns on this one and use Oracle, but the intentions are that this wil be used with all Databases (DBase, Oracle, SQL Server, my SQL, Acess, SQL anywhere, Interbase, Alpha, etc) so the nature of these procedures or the nature of the command literature, whther its T-SQL, P/SQL or ANSI stanrda is urrelevant, I just need to look at them so I can deconstruct them and build generic commands that are natively recognised to all SAN platforms.

In short, any sites, or pointers to getting these commands and procedures from any existing forums or templates for forums.

Any pointer os know of where I can get hold of this information?

Thanks for the help

Kai

bump.....

Are you saying that you want to create SP's that can be used on any DBMS?

If so, that isn't going to work I'm afraid - they all use different syntax to create SP's (and possibly to execute them too).

Hi si,

nope thats not what im saying, what I plan on doing is looking at the pre-designed stored procedures and crete commands and SP's based upon each databse platform.

What I want to do is look at some pre-built ones for... sy mySQL or SQL server then build my own form teh identifications I make from these.

SO what im asking is does nybody know wher I can look at some SQL commanda nd sp's for forums.

AND..

what is the equivelant of the mVarChar in ms SQL 2000 in mySQL? Text??

Cheers

Kai

bump bump!!!

I'm still not really sure what it is that you are after.. one thing I'll say tho is that not all DBMS's support stored procs, and the way they are called can vary too.

Depending on what it is that you are trying to acheive in each case, SP's may not be the best idea. Most of the DB work needed for forums doesn't need SP's, although obviously in many cases it can improve the performance. The trouble with trying to support a variety of DBMS's is that you will probably not have all of them optimised - as they all require slightly different tweaks to get the best from them.

Oh, and I'm afraid I have no idea about MySQL data types.

Its easy really.

all I want to do is look a t the sql code that is behind a forum thats all mate...

The rest I can perfectly handle myself..

Kai

Well I haven't seen any myself, but I would assume that it would just be a matter of working with tables like this:

Users (user_id, user_name, password, email, last_login, ...)
Groups (group_id, group_name)
UsersInGroups (user_id, group_id)
Forums (forum_id, forum_name)
Forums_for_groups (forum_id, group_id) '(groups who can see each forum)
Threads (thread_id, forum_id, thread_title, is_deleted)
Posts (post_id, thread_id, number_in_thread, post_title, post_text, is_deleted)

Cheers but Ive got the basic framework on thsi one already... What I really need is to look at some fothe advanced core SQL commands that are at the sheer heart of a forum, as this one is working a little differently, but is baseud ujpon the rule ofa forum, so what I really need are core SQL, not jsut basic framework.

Am gonna use this though as it does give me an idea on something though.

Cheers si

Kai