Active Query Builder ASP.NET Edition's MS Access-like user interface is based on jQuery. It's a commercial component for ASP.NET 2.0 and higher. It can build SELECT statements for MySQL server.
Dynamically creating the database schema might be a problem, because of the relations between tables. You could let the users carry the burden of selecting the relations but if i look at the "non-SQL fluent people" around me.. i'd probably not do that..
Other than that, if you want to create/check the structure on the fly, you practically have to create/check it every time the script is called. Generating a maybe huge, not necessary, overhead. I`d probably rather have a script/db-admin generate/update the structure every time someone twiddles with the database.
I doubt that you'll find something that does exactly what your looking for. Maybe pulling the structure out of a YAML file that's kept up to date by the db-admin might be better a better solution.
发布评论
评论（2）
Active Query Builder ASP.NET 版的类似 MS Access 的用户界面基于 jQuery。它是 ASP.NET 2.0 及更高版本的商业组件。它可以为MySQL服务器构建SELECT语句。
产品页面：http://www.activequerybuilder.com/product_asp.html
演示：http://aspquerybuilder.net
Active Query Builder ASP.NET Edition's MS Access-like user interface is based on jQuery. It's a commercial component for ASP.NET 2.0 and higher. It can build SELECT statements for MySQL server.
Product page: http://www.activequerybuilder.com/product_asp.html
Demo: http://aspquerybuilder.net
由于表之间的关系，动态创建数据库模式可能会出现问题。你可以让用户承担选择关系的负担，但如果我看看我周围的“非 SQL 流利的人”..我可能不会这样做..
除此之外，如果你想创建/检查动态结构，您实际上必须在每次调用脚本时创建/检查它。产生可能巨大但不必要的开销。我可能宁愿让脚本/数据库管理在每次有人摆弄数据库时生成/更新结构。
我怀疑您是否会找到完全符合您需求的东西。
也许从数据库管理员保持最新的 YAML 文件中提取结构可能是更好的解决方案。
Dynamically creating the database schema might be a problem, because of the relations between tables. You could let the users carry the burden of selecting the relations but if i look at the "non-SQL fluent people" around me.. i'd probably not do that..
Other than that, if you want to create/check the structure on the fly, you practically have to create/check it every time the script is called. Generating a maybe huge, not necessary, overhead. I`d probably rather have a script/db-admin generate/update the structure every time someone twiddles with the database.
I doubt that you'll find something that does exactly what your looking for.
Maybe pulling the structure out of a YAML file that's kept up to date by the db-admin might be better a better solution.