Click here to Skip to main content
15,922,155 members
Home / Discussions / Database
   

Database

 
GeneralRe: can someone please help me to solve the relational algebra equation? Pin
Chris Quinn27-Aug-14 4:55
Chris Quinn27-Aug-14 4:55 
GeneralRe: can someone please help me to solve the relational algebra equation? Pin
Richard MacCutchan27-Aug-14 7:00
mveRichard MacCutchan27-Aug-14 7:00 
AnswerRe: can someone please help me to solve the relational algebra equation? Pin
Bernhard Hiller27-Aug-14 20:50
Bernhard Hiller27-Aug-14 20:50 
AnswerRe: can someone please help me to solve the relational algebra equation? Pin
data modeling guy29-Sep-14 6:49
data modeling guy29-Sep-14 6:49 
QuestionPackage executed through SQL SERVER AGENT throwing exception Pin
hemjogi26-Aug-14 2:34
hemjogi26-Aug-14 2:34 
QuestionRe: Package executed through SQL SERVER AGENT throwing exception Pin
Eddy Vluggen26-Aug-14 3:02
professionalEddy Vluggen26-Aug-14 3:02 
QuestionTransactiona Replication Database MSSQL Server 2008 automatic sync Pin
Ahmad Hoshya23-Aug-14 8:48
Ahmad Hoshya23-Aug-14 8:48 
QuestionWriting A Database As Back-End For Application Developed By Others Pin
phil241514-Aug-14 1:41
phil241514-Aug-14 1:41 
I've written lots of small applications where I work, developing the databases in SQL Server, which is my forte, and the front ends in ASP.NET. When I've been doing it all myself it's been easy because, as the application developer, I know the databases and have no trouble writing ad-hoc queries in the application or, more often, calling Stored Procedures that I've written, knowing what parameters are required, and so on.

But now I'm embarking on a much larger project, for which we'll be hiring developers to write the application. I'm just writing the database. My plan was to write well-documented Stored Procedures to perform every operation required on the database - inserting, updating, deleting, retrieving records, and so on, and then letting the developers just call these procedures from the application without them needing to know the database's structure, effectively creating an API. If I have time, I also intended to write web services as an intermediate level for them to use, so that they call these services rather than the Stored Procedures. I don't know how much benefit there is to doing this for the core .NET application, but since we intend to also create mobile apps down the line, the same services could be used for those as well.

This morning I've been reading about CRUD and writing RESTful services and so on (not completely understanding it all), and now I'm starting to wonder if I'm missing something. I want to set up an API, so to speak, that will seem sensible, easy to work with and perhaps even familiar to our experienced developers after they are recruited, but since this is the first time I've worked in this way I'm not really sure what they'll be expecting. I want to work in line with best practice to deliver a successful project and an excellent product. Does my proposed plan fit this requirement, or should I be doing something else?

EDIT: Maybe I'd get more useful replies if this was in the Web Development thread? Can a mod move it?
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
Mycroft Holmes14-Aug-14 4:18
professionalMycroft Holmes14-Aug-14 4:18 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:38
phil241521-Aug-14 5:38 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
jschell15-Aug-14 9:39
jschell15-Aug-14 9:39 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:37
phil241521-Aug-14 5:37 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
PIEBALDconsult21-Aug-14 5:11
mvePIEBALDconsult21-Aug-14 5:11 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:20
phil241521-Aug-14 5:20 
Question(Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 21:45
Jassim Rahma11-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
Kornfeld Eliyahu Peter11-Aug-14 21:58
professionalKornfeld Eliyahu Peter11-Aug-14 21:58 
GeneralRe: (Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 23:40
Jassim Rahma11-Aug-14 23:40 
GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 1:42
professionalGuyThiebaut12-Aug-14 1:42 
GeneralRe: (Expiring Next Month) Problem Pin
Bernhard Hiller12-Aug-14 21:28
Bernhard Hiller12-Aug-14 21:28 
GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 21:45
professionalGuyThiebaut12-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
GuyThiebaut11-Aug-14 22:07
professionalGuyThiebaut11-Aug-14 22:07 
QuestionT-Sql Distribute data into groups based on existing numbers Pin
dreaddan10111-Aug-14 10:42
dreaddan10111-Aug-14 10:42 
AnswerRe: T-Sql Distribute data into groups based on existing numbers Pin
Jörgen Andersson13-Aug-14 22:44
professionalJörgen Andersson13-Aug-14 22:44 
QuestionProblem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd9-Aug-14 23:02
professionalVimalsoft(Pty) Ltd9-Aug-14 23:02 
AnswerRe: Problem with Decimal Places and Rounding off Pin
Kornfeld Eliyahu Peter10-Aug-14 0:00
professionalKornfeld Eliyahu Peter10-Aug-14 0:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.