Const-me

6 ms·

31.
by Const-me 7mo ago
> no variable-length columns Both varchar and varbinary columns work fine there. Blobs are indeed missing. > data loss on restart That’s OK, collections in memory do as well yet we use them pretty much everywhere. > Unlogged tables
32.
by Const-me 7mo ago
I like engine=memory tables. Compared to data structures found in programming languages, memory tables are more powerful: arbitrary columns, indices. The DB server solves concurrency with transactions and row-level locks; need B-tree primar
33.
by Const-me 7mo ago
I like the article, but why PostgreSQL specifically? I have recently needed some of these features in a server, MariaDB did the job reasonably well.
34.
by Const-me 8mo ago
> very small percentage of people to use the torrent over the direct download BitTorrent protocol is IMO better for downloading large files. When I want to download something which exceeds couple GB, and I see two links direct download a
35.
by Const-me 8mo ago
You’re welcome. Sadly, I don’t know how to observe ARM assembly produced by Prism. And one more thing. If you test on an AMD processor, you will probably see much less profit from FMA. Not because it’s slower, but because SSE4 version will
36.
by Const-me 8mo ago
> AVX2 level includes FMA (fast multiply-add) FMA acronym is not fast multiply add, it’s fused multiply add. Fused means the instruction computes the entire a * b + c expression using twice as many mantissa bits, only then rounds the num
37.
by Const-me 8mo ago
> but nobody is using it! What does that say? It’s impossible to replace JS with WebAssembly because all state-mutating functions (DOM tree manipulation and events, WebGL rendering, all other IO) is unavailable to WebAssembly. They expec
38.
by Const-me 8mo ago
> What if you have two different project with different requirements at the same time? Install multiple versions of Windows SDK. They co-exist just fine; new versions don’t replace old ones. When I was an independent contractor, I had 4
39.
by Const-me 8mo ago
> run games through a Proton-like shim even on Windows Already happening, to an extent. Specifically, modern Intel GPUs do not support DirectX 9 in hardware, yet legacy apps run fine. The readme.txt they ship with the drivers contains a
40.
by Const-me 9mo ago
> It was never the right choice for API payloads and config files Partially agree about API payloads; when I design my APIs I typically use binary formats. However, IME XML is actually great for config files. Comments are crucial for con
41.
by Const-me 9mo ago
Software developers might be majority here in HN comments, but definitely a small minority across general population. A lot of people are negatively affected by AI: computer hardware is expensive because AI companies bought all memory, Wind
42.
by Const-me 9mo ago
I have a hypothesis why issues like that are so widespread. That AI infrastructure is mostly developed by large companies; their business model is selling software as a service at scale. Hence containers, micro-services, TCP/IP in betw
43.
by Const-me 9mo ago
> you can get a performance improvement by calculating A, B, and C in parallel, then adding together whichever two finish first Technically possible, but I think unlikely to happen in practice. On the higher level, these large models are
44.
by Const-me 9mo ago
> if they are stored unpowered for a couple of years, then you clearly aren't doing regular backups I am doing regular backups yet I have a few backup disks unpowered for years. They are older, progressively smaller backup HDDs I ke
45.
by Const-me 9mo ago
Flash drives are less than ideal for backups. I think when they are stored cold i.e. unpowered, flash memory only retains data for a couple of years. Spinning hard drives are way more reliable for the use case.
46.
by Const-me 9mo ago
> keeps on nudging me to use Onedrive At least on Windows 10, you only have to decline once, here’s how. Ctrl+Shift+Esc to launch task manager, “Startup” tab, right click on “Microsoft OneDrive”, select “Disable” from the context menu, t
47.
by Const-me 9mo ago
> How large is large? About the same size as amount of physical memory. For Word 97, minimum system requirement was 8MB RAM. That’s not just for the word, also the entire OS. > Loading and saving a few GiB from my SSD is pretty fast I
48.
by Const-me 9mo ago
> to know "what is clearly a bug" 100% of the time in projects you don't own Owning a project is counter-productive for QA. If it’s your project, you know where to click and where to not click. OTOH, you don’t need to know
49.
by Const-me 9mo ago
> What if you don't know ahead of time how big that monitor is that you are displaying stuff on? Use a reasonable upper estimate? > ad-hoc re-implementation of virtual memory? If you rely on actual virtual memory instead of speci
50.
by Const-me 9mo ago
It’s technically possible to do, just very complicated and hard. Quite often, prohibitively so. Still, the main idea is despite the input files are arbitrarily large, you don’t need an entire file in memory because displays aren’t remotely
51.
by Const-me 9mo ago
I did forget to mention something important. Since about Vista, Microsoft tends to replace or supplement C WinAPI with IUnknown based object-oriented ones. Note IUnknown doesn’t necessarily imply COM; for example, Direct3D is not COM: no ID
52.
by Const-me 9mo ago
> versioned symbols are a thing on Windows There’re quite a few mechanics they use for that. The oldest one, call a special API function on startup like InitCommonControlsEx, and another API functions will DLL resolve differently or beha
53.
by Const-me 10mo ago
> there are source generators Last time I tried them discovered source generators in the current .NET 10 SDK are broken beyond repair, because Microsoft does not support dependencies between source generators. Want to auto-generate COM p
54.
by Const-me 10mo ago
A new keyboard for X1 Carbon 7th gen is available on e-bay for the price of $50-100. A faulty keyboard is IMO not a good reason to replace a whole computer.
55.
by Const-me 10mo ago
> it cannot be faster than normalization alone Modern processors are generally computing stuff way faster than they can load and store bytes from main memory. The code which does on the fly normalization only needs to normalize a small w
56.
by Const-me 10mo ago
> I'm genuinely surprised Microsoft's attitude towards "wndprocs don't have a context pointer" They designed windows classes to be reusable, and assumed many developers going to reuse windows classes across windo
57.
by Const-me 10mo ago
I find WSL 1 incredibly useful. C++ and .NET compiler toolchains, ssh and scp clients, and many other command-line Linux tools are working flawlessly for me despite the fake emulated kernel lacking some of the APIs. When I develop anything
58.
by Const-me 10mo ago
Hey, Katie. Just FYI, last week I paid $250 to your competitor after being unable to pass your identity verification. BTW, your web site didn’t even offer me an option to verify ID with a Paypal payment.
59.
by Const-me 10mo ago
> the api and the different ways everything has to be fed for it leaves a lot to be desired I think Microsoft fixed that in Windows Vista by providing a higher-level APIs on top of IOCP. See CreateThreadpoolIo, CloseThreadpoolIo, StartTh
60.
by Const-me 11mo ago
You’re describing an edge case. Generally speaking, memory is only reused after old objects are deallocated. And here’s the relevant quote from the OP’s post: > Having all the intermediate calculations still available is helpful in the d

More ›