[sqlalchemy] Re: Support for CouchDB
Hello Guys, Thanks for the info, i did expect that to be the case! I can understand that the architecture is indeed very different. As an extension to my question then, which DBMS would you guys recommend for stability. We have a small embedded platform which has an unreliable power source. We're currently using SQLite which appears to work pretty well, is that something you would recommend? or is there something else even simpler and more robust? Cheers, Robert On Aug 25, 3:32 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Aug 25, 2010, at 6:26 AM, Rawlins wrote: Hello Guys, Do we have support for CouchDB with SQlAlchemy? Can't seem to find much information anywhere so I'm guessing not, just thought I would check. There's a long term plan to allow plugins that would provide attribute instrumentation and Session persistence services to objects that are persisted by a non-SQL database. Such a plugin would need to be written by a third party for each database backend and querying would also be an ad-hoc affair. So there's a notion of it but nothing is happening on that front right now. Thanks, Robert -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
[sqlalchemy] Re: Support for CouchDB
Roger Binns has incorporated support for CouchDB into apsw by using SQLite virtual tables. Although apsw cannot be used directly by SQLAlchemy (as it is not dbapi compliant), you can pass an apsw connection to pysqlite connect() and then use that connection as a SQLAlchemy engine. I did some minimal work on a thin DBAPI compatibility layer on top of apsw and the initial results were encouraging but I have not been able to allocate any further time to it. I am not far enough in to know if it is a great idea that will work or an incredibly dumb one that has no chance of working! So if you want to do some hacking about with create_engine(creator = lambda ...) then you may just be able to get couchdb up and running with SQLAlchemy via apsw. If you try it, let me know how you get on. pjjH On Aug 25, 11:16 am, Rawlins rob...@supporttime.com wrote: Hello Guys, Thanks for the info, i did expect that to be the case! I can understand that the architecture is indeed very different. As an extension to my question then, which DBMS would you guys recommend for stability. We have a small embedded platform which has an unreliable power source. We're currently using SQLite which appears to work pretty well, is that something you would recommend? or is there something else even simpler and more robust? Cheers, Robert On Aug 25, 3:32 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Aug 25, 2010, at 6:26 AM, Rawlins wrote: Hello Guys, Do we have support for CouchDB with SQlAlchemy? Can't seem to find much information anywhere so I'm guessing not, just thought I would check. There's a long term plan to allow plugins that would provide attribute instrumentation and Session persistence services to objects that are persisted by a non-SQL database. Such a plugin would need to be written by a third party for each database backend and querying would also be an ad-hoc affair. So there's a notion of it but nothing is happening on that front right now. Thanks, Robert -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] Re: Support for CouchDB
On Aug 25, 2010, at 11:16 AM, Rawlins wrote: Hello Guys, Thanks for the info, i did expect that to be the case! I can understand that the architecture is indeed very different. As an extension to my question then, which DBMS would you guys recommend for stability. We have a small embedded platform which has an unreliable power source. We're currently using SQLite which appears to work pretty well, is that something you would recommend? or is there something else even simpler and more robust? sqlite is a very good choice. Anecdotally, a venerable old database like BerkleyDB might be the even simpler but still very solid kind of choice, or maybe Tokyo Cabinet. Cheers, Robert On Aug 25, 3:32 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Aug 25, 2010, at 6:26 AM, Rawlins wrote: Hello Guys, Do we have support for CouchDB with SQlAlchemy? Can't seem to find much information anywhere so I'm guessing not, just thought I would check. There's a long term plan to allow plugins that would provide attribute instrumentation and Session persistence services to objects that are persisted by a non-SQL database. Such a plugin would need to be written by a third party for each database backend and querying would also be an ad-hoc affair. So there's a notion of it but nothing is happening on that front right now. Thanks, Robert -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.