In general, which is more expensive? A double-nested for loop and one call to a database or a call to a database for each of N items in only one for loop? Not looking for an answer down to microseconds, just a general idea of which direction I should take. TIA. ...
I have been trying to learn a cross platform language with a fast learning curve, and so it seemed obvious Python was the logical choice. I've never programmed before but I have been reading on pragmatic programming and agile development for quite some time. The question comes, "What is the single best choice to create a desktop softwa...
I am not able to make a clear decision on this one. I am OK by having numeric values on my tables and have the value information on the description of the column on the database for DBA. But I also don't want to come to a point in future where having these numeric values on database creating too much headache for maintenance. I'm not...
hi, im trying to update all records in a sql table using the following code but no data is updated. does anyone know why? using (DataContext db = new DataContext()) { foreach (Item record in db.Items) { record.Description += "bla"; db.SubmitChanges(); } ...
Hello, I'm working on a shopping cart and my problem is, how should I design database for size selection for products? Tshirts can be "XL, L, M, S" etc. and shoes can be "36,37,38,39...blabla" Should I do just one size table or many tables for several types (tshirt, shoes etc.)? Thanks in advance... ...
I have a field of type image in my database which is mapped as binary in my model (ADO.NET Entity Framework). But somehow the image that I get from the input file box is not being passed to the object. I know this because I debuged my action and the object Language (the image I trying to upload to the database is a flag) has the propert...
I've been building out an SCM environment (that has to be PCI compliant, but that's tangential to this issue). I've got to the point where I want to automate database updates, but I'm not 100% sure that's the best way forward. Say I want to add a field to a DB table. Easy enough to add it to the dev environment, but what about rolling ...
Hi guys, I have a little DB challenge for you. Hopefully you can help. The Problem: I need a solution that will allows me to "handle" changes to primary keys/ composite keys. By "handle", I mean I should still be able to perform CRUD operations with little or no code changes. It needs to have minimum hassle from an application/ databa...
I'm pretty new into asp.net, and currently I have the need for storing various information in a database. Since I have used the standard Login control in asp.net, I already have the ASPNETDB database in my application. My question is: Is it good practice to use this database for other things than user and role information? Regards, Ca...
I've got a data source in Visual Studio. Is there any way to view the SQL that it generates before it sends it to the database? I don't just want to see the SelectComand, InsertCommand properties which are part of the asp:SqlDataSource, I want to see the query once the parameters have been filled. Is it possible to do this from Visual St...
Hi All, I need to point a tech team in the right direction to investigate a very short term interim solutiuon for an online XML authoring database. The idea would be to set up something which does not require us to commission a server Multiple users need to interact with any of the database records remotely from multiple locations A s...
In a reusable application (in which i don't want to change any code) i would like to change a SETTING var that the application uses (in its forms and maybe other parts) to be dynamic (update its contents from a db table). What would be the best approach to do that (a middleware maybe?) ? ...
I am trying to work out through the sample code that comes with Fast Track to MDX. ...
I frequently create nonparametric statistics (loess, kernel densities, etc) on data I pull out of a relational database. To make data management easier I would like to store R output back inside my DB. This is easy with simple data frames of numbers or text, but I have not figured out how to store R objects back in my relational database...
I'm attempting to merge multiple SQL Server databases into one. The problem is that one of the tables has an identity field as the primary key. The table also has two uniqueid fields. Something like: datatable: id pk identity link1 uniqueid link2 uniqueid My initial thought was to run the following script: declare @maxId as int set @...
I'm running some bizarre Postgres migration code from OpenCongress and I'm getting this error: RuntimeError: ERROR C25001 MVACUUM cannot run inside a transaction block Fxact.c L2649 RPreventTransactionChain: VACUUM FULL ANALYZE; So I'd like to try running it without getting wrapped by a transaction. ...
Is it possible to access a Pervasive 8 (not Pervasive SQL) database from python? ...
I'm looking at a database diagram generated by MySQL Workbench (actually, DBDesigner4), but I'm not familiar with it so I couldn't figure out some of the symbols it uses for relationships and fields. Does anyone know a good legend? ...
Is there a Hibernate configuration (hopefully an annotation on a classes mapped @Column field) that would let me sort a collection of entities associated with the loaded entity by a given column of that entity when a session.load(Entity.class, Id) is called? For example if I had an EntityA that contained a OneToMany association to an En...
Hi, How to get start date and end dates in a query from database. Thanks, Lico ...