# Resurrecting universal database API

**URL:** <https://discourse.julialang.org/t/resurrecting-universal-database-api/11412>\
**Category:** Data\
**Created:** [June 4, 2018, 1:49pm UTC](https://discourse.julialang.org/t/resurrecting-universal-database-api/11412 "2018-06-04T13:49:40Z")\
**Posts on this page:** 1\
**Page:** 4

<div class="post-metadata">

**Author:** ![jerlich](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jerlich/32/5205_2.png) [@jerlich](https://discourse.julialang.org/u/jerlich)\
**Post date:** [August 17, 2018, 4:23am UTC](https://discourse.julialang.org/t/resurrecting-universal-database-api/11412/61 "2018-08-17T04:23:38Z")

</div>

Since I sort of started this BLOB tangent, I thought I would chime in. The BLOB should be retrieved as `Vector{UInt8}` (or a stream of Uint8) as you described. It should also be possible to do something like (apologies if this is not great julia code).

```julia
a = 4
io = IOBuffer()
write(io, rand(10,5))
execute("insert into foo (int_col, blob_col) values (?,?)",(a,io))
execute("insert into foo (int_col, blob_col) values (5,?)",(b"hello",))

```

or something similar.

[Previous page](https://discourse.julialang.org/t/resurrecting-universal-database-api/11412.md?page=3)