Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
polyrand
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
43 ms
·
181.
▲
by
polyrand
4y ago
Quite cool to see PEX. I've used a similar package, shiv[0], with great results, and I always wondered why these are not used more. I think Python zipapps are really nice for bundling executables. [0]: https://shiv.readthedo
182.
▲
by
polyrand
4y ago
Interesting! You can also inherit from code.InteractiveConsole[0] to build a REPL. That's how the new sqlite3 REPL is implemented[1] [0]: https://docs.python.org/3/library/code.html#code.Interactive... [1]:
183.
▲
The Amo Tech Stack
(about.amo.co)
1 points
by
polyrand
4y ago
|
0 comments
184.
▲
Understanding Monomorphism to Improve Your JavaScript Performance
(builder.io)
3 points
by
polyrand
4y ago
|
0 comments
185.
▲
by
polyrand
4y ago
I'm super excited about the new query building. It's like having CTEs that you can easily debug and explore, and instead of having to work with big queries now you can just play around with Python objects. This will make testing c
186.
▲
by
polyrand
4y ago
TIL about 'hidutil', do you know if it can remap single key to a combination of keys? E.g: remap Caps Lock to "Ctrl + Option + CMD"
187.
▲
by
polyrand
4y ago
After some time using Karabiner (still use it), I moved most of the remappings to skhd[0]. I find karabiner a bit too complex for just remapping a few combinations. The main reason I keep karabiner is because it lets you have a different be
188.
▲
by
polyrand
4y ago
I did something similar using git hooks (for Heroku-like deployments) and curl for health-checking the app [0]. In my case, instead of using replicas, I created multiple services in the docker-compose.yaml file. The services are the same bu
189.
▲
Strong Dynamic Type Checking for JavaScript
(fosdem.org)
2 points
by
polyrand
4y ago
|
0 comments
190.
▲
Scalability is not your problem, getting people to use it is
(widgetsandshit.com)
2 points
by
polyrand
4y ago
|
1 comments
191.
▲
by
polyrand
4y ago
Awesome! I was just reading about pledge. I think I need to find some time to play around with it. Right now, there's a lot of interest in using WASM as a sandbox for untrusted code, but pledge looks easier to use and more versatile (y
192.
▲
by
polyrand
4y ago
I wonder if blink could be used as a lightweight sandbox. Looking at PR46[0], it seems sandboxing is not one of the current features, but it would be cool to have a way to run arbitrary code (e.g: Python) in a sandboxed environment. Even co
193.
▲
Amazon-Stripe partnership
(stripe.com)
258 points
by
polyrand
4y ago
|
151 comments
194.
▲
All about Search Suggestions
(spinscale.de)
1 points
by
polyrand
4y ago
|
0 comments
195.
▲
by
polyrand
4y ago
Interesting approach, thanks for sharing! If I understood correctly, a user query is first applied to the `SearchItem` table (using the `search_vector` field?). Then the returned `filters` are used to generate a normal (not full-text search
196.
▲
by
polyrand
4y ago
Yes, rename is atomic, but that doesn't get you very far. For example, if you want to do a partial update to a file, you need to copy the file (you already need more storage), edit the file and then rename it. But then you can't d
197.
▲
by
polyrand
4y ago
As others have pointed out, that benchmark is from 2017. However, the "SQLite: Past, Present, and Future" paper[0] has an updated version of this benchmark (see section 4.3 Blob manipulation), and also compares it with DuckDB. Edi
198.
▲
Build complex CI workflows using code
(github.com)
2 points
by
polyrand
4y ago
|
0 comments
199.
▲
by
polyrand
4y ago
I wonder why generated JSON is not used more widely, something like jsonnet[0], although I've never used it. Most systems come with Python 3 installed, which supports working with JSON[1] without installing any dependencies. So, I'
200.
▲
Querying SQLite Using Apache Arrow
(arrow.apache.org)
3 points
by
polyrand
4y ago
|
0 comments
201.
▲
Boring Data Tool
(github.com)
2 points
by
polyrand
4y ago
|
0 comments
202.
▲
PEP 703: Making the Global Interpreter Lock Optional in CPython
(github.com)
3 points
by
polyrand
4y ago
|
0 comments
203.
▲
by
polyrand
4y ago
The thing about automation is that it is really hard to automate workflows completely while getting everything right. One approach I like is the "Pareto automation"[0]. Normally, you can automate the most fragile or tedious parts
204.
▲
by
polyrand
4y ago
One thing that's missing from the article when comparing to `pigz` is that you can use the `-T0` flag in `zstd` and it will parallelize according to the number of CPUs. On some limited benchmarks, I found it to be much faster and worth
205.
▲
by
polyrand
4y ago
Hi, author of litexplore here! I agree remote management is the "least convenient" aspect of SQLite. If you have control over the remote VM where the DB is hosted, you can also run something like ClouDBeaver[0], Datasette[1] or sq
206.
▲
Libsqlfs: A Posix-style file system on top of an SQLite database
(github.com)
2 points
by
polyrand
4y ago
|
0 comments
207.
▲
by
polyrand
4y ago
You can write tests just like you would test a JSON API. But instead of testing the JSON structure, you can test the HTML structure. Depending on how deep you want to go, you can parse the HTML response and check for the components, but som
208.
▲
Important Optimizations to Apply in Your C++ Programs [video]
(youtube.com)
1 points
by
polyrand
4y ago
|
0 comments
209.
▲
Let’s use spreadsheets to rewire apps and make new ones
(interconnected.org)
6 points
by
polyrand
4y ago
|
0 comments
210.
▲
All in with Nuitka
(nuitka.net)
289 points
by
polyrand
4y ago
|
77 comments
More ›