Databases
StackOverflow2013
Postsdbo
POTo make a plan for my first MySQL project
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTo make a plan for my first MySQL project
    primarykey
    data
    text
    <p>I need to complete the plan of a <a href="http://translate.google.com/translate?hl=en&amp;sl=fi&amp;tl=en&amp;u=http%3A%2F%2Fwww.cs.helsinki.fi%2Fu%2Flaine%2Finfoht%2Faiheet%2Fis97je1.html" rel="nofollow noreferrer">ask-a-question site for my uni.</a> in a few days. I need to have the first version of the code ready for the next Tuesday, while the end of the project is in about three weeks.</p> <p><strong>Questions about the project which do not fit here</strong></p> <ul> <li><a href="https://stackoverflow.com/questions/1182674/users-text-in-my-database-as-a-separate-table-or-within-other-data">to make efficient tables</a></li> <li><a href="https://stackoverflow.com/questions/1182798/to-improve-a-relation-figure-for-a-database">to improve a relation figure</a></li> <li><a href="https://stackoverflow.com/questions/1182910/to-improve-a-sequence-diagram">to improve a ERD diagram</a></li> <li><a href="https://stackoverflow.com/questions/1183161/to-sha1-hash-a-password-in-mysql-database-by-python">to SHA1-hash you password in a MySQL database by Python</a></li> <li><a href="https://stackoverflow.com/questions/1182674/users-text-in-my-database-as-a-separate-table-or-within-other-data">to have a revision history for the questions</a></li> <li><a href="https://stackoverflow.com/questions/1184634/which-is-the-right-way-of-designing-a-database">to get the right way in designing databases</a></li> <li><a href="https://stackoverflow.com/questions/1184857/to-get-primary-and-foreign-keys-right-in-erd">to get primary and foreign keys right in ERD</a></li> <li><a href="https://stackoverflow.com/questions/1184888/to-understand-a-line-about-a-login-variable-in-a-session">to understand login -variable in cookies/URL</a></li> <li><a href="https://stackoverflow.com/questions/1187473/to-know-whether-my-uni-can-run-python-web-applications">to get info about my Uni's servers</a></li> <li><a href="https://stackoverflow.com/questions/1195816/to-improve-sql-queries-in-postgresql">to improve SQL -queries</a></li> <li><a href="https://stackoverflow.com/questions/1196034/is-there-any-iso-standard-of-how-to-write-sql-queries-in-ddl">to write SQL queries in DDL correctly</a></li> <li><a href="https://stackoverflow.com/questions/1196873/to-prevent-the-use-of-duplicate-tags-in-a-database">to prevent to use of duplicate tags in a question</a></li> <li><a href="https://stackoverflow.com/questions/1195816/to-improve-sql-queries-in-ddl">to improve SQL queries in DDL</a></li> <li><a href="https://stackoverflow.com/questions/1196873/to-prevent-the-use-of-duplicate-tags-in-a-database">to have no duplicate tags in a table</a></li> <li><a href="https://stackoverflow.com/questions/1197031/to-separate-answers-in-a-database">to separate answers in a databse</a></li> </ul> <hr> <p>My <a href="http://translate.google.com/translate?prev=hp&amp;hl=en&amp;js=y&amp;u=http%3A%2F%2Fcs.helsinki.fi%2Fu%2Flaine%2Ftikas%2Fmaterial%2Fohjeita.html&amp;sl=fi&amp;tl=en&amp;history_state0=" rel="nofollow noreferrer">uni. offers little support</a> for tools which I selected:</p> <p><strong>Tools in building the backend</strong></p> <ul> <li><strong>Python</strong> in building the database schema??? <em>(I am not sure which components I can build by Python)</em></li> <li><strong>MySQL</strong> to store data </li> <li>I am not sure <strong>which tool to use in building login and logout -system</strong>. <em>They do not allow me to use Google's system. This forces me to use some simple open-source code, since it would take more than a week to build a descent login/logout -system.</em></li> </ul> <p><strong>Tools in building the frontend</strong></p> <ul> <li>Django <em>(if we can use MySQL in Django)</em></li> </ul> <p><strong>Tools for Planning</strong></p> <ul> <li><strong>Google Docs' Spreadsheet</strong> for illustrating the usecases</li> <li><strong>TopCoder UML Tool</strong> to show primary keys and other relations in the database</li> </ul> <p><strong>Tools for coding</strong></p> <ul> <li>Vim, Screen, Zsh, OS X's Visor: my <a href="http://github.com/masi/Sam/tree/master" rel="nofollow noreferrer">dot-files</a></li> <li><a href="http://www.easyeclipse.org/site/distributions/python.html" rel="nofollow noreferrer">EasyEclipse for Python</a> <em>(only if I get a difficult error message)</em></li> </ul> <p><strong>My focus in the project:</strong> I aim to build a database system only for users and moderators such that I only provide the following features</p> <ol> <li>to allow user to add to a database such that I neutralize the input <em>(I know that there is some tool for that, but I am not sure about its name.)</em> </li> <li>to arrange questions by time</li> <li>to arrange questions by name</li> <li>to arrange questions by their subject</li> <li>to allow users to remove their questions</li> <li>to send an email to user that the question was successfully asked</li> </ol> <p><strong>Things about which I am uncertain</strong></p> <ol> <li><em>how to integrate the login -system to the database</em> such that the user sees only his data that is his username when he logins successfully, similarly as in Joomla</li> <li><strong>Which components should I not build by Python</strong> when I use MySQL for databases?</li> <li>My uni. does not give me hardware support for the project. This suggests me that I will be better of in using a host which is specialized in my project. I used Djangohosting.ch the last month, and by their toos, I got started. <strong>Which host would you use such that I can show the final product to my Uni.?</strong></li> </ol> <p>This is my first official database project so my plan apparently has shortcomings, since there must be tools which I do not know. <strong>Please, pinpoint any one of them.</strong></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USLéo Léopold Hertz 준영
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POTo make a plan for my first MySQL project
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POTo make a plan for my first MySQL project
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POTo make a plan for my first MySQL project
      1. USPhil
      1. VTFavorite
    1. COThere is a LOT of material here to cover, do you have any specific questions?
      singulars
      1. POTo make a plan for my first MySQL project
      1. USJanie
    2. COThis is an incredible amount of work for a week. Are you doing this by yourself or is it part of a team project? It's hard for us to point out things that you don't know, since it's impossible for you to list everything you know.
      singulars
      1. POTo make a plan for my first MySQL project
      1. USGreg Hewgill
    3. CO@Janie: Please, see the parts about which I am uncertain at the moment. --- @Greg: I am doing everything by myself. This thread acts as a roadmap for me. I will open new questions when I see things clearly such that I post the links here.
      singulars
      1. POTo make a plan for my first MySQL project
      1. USLéo Léopold Hertz 준영
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload