HackerTrans
トップ新着トレンドコメント過去質問紹介求人

dimitar

no profile record

投稿

SQLite in Production? Not So Fast for Complex Queries

yyhh.org
4 ポイント·投稿者 dimitar·5 か月前·0 コメント

コメント

dimitar
·20 日前·議論
There is an interesting technical reason why its a challenge (and they can't just swap in a supported library):

> What makes the “simulate inputs” approach work is that the engine takes utmost care to keep calculations identical on each client. This is not trivial because you still have to work with things that naturally differ on each client, such as mouse position or which units are selected - this is called the unsynced state. On top of that, there can be hardware differences that have to be worked around to get identical results - the huge effort involved is one of the reasons why Recoil is not available outside x86-64.

https://recoilengine.org/articles/netcode-overview/
dimitar
·28 日前·議論
It doesn’t have to be the leading countries, if the EU allows it, it is good enough to create a market for distilled models
dimitar
·3 か月前·議論
It is!

And also it has inspired a few other clojure datalog databases, so there is much more choice: * https://github.com/datalevin/datalevin * https://github.com/replikativ/datahike * https://github.com/threatgrid/asami

There is also xtdb, but it abandoned datalog and is going in another (albeit interesting direction) https://xtdb.com/

here is a comparison website, but it is somewhat out of date: https://clojurelog.github.io/
dimitar
·6 か月前·議論
Data oriented in clojure slang means modeling things in data structures like hashmaps and clojure sets as opposed to defining classes and types. The language encourages you to do it and provides a lot of built-in functions to work with them.

So it must have tools save, manipulate and visualize conveniently (pretty printing, folding etc) the values of vars that contain nested maps, sequences, sets, etc.

Existing clojure IDEs like CIDER for emacs or Calva for VSCode do that too, and it is a must have to have a nice experience with the language
dimitar
·9 か月前·議論
I'm an employed emacs user and more than half of my team also uses emacs
dimitar
·9 か月前·議論
Indeed! I went back just to mention it owes its incredible UX to the transient package, I am going to look up more uses for it. Do recommend more if you can, please!
dimitar
·9 か月前·議論
I think Emacs still does all of this; the argument the author makes is that it is "arcane", it just uses conventions he is not used to. It is however fully self-documented and interactive.

For me the best textual interface I've ever used remains Magit in Emacs: https://magit.vc/ I wish more of Emacs was like it.

I actually use emacs as my git clients even when I'm using a different IDE for whatever reason.
dimitar
·10 か月前·議論
30s might be the threshold for me; any more than that it is distracting; since this is a laptop I might open it just to check my email for example
dimitar
·10 か月前·議論
How quickly does your laptop start? I like this idea a lot, I am now going down the rabbithole of finding which distributions boot the fastest (I remember this mattered a lot to linux users about 20 years ago)
dimitar
·7 年前·議論
Clojure has a focus on concurrency, is functional and it embraces JS and Java, the dominant platforms.