Why put a simple query into a stored procedure in a web service?
I’m working as a junior programmer, and the senior programmer above me has instructed me to follow a certain unofficial policy for constructing new queries on our web development projects. Generally, we are developing an intranet site for some client, and they always have databases. He wants me to have a class containing a method for each query that the website will perform. This class calls web methods in a web service, hosted on the same machine. Those web methods use ADO to run stored procedures that perform simple queries. Sometimes the queries need parameters and sometimes they don’t. When I say simple queries, I mean simple…select * from table where column=@parameter
Which aspect of normal forms do entity-attribute-value tables violate, if any?
I’m not asking if EAV tables are good or bad. I’m wondering if they are considered “normalized”, and if not, why? If they aren’t normalized, which normal form are they violating and why?
What’s the difference between the insert methods and why one is faster
I have insert 14.485 lines on MySQL like this:
Making the switch from MySQL to PostgreSQL?
I’ve spent the last year becoming really comfortable with MySQL, but due to its increasing trendiness and my desire to homogenize my web-apps with Heroku, I’d like to start using PostgreSQL for my web apps instead. There are a resources out there for learning PostgreSQL, but I don’t really want to have database concepts explained to me from scratch again, and I don’t want to have to re-learn all the stuff that’s pretty much the same.
Help with DB Structure, vOD site
I have a video on demand style site that hosts series of videos under different modules. However with the way I have designed the database it is proving to be very slow. I have asked this question before and someone suggested indexing, but i cannot seem to get my head around it. But I would like someone to help with the structure of the database here to see if it can be improved. The core table is Videos:
TDD with SQL and data manipulation functions
While I’m a professional programmer, I’ve never been formally trained in software engineering. As I’m frequently visiting here and SO, I’ve noticed a trend for writing unit tests whenever possible and, as my software gets more complex and sophisticated, I see automated testing as a good idea in aiding debugging.
Methodologies for Managing Users and Access?
This is something I’m having a hard time getting my head around. I think I might be making it more complicated than it is.
Using XML as data storage [closed]
Closed 8 years ago.
Is there a way to determine if a database has been altered, then to push new data to the Application
All our (my company) currently applications pull information from that database, is their a way to get the following types of databses to either push data or push an event to allow the application to pull data.
Fitting it together, database, reporting, applications in C#
Introduction Preamble I was hesitant to post this, since it’s an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was actually going to write a blog post about this after I finished) I’ve discovered that the barrier I’m encountering is one that’s […]