Hi all, I want to show datagrid content (rows,columns) in XPS document.I have 20 columns. When i sent datagrid to XPS with XPSDocumentWriter.Write method ,it just show some columns not all of them.How can i show all columns and rows in xps(like Xceed datagrid xps exporting) Thx ...
We are currently in the process of solidifying a database change management process. We run MySql 5 running on RedHat 5. I have selected LiquiBase as the tool because it's open source and allows us to expand its functionality later if needed. It also seems to be one of the few free projects that are still active. Has anyone here had any ...
I have a database table containing a queue of work items processed concurrently by multiple readers, with these requirements: Each item should be processed by one reader only. If a reader fails for any reason, the item should be returned to the queue for another reader to process. Here is the pseudo code of a possible solution, each ...
I have a web app that have many tables (each represents a POJO). I wrote mapping files for each class and then use Hibernate's SchemaExport to generate the tables in my database. Now I want to create 2 additional tables for each existing table that was created: User permission table - stores user permissions on the POJO specific to ea...
Hello, I am not sure if this is possible in mySQL. Here are my tables:- Categories table - id - name - parent_id (which points to Categories.id) I use the above table to map all the categories and sub-categories. Products table - id - name - category_id The category_id in the Products table points to the sub-category id in which it ...
I had a revelation a couple of years ago when optimizing a database table that was running slow. The original query would take around 20 minutes in a table with large data-fields. After finally realizing that noone had bothered to index the table in the first place I built an index for a couple of the keys. Lo and behold, the query ran i...
Note: This is not for unit testing or integration testing. This is for when the application is running. I am working on a system which communicates to multiple back end systems, which can be grouped into three types Relational database SOAP or WCF service File system (network share) Due to the environment this will run in, the...
Hello all, I have to collect statisctics by days, weeks, months and years of user activity for a site. I am the DB design stage and I wanted to do this stage properly since it will make my coding life easier. What I have to do is just simply increment the values in the fields by 1 in the DB each time an activity happens. So then I can ...
Im currently creating a webportal with ASP.NET which relies heavily on database usage. Basically, every (well almost every :P ) GET query from any user will result in a query to the database from the webserver. Now, I'm really new at this, and I'm very concerned about performance. Due to my lack of experience in this area, I don't reall...
I will be storing a year in a MySQL table: Is it better to store this as a smallint or varchar? I figure that since it's not a full date, that the date format shouldn't be an answer but I'll include that as well. Smallint? varchar(4)? date? something else? Examples: 2008 1992 2053 ...
So I'm just confused here. I've got to migrate my database from MySQL to MS SQL Server 2008. I've transferred the data via the "MS SQL Data Wizard" app from SQL Maestros. It took the data+structure from my MySQL database "gk" and copied it into a database "gk" on my MS SQL Express instance. But when I connect to the MS SQL instance a...
Can I create tables in two databases using db:create? For example, can I have entries in database.yml for one_development and two_development and have both get created by rake db:create? I know rake db:create:all works -- I am just wondering if there is a way to segment what is created depending on the RAILS_ENV? ...
I have two identical servers with SQL Server 2005 and my application. Hard requirements: I must be able to update data at either server. I must be able to unplug either server without having to reconfigure anything in the database. When a server is plugged back in, it must automatically sync up with the other server. Notes: I pref...
Anyone know of an API (php preferable but I'd be interested in any language) for creating wiki-like data storage? How about any resources on rolling your own plaintext wiki? How do other plaintext wikis handle the format of the text file? I understand I can use Markdown or Textile for the formatting. But what I'm most interested in i...
What are your experiences using Amazons EBS snapshot features for MySql hot backups. I have a database running a batch processing job in ec2. I backup with EBS snapshot. So far the backups looks consistent. But I am afraid they "will stop being consistent as soon as I stop checking" (Uncertainty principle). What are your experiences wi...
Hi, yesterday I found out that setting a database on auto growth is not a very good thing. Are there other basic 'bad' practices (or best practices) when having SQL Server databases in production? thx, Lieven Cardoen ...
I have designed a database for an application which contains user settings. This database will come preloaded with several system user settings. These may change from version to version. How should I deal with updating these settings? The solutions I came up with: Apply a boolean 'system' field to the settings tables and replace all s...
Hello. I have n regexes. On input a string i have to find all the regexes that this string matches against. This is normally an O(n) operation: SELECT regex FROM regexes WHERE 'string' RLIKE regex Now I wonder, what's the fastest way to do this ? Are there database, structures or storage systems that are optimized to do such an operat...
I'd be grateful for any advice that anyone has regarding: How you you effectively store a gps (or any floating point number) in a varchar field that can be indexed. Background: We develop a content management system that can effectively store files of any type together with a collection of metadata. This file/metadata is stored as ...
Hey, I have two tables: CREATE TABLE `Car` ( `car_id` int(11) NOT NULL AUTO_INCREMENT, `car_name` varchar(25), PRIMARY KEY(`car_id`) ) ENGINE=INNODB; CREATE TABLE `Tire` ( `tire_id` int(11) NOT NULL AUTO_INCREMENT, `tire_size` int(11), `car_id_FK` int(11) NOT NULL DEFAULT '0', PRIMARY KEY(`tire_id`), CONSTRAINT `R...