Comments on App Engine Fan: App Engine and SQLite

Hi Hugo, > What's the status of this idea?...

2009-07-18T19:52:02.093-07:00

Hi Hugo,

> What's the status of this idea?

Take a look at
the sources. I have got a certain amount of test cases running on it, but I have not really pursued it any further since last November or so. For what works and what doesn't, check out the following list of posts: http://blog.appenginefan.com/search/label/SQLite .

I had not received a lot of feedback on the project (either users or contributors), so I have not worked on it for a while. Newer features of the store, such as key-only queries for example, will certainly not work. Feel free to take a look though -- if you find it useful, don't hesitate to submit bugfixes or improvements :-)

Cheers,

Jens

What's the status of this idea? I'm worki...

2009-07-15T13:48:06.964-07:00

What's the status of this idea?

I'm working on having my pet project support both sqlite3 and appengine, for certain things. As I'm implementing a particular feature on sqlite3, I find myself duplicating quite a bit of code, to be factored out later. Then I started thinking of factoring it out into an API very similar to the datastore's, and started wondering about fully-fledged datastore-api-on-sqlite3 implementations (either others', or my own).

This is very intersting. I have also been thinkin...

2008-09-01T09:57:00.000-07:00

This is very intersting. I have also been thinking about a higher-powered API-compatible datastore back-end for research or possibly self-hosting. Once there is a decent back-end, we already have WSGI on the front-end, so we have a pretty reasonable starting point for a hosting platform.

Once I started looking into app engine, from there I progressed into learning about non-relational databases because they match the datastore model better. I was even thinking of playing around with some of the open source ones, perhaps HBase or CouchDB. (There is also Amazon's SimpleDB to consider.)

For some reason, CouchDB interests me, ever since I heard the interview with CouchDB developer Jan Lehnardt. So I am still toying with the idea of using CouchDB (or possible HBase) as a replacement for the SDK datastore back-end.