Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Arch-TK
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
58 ms
·
901.
▲
by
Arch-TK
4y ago
It's all great to quote Gabe Newell but you are completely misunderstanding his point. The point is that the steam platform makes it so easy to buy and play games that pirating them is comparatively risky (chance of malware, lack of up
902.
▲
by
Arch-TK
4y ago
You know what reassures me that nothing has gone wrong? When unexpectedly I am greeted with big white text insisting everything is okay. Imagine if you got a letter through the post out of the blue saying "You don't have cancer.&q
903.
▲
by
Arch-TK
4y ago
You know, this tendency to call things which are not actually ORMs ORMs reminds me a lot of the tendency for a lot of "multi paradigm" languages to claim they support OO while actually not supporting true OO (whatever that really
904.
▲
by
Arch-TK
4y ago
What's so weird about this article is that the author recognizes that querying KV databases and querying relational databases is not the same thing and trying to overlay relational semantics over a KV database causes problems but then
905.
▲
by
Arch-TK
4y ago
I name all my machines after a theme, unlike a major organisation I don't have the money to have dns-server-0 and dns-server-1 which ONLY host an authoritative pair of DNS servers and then web-server-0 which ONLY hosts my website etc
906.
▲
by
Arch-TK
4y ago
I'm pretty sure the way NHS dental care works in the UK is basically broken and I'm not sure I trust any dental practice which relies solely on NHS income. Let me tell you why: This can be a bit fuzzy and I may make a mistake here
907.
▲
by
Arch-TK
4y ago
>[0] https://www.techpowerup.com/download/ryzen-dram-calculator/ Why on earth is this a binary program? Is there a document online which explains the maths or just implements it in javascript? I don't feel
908.
▲
by
Arch-TK
4y ago
If you don't need long options and don't want to use getopt (for whatever misguided reason) then I wrote a (rare) blog post about doing this without any macro abuse: https://the-tk.com/post/2021/07/2
909.
▲
by
Arch-TK
4y ago
This is a major abstraction leak and is very rarely as simple as you describe it. The only time I've seen it be this simple is with people who design their databases entirely around an ORM and in that case they're already leaving
910.
▲
by
Arch-TK
4y ago
Try re-creating a relational database in a graph database or vice versa by applying this approach and report back. I promise you that if you put a graph in a SQL database or vice versa you will end up with absolutely abysmal performance unl
911.
▲
by
Arch-TK
4y ago
How is it avoidable? It's a necessary part of using an ORM. Moreover, you're severely understating the complexity of dealing with how to load data through an ORM and how to control the underlying queries. SQL is already a perfectl
912.
▲
by
Arch-TK
4y ago
Sets of tuples and graphs of objects are fundamentally incompatible and I have not found a single ORM which didn't completely fail to pave over this fundamental incompatibility. The object-relational impedance mismatch is not just some
913.
▲
by
Arch-TK
4y ago
And an ORM which eagerly loads all related data before it is accessed will have a different but related problem. I'm actually not aware of any ORM which tries to do more than trivial guessing of when data needs to be eagerly loaded. Th
914.
▲
by
Arch-TK
4y ago
If you intentionally write poor code with plain SQL you will have the same problem as the auto-generated poor code of a lot of ORMs? Yes? I don't think Wordpress is relevant here in any way. If the code is poorly written and has N+1 qu
915.
▲
by
Arch-TK
4y ago
If you simply don't attempt to shoehorn your data into a graph structure then you don't need an ORM in the first place. ORMs only make development easier insofar as you insist on turning your relational data into graphs. In all in
916.
▲
by
Arch-TK
4y ago
This is specifically just a problem with all ORMs. They attempt to solve the object-relational mismatch and fail because these two concepts (sets of tuples and graphs) are completely orthogonal.
917.
▲
by
Arch-TK
4y ago
With SQLite there is no "database process" unless you are explicitly only using a dedicated process to make the queries through which isn't necessary with SQLite anyway. That being said, the problem here is not whether N+1 is
918.
▲
by
Arch-TK
4y ago
I think a good place to start is to mostly ignore most/all the advice in this thread. I haven't obviously read every response but I have struggled to find any response near the top which isn't recommending something which wil
919.
▲
by
Arch-TK
4y ago
> Please do tell, how is it hilariously wrong? It copies from user, and then copies to user, back into the const it got. I don't even know if this would compile but certainly nobody would expect the buffer they just wrote to a file
920.
▲
by
Arch-TK
4y ago
It rarely happens in for-profit situations but people are slowly wisening up to the cost of technical debt for longer term projects especially.
921.
▲
by
Arch-TK
4y ago
It's unfortunate that you have only ever experienced abstractions which grow in size over time. The best abstractions out there are ones which operate well together to solve a large set of problems in the smallest amount of complexity
922.
▲
by
Arch-TK
4y ago
Aside from the boilerplate, which it got mostly right as far as I can tell, the actual logic is hilariously wrong. Moreover, Linux kernel development really isn't just writing stand-alone self contained chardev drivers which calculate
923.
▲
by
Arch-TK
4y ago
3, 5 and 7 seem awfully pessimistic no?
924.
▲
by
Arch-TK
4y ago
I am a big fan of C, for all its faults, it's the language I have by far the most experience in, I have read multiple standard revisions multiple times at this point and regularly advise people on their understanding of the standard an
925.
▲
by
Arch-TK
4y ago
What are you on about? C/C++ was first standardized in the fractional year 1989/1998 in the (ANSI X3.159-1989)/(ISO/IEC 14882:1998) standard.
926.
▲
by
Arch-TK
4y ago
While it is likely that the issue affecting OpenSSL is memory safety related, how do you know for sure that it is and that rust would have prevented it without having a performance impact? While a language which prevents certain memory erro
927.
▲
by
Arch-TK
4y ago
Looks nice but runs extremely slowly.
928.
▲
by
Arch-TK
4y ago
Naming your executable shell scripts with .sh has similar problems to Hungarian notation. If your ~/.local/bin shell script ends up useful in a lot of places, you may want to re-write it in something less crap (and I say that as a
929.
▲
by
Arch-TK
4y ago
Yes, I can do everything via the website. But I must use a secure key dongle pinpad thing to log in.
930.
▲
by
Arch-TK
4y ago
At least so far my bank hasn't prevented me from using my web browser on linux to access the banking website. But I am certain they will once Windows 11 gets enough traction in a few years.
More ›