为我的第一个MySQL项目制定计划 [英] To make a plan for my first MySQL project

查看：62 发布时间：2020/5/14 20:52:04 python mysql

本文介绍了为我的第一个MySQL项目制定计划的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我需要完成

I need to complete the plan of a ask-a-question site for my uni. 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.

关于项目的问题不在此处

to make efficient tables
to improve a relation figure
to improve a ERD diagram
to SHA1-hash you password in a MySQL database by Python
to have a revision history for the questions
to get the right way in designing databases
to get primary and foreign keys right in ERD
to understand login -variable in cookies/URL
to get info about my Uni's servers
to improve SQL -queries
to write SQL queries in DDL correctly
to prevent to use of duplicate tags in a question
to improve SQL queries in DDL
to have no duplicate tags in a table
to separate answers in a databse

我的 构建后端的工具

Python 来建立数据库模式??? (我不确定我可以使用Python构建哪些组件)
MySQL 以存储数据
我不确定用于构建登录和注销系统的工具. 他们不允许我使用Google的系统.这迫使我使用一些简单的开源代码，因为建立一个下降的登录/注销系统要花一个多星期.

Python in building the database schema??? (I am not sure which components I can build by Python)
MySQL to store data
I am not sure which tool to use in building login and logout -system. 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.

构建前端的工具

Django (如果我们可以在Django中使用MySQL)

规划工具

Google文档的电子表格，用于说明用例
TopCoder UML工具，以显示数据库中的主键和其他关系

Google Docs' Spreadsheet for illustrating the usecases
TopCoder UML Tool to show primary keys and other relations in the database

编码工具

Vim，Screen，Zsh，OS X的Visor:我的点文件
EasyEclipse for Python (仅当我遇到困难时错误消息)

Vim, Screen, Zsh, OS X's Visor: my dot-files
EasyEclipse for Python (only if I get a difficult error message)

我对项目的关注:我的目标是仅为用户和主持人构建数据库系统，以便我仅提供以下功能

My focus in the project: I aim to build a database system only for users and moderators such that I only provide the following features

允许用户添加到数据库中，以便中和输入(我知道有一些工具可以使用，但我不确定其名称.)
按时间安排问题
按姓名排列问题
按主题安排问题
允许用户删除他们的问题
向用户发送电子邮件，询问该问题已成功

to allow user to add to a database such that I neutralize the input (I know that there is some tool for that, but I am not sure about its name.)
to arrange questions by time
to arrange questions by name
to arrange questions by their subject
to allow users to remove their questions
to send an email to user that the question was successfully asked

我不确定的事情

如何将登录系统集成到数据库中，以使用户在成功登录时只能看到作为用户名的数据，就像在Joomla中一样
当我将MySQL用于数据库时，不应该使用Python构建哪些组件?
我的大学.没有给我该项目的硬件支持.这表明我最好使用我的项目专用的主机.上个月，我使用了Djangohosting.ch，从他们的开始，我也开始了. 您会使用哪个主持人，以便我可以向Uni展示最终产品??

how to integrate the login -system to the database such that the user sees only his data that is his username when he logins successfully, similarly as in Joomla
Which components should I not build by Python when I use MySQL for databases?
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. Which host would you use such that I can show the final product to my Uni.?

这是我的第一个官方数据库项目，因此我的计划显然存在缺陷，因为必须有一些我不知道的工具. 请查明其中任何一个.

This is my first official database project so my plan apparently has shortcomings, since there must be tools which I do not know. Please, pinpoint any one of them.

为我的第一个MySQL项目制定计划 [英] To make a plan for my first MySQL project

问题描述

推荐答案

相关文章

数据库最新文章

热门教程

热门工具

登录关闭

为我的第一个MySQL项目制定计划 [英] To make a plan for my first MySQL project

问题描述

推荐答案

相关文章

数据库最新文章

热门教程

热门工具

登录 关闭

登录关闭