We have a set of applications that work with multiple database engines including Sql Server and Access. The schemas for each are maintained separately and are not stored in text form making source control difficult. We are interested in moving to a system where the schema is stored in some text-based format (such as XML or YAML) with d...
I am about to alter the several tables in a massive system which I probably only understand around 10%. I want to add three columns. One of these is just a rename of an existing column. Part of me wants to :- Rename the column but worried about the impact on unknown parts of the system that use the old name. Append the three columns...
I want a strongly-typed DataSet along with designer TableAdapters, but Visual Studio's DataSet designer generates provider-specific (e.g. SQL Server vs. MySql) code and I don't want to commit to just one provider. An ORM would help, but: Entity Framework is 3.5 only and doesn't play nice with DataSets, and NHibernate doesn't support S...
I'm looking for a command line tool to generate DDL for both tables and indexes (nothing more complicated is needed) for some sybase tables in databases I take care of. I have access to gui tools for viewing at individual DDLs, and I could cut and paste them, but I want something that will go through all the tables in a datbase and gene...
I need ideas to implement a (really) high performance in-memory Database/Storage Mechanism. In the range of storing 20,000+ objects, with each object updated every 5 or so seconds. I would like a FOSS solution. What is my best option? What are your experiences? I am working primarily in Java, but I need the datastore to have good perf...
connectionString="AttachDbFilename=C:\Documents and Settings\nmartin\My Documents\PS_Upload\TimeTrack\src\TimeTracker\TimeTrack\App_Data\ASPNETDB.MDF;Integrated Security=True; User Instance=True" providerName="System.Data.SqlClient" /> This is the connection string that is provided to me from the Server Explorer for my local MDF f...
Hello, In Microsoft SQL I can use the GETDATE() function as the default value for a DATETIME field. I'd like to be able to do the same kind of thing for a date field in an ArcGIS geodatabase. Is this possible, or am I limited to literal values? My geodatabase is using ArcSDE 9.1. The Feature Class with the defining attributes is versio...
Folks, Assume you receive a disconnected backup of a SQL Server database (2005 or 2008) and you restore that to your SQL Server instance. Is there a way, is there a system catalog or something, to find out when the last write operation occured on that particular database? I'd like to be able to find out what day a particular database ...
I am designing a table in the database which will store log entries from the application. There are a few things which is making me think about this design more than usual. However these log entries will be used at runtime by the system to make decisions so they need to be relatively fast to access. They also have the problem is that ...
Hello, in work we have big database with unique indexes instead of primary keys and all works fine. I`m designing new database for new project and I have a dilema: in DB theory, primary key is fundamental element,it`s OK... but in REAL projects what are adventages and disadventages of both? what do you use in projects? EDIT:...and w...
This is a problem that I come to on occasion and have yet to work out an answer that I'm happy with. I'm looking for a build system that works well for building a database - that is running all of the SQL files in the correct database instance as the correct user and in the correct order, and handling dependencies and the like properly. ...
Is there any performance issue in using SELECT * rather than SELECT FiledName, FiledName2 ... ? ...
Would 2 tier be a valid choice for this scenario: sql server database the business would never require more than a couple of hundred simultaneous connections to the shared database over a LAN the fact that (I believe) it is a lot less effort to develop a 2 tier application Client program updates automated over the LAN ...
I am building a web app targeting the iPhone. It is similar to a To Do list. I need the application to be able to work offline, i.e., it should allow the user to add/edit/delete entries when there is no connection to the server, which will later get synced when the server is online again. How do you recommend I store this data (remember...
I have the following table: ratings: ID | post_id | rating_type The rating_type field is either 'thumb-up' or 'thumb-down'. I want to get a result set telling me what the highest rated posts are. The following query gives me a result set with the number of up votes for each unique post_id. SELECT COUNT(post_id) as number_up, post_...
I have to be specific for this to make sense. In my application I have a model called theme which contains widget color theme information. We provide a few themes, but mainly rely on the user to create their own themes. So the question is: where do I store my themes? If I store them in the theme database, then anytime I switch databas...
What is the database concept equivalent to "when deleting the user, delete all his posts"? And is this a good thing? Another example: if your website is a programming forum, you need to find and delete comments related to that topic before deleting the topic. Should this be handled automatically in the database layer? ...
Simple question. I'm considering Firebird and SQLite for an upcoming project. SQLite has SQLite Administrator, which is pretty good but gets +1M because it has autocomplete. But Firebird supports FKs, so I'm more comfortable with it. I'm leaning toward Firebird right now. What is your favorite Firebird IDE and why? Edit: Personally, ...
The JDBC 3.0 spec talks about Connection (and Prepared Statement) pooling. We have several standalone Java programs (i.e. we are not using an application server) that have been using DBCP to provide connection pooling. Should we continue to use DBCP, or can we take advantage of the JDBC-provided pooling and get rid of DBCP? We are usi...
How would I go about creating multiple database tables at runtime that utilize the same model given that rails wants to infer the table name from the model name? I want to be able to create a new object based on a model, then create a new table with a unique name that the object will reference. Does anyone have any examples or advice t...