News for hackers. Stuff that matters.

A comment on PgOSQuery: Expose the operating system as a Postgres database. Parent comment

Re:PgOSQuery: Expose the operating system as a Postgres data... by johnteslade on Thursday October 30, 2014 @01:17PM (#8534322)
I tried this with sqlite and the apsw python library. A quick example is at https://github.com/johnteslade/pysqliteosquery

The interface is not quite as nice as Multicorn's but certainly nicer than the C/C++ SQLlite interface. But you could probably create a wrapper around apsw so it looked similar to Multicorn.

[ Parent | on HN ]
Re:PgOSQuery: Expose the operating system as a Postgres data... by Erwin on Thursday October 30, 2014 @03:37PM (#8535310)
FYI, you can use ":memory:" as the sqlite data source, instead of having to conditionally drop the tables (unless you actually do want to store some persistent data on disk).
[ Parent | on HN ]
Re:PgOSQuery: Expose the operating system as a Postgres data... by johnteslade on Friday October 31, 2014 @05:32AM (#8537964)
Good spot. The in memory table also runs 3 times quicker.
[ Parent | on HN ]