I'm working on early designs for an application that needs to start out small but be highly scalable. I'm particularly worried about the user database, which in this case will have a high INSERT and UPDATE load, and is unlikely to survive long on a single master. (Although my question isn't tied to any particular RDBMS, for the record, ...
I have a question about IPTC metadata. Is it possible to search images that aren't in a database by their IPTC metadata (keywords) and show them and how would I go about doing this? I just need a basic idea. I know there is the iptcparse() function for PHP. I have already written a function to grab the image name, location, and exten...
Hello. Can I avoid instantiate a Db object inside of Names object to access it anyways? Would __autoload work for that? Is there another smart solution? I have following classes (They are conceptual so they won't work if executed): Db { function connect($config) { // connect to data base } function query($query) { ...
Hi all, I need to call database function within in qt application. But, it fails with below error; QOCIResult::exec: unable to execute statement: ORA-06576: not a valid function or procedure name DB: Oracle Driver: QOCI The Function returns record table. C++ code: QString qs = "CALL func()"; QSqlQuery query; query.exec(qs); // thi...
When I execute a query from my application (Java JDBC), it is returning the row with seq 83 first. But I want the row with seq 84. seq | dtCreated | 84 | 2009-09-14 16:16:23 | 83 | 2009-09-14 16:16:23 | 82 | 2009-09-14 16:15:01 | Is this query correct ? I'm interpreting this to mean that if there are ties in dtCre...
I have kind of a such scenario: Here i need to synchronize local server database with main DB server(example: computers in office are connected to office server and they use it like a local server, so that no sync is required.BUT computers in other office work with their local server too and we need synchronization between the offices...
Hi Guys, I am just learning prolog. I have a task ahead. I have to insert some data in to a database like mysql or MSSQL using Prolog ODBC INterface. I know there are some example predicates(SWI-PROLOG) like open_wordnet :- odbc_connect('WordNet', _, [ user(jan), password(xxx), ...
I want to create a project in which it is required to synchronize local database with remote database. Changes made in local database must be reflected to remote database. This must be done synchronously. I have application which does CRUD operations on local database written in java/jpa. Synchronization should be triggered from java cod...
I need to run a Windows Forms application (C#) in a client and the database on the other. I want the user to select the database (SQL Server 2005) manually in the program. In case of that the database can be changed from one PC to other. I need to avoid the computer name or IP number in the connection string or something helpful. How ...
Hello! I'm implementing a web - based application using silverlight with an SQL Server DB on the back end for all the data that the application will display. I want to ensure that the application can be easily scalable and I feel the direction to go in with this is to make the database loosely coupled and not to tie everything up with f...
I need a lightweight database engine for a desktop application. The application is not data centric, although it needs some persistent data. Which one would you use MS SQL Server express edition or SQLite? EDIT Is SQL Server Compact edition free? If it is the case, what about SQLite vs SQL Server Compact edition to develop this kind of...
I need a excel-like grid control in MFC, do anyone have good suggestion to implement that ?] with the control i can filter the data by clicking on the header, then it will display distinct data of current column for selection. Thanks! ...
I have two tables defined below. Create table tickets (id long not null, reseller long not null, constraint pk_lock primary key (id)); Create table ticketRegistrations (id long not null, customer long not null, constraint fkTicketRegistrationTicket foreign key (id) references tickets (id) on update cascade); The client can input ...
Hi, For a few different reasons one of my projects is hosted on a shared hosting server and developed in asp.Net/C# with access databases (Not a choice so don't laugh at this limitation, it's not from me). Most of my queries are on the last few records of the databases they are querying. My question is in 2 parts: 1- Is the order of ...
I'm using rails 2.3.4 When I execute rake db:test:prepare the id field created is not a primary key and auto-incremented. When I look at the development db no problem with the primary keys. Using MySQL. Edit: It looks like my schema.rb file was changed :id => false should be true. What generates this file? DB Migrations? [EDIT] What...
Hi, this is my first question on SO, am really posting this out of desperation after searching around a lot for an answer and trying a few different things with no success. I have an Access database where I have recently migrated the tables to SQL 2005, Access continues to function to the users as a front-end providing forms, reports, ...
I am using hibernate 3.2.2 in my application. For connection pooling, we are using c3p0 0.9.1. I am using Generic DAO Pattern and Open Session in View pattern to do database operation. We are working on new website of existing website. Right now, the no of visits is half million page visit in existing application. I am confused with t...
Hi everyone, I was wondering about the Google Analytics database design, how they handle the huge values in hourly basis, even in minutes. Let's say, they have 100 million users and almost every user has 300 counters at every minute. For one user, 300 counters have 18000 rows in one hour. For one day it is 432K rows and almost 3 millio...
I am looking for a free/opensource relational database to use on a commercial asp.net 3.5 project. Any recommendations? ...
Hello: I am building a Tcl application that reads off of a Sqlite Db. Currently, I can enter data into the database using the Tcl frontend. Now, I am trying to figure out how to display the data within the Sqlite Db from the Tcl frontend. After a little bit of research, I found that the treeview widget would work well for my needs. ...