I have a internet application that supports offline mode where users might create data that will be synchronized with the server when the user comes back online. So because of this I'm using UUID's for identity in my database so the disconnected clients can generate new objects without fear of using an ID used by another client, etc. H...
Please do suggest an embedded database with row locking feature for c# ? ...
Do you know of any websites, that have animations to explain topics and concepts like Databases, in a simple manner, especially for non-programmers? Something like this animated intro to Adobe Flex. Notice the clarity with which animations can explain new topics. ...
right now, i need to load huge data from database into a vector, but when i loaded 38000 rows of data, the program throw out OutOfMemoryError exception. What can i do to handle this ? I think there may be some memory leak in my program, good methods to detect it ?thanks ...
I'm working on versioning our database and now searching for a way to drop all stored procedures and functions from a C# Console Application. I'd rather not create a stored procedure that drops all stored procedures and functions. I has to be some sql executed from C#. I tried to drop the stored procedure before creating it, but I get t...
As mentioned I write a lot of proposals to reply to government RFP's. No matter what the RFP is about most require the same information. It is always narrative, charts, graphs, photos, tables, organizational charts, etc. To save time cutting and pasting and searching old proposals I was wondering if it is possible to create a database...
Hi I am inserting jpeg images into my UTF-8 encoded Postgres database into bytea column/s. I'm using a prepared sql statement to insert the images. In the statement I create a file object, within Java, of the jpeg image and then pass it as a FileInputStream into the setBinaryStream method. However every now and again my Java app will th...
I have an asp.net mvc application and i need to connecto to the DB i have saw a tutorial video that connect to DB using wizard by adding DB connection and determine the DB and add a model but i need to know if i can use connection string and query the DB or calling procedures in DB ??? I need any tutorials or step by step article that ...
Apparently oracle doesn't seem to distinguish between empty strings and nulls. E.g. Select name from TABLE_A where id=100; ID NAME 100 null Update TABLE_A set NAME='' where id=100; SELECT --> ID NAME 100 null SELECT length(NAME) FROM TABLE_A WHERE id=100; null I can't think of any good reason why Oracle would be bui...
I have a site that is a mix of Wordpress and other PHP pages. Can I query the other database and have the results show within Wordpress? ...
I am building an interface between two Oracle databases (A and B) on separate pieces of hardware. I am soliciting advice on the following options (or looking for other ideas) for referencing columns from database B in code on database A (I am using the %ROWTYPE feature in Oracle for all of my variables) *Do it the hard way SCHEMA.TABLE...
Okay, here's the situation: We have a table of about 50 columns (created by joining database tables) and several thousand rows. We need to identify a pattern in several known faulty records of that data. Here's a really boiled down example. Given a table: ----------------------- | id | title | date | ----------------------- | 01 | c ...
Hi all, I currently have a script which will pull in image contents from a database and, using createimagefromstring(), returns a resized (resampled) image for display: $max_width = 170; // Get the image @mysql_connect('host', 'user', 'pass'); @mysql_select_db('db'); $query = "SELECT `thumbnail_contents`, `thumbnail_mimetype` FROM `v...
I realize this question may seem a little on the "green" side, but after the number of "enterprise" or "commercial" databases I've encountered I've begun to ask this question. What advantages to constraints provide to a database? I'm asking more about Foreign Key constraints rather than Unique constraints. Do they offer performance gains...
In a desktop application, I need to store a 'database' of patient names with simple information, which can later be searched through. I'd expect on average around 1,000 patients total. Each patient will have to be linked to test results as well, although these can/will be stored seperately from the patients themselves. Is a database the...
Hi all, Recently I have found that there are many new databases popping up all around my radar, and I would like to make a list of what they do and perhaps what their advantages/disadvantages are. I'll seed the list with some names and perhaps someone with more knowledge can chip in with some information about each and how they stack u...
my question is: i have a member that can pay in 3 different way credit card check transfer from bank account how design the table that contain the history of payment. the fields of every way is different . if i save all in one table , i have lot of blank field ? what the right way to deal it ? ...
Hi all, How to run database scripts(MySql db scripts) in c#. Thanks, sirni. ...
I have a frend who has a company with 6 satellite offices. He wants to install an ERP software in his main office( central database) and will let the satellite office access the ERP application through terminal services. My questions are.. Is this possible with the current remote terminal service application by microsoft? Is there a ne...
Background I'm having trouble understanding the primary key choices in the database for a major vendor supplied product that we support and write SQL reports on. Some irrelevant details have been changed. Each major table has a unique autonumber "internal ID" field, but this field is not always used as the primary key. My question In...