ak39

8 ms·

31.
by ak39 3y ago
LOL. What did this comment (no pun!) do for your HN karma points?
32.
by ak39 3y ago
SQLite not supporting "stored procedures" is a deal-breaker for me. The idea for stored procs is not to "put the process as close to the data" but simply that we have a single place for language-agnostic encapsulation of
33.
by ak39 3y ago
Paul MM Cooper's podcasts and video essays on YT are excellent. There's info on Mansa Musa in this episode: https://www.youtube.com/watch?v=GfUT6LhBBYs
34.
by ak39 3y ago
A whole new generation of developers is learning what the previous generation termed "briefcase applications". When client-server applications were the thing late 90s and early 2Ks, internet speeds were a serious limitation. This
35.
by ak39 3y ago
Slightly off-topic: The top Reddit response cites some good reasons why this may be so. The writer mentions they needed to move from Node to improve "throughput" (and .NET was suggested). In what way would .NET improve performance
36.
by ak39 3y ago
Does it handle stock splits, consolidations, dividends etc? Calculating returns (basically tracking growth) is a non-trivial problem.
37.
by ak39 3y ago
Always use surrogate primary keys. Use alternate keys (AK) for your "natural keys". Modify the AK business rules as and when needed. There are several advantages to using meaningless random integers, sequential integers or UUIDs a
38.
by ak39 3y ago
I’ve never truly used DISTINCT and felt comfortable for using it. Always felt using it revealed a design smell in my query. (Been doing SQL for 30 years and still!)
39.
by ak39 3y ago
2019?
40.
by ak39 3y ago
"Probably the fundamental problem here was a sub-optimal schema, but sometimes you're just working with what you've got. Plus a commenter on Reddit pointed out that if we used pure SQL functions instead of PL/pgSQL, we&#
41.
by ak39 3y ago
You can horizontally scale the database directly.
42.
by ak39 3y ago
"2. Push all your application logic into Postgres functions and procedures" Why are functions and procedures (an abstraction layer at db layer) considered harmful to performance when the same abstraction layer will be required at
43.
by ak39 4y ago
A few "give it time" replies is emblematic of the culture of "chalega" ("it will do") in Indian commerce. This is hardly what Apple will tolerate.
44.
by ak39 4y ago
100%. My projects are DevExpress heavy.
45.
by ak39 4y ago
Embarcadero insane pricing of Delphi is the reason I haven't continued beyond my old version Xe2. I guess they are making hay while the sun shines with the locked-in customers.
46.
by ak39 4y ago
Not being snarky: what's the risk of using UUIDs for session tokens if they are created by the server/db and are always verified by server (db) (for authorisation etc)?
47.
by ak39 4y ago
Same. Do you have any guess when this is likely going main branch?
48.
by ak39 4y ago
“That’s one heck of a nurse” after hitting the Nuke button which was right next to the “Nurse” button. Can you guess which music video that’s from?
49.
by ak39 4y ago
Thanks for this. I have yet to read Blood Meridian. I have read The Road and NCFOM. Both were great and absorbing reads. But I have one major gripe with CM (if I am allowed to do so). It's not his style - in fact it's his unique a
50.
by ak39 4y ago
And yet, after all these years, Svelte is a response precisely to that design philosophy: taking us back to accepting that two-way binding is nothing to be scared of. The endless loop of thinking in the JS community is expensive.
51.
by ak39 4y ago
And Svelte is a “reinvention” of Knockout, just requiring a precompile. (Not complaining at all, thank goodness we have such choices.)
52.
by ak39 4y ago
Well explained, thank you. When did "data binding" become "reactivity" (why the need to create a whole new lexicon for the same ol' thing)? A lot of this confusion (as per the OP) could have simply been explained aw
53.
by ak39 4y ago
Twice the effort wasn't implied as twice the speed. He just meant that going from 50% to 100% effort wasn't translating into double the speed.
54.
by ak39 4y ago
Serious question: why is the US trying to (or is already preventing) China from acquiring EUV chip tech? What’s the reason for such an aggressive intervention in a free market?
55.
by ak39 4y ago
Thanks for linking this. I've had this fruit before, fond memories of a childhood visit to Mumbai in early 80s. It's known by the Marathi speakers as "targolay". Its taste can be roughly described as a mix between a slim
56.
by ak39 4y ago
I wish I could write like this. This is music in words. Thank you.
57.
by ak39 4y ago
Delphi has legendary ARC not just with its VCL and object hierarchies with TOwner model but also with its wrappers of COM's IUnknown and QueryInterfaces. Yes of course, developers can still make mistakes about sequences and memory mana
58.
by ak39 4y ago
This is a fascinating topic, some of the comments are interesting too. I wonder whether some folks who knowingly or unknowingly use this technique to their advantage are the ones recently insisting the end to WFH and a return to the office?
59.
by ak39 5y ago
This is one of the most beautiful comments I have ever read. Thank you writing them.
60.
by ak39 5y ago
First attempt is 5. But anxiety levels were sky high. Throwback trauma.

More ›