News for hackers. Stuff that matters.

A comment on Show HN: Pg_blkchain – Postgres blockchain extension. Parent comment

Re:Show HN: Pg_blkchain – Postgres blockchain extension by ComputerGuru on Saturday October 21, 2017 @10:05PM (#15524754)
> but if sqlite only talks SQL

What does that mean? Like any RDBMS, SQLite is interfaced with in SQL, but can store and process binary data just fine.

[ Parent | on HN ]
Re:Show HN: Pg_blkchain – Postgres blockchain extension by comboy on Sunday October 22, 2017 @03:15AM (#15525581)
I mean that you need to serialize binary just to make an SQL statement that includes it, and that's very expensive. E.g. postgresql's COPY supports binary format which allows you to avoid that.
[ Parent | on HN ]
Re:Show HN: Pg_blkchain – Postgres blockchain extension by ComputerGuru on Sunday October 22, 2017 @12:29PM (#15527544)
The fact that SQLite is embedded means it can take full advantage of pointer passing. I don't think it serializes anything when you bind parameters to a blob.
[ Parent | on HN ]
Re:Show HN: Pg_blkchain – Postgres blockchain extension by anarazel on Monday October 23, 2017 @03:39AM (#15531411)
FWIW, you can use the binary protocol for SELECTs too.
[ Parent | on HN ]