sql.js.org website

[brody4hire]

js-org/js.org#3775

Would definitely be nicer than sql-js.github.io/...

I would be happy to help with this if needed.

[lovasoa]

Yes, work on the website would be welcome, thank you for proposing your help @brodybits !

I think there is quite some work:

• cleaning up the website files that are currently mixed with the source files, and creating a CNAME file for js.org
• have a single command to build the website (including the jsdoc documentation)
• add an action to .github/workflows to run that command on CI and push the result to the gh-pages branch

Once we have that, we can open a PR to js.org to have sql.js.org.

[lovasoa]

I created a demonstration of how to integrate sql.js with webpack at https://github.com/sql-js/react-sqljs-demo

You can use that, and move it into gh-pages if you want, @brodybits

[brody4hire]

Hi @lovasoa that demo looks really nice. A couple questions & ideas:

• I would favor making the demo under MIT license, which should be more consistent with React, SQL.js, and so many other packages in the JS ecosystem.
• Nicer multi-line editor, ideally with SQL highlighting (should be pretty easy to find an existing solution that can work with React)

[lovasoa]

I updated the license.

As for the second change... Maybe there should be two demos ?
One that is full-featured and replaces the old https://sql-js.github.io/sql.js/examples/GUI/
and one that is very short and well-commented that can be used as a template and a reference for how to integrate sql.js with a build system. I would like users to be able to go over the sources of this demo in <5mins.

[brody4hire]

one that is very short and well-commented
[...]
I would like users to be able to go over the sources of this demo in <5mins.

Yes, maybe with some kind of a "use this template" button like here: https://help.github.com/en/github/creating-cloning-and-archiving-repositories/creating-a-repository-from-a-template

[lovasoa]

maybe with some kind of a "use this template" button

I did that already.

[kaizhu256]

nice work on react-demo.

but are we gonna use react for full-feature demo? i prefer it stays vanilla-js so people like me can clone-and-modify it w/o any extra tooling.

also have plans to add import/export csv buttons to the full-feature demo (and perhaps store/load buttons for indexeddb).

[lovasoa]

I think a majority of frontend project these days use some sort of tooling. But nothing is preventing us from having many different demos, demonstrating different usages. One of them can be one where everything is done by hand.

[lovasoa]

@brodybits : are you still working on this?