database

I have  student  table , which has four fiels  id, name, address  and  age . In this table 50 student. My question is , How…

I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes. I'm also starting to…

I have a background working with relational databases but recently started to dabble in CouchDB and was surprised by how some non-relational…

My problem is pretty much decribed with the title! I have this code that inserts data to the db: <?php require_once 'connection.php'; $pName =…

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I am trying to open a SQLite database in android, the database works fine in the sqlite browser, but android does not read that the table in…

I have a Palm Pre app that has a large(ish) database. I would like to transfer the database directly to the phone rather than having the app create…

i will create schema the database MySQL. There are username, password etc and rating system and available in month. Standard it looks like this: id…

I've hosted my site on a server provider that I got cheaply. Recently when the traffic to the site increased suddenly I started getting a Database…

I'm currently working on a php project with 3 other people. I need a free software which can help me document the changes/revisions on the database…

Is there a Rails gem, plugin or other means to automatically add or remove ALL RI constraints from your DB and schema? Or ALL of them on a per table…

I'm beginner in iphone programing, now and for the first time I build my first app. I have a php/mysql website and I would like to show a list of…

So I have a form that can increase and decrease according to what the user adds to the page. To be able to handle unknown posts, I have set up a…

I've never had to do this before, so really I just want to check and see if I'm approaching this the correct way. I need to switch databases in the…

I am trying to understand the concept of document storage and fail to see how it would apply to some situations. For example, in the case of a…

I have this code: $local_id = $_GET['id']; $sql = dbquery("SELECT * FROM `videos` WHERE `id` = ".$local_id." LIMIT 0, 1"); while($row =…

there are two tables in db Book{ isbn integer, //primary key title char(50), publisher char(30), year integer } Author{ isbn integer, //foreign key…

I am wondering if there is any method available to implement event trigger based on time. Lets say i want to deleted/modify a record in a certain…