PuppetDB Curl Queries

[Peter Krawetzky]

Using CURL to query PuppetDB has got to be the most time consuming thing I've ever done.  It took me almost 3 hours one day to create a CURL query that I ended up creating in a SQL statement in 10 minutes once I figured out the database structure.

Does anyone have:

1. A documented list of CURL queries and the syntax
2. A documented list of SQL queries to directly against the Postgresql database

[R.I.Pienaar]

Best to use PQL via 'puppet query'

Examples:
https://docs.puppet.com/puppetdb/5.0/api/query/examples-pql.html

On Tue, Jul 11, 2017, at 17:48, Peter Krawetzky wrote:
> Using CURL to query PuppetDB has got to be the most time consuming thing
> I've ever done. It took me almost 3 hours one day to create a CURL query
> that I ended up creating in a SQL statement in 10 minutes once I figured
> out the database structure.
>
> Does anyone have:
>

> 1. A documented list of CURL queries and the syntax
> 2. A documented list of SQL queries to directly against the Postgresql
> database
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to puppet-users...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/puppet-users/8d8e9b09-0c05-4ae8-afcf-48d6a83f8247%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.


--
R.I.Pienaar / www.devco.net / @ripienaar

[Peter Krawetzky]

Isn't that for the PE version?  we are using open source.

[R.I.Pienaar]

On Tue, Jul 11, 2017, at 19:07, Peter Krawetzky wrote:
> Isn't that for the PE version? we are using open source.

It's in all versions