HackerTrans
TopNewTrendsCommentsPastAskShowJobs

dirslashls

no profile record

Submissions

Show HN: Fully functional pivot table creator

sqlframes.com
1 points·by dirslashls·3 tahun yang lalu·0 comments

Show HN: Codeforces Submissions Analyzer

jamstackanalytics.com
1 points·by dirslashls·3 tahun yang lalu·0 comments

Show HN: In-browser analytics within JAMSTACK

jamstackanalytics.com
1 points·by dirslashls·4 tahun yang lalu·0 comments

comments

dirslashls
·4 tahun yang lalu·discuss
Would love to see any factual references about the trend. It's in my vested interested as a founder of sqlframes.com
dirslashls
·4 tahun yang lalu·discuss
Nice one. How do you decide the difficulty of each problem? One hard problem seemed easy using analytic functions while a medium problem felt hard as it required a self-join the realization of which is the harder part.
dirslashls
·4 tahun yang lalu·discuss
Creative!
dirslashls
·4 tahun yang lalu·discuss
Nice. It would be good to have a way to reset to get back to the initial state after zooming/panning.
dirslashls
·4 tahun yang lalu·discuss
Great!

How does this compare to react-virtualized (https://github.com/bvaughn/react-virtualized)? Does it handle tables (rendered with table elements and not div)? Does it support column virtual scrolling?
dirslashls
·4 tahun yang lalu·discuss
Nice work and great use of React Flow.

What level of sophisticated queries can be created with it? For example, can it do "Top N and Other"? Which BTW, was recently added for SQL Frames ( https://sqlframes.com/docs/data_sets/top_n_other_sets )

Most of these visual SQL builders I have seen only tackle the basic level of SQL. I am interested in an advanced SQL builder myself to plug as a no-code SQL builder to front the SQL Frames API.
dirslashls
·4 tahun yang lalu·discuss
Sorry, the correct link is https://sqlframes.com/docs/sql_frames/intro

I didn't find a way to edit my initial comment.
dirslashls
·4 tahun yang lalu·discuss
The morphing of the charts looks great. I don't know how that works, but currently I am using eCharts to achieve similar effects.
dirslashls
·4 tahun yang lalu·discuss
Not sure if your ask is only for open source. I got lucky that my product is JavaScript based and Docusaurus is a perfect way for me to have live interactive docs by using MDX and a wrapper react component. https://sqlframes.com/docs and a quick 5 minute tutorial at https://sqlframes.com/tutorial .
dirslashls
·4 tahun yang lalu·discuss
Go to https://sqlframes.com/demo and in the code editor enter the following and execute (this example is taken from the first example on PRQL github page). It generates SQL, but it also computes and displays the results within the browser (though the data set below gives no results).

const employees = SQL.values([{ title: 'Developer', country: 'USA', salary: 120, payroll_tax: 20, healthcare_cost: 6 }]); employees.schemaName = 'employees'; const { groupBy, where: { gt, eq, and }, agg: { count, sum, avg } } = SQL; return employees.pdf(SQL.script('[salary]+[payroll_tax]').as('gross_salary'),SQL.script('[gross_salary]+[healthcare_cost]').as('gross_cost')) .fdf(and(gt('gross_cost',0),eq('country','USA'))) .gdf(groupBy('title','country') ,avg('salary').as('average_salary') ,sum('salary').as('sum_salary') ,avg('gross_salary').as('average_gross_salary') ,sum('gross_salary').as('sum_gross_salary') ,avg('gross_cost').as('average_gross_cost') ,sum('gross_cost').as('sum_gross_cost') ,count().as('count')) .having(gt('count',200)) .orderBy('sum_gross_cost');