riseuplabs/crabgrass-core

Incompatibility to other databases due to index on partial column value

red-hood opened this issue · 3 comments

red-hood commented

Databases like sqlite or PostgreSQL do not support indices on partical column values, As index creation seems to be hard coded in the schema, setup of other Databases will fail, e.g.

SQLite3::SQLException: near "(": syntax error: CREATE INDEX subject_0_4_0 ON activities (subject_id,subject_type(4),access)

Is there a special reason why crabgrass needs indices on partial values only? Is that reason strong enoug to break compatibility with other databases?

azul commented

There are a number of other places we break that compatibility. If you want to move towards a more compatible crabgrass writing a postgreSQL adapter for the path_finder would be where i would start.

red-hood commented

Thanks for the information, I might have a look there.
Is there a roadmap for the development of gc-core, and its deployment on we.riseup.net?

azul commented

https://we.riseup.net/cgdev has a dev roadmap and the plan is to deploy by the end of the year.