This is more of a product philosophy/software architecture question. If you are writing a business application, groupware, bug tracker, etc. you'd come across a client demanding "I want field XYZ in this entity." You know the field is too specific for the organization's needs and/or the terminology does not fit your product. Do we give...
With the code, forms and data inside the same database I am wondering what are the best practices to design a suite of tests for a Microsoft Access application (say for Access 2007). One of the main issues with testing forms is that only a few controls have a hwnd handle and other controls only get one they have focus, which makes autom...
Consider the following 2 queries: select tblA.a,tblA.b,tblA.c,tblA.d from tblA where tblA.a not in (select tblB.a from tblB) select tblA.a,tblA.b,tblA.c,tblA.d from tblA left outer join tblB on tblA.a = tblB.a where tblB.a is null Which will perform better? My assumption is that in general the join will be better except in cases whe...
I've been trying to implement unit testing and currently have some code that does the following: query external database, loading into a feed table query a view, which is a delta of my feed and data tables, updating data table to match feed table my unit testing strategy is this: I have a testing database that I am free to manipula...
Hi, I'm looking for a desktop/embedded database. The two candidates I'm looking at are Microsoft SQL Server CE and Oracle Lite. If anyone's used both of these products, it'd be great if you could compare them. I haven't been able to find any comparisons online. The backend DB is Oracle10g. Thanks! Update: Clarification, the business ...
Hey guys, What is the maximum size you have seen a MySQL table? 2 Million at 50gig? 5million at 80gig? Any stories appreciated. Did you end up compressing data? Splitting the table if it grew too big? ...
HI All, We have a .Net 2.0 application which has a MySQL backend. We want to be able to deploy MySQl and the DB when we install the application and im trying to find the best solution. The current setup is to copy the required files to a folder on the local machine and then perform a "NET START" commands to install and start the mysql ...
In our current database development evironment we have automated build procceses check all the sql code out of svn create database scripts and apply them to the various development/qa databases. This is all well and good, and is a tremdous improvement over what we did in the past, but we have a problem with rerunning scripts. Obviously...
What options exist for accessing different databases from C++? Put differently, what alternatives are there to ADO? What are the pros and cons? ...
What are the other types of database systems out there. I've recently came across couchDB that handles data in a non relational way. It got me thinking about what other models are other people is using. So, I want to know what other types of data model is out there. (I'm not looking for any specifics, just want to look at how other peop...
I work for a company whose primary business is not software related. Most documentation for using source control is written with a development team writing for commercial or open source projects in mind. As someone who writes in house software I can say that work is done differently then it would be in a commercial or open source setting...
How can you find out what are the long running queries are on Informix database server? I have a query that is using up the CPU and want to find out what the query is. ...
In postgresql I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there a oracle equivalent? ...
I'm doing a research project, part of which is concerend with object oriented databases. I would like to hear from anyone who has experience using such databases, or considered using them but opted to go for a different approach. What did you like? What didn't you like? What made you choose using the approach you ended up using? When ...
So, I have 2 database instances, one is for development in general, another was copied from development for unit tests. Something changed in the development database that I can't figure out, and I don't know how to see what is different. When I try to delete from a particular table, with for example: delete from myschema.mytable where...
I am writing a DDL script to drop a number of tables but need to identify all dependencies for those tables first. Those dependencies include foreign key constraints, stored procedures, views, etc. Preferably, I want to programmatically script out dropping those dependencies using the system tables/views before dropping the dependent tab...
I have a webapp that uses JNDI lookups to get a connection to the database. The connection works fine and returns the query no problems. The issue us that the connection does not close properly and is stuck in the 'sleep' mode (according to mysql administrator). This means that they become unusable nad then I run out of connections. Ca...
In trying to figure out this problem (which is still unsolved and I still have no clue what is going on), I am wondering if maybe an external reference to the table in question is causing the problem. For example, a trigger or view or some other such thing. Is there an easy way to find all references to a given database table? Includi...
I would like to offer a database connection prompt to the user. I can build my own, but it would be nice if I can use something that somebody else has already built (maybe something built into Windows or a free library available on the Internet). Anybody know how to do this in .Net? EDIT: I found this and thought it was interesting: Sho...
When trying to connect to an ORACLE user via TOAD (Quest Software) or any other means (Oracle Enterprise Manager) I simply get the error: ORA-011033: ORACLE initialization or shutdown in progress [in the spirit of StackOverflow I will answer this one myself - at least I'll relate how I resolved it in my case - please also relat...