bcherny / -dev-null Goto Github PK

m0: Init

• node + express + couchdb for backend
• react + es6 + gulp for frontend
• GitHub auth for teams
• Personal + Global workspaces

m1: Shared DB client

• Support MYSQL as first db. See AirPal
• Easy to switch DBs through dropdowns
• Deep linking i.e. unique urls can be sent over chat

m2: Share your CURLs

• Support Insomnia style http queries. Also see Postman Cloud
• Easy to switch curl hosts through drop-downs. See DHC
• Store each request in this format

m3: History

• Store history of every requests
• Diff/history viewer

m5: IDE enhancements

• Mustache style templating of vars - global configs with personal overrides
• Paginate db queries or lazy load?
• Inline auto-suggest
• View results as table or export to Excel
• Syntax highlight SQL. See 0xDBE
• Sidebar chat

v1: Profit?

• Homepage
• Documentation
• Sell it. See JackDb

v2: Future Ideas

• Store HTTP API tests
• Able to issue remote command over SSH to hosts. See this
• CodeBunk style REPL for any language
• Vizualize query results like Periscope.io
• Plugin system
• Some discussion here
• https://tyk.io/

We need an adapter which can talk postgres, mysql, sqlserver and maybe even mongo, couch etc etc etc.

Some research yield these (some of these are full-fledged ORMs, but in our case, we just execute user provided queries):
https://github.com/grncdr/node-any-db
http://docs.sequelizejs.com/en/latest/docs/getting-started/
https://github.com/1602/jugglingdb
https://github.com/balderdashy/waterline

Some options:

• As source
• In a docker container
• As a native app, using something like electron or node-webkit
• As a chrome app

See https://github.com/pathikrit/-dev-null/blob/master/server/index.js#L59

I'm running into rate limiting issues.

We already have some /user and /login routes to login. I also added a route like /eval/db/mysql.

But, how do sync the team/user workspaces? What routes? To have a live shareable template maybe websockets?

options:

• dbcurl.com
• ack.mo
• acks.io