Is it possible to use Python (specifically PySQLite) with AJAX? Can AJAX access the database from PySQLite?
Ajax is a client technology. You can use whatever you want in the server to receive and process the Ajax requests.
If you are new (or not) to Javascript you had better use a Javascript framework to generate the Ajax code. Some of the most known Javascript frameworks are Prototype and Jquery.
random reply, here. if you're used to python, take a look at http://pyjs.org - it will allow you to write your front-end in python, it then gets converted to javascript, and you get a full AJAX framework and widget set to play with.
your best bet is to use something like JSONRPCService to talk to a back-end server, which can be in anything, of course, as kakao says, and i'd recommend either django, or pylons. take a look at http://code.google.com/p/pyjamas/wiki/DjangoWithPyjamas if you'd like to use django, or if you prefer to do your own stand-alone JSONRPCService, any of the suggested JSON RPC services mentioned in that page should be easily adatible as stand-alone and/or WSGI and/or as python CGI.