Tagged Questions
-1
votes
0answers
35 views
People who visited this item, also visited these items
The problem is: how to store a 2-sided link/relation in mysql database?
there are so many products on the website each one with a unique Id.
I store cookies for the user ip address and also last 10 ...
0
votes
1answer
12 views
Database Modelling when multiple entities are involved
I have three entities in a MySQL based web application - Customer, Service and Note. Each customer can have multiple notes posted by different users. Similarly a Service can also have multiple notes. ...
0
votes
1answer
27 views
Is relating (image) table with (user), (product), (company) and any independent tables advised?
I'm thinking about having one image table to store images of any other independent table like user, product and so... (of course any single instances of independent tables (like John Smith as a user, ...
0
votes
3answers
25 views
Very basic database design (total beginner) [on hold]
I just started learning server-side programming (PHP) and I'd like to try to make a simple application that uses a MySQL Database to store some users' data (like notes).
I'm a total noob in databases ...
0
votes
1answer
29 views
Have a huge database based on a specific design (for performance tests)
I thank you for your time.
I know there are threads on StackOverflow that look similar, but none of them are answering my question.
Given a design of a database, is there a tool that can fulfill it ...
0
votes
1answer
35 views
MySQL create a table from two existing table calculations
I'm making a php web page with Yii and MySQL. My problem is in database part.
I have two tables, "stock" and "given". They are like:
stock = id (primary key), name, amount (this is integer), ...
-1
votes
4answers
58 views
Where does Facebook store multi millions of Images and Videos. In database or somewhere else? if so, Where?
I am completely new to database. I require some information regarding where does the Facebook which stores millions and millions of pictures and videos. Do they store it in their database and then the ...
1
vote
1answer
32 views
Disadvantages to having many MySQL tables?
I was wondering what the disadvantages are to having many tables (let's say ~100,000) rather than one large table. An example would be having one table per user, or one large table for all users where ...
-1
votes
1answer
23 views
Select one record based on results from multiple rows
I have two tables:
| conversations | | conversation_participants |
------------------- ----------------------------------
| id | project_id | | id | conversation_id | user_id |
...
0
votes
1answer
14 views
In MySQL, does the designated size of TEXT or BLOB affect performance or table size?
I have a table of data that simply consists of foreign_key fields and a BLOB column, as other tables need not retrieve large blobs on a regular basis.
So with the data-blob on its own, does it matter ...
0
votes
1answer
20 views
How to manage eficiently the new products of my database?
I have a database of a store which I have to add new products constantly. But before publish a new product or after r modifying one the admin have to check if it has the correct data.
I thought in ...
1
vote
1answer
33 views
Database Design - Is redundancy better than adding more relationship?
Hi I wonder which one of these database designs is better:
I have Shopping db, it has two tables: Categories and Brands. Both of those tables have the columns: name, description, and image_url.
So ...
1
vote
2answers
28 views
Advice on database design for multiple catalogs
I have a relatively simple database design that I will simplify here for the sake of brevity.
I have 4 tables => Products, Product_Sizes, Stores, Catalogs.
There are 6 stores and each store has ...
1
vote
1answer
26 views
Correct database implementation of groups like Google's circles
create table USERS (
PK_USER int not null auto_increment primary key,
EMAIL varchar(100) not null,
PASSWORD char(40) not null
);
create table CIRCLES (
PK_CIRCLE int not ...
0
votes
1answer
36 views
Database design opinions [on hold]
I'm working on a rails app that will store financial data from various public companies. The data is several years worth and I'm having a hard time figuring out the best way to store this.
...
