In my fictional database, I have several columns of data. In designing a PHP front-end to the script, it was necessary to allow the user to modify all attributes of a tuple if necessary. If the end-user only ends up modifying one attribute instead of all of them, the following statement: UPDATE foo SET name='bar' location='YYZ' dri...
what is the way to avoid the redundancy in the listview when the items are added to it.. im using winforms c#.net.. i mean how can i compare between the items in listview1 and items in listview2 so that while adding the items from one listview to another it could not enter the items that are already entered in the target listview.. im ab...
Hi guys , I'm getting my feet wet with developing my order management applications for integration with google apps. However there are certain aspects I need to take into consideration prior to proceeding any further. My application is such that it would upload documents to google documents and store contacts in google contacts. It requ...
In my project i have a lot of css styles. Some of them are never used (not anymore). I check this manually with eclipse: i select text and then with "Search -> Text -> Project" i can find, if this style occurs only in the stylesheet or also in java files. Is there better way to check, which styles are currently used in my GWT project? e...
I'm profiling an app that has a boat load of functions in many files and I'm trying to isolate functions that don't get called ever. Any ideas before I proceed? ...
The entities to be stored have 25+ properties (table columns). The entities are pretty diverse, meaning that, most of the columns are empty. On average, I'd say, less than 20% (<5) properties have a value in any particular item. So, I have a lot of redundant empty columns for most of the table rows. Almost all of the columns are decimal ...
Hey guys, I just noticed I get a lot of redondant code from one class to another in my project (like menus or buttons) ;) Is there any way to optimize it ? Thank you ! Gotye. ...
This is a question about coding style and recommended practices: As explained in the answers to the question unnecessary to put super() in constructor?, if you write a constructor for a class that is supposed to use the default (no-arg) constructor from the superclass, you may call super() at the beginning of your constructor: public M...
I am interfacing an embedded device with a camera module that returns a single jpeg compressed frame each time I trigger it. I would like to take three successive shots (approx 1 frame per 1/4 second) and further compress the images into a single file. The assumption here is that there is a lot of temporal redundancy, therefore lots of ...
An example for the sake of the question: I have a database which contains users, questions, and answers. Each user has a score which can be calculated using the data from the questions and answers tables. Therefore if I had a score field in the users table, it would be redundant. However, if I don't use a score field, then calculating th...
So, in Python (though I think it can be applied to many languages), I find myself with something like this quite often: the_input = raw_input("what to print?\n") while the_input != "quit": print the_input the_input = raw_input("what to print?\n") Maybe I'm being too picky, but I don't like how the line the_input = raw_input("w...
For my next app, users will likely have a number of 'points' which changes constantly. For example, a user might accrue a number of points for performing a task, have points taken away, or have points donated to them. I'm wondering whether to store that value and update it constantly in addition to a 'history' table (which would contain...
Suppose I want to create a (stateless) WCF service with three methods exposed on an endpoint: performSqlOperationA(), performSqlOperationB(), and performSqlOperationC(). Each method inserts data into a SQL database. The way I've seen things done at my office, each method would begin with code to initialize a SqlConnection object. Each...
I came across this code in some existing codebase: double rad = ComputeCurviness(); double off = Math.Abs(rad); if (rad < 0) off = -off; It seems to be basically just making off equal to rad. The variables are used interchangeably later in the code. Is there any reason to leave this code in? ...
I had a pretty big equation that I needed to use to solve for a given variable. So I used an online tool that was capable of rewriting an equation in terms of a given variable. It gave me some huge 700 character equation. I tested it, and it does work. I can see some pretty obvious redundancies in the equation where it's recomputing a v...
Following join is supposed to retrieve user info along with their messages for users with a certain status: SELECT * FROM user, message WHERE message.user_id=user.id AND user.status=1 The problem is that all rows about a certain user in the result set contain redundant columns that repeat the same data about that user (those fields re...
Hello, Do you guys by any chance know of a tool for visual studio that can scan the entire application and find code duplication? I have to clean up a medium sized asp.net c# application and I am using "Find and Replace" but it is really tedious work. I was wondering if there was a utility or VS plug-in that could automate this process...
I love Ruby, for past couple of years it is my language of choice. But even since I started learning it, I was repelled with the fact that so often there are several ways to do the same (or equivalent) thing. I'll give couple of examples: methods often have aliases, so you always have to bother to choose the most adequate, popular or ...
Is there any difference between those three declarations? var x; var y:Object; var z:*; Is there anything in AS that's not an Object? ...
I am planning a fairly large web deployment with geo-redundancy capability. This is not just clustering a number of servers in a same server room. Some points to consider Load sharing among multiple sites Traffic distribution based on user geographic location (e.g. west coast users only access servers in west coast, etc.) Traffic (auto...