3 ms·
Yes, we've focused on SELECT for read only - which provides a lot of value as a "universal API" to live query these many sources. Steampipe is built on Postgres
by nathanwallace 4y ago
Yes, we've focused on SELECT for read only - which provides a lot of value as a "universal API" to live query these many sources. Steampipe is built on Postgres Foreign Data Wrappers [1] under the hood, so could be extended to full CRUD in time. Our current belief is that it's better to follow CQRS [2] in this case though - using SQL for the queries and more native tools for the commands.
1 - https://www.postgresql.org/docs/current/ddl-foreign-data.html https://www.postgresql.org/docs/current/ddl-foreign-data.htm...
2 - https://martinfowler.com/bliki/CQRS.html https://martinfowler.com/bliki/CQRS.html