为我的第一个MySQL项目制定计划

编程入门行业动态更新时间:2024-10-25 22:24:05

本文介绍了为我的第一个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.

关于项目的问题不在此处

来提高效率桌子
改善关系图
改善ERD图
SHA1将您的密码哈希在MySQL中用Python建立数据库
>问题的修订历史记录
以正确的方式设计数据库
在ERD中正确获取主键和外键
了解Cookie中的登录变量/URL
获取有关我的Uni服务器的信息
改善SQL查询
编写SQL在DDL中正确查询
以防止在问题
改善DDL中的SQL查询
在表中没有重复的标签
在数据库中分离答案

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

我的 uni.对我选择的工具几乎没有支持:

构建后端的工具

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.

推荐答案

首先，一周之内可以完成很多工作.但是就这样.

First, this is all a lot to work with in a week. But here it goes.

后端工具:

SQLAlchemy-这是一个ORM工具包，在使用Python构建的MySQL数据库时，它对于大多数较小的任务而言功能强大.据我所知，这是这项工作的最佳选择. www.sqlalchemy/

Django-"...是高级Python Web框架..."这对于快速开发站点(包括登录/注销方法)和对Web/Python理解的人来说学习曲线最少可能会更好.

构建前端的工具:

如果您已经计划将Django用于后端，则建议您也将其用于前端.

If you already plan on using Django for the backend, I'd recommend using it for the frontend as well.

您不确定的事情

可以在MySQL中指定用户，并可以相应地设置其权限.

从您列出的一些要求中，大多数听起来像可以包含在Django的功能之内.