TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: Django SQL Explorer

14 pointsby numlockedover 11 years ago

6 comments

randletover 11 years ago
This looks great numlocked! Excited to give it a whirl.<p>I spend a lot of time writing intranet CRUD apps and these kinds of tools can be really useful to give your users access to the raw data so they can export to csv &amp; do their own analysis in Excel (or whatever their tool of choice).<p>Thanks a bunch for open sourcing it!
评论 #7034509 未加载
sehropeover 11 years ago
This is pretty cool. It&#x27;s kind of funny how after all the admin interfaces and fancy forms, people always end up wanting to just write their own custom SQL.<p>On the security front, the SQL blacklist definitely has to go. It&#x27;s a false sense of security (ex: string concat + dynamic execution gets around it). The suggestion to use a read only user is a good one but even better is to use a read only database (ex: a Postgres replication slave).<p>Have you checked out JackDB? (<a href="http://www.jackdb.com/" rel="nofollow">http:&#x2F;&#x2F;www.jackdb.com&#x2F;</a> <i>full disclosure: I&#x27;m the founder</i>) It&#x27;s a full featured database client that runs entirely in your browser.
评论 #7034796 未加载
abstrctover 11 years ago
Are you able to login as different database users?<p>I would love to try using this with Schemaverse (<a href="http://schemaverse.com" rel="nofollow">http:&#x2F;&#x2F;schemaverse.com</a>) but most frameworks I have seen have trouble with multiple database roles&#x2F;connections.
评论 #7034455 未加载
Edmondover 11 years ago
Looks interesting, been thinking of implementing one for our product (jvm based). I might consider a port, though not sure how much effort it would take.<p>Thanks!
评论 #7034367 未加载
numlockedover 11 years ago
Hey there HN - over the last few weeks I wrote this Django app to help share data across our start-up (ePantry.com). It&#x27;s our first significant open source contribution, and I hope some folks find it useful. I&#x27;d love to hear your feedback.
评论 #7034372 未加载
swiftsailingover 11 years ago
Wow this is going to save me so much time!!!!!!