HackerLangs
TopNewTrendsCommentsPastAskShowJobs

dimitar

no profile record

Submissions

SQLite in Production? Not So Fast for Complex Queries

yyhh.org
4 points·by dimitar·5 เดือนที่ผ่านมา·0 comments

comments

dimitar
·19 วันที่ผ่านมา·discuss
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 วันที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
I'm an employed emacs user and more than half of my team also uses emacs
dimitar
·9 เดือนที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
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 เดือนที่ผ่านมา·discuss
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 ปีที่แล้ว·discuss
Clojure has a focus on concurrency, is functional and it embraces JS and Java, the dominant platforms.