The good old Relational Database Management System (RDBMS) has been around for quite some time now and is still, certainly in my opinion, the mainstay of the majority of production platforms/software applications. Recently there seems to be a great deal of hype in the community regarding relatively young database technologies such as Cl...
I've read that (all things equal) PHP is typically faster than MySQL at arirthmetic and string manipulation operations. This being the case, where does one draw the line between what one asks the database to do versus what is done by the web server(s)? We use stored procedures exclusively as our data-access layer. My unwritten rule ha...
When should I be using stored procedures instead of just writing the logic directly in my application? I'd like to reap the benefits of stored procedures, but I'd also like to not have my application logic spread out over the database and the application. Are there any rules of thumb that you can think of in reference to this? ...
What is the recommended way of joining SQL Server database tables located on databases which are on different servers? All databases will be on the same network. ...
Hello , I use this code and SQLite says "Data Source cannot be empty. Use :memory: to open an in-memory database" here is my code string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\m23.db"; string sql; DateTime dt = DateTime.Now; SQLiteCon...
How do I show a table's foreign key's in TimesTen? ...
I'm having trouble with an Oracle update. The call to ExecuteNonQuery hangs indefinitely. The code: using (OracleCommand cmd = new OracleCommand(dbData.SqlCommandStr, conn)) { foreach (string colName in dbData.Values.Keys) cmd.Parameters.Add(colName, dbData.Values[colName]); cmd.CommandTimeout = txTimeout; int nRo...
Hello! I am trying to list data types from Microsoft Access 2000-2007 (depending on the MS Access database version) in a combobox for a C# program. I want my program to be capable of opening MS Access 2000-2007 databases. If I open a MS Access 2003 I wish my program to be capable of using the datatypes of any data specific to MS Access 2...
What should be the C# code to find all the Database Servers connected in a network(including instance-name, port no, and IP address)? ...
Here's an obfuscated version of something I've been trying to do at work. Say I have been given this month's data for customers in my shop - how much they've spent split by the food type: CUSTOMER FOOD_TYPE FOOD_TYPE_VALUE 1 SWEET 52.6 1 SAVOURY 31.0 1 DAIRY 45.8 1 ...
Preface: I am new to django and to db design. SUPEREDIT: I made some significant changes, so the answers before my changes may reference things not here. I apologize. I'll get right to the code: models.py: class Player(models.Model): name = models.CharField() class Team(models.Model): name = models.CharField() members = m...
What's the best way to automatically deploy changes to a database driven web application? Is there a single product out there that can modify the following... Website (dlls, aspx, css files etc) Database Schema (add tables, columns, etc) Database data (modify table contents) Reporting Services reports I've seen various separate prod...
Hello! Like youtube, i have a usertable, a table with objects (videos) and a table with categories. Now, I want a user to be able to subscribe to a category, but how do I do this effectivly? I would need a table for keeping track of which categories a user subscibes to (many-to-many relationship), but I also need to keep track of which...
Hi. I'm pretty new to SQL world. Here are my questions: What are the benefits of stored procedured over normal SQL statement in applications? Does stored procedure help eliminates SQL injection? In Microsoft SQL Server it is called stored procedure. How about in Oracle, MySQL, DB2, etc.? Thanks for your explanation. ...
How can I cache a Reference Property in Google App Engine? For example, let's say I have the following models: class Many(db.Model): few = db.ReferenceProperty(Few) class Few(db.Model): year = db.IntegerProperty() Then I create many Many's that point to only one Few: one_few = Few.get_or_insert(year=2009) Many.get_or_inser...
Okay so I split my access database, and now I have a backend: If I started a brand new table, a brand new query, and a brand form for a different purpose within the db_be.mdb would it appear in the connect "front end" db as I saved it in the backend, or do I have to import it up? If I do have to import the above, the how do I make th...
Many years ago, I was asked during a phone interview to delete duplicate rows in a database. After giving several solutions that do work, I was eventually told the restrictions are: Assume table has one VARCHAR column Cannot use rowid Cannot use temporary tables The interviewer refused to give me the answer. I've been stumped ever...
I am abit curious about dbml.... Should I create one dbml file for one database or separated into different parts e.g. User dbml (only tables relate to users) etc? When I do this I will have abit of problems. Assume the User dbml has a User table and if the Order dbml has a User table as well, this won't be allowed if the entity namespac...
Is this like an "embedded" database of sorts? A file containing a built in database? ...
Does Clustered index needs one extra table to sort/keep the rows data? When it does the sorting , on each Insert or delete statement or when ? How clustered index store data and how it is different from Non-clustered one. ...