News for hackers. Stuff that matters.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by clarkevans on Tuesday August 20, 2013 @03:40PM (#6246061)
Over the past few years we've also been working on a HTTP based API for SQL databases -- http://htsql.org; it has insert/update/delete features in a plugin.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by Arnor on Tuesday August 20, 2013 @03:27PM (#6245984)
I really hope this makes it to production. I'll be contributing code and money to see that happen. Thanks for this extremely useful tool.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by jknupp on Wednesday August 21, 2013 @07:07AM (#6249332)
Contributions are always welcome. I've been making reasonably quick progress on it and it's getting more robust by the day. Already added features include a Django-style admin interface, user-defined HTTP methods per Model, and user-defined, per-method validation.

The two main features needed to make sandman really usable are authentication and the generation of "rel" links automatically from foreign key information. I'm working on authentication as we speak...

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by deckiedan on Tuesday August 20, 2013 @01:06PM (#6245019)
Very very cool. With a django-admin style gui, and some method of auth, this could make prototyping new apps extremely quick for legacy (or other-department maintained) databases.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by asparagui on Tuesday August 20, 2013 @01:15PM (#6245072)
I've messed with inspectdb a few times, it's a good trick to know if you're in the land of django:

https://docs.djangoproject.com/en/dev/howto/legacy-databases...

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by bmelton on Tuesday August 20, 2013 @06:46PM (#6247091)
Caveat: It's also frigging miserable if you are in the minority of developers using Django with Oracle DB. It gets quite a bit wrong, but my main gripe is that I can't inspectdb against an Oracle table and then syncdb the resultant models and get the same (or even necessarily working) tables.

YMMV.

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by jknupp on Wednesday August 21, 2013 @06:59AM (#6249298)
Your wish is my command. Django-style admin GUI added! Check out the GitHub page for a screenshot.

Authentication is next on my list...

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by eli on Tuesday August 20, 2013 @01:13PM (#6245057)
Nice. I could've used this earlier. Tastypie is nice, but it really kinda assumes your models and relationships are already designed for a public API.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by dpcx on Tuesday August 20, 2013 @05:33PM (#6246724)
Anyone know of a PHP version of this? Would make my life so much easier.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by allannienhuis on Tuesday August 20, 2013 @11:09PM (#6247942)
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by gnaritas on Tuesday August 20, 2013 @06:36PM (#6247050)
Why would you need a PHP version? If you like this idea, just use this and consume the services with your PHP front end.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by allannienhuis on Tuesday August 20, 2013 @11:12PM (#6247951)
A php version would be useful for someone with an existing php project who doesn't want to add another tech stack to their build/deploy/host requirements. This is especially useful for authors who might target customers self-hosting on low cost shared hosting services, where php & mysql is ubiquitous.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by ChikkaChiChi on Tuesday August 20, 2013 @06:49PM (#6247103)
As a for instance, PHP has a native driver for Microsoft SQL services.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by gnaritas on Tuesday August 20, 2013 @09:03PM (#6247574)
And Python doesn't?
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by clubhi on Tuesday August 20, 2013 @01:44PM (#6245288)
A few lines of code added on django-admin will get you this as well.
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by johnsonmkj on Tuesday August 20, 2013 @02:38PM (#6245687)
New to django, care to share a link?
Re:Sandman: A Boilerplate-free Python REST API for Existing ... by dkroy on Tuesday August 20, 2013 @09:15PM (#6247613)
from app.models import ModelName

admin.site.register(ModelName)

Django documentation for this: https://docs.djangoproject.com/en/dev/ref/contrib/admin/

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by jknupp on Wednesday August 21, 2013 @07:02AM (#6249305)
The point is, with Django you'd have to painstakingly reverse-engineer a Django Model from your existing database. sandman does all of this without writing any boilerplate code (aside from listing the names of the tables you want included in your API).

The difference in LOC and general frustration is huge.

Re:Sandman: A Boilerplate-free Python REST API for Existing ... by dkroy on Wednesday August 21, 2013 @06:59PM (#6253880)
I agree that is extremely awesome. I was just responding to his question. I have already started playing with your project, and have enjoyed experimenting with it.