Hello, I was wondering how/if people have worked around db schema changes that would otherwise cause a production system to be down. It seems with additive changes that are constrained in some way (e.g. unique constraint) would be difficult to do b/c the app and the db must change at the same time otherwise errors will occur either in t...
this is what I mean: job has many docs. I want to create a doc, I can do: @doc = Doc.new(params[:doc]) but I'd like to enforce the parent-child relationship, since I already know the job.. something like this: @job.docs.new(params[:doc]) so that the job_id field gets ignored and only the @job object matters... does it make any se...
I'm using in-memory derby db for my java application. I would like to delete all the tables/databases it created once the application ends. So when it starts back up, I want it to start fresh. ...
I am creating a desktop application written in Delphi and I am looking for a database for my application. I'm a bit overwhelmed by the number of available options. I'd really appreciate some recommendations and insights from other developers based on their experiences. Critical factors Low or no buyin cost. No distribution fees. E...
I'm interested in hearing about design strategies you have used with non-relational "nosql" databases - that is, the (mostly new) class of data stores that don't use traditional relational design or SQL (such as Hypertable, CouchDB, SimpleDB, Google App Engine datastore, Voldemort, Cassandra, SQL Data Services, etc.). They're also often ...
This works: var i = (from x in db.Test where x.Id == 1 select x).First(); db.Test.DeleteOnSubmit(i); db.SubmitChanges(); I get a cast error for this (int/string): var i = db.Test.Single(x => x.Id == 1); db.Test.DeleteOnSubmit(i); db.SubmitChanges(); I was also able to make an update using Single sucesssfully on the same ta...
Hi, I've read the Core Data references on Apple's site. But I wonder, what they mean with atomic store types? They write something of "they have to be read and written in their entirety". Could somebody clarify this, please? ...
What is the proper way to define an oracle table who has an optional foreign key relationship with another table? For instance, some employee records have defined the country they are from (a FK from countries table), and some have not. ...
The Database Engine Tuning Advisor has recommended the creation of some statistics for several of our queries. Turns out that some of these are the same just the column order is different in the CREATE STATISTICS command. For example: CREATE STATISTICS [StatName1] ON [dbo].table1 CREATE STATISTICS [StatName2] ON [dbo].table1 are the...
I'm sorry if this is really basic, but: I feel at some point I didn't have this issue, and now I am, so either I was doing something totally different before or my syntax has skipped a step. I have, for example, a query that I need to return all rows with certain data along with another column that has the total of one of those columns...
I am new to oracle. I need to process large amount of data in stored proc. I am considering using Temporary tables. I am using connection pooling and the application is multi-threaded. Is there a way to create temporary tables in a way that different table instances are created for every call to the stored procedure, so that data from ...
We have a great process for upgrading our clients' websites as far as updating html/js code and assets is concerned (by using Subversion) that we are very happy with. However, when it comes to upgrading databases, we are without any formal process. If we add new tables/fields to our development database, when it comes to rolling it ou...
I want to call "storing a password in plain text in a Database" a bad pratice... but our customer did this in his Application. They want me to renew that Application. My point: I want to change this...but since it is not a need for our Customer it is still unclear. How do you handle such issues regarding security? From my point of view...
Hello, I am trying to place items dynamically from a mysql database into a shopping cart(jcart). I have a page with 3 divs and all contain a form for the shopping cart(form code below). I am grabbing info from the database and placing it in the form. The first div is getting the info correctly, but the second div displays the exact same...
I want to have the pk in my fetched objects, so i can use the unique pk number for a unique image filename. But i can't make it work, i just need a unique filename for my images. Does somebody has a solution for this? When i NSLog object ID i get this: NSManagedObjectID *ID = [someThing objectID]; NSLog(@"ID: %@",ID); Output: ID: 0x1...
Hello, I've got a problem with JDBC. I'have the following code: //blargeparam is a blob column. PreparedStatement pst =connection.prepareStatement("update gcp_processparams_log set blargeparam= ? where idprocessparamslog=1"); pst.setBinaryStream(1,inputStream); I get the following error: Exception in thread "main" java.lang.Abstra...
My collegues don't like auto generated int serial number by database and want to use string primary key like : "camera0001" "camera0002" As camera may be deleted, I can not use "total nubmer of camera + 1" for id of a new camera. If you were me, how will you generate this kind of key in your program? PS : I think auto generated serai...
I want to implement modules such as comment, rating, tag, etc. to my entities. What I thought was: comments_table -> comment_id, comment_text entity1 -> entitity1_id, entity1_text entity2 -> entitity2_id, entity2_text entity1_comments -> entity1_id, comment_id entity2_comments -> entity2_id, comment_id .... Is this approach correc...
Is there a way to open a cbk file to see what application created it? I know that if it was a .net application it would have a CLI header that would give some insight. Is there a Win application that will allow us to see this? I know it is not a cardscan backup, but definetly is a database of some sort, just need to figure out what ...
There have been a couple of questions about limiting login attempts, but none have really discussed the advantages or disadvantages or different ways of storing the record of login attempts (most have focused on the issue of throttling vs captchas, for instance, which is not what I'm interested in). Instead, I'm trying to figure out the ...