search

benbjohnson / postlite

Postgres wire compatible SQLite proxy.
Apache License 2.0
1.21k stars 30 forks source link

Possible to use postlite to query osQuery endpoints? #13

Closed shah closed 2 years ago

shah commented 2 years ago

This is a very slick little utility - I have a similar need ... accessing osQuery endpoints. osQuery has its own, special, access points but it would much nicer to have a PostgreSQL wire compatible interface to osQuery endpoints.

Since osQuery is built on top of SQLite, does anyone know if a PostgreSQL wire compatible interface to osQuery endpoints is possible with postlite?

benbjohnson commented 2 years ago

@shah If osquery is able to be loaded as a runtime extension (e.g. .load) then you might be able to use it through Postlite. However, Postlite is still very alpha so just be careful. 👍

shah commented 2 years ago

Thanks for the direction @benbjohnson - I do not believe osQuery can be loaded as a runtime extension but I'll dig further. Please keep working on postlite, it's a fantastic idea! :-)