Hi can someone advise whether there is an adapter for sqlite3 for zope. I normally use Postgres but I am curious about this for lightweight use. I realize sqlite3 is not multi-threaded itself but might be fine for small volume sites (if it can be forced to use a single thread for interaction with the db). Does anyone have any experience they can share if they have tried this before. Many thanks. Regards David
David Pratt wrote at 2006-1-20 10:00 -0400:
Hi can someone advise whether there is an adapter for sqlite3 for zope. I normally use Postgres but I am curious about this for lightweight use. I realize sqlite3 is not multi-threaded itself but might be fine for small volume sites (if it can be forced to use a single thread for interaction with the db). Does anyone have any experience they can share if they have tried this before. Many thanks.
I think almost all DA for DB API 2 compatible modules have a common ancestor. They are all very similar. If there is not yet a DA, it should be easy to copy an existing DA and make some minor adjustments for "SQLite3". -- Dieter
Hi Dieter. Many thanks. :-) I was hoping there might be something but if I cannot locate anything existing, I will likely go this route if I can find a bit more time. Regards, David Dieter Maurer wrote:
David Pratt wrote at 2006-1-20 10:00 -0400:
Hi can someone advise whether there is an adapter for sqlite3 for zope. I normally use Postgres but I am curious about this for lightweight use. I realize sqlite3 is not multi-threaded itself but might be fine for small volume sites (if it can be forced to use a single thread for interaction with the db). Does anyone have any experience they can share if they have tried this before. Many thanks.
I think almost all DA for DB API 2 compatible modules have a common ancestor. They are all very similar.
If there is not yet a DA, it should be easy to copy an existing DA and make some minor adjustments for "SQLite3".
I don't use sqlite. I hope this linki http://www.initd.org/ would be useful to you. CY David Pratt <fairwinds@eastlink.ca> wrote: Hi Dieter. Many thanks. :-) I was hoping there might be something but if I cannot locate anything existing, I will likely go this route if I can find a bit more time. Regards, David Dieter Maurer wrote:
David Pratt wrote at 2006-1-20 10:00 -0400:
Hi can someone advise whether there is an adapter for sqlite3 for zope. I normally use Postgres but I am curious about this for lightweight use. I realize sqlite3 is not multi-threaded itself but might be fine for small volume sites (if it can be forced to use a single thread for interaction with the db). Does anyone have any experience they can share if they have tried this before. Many thanks.
I think almost all DA for DB API 2 compatible modules have a common ancestor. They are all very similar.
If there is not yet a DA, it should be easy to copy an existing DA and make some minor adjustments for "SQLite3".
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) --------------------------------- What are the most popular cars? Find out at Yahoo! Autos
On 1/21/06, David Pratt <fairwinds@eastlink.ca> wrote:
Hi Dieter. Many thanks. :-) I was hoping there might be something but if I cannot locate anything existing, I will likely go this route if I can find a bit more time.
isn't this it? http://www.google.com.my/search?hs=OJf&hl=en&safe=off&client=firefox-a&rls=o... Regards,
David
Dieter Maurer wrote:
David Pratt wrote at 2006-1-20 10:00 -0400:
Hi can someone advise whether there is an adapter for sqlite3 for zope. I normally use Postgres but I am curious about this for lightweight use. I realize sqlite3 is not multi-threaded itself but might be fine for small volume sites (if it can be forced to use a single thread for interaction with the db). Does anyone have any experience they can share if they have tried this before. Many thanks.
I think almost all DA for DB API 2 compatible modules have a common ancestor. They are all very similar.
If there is not yet a DA, it should be easy to copy an existing DA and make some minor adjustments for "SQLite3".
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- http://myzope.kedai.com.my - my-zope org
Wow. Thanks Bakhtiar! I did some searching but was unable to locate it so many thanks for this link. Now I can experiment. It sounds like an odd combination with zope but I am curious mostly. I just wanted to see how it would cope for something small. Regards, David Bakhtiar A Hamid wrote:
On 1/21/06, *David Pratt* <fairwinds@eastlink.ca <mailto:fairwinds@eastlink.ca>> wrote:
Hi Dieter. Many thanks. :-) I was hoping there might be something but if I cannot locate anything existing, I will likely go this route if I can find a bit more time.
isn't this it? http://www.google.com.my/search?hs=OJf&hl=en&safe=off&client=firefox-a&rls=o... <http://www.google.com.my/search?hs=OJf&hl=en&safe=off&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=sqlite3+zope&btnG=Search&meta=>
Regards, David
Dieter Maurer wrote: > David Pratt wrote at 2006-1-20 10:00 -0400: > >>Hi can someone advise whether there is an adapter for sqlite3 for zope. >> I normally use Postgres but I am curious about this for lightweight >>use. I realize sqlite3 is not multi-threaded itself but might be fine >>for small volume sites (if it can be forced to use a single thread for >>interaction with the db). Does anyone have any experience they can share >>if they have tried this before. Many thanks. > > > I think almost all DA for DB API 2 compatible modules have > a common ancestor. They are all very similar. > > If there is not yet a DA, it should be easy to copy an existing > DA and make some minor adjustments for "SQLite3". > > _______________________________________________ Zope maillist - Zope@zope.org <mailto:Zope@zope.org> http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce <http://mail.zope.org/mailman/listinfo/zope-announce> http://mail.zope.org/mailman/listinfo/zope-dev )
-- http://myzope.kedai.com.my <http://myzope.kedai.com.my> - my-zope org
participants (4)
-
Bakhtiar A Hamid -
David Pratt -
Dieter Maurer -
Infor Gates