I am using PHP to create a process that monitors our database and puts up a maintenance page on our website if the database is down. I'm using PDO and Oracle. I am trying to use one database connection and query it once a minute, alerting people if there's a problem. However, if the database goes down, the script waits 15 minutes befo...
I have lot of objects, each can have many different kind of attributes. a lot of the attributes overlap, for example, many objects have the attribute "name". Since there are many type of objects, if there is a table constructed for each set of objects with same set of attributes, it will take lot of tables. Currently I'm using a mysql, ...
(This doesn't look like a programming question but it might boil down to a programming question.) I'm using MS Access 2007 to view tables in a database (through an *.adp file) that lies on SQL Server 2000 and SQL Server 2005. I use the Copy Database task in MS SQL Server Management Studio to copy the data from SQL Server 2000 (the "liv...
On DBD::SQLite of SQLite3 If I am going to query a SELECT only once. Should I CREATE a INDEX first and then query the SELECT or just query the SELECT without an INDEX, which is faster ? If need to be specified, the col. to be index on is a INTEGER of undef or 1, just these 2 possibilities. ...
Is there any limit on number of tables to be used to create a view? If there is a limit,then maximum how many no of tables we can use to create a view? ...
Here is my code - i am simply checking my MySQL database connection. But first i have compiled and run the program successfully. but then i have commented the line Class.forName . Still when i compile it runs successfully, without any error.Why? import java.sql.Connection; import java.sql.DriverManager; public class FirstJbdc { pu...
This is something I would like to see while doing my day today programming works, But I've never seen such application yet. You input is highly appreciated. Lets say we have an application that needs MSSQL server as DBMS. And suppose you just need to install it and do something. (i.e You are not going to deply it in production servers e...
I have a table with 8 million records that looks like this: CREATE TABLE `bdp_dosis` ( `ID_INSTITUTION` varchar(4) NOT NULL default '', `ID_SERVICE` char(2) NOT NULL default '', `SECUENCIAL` char(3) NOT NULL default '', `TYPE` char(1) NOT NULL default '', `DATE_LECTURA` varchar(8) NOT NULL default '', `ID_TARJETA` varchar(9)...
We are in the process of developing a client-server software (in C#, Net 2.0)which can be sold off the shelf. The product is in Medical domain. Can anyone suggest the best possible database for the following conditions: Should be able to distribute it free to the customers. Customers should be able to add images too to the database. S...
Greetings fellow overflowers, After reading on MSDN about correct strategies on how to perform database replication, and understanding their suggestion on Master-Subordinate Incremental Replication. It left me wondering, what OOD design pattern should I use on this... The main elements of this strategy are the Acquirer, the Manipulator...
i am currently working on recommendation systems especially for audio files.but i am a beginner at this subject.i am trying to design database first with mysql but i cant decide how to do it.İt is basicly a system which users create profile then search for the music and system recommend them music similar to they liked. which database ...
I have this programming task due in about 15 days and I've decided to make a sort of shopping cart/web sales thing. I'll have a Database with Products, Prices, Images, etc. I was thinking of having another Database with processed orders, etc. Should I just make a combination that works (make a single Database) or should I use Separate...
hello all friends.......... I create a form inside the Dll. But it compile is not successfully.Some Error below. " Access violation at address 004EB784 in module 'Project1dll.dll'.Read of address 00000048" Thanks..... ...
Hi, is it possible to write Django apps, for example for internal/personal use with existing databases, without having the 'overhead' of Djangos own tables that are usually installed when starting a project ? I would like to use existing tables via models, but not have all the other stuff that is surely useful on normal webpages. The rea...
Is there any way to make a PDO object throw an error if a query takes too long? I have tried PDO::ATTR_TIMEOUT to no effect. I'd like a way to have a query throw an error if it is running for longer than a certain amount of time. This is not something that I can do in the database, ie, no maintenance jobs running on the db or anything...
Hi Gurus, I have a design/programming question. First I wanna ask if my design is good and then I wanna know how to. What I wanna do is to have an i18n page, which may or may not have a translation. e.g. Page A has English & Japanese, and Page B may only have English This is the DB layout page ---- id int topic varchar(128) content v...
I have to give presentations to end-users about technical topics and one of the questions I have occasionally been asked is why I use a cylinder icon to represent a database. I don't have a good answer for this except that this is the way databases are usually represented in technical literature and, since I'm not an artist, I haven't be...
I have 2 schemas in a database about the same application (Different versions) I want to generate a Delta script with the differences It exists some tool that helps me (Open source solution should be perfect) Thank you ...
I have installed a sample database, specifically Northwind from http://msdn.microsoft.com/en-us/library/8b6y4c7s.aspx. After installing the .msi file, I dont see any Northwind database in my local sql express server when using SQL Server management studio. Am i missing a step? Do i have to run some script? ...
If I have Model.objects.all() I want to get only one object for any content_object=foo, object_id=N. How can I do that? Say I am ordering by -datetime. If I can get only one object in the queryset for any content_type=foo, object_id=N ... it should be the latest.. How to specify that I only want 1 object for any combination of cont...