Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
antender
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
antender
3y ago
This is not exactly true, QUERY pseudoSQL is available, but as a separate API not listed in Sheets Docs: https://developers.google.com/chart/interactive/docs/queryla... I used it as a DB for Cloudflare Worker
2.
▲
by
antender
3y ago
In case of client-server databases one alternative that works great is to open an ssh tunnel using "ssh -L" and just connect using gui tool to it.
3.
▲
by
antender
3y ago
Yep, in Russian xerring (ксерить) sounds way better because "ox" part is rarely used in native words.
4.
▲
by
antender
4y ago
We already had serverless db for ages and it's called ... Google Sheets. You can even query it with simple SQL-like language. The problem with most other "serverless" databases is that they don't offer HTTP API to query
5.
▲
by
antender
5y ago
Good job, Mastercard (and Visa)! Now all people opposing Putin and trying to gather money for leaflets will have to use state-created MIR instead. Putin will be pleased!
6.
▲
by
antender
5y ago
Basically I think this syntax addition is nonorthogonal, isn't making SQL any more powerful, but isn't solving the main usability problem, which is composability of queries in any way. Like writing JOIN's is not complicated i
7.
▲
by
antender
5y ago
The issue, as i see it, is that adding this feature complicates the language parser even more for not that much actual gains. 1) Implementation has to do some nontrivual rewriting into actual JOIN's which uses indexes, previous specia
8.
▲
by
antender
5y ago
I, personally, feel like this is a rather pointless addition to an already somewhat bloated language. It it isn't saving that much typing (we have NATURAL JOIN's already, nobody is using them), is kind of inconsistent with other l
9.
▲
by
antender
5y ago
Java is for pussies, in Javascript you don't even give ***** if it is literally "null" or "undefined".
10.
▲
by
antender
5y ago
Yeah, and it's not even the funniest one of a bunch of different phrases. I really prefer adding dogs instead of horseraddishes: "да и пёс с ним".
11.
▲
by
antender
5y ago
There is also an interesting solution to this problem: use native WebView, so you don't have to pack the whole Chrome with your app. Basically every "electron alternative" with HTML+CSS+JS works this way. https://g
12.
▲
by
antender
5y ago
Basically, the site is rebranding as OnlyBans :)
13.
▲
by
antender
5y ago
You mean something like Hyperdrive (formerly Dat) + Beaker browser?
14.
▲
by
antender
5y ago
This article is like reading Gulliver's Travels Part III: A Voyage to Laputa, but as a real-life thing. Can't stop laughing!
15.
▲
by
antender
5y ago
Also, from the point of query optimisation this is a really bad idea. Usually you DO actually care about size of fields in SQL databases, because something like BOOLEAN is usually stored as single byte (or bit in a bitfield) vs 4 bytes or e
16.
▲
by
antender
6y ago
If we follow the logic of the article's author to the end, then JS doesn't have this problem either. You can await on non-Promise values, so can just say that everything is red, add await to every function call and call it a day.
17.
▲
by
antender
6y ago
Can a goat in the swarm catch a random virus from the Web? What's your policy on replacing dead instances and replication?
18.
▲
by
antender
6y ago
Also "split views", //TODO comments and focusing on one task at a time help a lot.
19.
▲
by
antender
6y ago
Personally I have an opposite problem of thinking too much about work after hours, but in case I really need to remember something it is written into notepad or note taking app. All modern text editors after introduction of Sublime Text (I
20.
▲
by
antender
6y ago
BTW, first version of Redis was actually built in equally slow TCL and later rewritten in C.
21.
▲
by
antender
6y ago
I provided all the data he needs to prove my theory (in previous linked issue) and his theory (in this issue). And now i'm the bad guy. Really? BTW, specific VM settings doesn't matter for the purpose of issue replication, the pro
22.
▲
by
antender
6y ago
The maintainer is just closing this issue and all related with his own network-"hacking" theory without proving it by himself and having 0 arguments supporting it in the first place. I started this discussion with arguments in fav
23.
▲
by
antender
6y ago
Proof was in description. Maintainers claimed that problem wasn't related to image but rather to infrastructure, so we changed the base image to prove that infrastructure was totally fine. Also i personally don't actually care tha
24.
▲
Docker hub image for PostgreSQL version 12.4 contains cryptominer
(github.com)
4 points
by
antender
6y ago
|
7 comments
25.
▲
by
antender
6y ago
I know that using public docker images is a problem by itself, but this one is "official" in Docker Hub ...
26.
▲
by
antender
6y ago
After consulting with GNU sort manual: sort has -m option just for the case of merging presorted files, so you can test this by using 'split -l', then 'xargs sort' (to parallelize), then 'sort -m' to merge chun
27.
▲
by
antender
6y ago
Was there any external requirement to specifically sort this file in-memory only? Why not just split the file into chunks (around 100MB), sort them as usual, and then k-way merge sort them after that. This, in theory, can be faster than all
28.
▲
by
antender
6y ago
http://pythonanywhere.com This guys specialize in python hosting and have a free tier
29.
▲
by
antender
6y ago
Refcounting can mess with caches in multithreaded scenarios, so results aren't really surprising to me. It also generates unnecessary work to maintain counters on all writing threads, while concurrent tracing GC batches all its actions
30.
▲
by
antender
7y ago
Python, actually, is older than Euphoria. :) The cool part is the focus on cache-local data structure first. Way more popular scripting languages like JS and Lua use hash tables as their primary data structures, Python and Ruby offer arrays
More ›