Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using sqlite extensions #706

Open
mwinokan opened this issue Feb 28, 2024 · 0 comments
Open

Using sqlite extensions #706

mwinokan opened this issue Feb 28, 2024 · 0 comments

Comments

@mwinokan
Copy link

I have just discovered Pony ORM, and I'm considering using it for a drug discovery project. For this it's imperative that there is performant structure based searching of entries in the database. I have had success using the chemicalite extension to sqlite for this purpose. Is it possible to use this extension with Pony?

Without pony I am able to load the extension from python as follows:

conn = sqlite3.connect(self.path)
conn.enable_load_extension(True)
conn.load_extension('chemicalite')
conn.enable_load_extension(False)

I presume this could cause issues when defining attributes in Pony entities that have custom chemicalite datatypes such as MOL.

Thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant