Re: [review] [sqlite]

From: Nelson, Erik - 2 (erik.l.nelson_at_[hidden])
Date: 2024-11-19 21:13:58

Ruben Perez wrote on Tuesday, November 19, 2024 3:52 PM

On Tue, 19 Nov 2024, 19:46 Nelson, Erik - 2 via Boost, <boost_at_[hidden]<mailto:boost_at_[hidden]>> wrote:
Ruben Perez wrote on Tuesday, November 19, 2024 1:25 PM

... snip ...

>In other words, is
>writing virtual table implementations really something that happens in
>day to day development? I feel that the answer to this question is no,
>so I find it surprising that all examples except one are about virtual
>tables. Take this with perspective, though, as I'm no expert in this
>topic.

Not C++, but I use virtual tables in Python to expose Numpy memory structures so users can query them directly.  It's quite handy.

Erik

>This is pretty interesting, thanks for sharing. Did you get to write the virtual table implementation, or is it part of an already existing package?

Our team wrote it, I haven’t seen anything comparable.  It uses Numba to jit-compile the python into C-callable functions.  Then pointers to those can be passed to the sqlite3 API.

We basically extended the concepts pioneered in the numbsql project (https://github.com/cpcloud/numbsql) to the sqlite3 virtual table API.

Erik


----------------------------------------------------------------------
This message, and any attachment(s), is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/electronic-disclaimer. If you are not the intended recipient, please delete this message. For more information about how Bank of America protects your privacy, including specific rights that may apply, please visit the following pages: https://business.bofa.com/en-us/content/global-privacy-notices.html (which includes global privacy notices) and https://www.bankofamerica.com/security-center/privacy-overview/ (which includes US State specific privacy notices such as the http://www.bankofamerica.com/ccpa-notice).