在 Linux 上具有角色的 Web CRUD 应用程序的最佳语言/框架
我有一个 Linux Web 服务器，我想在 Web 上提供一些数据库表（当前在 Access 中）以用于 CRUD。 需要基于角色的安全性。 开发这个的最快途径是什么？
另外，哪个数据库最好？ 如果有什么区别的话，我已经在那个机器上运行了 mySQL。
I have a Linux web server and I'd like to make some database tables (currently in Access) available on the web for CRUD. There needs to role-based security. What's the quickest path to develop this?
Also, which database would be best? I already have mySQL running on that box if it makes any difference.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我同意查克的观点，问题实际上不应该与语言有关，而应与您选择的框架有关。
我不久前做了一些与你类似的事情，最终使用了 Ruby on Rails 和 activescaffold 插件 (http:// www.activescaffold.com/）提供一个漂亮的前端。 我最终编写的实际代码非常少。 Rails 还有其他插件也提供基于角色的安全性（我没有打扰，我只是有“你要么已登录并具有写入权限，要么你没有登录并且没有”）这也意味着您不必自己写太多东西。
所以让我站在 Rails 的阵营中，因为宗教战争即将来临 ;)
编辑：MySQL 是一个完美的数据库，所以你不必担心。
I agree with Chuck, the question shouldn't really be about the language, but about the framework you choose.
I did something similar to you a while back, and ended up using Ruby on Rails, and the activescaffold plugin (http://www.activescaffold.com/) to provide a pretty front end. The actual code I ended up writing was extremely minimal. There are other plugins for Rails which provide role based security too (which I didn't bother with, I just had "you're either logged in and have write access, or you're not logged in and you don't") and which also mean you don't have to write much stuff yourself.
So put me in the camp for Rails come the religious war ;)
Edit: MySQL is a perfect database to use, so you don't have to worry there.
这将演变成 Ruby on Rails 阵营和 Python 阵营之间的宗教战争，其中 PHP 和 Perl 也有一定程度的差异。 您应该自己评估语言并决定什么最适合您。 当然，还有其他选择，但列出这些只会引发更多的宗教斗争。 尽管如此，我想说我列出的所有这些都是合理的选择。 尽管您选择的语言可能有任何缺点，但您通常可以创建一个好的设计。
This will turn into a religious war between the Ruby on Rails camp and the Python camp, with a good smattering of the PHP and Perl. You should evaluate the langauges yourself and decide what is best for you. There are, of course, other choices, however listing those would just elicit mroe religious battles. Although, I would say all of those I listed would be reasonable choices. You can usually create a good design in spite of any shortcommings your chosen language may have.
如果您想要一个可靠、干净、稳定的 CRUD Web 应用程序，并且可以在未来几年内进行维护和扩展，请坚持使用以下标准：PHP、Perl、JavaScript、CSS 和 HTML。 好好学习这些根源语言。 花时间把事情做好，并注重良好的编码习惯，例如清晰度、一致性和组织性。 练习良好的代码重用、良好的命名、良好的注释和良好的数据库设计。 测试、记录和重构。 为您的 CRUD 应用程序的精湛工艺感到自豪。 由内而外地学习它。 奠定基础，以便您以后可以维护和扩展它。 您的目标是打造一款运行良好、经久耐用并能获得丰厚商业投资回报的产品。 有人曾经说过，成为一名优秀的程序员需要 10 年的时间。
至于框架、插件和外部库，这真是锦上添花。 但永远不要将糖衣与蛋糕混淆。 如果您想学习编码，请花时间正确学习。 如果您不习惯编写简单的 CRUD 应用程序，那么尝试浏览框架生成的代码就会更加不习惯。 编码是一项很棒的工作。 但千万不要把嘶嘶声误认为是牛排。
If you want a solid, clean, stable CRUD web app that can be maintained and expanded for years to come, stick with the standards: PHP, Perl, JavaScript, CSS, and HTML. Learn those roots languages well. Take the time to do it right and focus on good coding habits like clarity, consistency, and organization. Practice good reuse of code, good naming, good commenting, and good database design. Test, document, and refactor. Take pride in the craftsmanship of your CRUD app. Learn it inside and out. Set the stage so you can later maintain and expand it. Your goal is to build something that will work well, last a long time, and make a great return on the business investment. Someone once said that it takes 10 years to become a good coder.
As for frameworks, plugins, and external libraries, that's wonderful icing to put on your cake. But never confuse the icing with the cake. If you want to learn to code, take the time to learn it right. If you're not comfortable coding a simple CRUD app, you'll be even less comfortable trying to navigate the framework-generated code. Coding is a wonderful gig. But never mistake the sizzle for the steak.
我认为语言不是你应该问的问题。 没有一种语言特别适合 CRUD Web 应用程序。 不过，有许多针对此类事情设计的框架，有许多不同的语言，这些可能就是您想要查看的。
我认为 Rails 总体来说是最好的，这也是我在大多数项目中使用的。 它非常适合 CRUD 应用程序（它允许您创建一个简单的应用程序而无需编写任何代码）。 但如果真的有一个无可争议的“最佳”选择，你可能已经知道了。 相反，有些应用程序是用 Rails 制作的，有些是用 Django 制作的，有些是用 Cake 制作的，等等。
I don't think language is the question you should be asking. There's no language particularly well-suited to CRUD Web apps. There are many frameworks designed for that sort of thing, though, in many different languages, and those are probably what you'll want to look at.
I think Rails is the best in general, and that's what I use for most projects. It's very well-suited to CRUD apps (to the point where it allows you to create a simple one without writing any code at all). But if there really were an undisputed "best" choice, you'd probably already know about it. Instead, some apps are made with Rails, some with Django, some with Cake, and so on and so forth.