Postgres HStore and JSon

[Namith]

Sorry if this is the wrong place to ask this.
Is there planned surport for postgres hstore and json types posibly in 4.0?

[Oskar Berggren]

Sounds like you should implement IUserType, or not?

Looks like Dru found an issue in Npgsql also: https://nhibernate.jira.com/browse/NH-3603

Apart from that, anyone is free to suggest what features NHibernate should have in relation to this, and come up with an implementation. I'm not aware of anyone working on something.

/Oskar

2014-03-10 19:09 GMT+01:00 Namith <namt...@gmail.com>:

Sorry if this is the wrong place to ask this.
Is there planned surport for postgres hstore and json types posibly in 4.0?

--

---
You received this message because you are subscribed to the Google Groups "nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-develo...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Marek Barilla]

Hi,

I made some solution, which is not perfect, but it can help in case of using Json type.

https://gist.github.com/bariloce/e65fe5db6c6ddf46e6f8

Marek

On Monday, March 10, 2014 7:59:31 PM UTC+1, Oskar Berggren wrote:

Sounds like you should implement IUserType, or not?

Looks like Dru found an issue in Npgsql also: https://nhibernate.jira.com/browse/NH-3603

Apart from that, anyone is free to suggest what features NHibernate should have in relation to this, and come up with an implementation. I'm not aware of anyone working on something.

/Oskar

2014-03-10 19:09 GMT+01:00 Namith <namt...@gmail.com>:

Sorry if this is the wrong place to ask this.
Is there planned surport for postgres hstore and json types posibly in 4.0?

--

---
You received this message because you are subscribed to the Google Groups "nhibernate-development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-development+unsub...@googlegroups.com.

[Ricardo Peres]

But JSON is just text, right? Why is there a need for a JSON type?

If you want to store any object, just make it serializable and use the SerializableType.

RP

[Alexander Zaytsev]

Ricardo, the PostgreSQL has a JSON _type_ for column, it is not quiet a text.

To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-develo...@googlegroups.com.

[Ricardo Peres]

Ah, ok, didn't know that. And does it also exist in other dbs?

RP

On Wednesday, December 3, 2014 8:11:00 PM UTC, Alexander Zaytsev wrote:

Ricardo, the PostgreSQL has a JSON _type_ for column, it is not quiet a text.

On Thu, Dec 4, 2014 at 3:44 AM, Ricardo Peres <rjp...@gmail.com> wrote:

But JSON is just text, right? Why is there a need for a JSON type?

If you want to store any object, just make it serializable and use the SerializableType.

RP

On Wednesday, December 3, 2014 9:19:23 AM UTC, Marek Barilla wrote:

Hi,

I made some solution, which is not perfect, but it can help in case of using Json type.

https://gist.github.com/bariloce/e65fe5db6c6ddf46e6f8

Marek

On Monday, March 10, 2014 7:59:31 PM UTC+1, Oskar Berggren wrote:

Sounds like you should implement IUserType, or not?

Looks like Dru found an issue in Npgsql also: https://nhibernate.jira.com/browse/NH-3603

Apart from that, anyone is free to suggest what features NHibernate should have in relation to this, and come up with an implementation. I'm not aware of anyone working on something.

/Oskar

2014-03-10 19:09 GMT+01:00 Namith <namt...@gmail.com>:

Sorry if this is the wrong place to ask this.
Is there planned surport for postgres hstore and json types posibly in 4.0?

--

---
You received this message because you are subscribed to the Google Groups "nhibernate-development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-development+unsubscri...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Alexander Zaytsev]

Nope

To unsubscribe from this group and stop receiving emails from it, send an email to nhibernate-develo...@googlegroups.com.

[Dmitry Kalyanov]

Support JSON type is actually more complex than just custom IUserType.

JSON type in postgresql also add several operators for constructing and destructuring JSON values (e.g., you select only part of an object or use JSON fields in `where` predicate). I guess that some of operators could be implemented with custom SQL functions and appropriate HQL generators for LINQ. But some JSON-related functions are more complex - e.g., you can aggregate entire query result into one JSON value or "unnest" single JSON value to multiple rows.

[Paul]

Are there any updates on support for jsonb in nhibernate? 

I was able to create a working solution using for saving jsonb to and from postgresql. This link in particular was very helpful: 
https://www.cloudconstruct.com/blog/using-postgresql-s-jsonb-data-type-with-nhibernate

I can use the raw query interface to create postgresql json queries, but I would like to be able use LINQ like I can I for non jsonb queries. Is this something that needs to be implemented in nhibernate or could I create an extension for it similar to the IUsetType for supporting jsonb?