I'm testing ELMAH and have deliberately turned off the database connection for the ELMAH log in my application to see what will happen in production if the DB isn't available. It seems that ELMAH can't trap its own errors- the AXD file isn't available when the SQL databse log fails. What is the intended behavior of ELMAH if the databas...
This is vaguely related to: Should I design the application or model (database) first? Design from the database first through to UI or t’other way round? But my question is more about modeling and artifacts and less about the right way to do design. I'm trying to figure out what sort of design artifact would best enunciate the link ...
I'm writing some code that needs to work against an array of different database products. MySql Sql Server 2000 to 2008 PostgreSQL Oracle 9i & 10g Jet 4.0 (MS Access) MSDE Sybase Adaptive Server Anywhere Sybase Sql Anywhere Progress OpenEdge We have a set of generic integration tests that we need to run against each database produc...
This is probably an easy question to answer, but I don't see it mentioned in the documentation... What happens when insert results in an error? Is an exception thrown? What type? I'm trying to understand what would happen when trying to insert duplicate data in a column that is unique. So I feel like I need to do some checking first......
I have been interested in SSD drives for quite sometime. I do a lot of work with databases, and I've been quite interested to find benchmarks such as TPC-H performed with and without SSD drives. On the outside it sounds like there would be one, but unfortunately I have not been able to find one. The closest I've found to an answer was t...
I am thinking of creating a "wishlist". Each user will be able to purchase wishes in a shop. How do I store the wishlist? I am thinking of creating an user table and a wishlist table. The structure of user table: Columns: id, username, password etc Columns: id, wish, price, quantity etc user id is the primary key for user table and i...
Hi, I have a problem in my code or connection I think... I tried to connect to a MySQL database and web service, but when I run the program, it gives me the following error: @WebService() public class LostNumWebService { /** * Web service operation */ @WebMethod(operationName = "getCategory") public List getCategory(@WebPar...
I work for a software shop, which has an in house predictive dialer product, and we need to implement a solution to obey to the DO-NOT-CALL lists. Basically, I have a database with the customers/prospective customers that I need to call, and another database with the phone numbers I can't call. As the system is a predictive dialer, bas...
I have a rake task that populates some initial data in my rails app. For example, countries, states, mobile carriers, etc. The way I have it set up now, is I have a bunch of create statements in files in /db/fixtures and a rake task that processes them. For example, one model I have is themes. I have a theme.rb file in /db/fixtures t...
What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area? The idea of this question is to collect the shed load of resources that invariably exist, so that people can have a "one stop" knowledge shop of the good, peer approved resources. General SQL Book: SQL Perform...
Hi, I was probing around a bit in the realm of databases and hit the notion of having heterogeneous databases. I googled and found this - link text My question is what kind of scenario would put this into practice and is it really useful? Is it just another thing which was thought about but not implemented or in case it was implemented...
I'm surprised this hasn't been posted yet. Any interesting tricks that you know about in Postgres? Obscure config options and scaling/perf tricks are particularly welcome. I'm sure we can beat the 9 comments on the corresponding MySQL thread :) ...
I have two tables in my SQL database: Company: - ID (autoincrement) - name - address - ... Employees: - ID (autoincrement) - Company_id - internal_id - name - lastname The problem is that I would like to have a employee id (internal_id) that is relative to the company they belong to. I got this dilema since I'm really been se...
There are some tool (free preferentially) to to migrate data between different DBMS (like from MySql to Firebird, or Sql Server to Sqlite, etc)? Edit: I want specifically to migrate from "Firebird Embed" to "Sqlite". But in another situations (like migration of my customers websites) I need migrate from MySql to Sql Server (and vice-ver...
I have a site which has a page that shows the user a set of workout sessions in each table. The exercises in the sessions are href links and cannot be sent to the database as variables. The links are displayed in tables on the page which is another reason why I can't send them to the database. How can I save the state of the web page, (...
I've read a few questions on SO (such as this one) in regards to versioning your data within a database. I liked some of the suggestions that were mentioned. I have for the longest time wanted (needed) to revision many of my tables but never got around to it. Being a programmer with only simple database work under my belt I was wonder...
I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples? ...
I developed an ASP application (VBScript backend, JavaScript frontend) that makes use of a remote MySQL database (Bugzilla). The applicaiton works well on a localhost, yet fails to work when uploaded to GoDaddy. Spending two hours on the phone with GoDaddy's support didn't help... The error I'm getting is: =============================...
Hi! What tools are you using to track changes in your MySQL database? Currently I'm in a project where we use a plain text-file (version controlled via SVN) in which we manually add SQL statements when making changes to the database.Many of the changes magically disappears every now and then, and we are now looking for a better way to c...
This might be more of a serverfault.com question but a) it doesn't exist yet and b) I need more rep for when it does :~) My employer has a few hundred servers (all *NIX) spread across several locations. As I suspect is common we don't really know how many servers we have: more than once I've been surprised to find a server that's been u...