|
-
Nov 23rd, 2005, 08:02 AM
#1
Thread Starter
Fanatic Member
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
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
 Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Nov 23rd, 2005, 11:49 AM
#2
Thread Starter
Fanatic Member
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Nov 23rd, 2005, 12:45 PM
#3
Re: Stored Procedures
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).
-
Nov 23rd, 2005, 12:49 PM
#4
Thread Starter
Fanatic Member
Re: Stored Procedures
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
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Nov 24th, 2005, 10:04 AM
#5
Thread Starter
Fanatic Member
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Nov 24th, 2005, 10:23 AM
#6
Re: Stored Procedures
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.
-
Nov 24th, 2005, 10:30 AM
#7
Thread Starter
Fanatic Member
Re: Stored Procedures
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
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
-
Nov 24th, 2005, 10:56 AM
#8
Re: Stored Procedures
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)
-
Nov 24th, 2005, 11:52 AM
#9
Thread Starter
Fanatic Member
Re: Stored Procedures
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
As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..
A few things that make a good Developer a Great One.
Methodical and a thorough approach to research and design inevitably leads to success.
Forward thinking is the key to Flow of control.
Never test in the design environment, always test in real time, you get the REAL results.
CBSE & OOSE are the same animal, they just require different techniques, and thinking.
SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
The key to good design is explicit attention to both detail and response.
Think Freely out of the "Box" you're in..... You will soar to better heights.
Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
