jacky banh

> I think I found a workaround for compiling this package for windows (however, I have not tested the impact on performance). MSVC has a problem with `constexpr` and can't...

Another interesting note: - swapping `Array(UUID())` to `Array(Varchar())` would still run the complex query - swapping `Array(?)` to `JSONB` would still run the complex query

hello @sinisaos @dantownsend Is there a way to change `psycopg` to another sql driver or prerun `introspection` queries on boot? im running piccolo on a container and cold starting the...

Hello @sinisaos I have checked out `PSQLlPy` and [psqlpy-piccolo](https://github.com/psqlpy-python/psqlpy-piccolo) wrapper, it looks promising but in its very infant stage of development: e.g major issues datatype comparisons I have found a...

this is very likely a out of memory error, I faced a similar scenario when loading big files e.g videos and performing some file manipulation.

Update: - It doesn't work on native platforms because of objects such as `LoadingSpinner`, trying to find `div` when it shouldn't exist on other platforms. is there a way to...

Hi @mkkellogg thank you for your response, I have tried this too, it did work but [antimatter15](https://github.com/antimatter15/splat)'s implementation uses web workers which doesn't translate to native platforms ([1](https://github.com/mkkellogg/GaussianSplats3D/blob/main/src/worker/SortWorker.js#L200-L207) [2](https://github.com/antimatter15/splat/blob/main/main.js#L768-L774)), I've...

In my case, [pgvector](https://github.com/pgvector/pgvector) needs the vector to be a string such as `'[1,2,3]'` but in the python code it should be accessed as a iterable.

hello @sinisaos the suggested discussion is what I'm currently doing, but constantly using `Table.raw` to resolve most uncovered query needs kinda defeats the purpose of the ORM existing. When I...

Thank you for your reply @sinisaos but its not quite whats desired. The thing I am describing actually exist in the code here [Column.get_sql_value](https://github.com/piccolo-orm/piccolo/blob/master/piccolo/columns/base.py#L833-L910), This translate the python type to...