How to use Postgres buit-in fulltext search and Array type with Slick ??

[briche arnaud]

Hi,   

   I'm new to Slick and I wonder if there is a way to use advanced Postgres functionalities like Array type and built-in fulltext search ??

[Pradeep Kumar Mishra]

yeah I am also looking for pointers to this functionality. Let me know  please if you have idea?

[Dan Carleton]

I tried to create a proper TypeMapper for JDBC Arrays in PostgreSQL, but couldn't figure out how to construct a java.sql.Array other than java.sql.Connection.createArrayOf.  Connection isn't available inside TypeMappers (AFAICT) -- does anyone have a tip?

My poor man's work-around is to use string serialization, which works OK but probably has bugs:

https://gist.github.com/dacc/5054859

- Dan

[Christopher Vogt]

> built-in fulltext search ??

you could probably fall back to plain SQL for that http://slick.typesafe.com/doc/1.0.0/sql.html

[Pradeep Kumar Mishra]

Yeah that's what I am planning to do but since some code is already written using lifted query, I am not sure if I can mix plain sql with lifted..that too without incurring extra db trip. 

[Christopher Vogt]

I am not sure if I can mix plain sql with lifted..

sure, you can.

[Michael Slinn]

A code example of this in the new and improved docs would be helpful.

Mike