Large object support about vertx-sql-client HOT 7 OPEN

started to contribute in this branch : https://github.com/vietj/reactive-pg-client/tree/blob-support

from vertx-sql-client.

it seems actually we don't need function call support and we can rather reuse prepared statement which simplifies the implementation

from vertx-sql-client.

large object is really something aside tables (https://www.postgresql.org/docs/9.2/static/largeobjects.html) and I'm whether the API should be oriented to be like a file system to manipulate streams keyed by OID (basically a large object is pretty much like an AsyncFile) and then the developer should use OID when referencing them in tables.

coupling a large object with a table is really an artificial view that JDBC expose (perhaps it makes sense in some databases).

from vertx-sql-client.

cc @pmlopes @EmadAlblueshi

from vertx-sql-client.

cc @Sanne : any opinion on this ?

from vertx-sql-client.

There are 2 kinds of large objects, the external files that you need to track the OID as you described and the type bytea which is stored on the table itself. They both have their use cases but usually should behave the same from a API perspective.

from vertx-sql-client.

I don't think they should have the same API because you don't consume/produce them the same way, small one have to be handled as Buffer (a stream is overkill and anyway the bytes are fully loaded when decoding the row), other are usually stream oriented and can be seeked.

from vertx-sql-client.