database

Will this get Search Engines to index my content?

I have a classifieds website... The classifieds are displayed in a dynamic php page. For instance, if one searches for "bmw m3" in the form (which is in index.html) and submits, then a php page will appear showing results. The php page called results.php, connects to mysql databases and fetches the information, and puts them in a tabl...

Help modelling an ER Diagram

I am trying to model the following 2 sentences in an ER Diagram: Each company has a set of tanks. It is also known for each tank how filled up it is for each time of day. It is not known if there are specific times of day for which there are logs. It can be once a day, twice, each hour, maybe some days you don't have any info, ...

Can you recommend a database schema migration tool that is not tied to a particular framework or ORM?

I've used South migrations in the past, but am now looking for a database migration tool that is not tied to a particular framework or Object Relational Mapper (South is for Django). I need it simply for managing schema updates (and rollbacks) and nothing else. Various tools and applications use the same database, so I'd like a dedicated...

Extracting e-mail addresses from Sharepoint site/database

I would like to extract e-mail addresses from a Sharepoint site/database. One list item in Sharepoint can contain several addresses inside a textbox, so I need some sort of regular expression or other trick to recognize what is an e-mail address and what is not. So I'm not sure which approach is the best. SQL Queries and/or script? ...

Visual C# and Settings

I am using Visual C# built in feature Settings to save some of my program's options. It looks like it is using a xml file to save my values, I can save and load settings easily, my question is if I compile the source to an application, where does it hold these values? Does it make a xml filesomewhere, if it does, then where? I compiled a...

want to grow in database administration side

i have 5+ years of development experience. want to grow in database administration side.Planning to do DBA certification. any one can suggest me? Will industry accept my exprience if i get into dba side? ...

What is a good lightweight database that can be used for an ASP.NET MVC application?

I need lightweight database for an ASP.NET MVC application. would prefer not to install anything additional on the host box would also prefer being a little more robust than XML would like to use activerecord or entity frameworks ...

Retrieving filename column form Gridview.

I have a Gridview which displays the filenames in the database. I have written code for deleting filename entry from database, but I also want to delete it from the directory, so how do I retrieve filename from Gridview ? I don't want to execute another select command for retrieving filename. Code : protected void GridView1_RowDe...

Microsft Enterprise Library - How to create database based on Type

Hi, I'm using Enterprise Library 4.1. I have a new feature to implement and it requires the use of mysql. I have found Enterprise Library Contrib, which adds functionalities to use MySQL with Enterprise Lib. Works great. To get it to work, you need to call the method 'DatabaseFactory.CreateDatabase(connectionStringName);' like you w...

Access 2000 automaticly add text to a form entry field.

I have an Access 2000 database with a custom form. People are entering info into this. On one of the fields I want to automatically append a ".zip" to one of the fields. How? ...

Will more MySql tables slow down searches on MySql database?

I have a classifieds website, and I am thinking about redesigning the database a bit. Currently I have 7 tables in the db. One table for each "MAIN CATEGORY". For example, I have a "VEHICLES" table which holds all information about the following categories of classifieds: cars mc mopeds/scooters trucks boats etc etc ...

oracle 11g thin jdbc driver compatible with oracle 10g database?

Currently I'm using the ojdbc14.jar Oracle 10g thin driver to access an Oracle 10g database. I would like to upgrade the driver to the thin ojdbc6.jar Oracle 11g driver ahead of the actual upgrade of the DB server occurs. Using an 11g driver against the 10g DB seems fine in testing so far, but I'm wondering if anyone can confirm this O...

How can I check that two relational databases are identical regardless of primary keys?

I have a relational database with about 100 tables. Each table has unique, numerical, primary key with synthetic values and there are many foreign keys which link the tables. The tables are not big (tens or hundreds or records). This is a SQLite database. I need, for testing purposes, to compare two copies of the database by a linux scr...

Lookup tables for basic user input?

Data like Birth month, day and year, user's age, Gender/Sex, etc. Should these be stored as text or ID based in database? ID based means they will have lookup values. Usage is for example: User signup will record age, user profiles will have a seeking partner age, etc so age and other data can be used in multiple places. In backend there...

Normalization and historical data

Before I describe my problem, I'd like to get a couple things out of the way: I'm an experienced (though not expert) database designer. I believe I have a good grasp of the relational model. I don't have such a firm understanding of the relational model that I know exactly what to do in every situation. I'm still learning. Let's say ...

is there an "inverse" cascade in grails like there is in hibernate?

I have the following sql database that grails set up for me automatically. see picture for diagram http://yfrog.com/ngskillsdbj Whenever I try to delete all projects from an employee, I am getting a cascade re-save exception on the role_skill. Is that because of the way this is set up where role_skill is keyed into skill and role? I s...

C# + OLEDB insert varchar with special character??

Hi, I have a problem with this code, maybe you can give me a hand. Im inserting file information as rows with name, size, ... they are all varchars The problem is that the "name" has this ' tildes in the namefile so when it tryies to parse the data it crashes. the filename is : Creedence Clearwater Revival - Lookin' Out My Back Door - ...

In SQL, how do I get all rows where a column's value is the lowest in the table?

I am a newbie to SQL, I am using this query to look for the minimum value in the field weight of my table. SELECT product_id, MIN(weight) FROM table WHERE 1; It does show one field with the min value, but only one? But I have many products with the same minimum weight. Is there a way I could specify that I need to show a...

How to store "same as" data?

I've got one model with 3 addresses: pickup, dropoff, and billing. I figure the billing address will usually be either the pickup or drop-off address, so from a UI perspective, I should have a "same as" option. But from a DB perspective, should I save the "same as" field, or should I duplicate the data? ...

How to recover Mysql database from backup files

I have using VPS that had to be re-imaged. my DB was part of it and it was being backup up as the app wasn't in production yet. However, there is some data that I wish to recover on it. the VPS provider is giving me a backup of the image (Ubunto Linux) that has all the files. Is there a way I can recover my data? ...