Ask YC: any good Web based DB Client?
Initial Agenda: 1) Create Table/View
option to add primary/foreign key Create indexes on columns Null/Not Null/Check constraints for each column
2) Insert / Update / Delete / Select where condition "and" operator "order by"/"group by"/"having" clauses
Till Now:
Fetching metadata was easy and I have just added JavaScript sugar code using jquery to put things into place. I am able to get proper sql for around 60% CRUD cases which we require in day to day DB operations. Lets see whether this works out well or not.
What next?
I am thinking of make this work across databases db2/oracle/mysql.
Advantages:
For users who just need simple operations with tables can use this thin web client. For small firms can simply get rid of the license fees for most of the developer machines.
Things to look:
Need to search whether such commercial applications are available
Ideas:
Write DSL ( on top of/ using ) JQuery for commmon db operations; which can return me back correct sql.
0 comments
[ 2.5 ms ] story [ 12.3 ms ] threadNo comments yet.