Soon it will also support running tests.
And I'd be happy to help make all the Learning Zig examples interactive, if the author is interested.
6,898 karma · joined December 12, 2016
Soon it will also support running tests.
And I'd be happy to help make all the Learning Zig examples interactive, if the author is interested.
1) I wanted human readable specs and lockfiles.
2) I didn't want to introduce a dependency (working with SQLite in Go is pretty ugly, it either requires GCC or a ton of other dependencies for a pure Go implementation).
It's better to start with the latter if you seek to understand, not attack.
https://sqlite.org/lang_with.html#recursive_common_table_exp...
Some text functions like `trim` have been added recently, and there will even be a (long-awaited) `timediff` function in the next release.
I have absolutely nothing against EdgeDB or its creators. As far as I can tell, it's a great product.
Interactive SQL examples give readers the ability to edit a query and see how the results change. Or even write their own queries.
It works entirely in the browser, without a server (powered by SQLite Wasm), and requires only minimal changes to existing HTML code.
Even the main set extensions are split into modules, rather than released as a single binary - so people can use them independently.
As for 'noise'. Well, good luck implementing `regexp_substr` and `regexp_replace` using the well-maintained and tested sqlite codebase. Or streaming file I/O.
As a maintainer of a large set of C SQLite extensions, I envy him :)
For example, on 1M rows table with very simple flat JSON values like these:
{"object": "user", "object_id": 10, "action": "login"}
Without index, this query is going to take 500ms or more: select * from events where json_extract(value, '$.object_id') = ?;
With index on json_extract(value, '$.object_id'), it is going to take 1ms.See for yourself:
1. Word Embeddings (this article)
2. Text Classification
https://lena-voita.github.io/nlp_course/text_classification....
3. Language Modeling
https://lena-voita.github.io/nlp_course/language_modeling.ht...
4. Seq2Seq and Attention
https://lena-voita.github.io/nlp_course/seq2seq_and_attentio...
5. ELMo, GPT, BERT
https://lena-voita.github.io/nlp_course/transfer_learning.ht...
All by Lena Voita, who has a real talent for explaining complex stuff.
https://github.com/nalgeon/metro/blob/main/.github/workflows...
Mine is a tool for testing and sharing small snippets of SQL code.
That part is provided by the excellent sql.js project btw: https://github.com/sql-js/sql.js/
But there are 'more > show tables' command in the toolbar and Ctrl+/ shortcut which do exactly that.
Here is what I wanted:
— Binary database import, not just SQL schema.
— Support both local and remote databases (by url).
— Save the database and queries in the cloud.
— Free of charge, no sign-up required.
— The latest version of SQLite.
— Minimalism.
So I did it myself — an online SQLite playground for debugging and sharing SQL snippets.
Sample database: https://sqlime.org/#gist:e012594111ce51f91590c4737e41a046
— Confusingly named it 'Business Communication Standards'
— Published the web version in a barely readable way
— Hid the PDF behind the paywall
Honestly, I've got no idea why one would publish a standard under Creative Commons license in such a strange way. Nevertheless, I've found it.
I believe the guide itself is useful. So with some Python and a lot of manual work I turned it into a GitHub-hosted markdown book, EPUB and PDF. Give it a try ツ