I am creating a new DB in MySQL for an application and wondered if anyone could provide some advice on the following set up. I\'ll try and simplify things as best as I can.
Another question. Is it better to vertically partition wide table (in my instance I am thinking about splitting login details from address, personal etc. details of the user) on a design stage or bet
I\'m writing an application which has certain features that are similar to Google Circle/FB friend list.
What fields do you think I need to store/retrieve files generically? I am thinking: name (varchar) data (blob)
I have a central database and a unique database for a project I am working on.The central database allows me to provide users with default options and data.
For example, our application tracks animal movements and prices for a farm. To get the current stock count the simplest solution is to have a starting number, then add up all the movement in and out u
I am starting a new project that will handle surveys and reviews. At this point I am trying to figure out what would be the best sql table structure to store and handle such information.
I am trying to create a database table for my game, and would like to see what is the best approach. I have lots of monsters, each monster has number of attacks, monsters do not necessarily have the
I\'m new to the SQLite database, and more generally, to the concept of embedded databases altogether. I\'m used to creating a connection string and connecting to a remote DB server (MySQL, MSSQL Srv,
I think I have a fairly straight forward design question. Say I have 3 applications App1 App2 App3 They all need to access common data, so I made a common database with a table called Locations