Question Summary: Is there a better method than the one posted below to implement the database-creation stage of an automated deployment? Background/Requirements: I am in the process of attempting to develop a coherent database version control process using an approach similar to this one. This question is specifically about the bas...
My dilemma is that I am losing my ResultSet from the primary table when accessing a foreign key table. I need to save the results from the first table query while I query another table. Scenerio: I am implementing a recipe database system. Each recipe can have 1 to many ingredients. To resolve the 1 to many relationship, I created ...
I'm trying to use SqlBulkCopy to import a bunch of data to our website. In most of the other areas we're using Entity model which uses byte arrays to represent binary data in SQL. However, SqlBulkCopy seems to be confusing byte[] with string. Everything seems to be working fine except for this one binary column which throws an exception:...
In the following Form-code I have a FrmPrintKasTicket witch i start form another form. This Form should print a document based on information in a SQL database. When I use a button on this form (and remove the "PrintKasTicket();" under FrmKasTicket_Reload) it actually prints. But when I envoke the printKasTicket-methode when the Frm is ...
I have a ListView that is backed by a SimpleCursorAdapter. I'd like to be able to filter the list like you would a contacts list, just by typing, and I came across the textFilterEnabled() Problem is, I couldn't see how to get it to work with a SimpleCursorAdapter. Is this even possible? If so, how is it done? ...
I'm building web-application using Django1.1 framework with imposed database schema and data (in fact - db already exists - Postgresql). I wrote models already, now I want to perform some unit-testing. The problem: test runner destroys and reconstructs (using information from models) database after every test method, but that's undesira...
Hi there, does it make sense to create indexes for a table called user_movies with the following columns: user_id movie_id There will be much more reading than inserting or updating on this table but I'm not sure what to do. Also: Is it adequate to omit a primary key in this situation? ...
I'm working on an app which I will be displaying events (sporting events, concerts, etc, etc). I'm trying to come up with a model where I can single out teams playing for sporting events, and bands/artists playing in a concert. My initial stab at is it to have an events table, team table, band/artist table. But I can't figure out the op...
I want to disallow the use of spaces in some text/varchar fields. Even more, it would be best to have only a set of characters that are allowed to use there, like: [a-zA-Z0-9_\-] And I want to make it as a rule to all VARCHAR fields that are members of primary key in their tables. This should be done on the database level and could...
Hello! I have a Database column with the syntax "0000-00-00 00:00:00". In PHP I would do date('Y-m-d H:i:s'); In Ruby, I do require 'date' now = DateTime::now() puts "#{now.year()}-#{now.mon()}-#{now.mday()} #{now.hour()}:#{now.min()}:#{now.sec()}" The result is: "2010-1-5 10:16:4" That's not okay. How could I create a "timestring...
Are there any proven ways of refactoring a database into supporting multiple versions of entries? I've got a pretty straight forward database with some tables like: article(id, title, contents, ...) ... This obviously works like a charm if you're only going to store one version of each article. I remember asking my client really cl...
As a tester, how much should one expect a tester to know about databases? Is it only writing queries in sql or do we need to know about stored procedures, triggers etc. ...
Is there a way to connect to a remote oracle DB from a client PC without installing oracle on the client ? ...
Greetings gurus, I need a database solution that satisfies: 1: Custom-formated output from queries. 2: Custom functions integrated into queries. Some implementations of XQuery with update facility might suite my needs. However, I'm unsure of their performance when it comes to thousands (and maybe millions) of records of various nesting...
Sqlmetal creates "embedded" properties for any foreign key it finds for table. Nice. The problem is when I have several foreign keys which refers to the same (foreign) table. This I like: FK_Company_Post then I can write in code: company.Post But this I don't like -- cutting suffixes: FK_Company_Post_HQ FK_Company_Post_Mailing ...
Is it acceptable to cache an instance of the database connection on application start? Looking at the MSDN documentation on thread safety, I quote: Any public static [...] members of this type are thread safe. Any instance members are not guaranteed to be thread safe. Given that, is it acceptable/safe for code such as this example...
Hi I want to retrieve identity column value after running Insert or Update (using Access DB in C#). How can I do it? i use a Typed dataset to fill and update... ...
Scenario: The "Invoice" has a reference to the class "User". A user object is delete through the user himself or an administrator, but the invoice object still needs a recepient (the user). The user object could be marked as deleted instead of delete it physically. But I think it is a bad design to use an object, that is marked as delet...
Hi, how do I display the progress in a jProgressBar when I write something in the database? Thanks ...
The Idea is to have a tagging system between Users and Content(images, videos, posts) Kind of like the tagging system here on SO with questions. I like the achievements system on SO, meaning that after a certain amount of points a user can start making his/her own tags. Same Idea for my system My current table design looks like Tag ...