Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

github.com

Post reply on HN
Print view View original

11–16 of 16 posts

Re: Show HN: Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

#11

Post by Puchaczov »

re_spond wrote: post #9

Where would you place this between osquery and steampipe? It seems to borrow concepts on both sides, but I'm not sure how it could not be plugin for either.

I see it a bit that way: while osquery focuses on OS-level queries and steampipe on cloud services, Musoq is more developer-centric, I'm using it like swiss army knife for various thing, something like sed or grep. You can ofcourse create plugins that covers what mentioned tools do or even, use that tools as a plugin for musoq but in general - I'm not going to compete with any of them, I'm filling my own niche - flexible developer tool.

Re: Show HN: Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

#12

Post by re_spond »

Puchaczov wrote: post #11
re_spond wrote: post #9

Where would you place this between osquery and steampipe? It seems to borrow concepts on both sides, but I'm not sure how it could not be plugin for either.

I see it a bit that way: while osquery focuses on OS-level queries and steampipe on cloud services, Musoq is more developer-centric, I'm using it like swiss army knife for various thing, something like sed or grep. You can ofcourse create plugins that covers what mentioned tools do or even, use that tools as a plugin for musoq but in general - I'm not going to compete with any of them, I'm filling my own niche - flex…

That helps, thanks! It is all about the framing. I love these kinds of tools and have been using a combination of them together with nushell, but it is a road less travelled it seems. All the more reason to evangelise your tool :) keep up the good work.

Re: Show HN: Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

#14

Post by Puchaczov »

johnthescott wrote: post #13

in postgresql syntax for data types is stored in the database. how would this tool parse gis expressions, for example?

You actually don't need any special type system or complex infrastructure for this. Each data source can handle its own data representation and operations. For GIS data, you could create a plugin that naturally handles spatial operations. Here's how it could work:

select Id, DistanceBetween(s.FromPoint(-73.935242, 40.730610)) as Distance, s.IsBetween(s.FromPoint(-73.935242, 40.730610)) as IsInArea from #gis.shapefile('map.shp') s

You could even combine it with other data sources. For example, if you have geometry data in a CSV:

select sfg.DistanceBetween(sfg.FromPoint(..., ...)) from #csv.file(...) c cross apply #gis.ShapeFromGeometry(c.Geometry) sfg

Re: Show HN: Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

#16

Post by Puchaczov »

lathiat wrote: post #3

This looks awesome. As someone working in support for a wide array of Linux Apps, and data dumps from customers where I have no access to the system, plus I also write or backport bug fixes to all sorts of random software, I often want to do this kind of crazy stuff. With exactly these kinds of artefacts.

Thanks! Would love to hear about your specific support scenarios :)
Post reply on HN