SmartGWT、ZK 和 GenericFrame - 在线作业
美好的一天，
我们的学校是新西兰半农村地区的一所小型高中，目前正在研究在线作业解决方案。作为 IT 人员之一，我被要求研究一些选项。我们进行了检查，没有找到能够满足我们需求的可靠解决方案。因此，我们正在考虑开发自己的系统，无论是我们自己还是与其他一些学校合作。
在我投入大量时间选择任何一种选择之前，我认为我应该寻求一些专家的建议。
请记住，我们的主要障碍之一是，大约 20% 的学生使用拨号上网，因为他们所在的地区没有宽带。
我们也不限于列出的技术，它们只是我们迄今为止一直在研究的技术。
考虑到这一点，就这样吧。 1. 有没有办法预先确定这些技术所需的带宽？ 2. 如果带宽仍然太有限，最终的解决方案是否可以独立，以便我们可以通过 CD 或 USB 记忆棒将其分发给学生？ 3. 与数据库（特别是 mysql 或 postgresql）一起使用时，各自的优缺点是什么？ （毕竟我们确实需要跟踪大量数据） 4. 这些 RIA 开发各自的优点/缺点是什么？
我感谢大家在此事上分享他们的时间和专业知识。
干杯， 本
Good day,
Our school, a small high school in semi-rural New Zealand, is currently looking into online homework solutions. Being one of the IT guys, I have been asked to look into some of the options. We have checked around and there are no robust solutions that cover what we are looking for. So, we are considering development of our own system, either on our own or in collaboration with some other schools.
Before I put significant time into any one option, I would thought I should ask for some expert advice.
Please keep in mind that one of our major obstacles is that around 20% of our students are on dial-up because broadband is not available in their area.
We are also not limited to the technologies listed, they just are the ones that we have been looking into up to this point.
With that in mind, here goes.
1. Is there a way to pre-determine the bandwidth needed for these technologies?
2. If bandwidth continued to be too limiting, could the final solution stand alone so we could distribute it to students on CD or USB stick?
3. What are some pros/cons of each for use with databases, specifically mysql or postgresql? (After all we do need to keep track of lots of data)
4. What are some pros/cons of each for of these RIA development?
I appreciate everyone for sharing their time and expertise on the matter.
Cheers,
Ben
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
1) 如果您编写完整的 AJAX 应用程序，例如在 GWT 中，则 bandwitch 将是：
a) 应用程序java脚本、图像等的大小，您可能会认为用户登录时所有内容都已加载（图像缓存可能看起来很大，但很容易过载）
b) 通信的大小 - 在 GWT 中，它仅取决于您！没有神奇的全帧重载，发送的只是您想要发送的内容
2）我不明白你的意思，独立应用程序可以这样分布，使用数据库的应用程序通常不能
3）postgresql 与 Oracle 具有很高的兼容性- 相同的事务+选择更新行为，pgPLSQL 深受 PL/SQL 的启发（易于重写存储过程）。
1) If you write full-AJAX application, such as in GWT, the bandwitch will be:
a) the size of application java script, images, etc., you may consider that everything is loaded when user logs in (cache for images may seems to be big, but it's easily overloaded)
b) the size of communication - in GWT it depends only from you! no magic full-frame reloading, sending is only what YOU are wanting to send
2) I do not catch your point, stand alone applications can be distributed such way, applications that use databases generally can't
3) postgresql has high compatibility with Oracle - same transaction+select for update behaviour, pgPLSQL is highly inspired by PL/SQL (easy to rewrite stored procedures).
我个人建议将 MySQL 用于学校项目，因为它简单。 PostgreSQL 功能强大，但配置有点复杂，并且优化查询的可视化工具不好。
在不考虑带宽的情况下，我绝对推荐 ZK，因为它更容易学习、开发和维护（也更强大）。 GWT 的带宽消耗和延迟实际上取决于您想要投入多少精力，以及您的人员对分布式计算的熟悉程度，而网络带宽基本上是 UI（而不是数据）的状态，相当小。简而言之，如果您使用 GWT 进行最佳优化，您可以获得最佳的网络带宽和延迟，而 ZK 则不用担心，但如果您想改进，则必须使用 jQuery（即在 JavaScript 中）。
I personally suggest MySQL for a school project for its simplicity. PostgreSQL is powerful but a bit complicate to configure and the visual tool for optimizing queries not good.
Without considering the bandwidth, I definitely suggest ZK since, again, it is much easier to learn, to develop and to maintain (also much more powerful). The bandwidth consumption and latency of GWT really depends how much effort you want to invest, and how skillful your people are familiar with distributed computing, while the network bandwidth is basically the states of UI (not data), which is reasonably small. In short, you could have the best network bandwidth and latency if you optimize it at the best with GWT, while ZK is less to worry but, if you want to improve, you have to use jQuery (i.e, in JavaScript).
谢谢 lechlukasz，我很欣赏你的评论和见解。
我将澄清我关于独立应用程序的观点。我们有相当多的学生，由于地理位置的原因，没有接入宽带，比例高达20%。作为设计的一部分，我们正在考虑如何分发独立版本。
例如，如果我们要使用 GWT 中的单独类来抽象所有数据库调用，我们可以重新编译一个不进行数据库调用的独立版本。该数据库可能仅用于跟踪结果和报告。
实际上，我们可能会首先实现前端产品，并引用用于将结果存储在数据库中的空方法，然后再实现这些方法。
作为记录，我们已经开始使用 GWT/SmartGWT 编写一些测试用例，并对结果感到满意。尽管我们无法评论所考虑的其他技术，因为我们没有在相同程度上尝试它们，但我们对项目目前的结果感到满意。
干杯，
本
Thanks lechlukasz, I appreciate your comments and insight.
I will clarify my point about stand alone applications. We have a number of students, as high as 20%, who do not have access to broadband due to their geographic location. We are considering, as part of the design, how we may be able to distribute a stand alone version.
For instance, if we were to abstract all the database calls using a separate class in GWT, we could recompile a stand alone version that didn't make the database calls. The database would likely only be for tracking results and reporting.
In reality, we would likely implement the front end product first with references to empty methods for storing the results in a database and implement those methods at a later time.
For the record, we have started to code up some test cases using GWT/SmartGWT and are pleased with the results. Although we cannot comment on the other technologies considered because we didn't try them to the same extent, we are pleased with the results to this point of the project.
Cheers,
Ben