[Tutor] build a really simple "json" api from a db
brunson at brunson.com
Mon Jul 30 23:39:00 CEST 2007
> The beginning idea was to build a json API myself. Since I need only
> to generate json from a db, maybe Django is too much. I'm a Django
> beginner. I don't know Turbogears.
> I've not found anything like: "how to build a json api".
> Maybe MySqldb+simplejson is the enough?
> Is It more simple to learn how to use Django to create a json api?
You seem to be in analysis paralysis. You don't understand the
underlying technology, which is making the task seem daunting. Break it
down into component parts and learn the ones you don't already understand.
It seems the most important aspects of the project are getting info out
of the database, converting it to JSON and publishing it via HTTP. Do
you have a web server? Then write the simplest example of a CGI script
to query a database and serve serve it up using simplejson. If you
don't have a web server, then wrap it in a little CGIHTTPServer
I'm not trying to criticize on you or make you mad, but if you'd jumped
in and tried it out instead of posting here all weekend, you'd probably
have a working prototype by now. You'll probably go through 10
different iterations before you have a final product and you'll be able
to reuse any of the code you come up with. Just do it and we'll help
you with any questions you have along the way.
Go, go, go. It's your birthday, you can do this. :-)
> 2007/7/28, Alan Gauld <alan.gauld at btinternet.com>:
>> "Picio" <picioslug at gmail.com> wrote
>>> Hello, I'd like to know the necessary steps to build a json api for
>>> two table on my db.
>> Since you seem to be using Django are you sure that isn't built in?
>> I use Turbo Gears and JSON is a standard feature turned on by
>> an option in a method. Django is quite similar to TG in most respects
>> so I'll be surprised if it can't do JSON directly.
>>> I've seen this snippet on the djangosnippet site.
>>> Is It the right way.
>> If its on the Django web site and you are using Django then
>> probably! :-)
>> It certainly looks like a recommendation to me.
>> Alan Gauld
>> Author of the Learn to Program web site
>> Tutor maillist - Tutor at python.org
More information about the Tutor