Hi All - I am working on an application where I need to connect N number of database systems [N ranges any where between 1 to 350]. The idea is - the user will be presented with a list of databases and will be asked to select any or all of the databases from the list. Once the databases are selected, I need to connect to each of the ...
I´m looking for one tool capable to analyse an existing db model (an Oracle schema in my setup) building a report with quality metrics, potential causes of problems (circular constraints, for example), etc. We have this kind of features for Java code using tools like PMD or checkstyle. Does anyone know about some tool like this for d...
Hello All, I'm wondering how safe or if it's even possible to have a website pull data from a Oracle database on a remote server? What and how big are the security issues with this? Thanks, Dane ...
I use this dynamic LINQ library together with Linq-to-Entities. I build query and after that iterate it with foreach(object e in query){} query=db.Table1.Where("it.FieldA>10").Select("it.FieldB"); works. query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key") works. But query=db.Table1.Where("it.FieldA>10").Grou...
We are currently using a summary table that aggregates information for our users on an hourly basis in UTC time. The problem we are having is that this table is becoming too large and slowing our system down immensely. We have done all the tuning techniques recommended for PostgreSQL and we are still experiencing slowness. Our idea ...
I try updating my database after updating the dataset, but evenafter calling the data adapter's update function the underlying database doesn't change. I used SqlCommandBuilder and it still wouldn't update. Once I have the GUI open I can submit and search for values in my dataset but once I close it then re run it, all the changes are go...
what is collation usage for database ? well for html utf-8 i know a bit, like for displaying other language type. but whats for in database ? im useing latin-1 ( default ), my friends told me that to use utf insted, when i ask why, they just dont know and said, others use it. so im questioning what does collation reall...
Hey what i m doing i have to send requests to yahoo for picking up the stock rates. The companies name which i need to send are in an array n i have also coded to send only 100 companies request but what happens is the requests are sending all at a time and since it doesnt wait for the response i get response only for the first 100. how ...
Does Postgresql and Mysql use different SQL:s? I have a book, Head First SQL. If they are different, how do I know which database SQL it is? ...
Which one is better for (mysql) performance ? "1500 (300x5) Tables with 365 rows per table" OR "(300x5)1500x365 rows in 1 table" ? (I will get the data(s) with php.) 365 -> days number of the year if second: I will use "date" and "x_id" to get the 1 row from (300x5)1500x365 rows. if first: I will use "date" and "table_name" to get 1...
Hello, I have a little exercise. I need to load data from the DB (XML file) into a dataset or something else, and use queries. what is the simplest way to do it? I want to use a Dataset GUI to make a queries. thanks, Dani. ...
What is the most flexible design for a table of physical addresses in some variety of SQL? I assume there is something better than { street address, building address, city, state/province/region, country, zipcode }. Also are there standard names for various components of addresses, especially international standard names? Further, wha...
Hi, I have some doubts about SQLite... My app uses only one table (encapsulated in a data logic class) to store small data, the connection is opened in didFinishLaunchingWithOptions and finalized in applicationWillTerminate (yes, I know that in iOS4 applicationWillTerminate is only called by iSO if necessary, but I write on database at e...
I will design my mysql tables/columns using "multiple column index". I've checked some articles about "multiple column index". But I can't find information about the option "between" with "multiple column index". http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html http://www.mysqlfaqs.net/mysql-faqs/Indexes/When-does-m...
I'm struggling with doing this, I want to basically do a database deleteAll where one field is equal to something and another field must NOT be equal to something.. its for deleting duplicate rows so I want to delete all but one row.. the way I tried below isn't working, I Would appreciate any advice: $conditions = array ( "Prox.prox...
I Hope someone can clarify and help. I've moved to creating/using schemas in Sql Server 2005, where I've also created database roles and assigned schemas to the roles. The problem I have is one of the db roles I have should have full access - say SuperSysRole. However, when I assign a login to that role, it cannot execute specific comma...
I wish to have a foreign key in a table but I have no idea how to do it. I wish have a UserID Column in the "wall" table so that I can link back and get the userid's details etc. How would i go about doing this? Wall Table: Users Table: ...
Having trouble inserting new records into a table. Anybody care to help? <?php include('config.php'); ?> <?php if(!empty($_POST['forename']) && !empty($_POST['surname']) && !empty($_POST['email']) && !empty($_POST['emailconfirm']) && !empty($_POST['password'])) { if($_POST['email'] == $_POST['emailconfirm']) { $forename = ...
Hi there, I'm on Rails 3,and I have a SQL query composed of a few joins that I've built up in Arel. I want to run this query from a method in one of my models, but I'm not sure of how to do this. The arel object turns out to be of type Arel::InnerJoin, and I want to retrieve an array of all objects returned from that query. Do I run Mod...
I've got a form that allows the user to edit an employees information: name, email, technician level, etc. Well this is not hard in itself, I'm trying to find a good method for updating phone numbers for each employee. I have two tables (that are relevant): technicians and phones. My form allows the user to add, remove and edit any amoun...