I really don't know what problem(s) this solves. Don't all the javascript runtimes already have wasm engines built into the runtimes?

You don't need to carry around a whole Javascript engine when all you want is running some WASM/WASI code. Granted, the real-world differences aren't all that big:

    - wasmer: single 45 MByte exe
    - wasmtime: single 28 MByte exe
    - node.js: 87 MByte, lots of individual files
    - deno: 186 MByte over two executables (deno and denort not sure what denort is though)

As an extreme outlier, there's wasm3 which is a WASI interpreter and which is just a single 255 KB executable (not a typo).

All sizes looked up on an ARM Mac.

Is this (size) an issue in the real world?

On desktop and server machines probably not. But more code also means a bigger attack surface.

It depends what real world is for you. In embedded or with low bandwith it might.

How does this compare to the following?

create table testInt(num Integer); WITH n(n) AS(SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n < 1000000) insert into testInt select n from n;

On my machine - Mac Mini 3 GHz Dual-Core Intel Core i7 16 GB 1600 MHz DDR3

this takes Run Time: real 0.362 user 0.357236 sys 0.004530

you test just 1M record not 1B?..

30 network requests and 13 script requests to display some text on a page??? Surely this is not the most efficient way to do this???

Thank you for your feedback, Mike. It is an mvp, so there's definitely lots of things to improve, but the goal for v1 was just to make it possible to create and publish a personal website / profile.

If you have any suggestions for improvement, or if you're a freelance/consultant developer, please send your feedback, availability and rate to adishasanic@icloud.com

This is awesome!

They are already using it, it is stated in the author's note.

websocketd - Turn any command that uses stdin into a web socket server (i.e. connect to it from any browser) https://github.com/joewalnes/websocketd

sqlite shell - https://www.sqlite.org/download.html

combine the two for a high throughput web app - https://hackernoon.com/stream-a-million-websocket-sql-reques...

I had blogged about websocket with an example using Python and JavaScript here:

Use WebSockets and Python for web-based system monitoring:

https://jugad2.blogspot.com/2014/01/use-websockets-and-pytho...

websocketd and Python for system monitoring - the JavaScript WebSocket client:

https://jugad2.blogspot.com/2014/01/websocketd-and-python-fo...

Will check out your hackernoon post, sounds interesting.

I read that post. It's impressive that the combination of websocketd and sqlite can be so fast.

http://nodeca.github.io/pako/ http://pieroxy.net/blog/pages/lz-string/index.html

Don't get mislead by the "lite" in sqlite. I can do about 200k sql requests per second with a sqlite inmemory db and node.js