polyrand

21 ms·

211.
JIT in ClickHouse(maksimkita.com)
4 points by polyrand 4y ago|0 comments
212.
Python Type Hints: case study on parsy(lukeplant.me.uk)
3 points by polyrand 4y ago|0 comments
213.
by polyrand 4y ago
I do something similar using entr [0][1]. I use it instead of `watch` because I would rather not re-run things if no relevant files have changed. For example, I run: fd -e j2 -e py | entr -c python3 build.py To rebuild a static site
214.
DuckDB 0.6.0(duckdb.org)
36 points by polyrand 4y ago|0 comments
215.
by polyrand 4y ago
> Any downside to this approach? None that I can think of unless you need foreign key constraints between both. > Are JOINS slower across two files than across two tables in the same file? I was recently debugging as slow JOIN with AT
216.
Using LLVM to JIT PyTorch fx graphs to native code(blog.christianperone.com)
2 points by polyrand 4y ago|0 comments
217.
SQLite 3.39.4(sqlite.org)
4 points by polyrand 4y ago|0 comments
218.
Understanding the Snowflake Query Optimizer(teej.ghost.io)
1 points by polyrand 4y ago|0 comments
219.
Comparing SQLite WAL Mode to Voron’s(ravendb.net)
1 points by polyrand 4y ago|0 comments
220.
by polyrand 4y ago
> attempting to square-peg-round-hole something like this into AWS S3 I don't think it's like that. AWS already offers services like S3 Select[0] or Athena[1] that do something similar. > the user is merely invited to retry
221.
by polyrand 4y ago
This VFS is only for reading databases stored in S3, not writing. The README gives some alternatives for other implementations which allow writing.
222.
by polyrand 4y ago
Yes, I actually used MinIO to test it (see the `test.py` script)
223.
by polyrand 4y ago
Author here! This is something I want to look into. One of the reasons to use s3fs is that the underlying `fsspec` classes already handle caching. S3File (from s3fs) inherits from AbstractBufferedFile[0], which has a cache[1], implemented h
224.
by polyrand 4y ago
That DynamoDB VFS looks cool! I agree that the VFS api makes one think about plenty of crazy ideas. Someone is working on a VFS based on Foundation DB[0] that looks very promising. It was recently discussed here[1] [0]: https://g
225.
by polyrand 4y ago
Author here! I would say the main advantage is that this just needs uploading a single file to S3. `sqlite-s3vfs` will split the database in pages and upload the pages separately to a bucket prefix. Having just a single file has some advant
226.
Show HN: Query SQLite files stored in S3(github.com)
160 points by polyrand 4y ago|61 comments
227.
by polyrand 4y ago
HTML media capture is superb. I have successfully used it in production, and I was surprised by how simple it was and how well it worked. I learned about it from here[0]. It's cool because if you have an app that requires users uploadi
228.
HTML Media Capture Examples(anssiko.github.io)
2 points by polyrand 4y ago|0 comments
229.
by polyrand 4y ago
Yes! I love UDFs in SQLite: 1. I can just write functions in whatever programming language I want. 2. Not having to worry as much about overwriting other UDFs, since different connections can have the same UDF with a different implementatio
230.
by polyrand 4y ago
I submitted it when I wrote that blog post, but it went unnoticed [0]. [0]: https://news.ycombinator.com/item?id=31388241
231.
by polyrand 4y ago
I actually wrote a blog post about that: https://ricardoanderegg.com/posts/extending-sqlite-with-rust...
232.
by polyrand 4y ago
Adding user-defined functions to SQLite is not difficult, and the mechanism is quite flexible. You can create extensions and load them when you create the SQLite connection to have the functions available in queries. I wrote a blog post exp
233.
by polyrand 4y ago
Regarding hash joins, the SQLite documentation mentions the absence of real hash tables [0] SQLite constructs a transient index instead of a hash table in this instance because it already has a robust and high performance B-Tree impl
234.
Velox: An open-source unified execution engine(engineering.fb.com)
151 points by polyrand 4y ago|52 comments
235.
Manual work is better than bad automation(ricardoanderegg.com)
59 points by polyrand 4y ago|10 comments
236.
Abuse the Node inspector to execute arbitrary JavaScript code(github.com)
3 points by polyrand 4y ago|0 comments
237.
Musings about Automation(ricardoanderegg.com)
2 points by polyrand 4y ago|1 comments
238.
A SQLite extension for reading large files line-by-line(github.com)
157 points by polyrand 4y ago|29 comments
239.
Distributed, MVCC SQLite that runs on FoundationDB(github.com)
1 points by polyrand 4y ago|0 comments
240.
Conflict-Free SQLite(github.com)
3 points by polyrand 4y ago|0 comments

More ›