Show HN: Musoq – Use SQL on various data sources
1–10 of 15 posts
Re: Show HN: Musoq – Use SQL on various data sources
#2What about including data from an actual database? Having a union of data from, say, a rest api and data I have in my database would be really neat.
Re: Show HN: Musoq – Use SQL on various data sources
#3What about including data from an actual database? Having a union of data from, say, a rest api and data I have in my database would be really neat.
Easily accessible thing you can do is to write a plugin that takes data from database or databases and combine them with the second plugin that gets data from your rest api
Re: Show HN: Musoq – Use SQL on various data sources
#4Have you looked at Apache Calcite?
Quite similar in very high level concept.
Re: Show HN: Musoq – Use SQL on various data sources
#5Tangentially related: check out the (awesome) Postgres foreign data wrappers (FDWs) and the multicorn scripting library to write them. There's 100s of connectors listed on the wiki.
Re: Show HN: Musoq – Use SQL on various data sources
#6What about including data from an actual database? Having a union of data from, say, a rest api and data I have in my database would be really neat.
Easily accessible thing you can do is to write a plugin that takes data from database or databases and combine them with the second plugin that gets data from your rest api
Is that plugin system documented? I thought I read that it was on the roadmap but not an existing feature.
Re: Show HN: Musoq – Use SQL on various data sources
#7Have you looked at Apache Calcite? Quite similar in very high level concept.
Haven't looked at that, Looks very promising! I was creating Musoq to get rid of scripting such things. Can't find is it possible to parametrize easily the table you are connect into
Re: Show HN: Musoq – Use SQL on various data sources
#8Earlier quoted context omitted.
Easily accessible thing you can do is to write a plugin that takes data from database or databases and combine them with the second plugin that gets data from your rest api
Is that plugin system documented? I thought I read that it was on the roadmap but not an existing feature.
look here: https://github.com/Puchaczov/Musoq/wiki/Plugins
You can also look how implemented are default plugins, especially flat file one, it's pretty easy
https://github.com/Puchaczov/Musoq/tree/master/Musoq.Schema....
Re: Show HN: Musoq – Use SQL on various data sources
#9Tangentially related: check out the (awesome) Postgres foreign data wrappers (FDWs) and the multicorn scripting library to write them. There's 100s of connectors listed on the wiki. https://www.google.com/search?q=postgres+fdw
I wasn't aware of that, thank you!
I was targeting to be succesor of LogParser more :)
Re: Show HN: Musoq – Use SQL on various data sources
#10If csv is your main use case, also have a look at qtextasdata[0].