ptrwis

9 ms·

61.
by ptrwis 5y ago
It is best to check the number of job offers for each framework. Angular and React are the most popular, much less for Vue and almost none for Svelte.
62.
by ptrwis 5y ago
When did you last use pgadmin4? It recently went through a big changes, in my opinion it's the best client for PostgreSQL.
63.
by ptrwis 5y ago
https://windows-internals.com/i-o-rings-when-one-i-o-operati... https://docs.microsoft.com/en-us/windows/win32/api/ioringapi...
64.
by ptrwis 5y ago
In example pgcrypto extension has a lot of functions, if you have more stored functions it might be worth to install pgcrypto in dedicated schema.
65.
by ptrwis 5y ago
Exactly, Oracle should be chosen when business logic is written in sql/plsql
66.
by ptrwis 5y ago
Look at their improvement (2x) in HTTP/RPS after moving to io_uring. It's not there yet though https://github.com/crystal-lang/crystal/issues/10740
67.
by ptrwis 5y ago
Yes, but look at the example in the blog post of this thread- "stat" depends on "file", "file" depends on "path". You can call defer in any order in your code, the language syntactically doesn't
68.
by ptrwis 5y ago
With defer it's developer's responsibility to free resources in right order, when one depends on another. Maybe something like this in Zig would be better: try std.fs.cwd().openFile(path, .{}) |file| : file.close() { &#x
69.
by ptrwis 5y ago
I did the approach with nesting jsonb_agg queries, it worked for me but was a bit hacky and sometimes complex. I hoped for Graph Query Language (the one supposed to be part of SQL standard) to make it easier to retrieve structred json from
70.
by ptrwis 5y ago
I thought that maybe at least PWA apps could be bundled this way, but I can't find anything about it
71.
by ptrwis 5y ago
Security was not the goal for software-isolated processes, but performance and getting rid of task-switches. Who knows, maybe this is what MS recently described as "next windows" (naive hope).
72.
by ptrwis 5y ago
With "Expr" it should be possible to built an ORM similar to Entity Framework, it allows to write elegant queries thanks to Expression Trees in C#.
73.
by ptrwis 5y ago
I don't like keyboard layout- lack of full-sized arrow keys and column of Home/PgUp/PgDn/End buttons on the right.
74.
Asynchronous and “direct” IO support for PostgreSQL(postgresql.org)
62 points by ptrwis 6y ago|0 comments
75.
by ptrwis 6y ago
Let's say they maxed out their former storage capacity of 24x3.8[TB]. For these 235millions of websites as they claim it's around 400kB per website.
76.
by ptrwis 6y ago
Stackblitz is great
77.
by ptrwis 6y ago
My general impression after reading between the lines over last years about Libra is they are targeting in-app micropayments and more like a competition to something like Paysafecard.
78.
by ptrwis 6y ago
How much effort of human mind is being lost to solve these ORM or JS frameworks problems. Programmers community is fighting with problems which at first should not even exist. With good tools we shouldn't even bother about them
79.
by ptrwis 6y ago
May I ask what fs did you use? Maybe F2FS would extend the life of the flash memory
80.
by ptrwis 6y ago
> A much bigger problem is #2. We need the result of the insert to know if a row was inserted or not. You can write a trigger on insert and make second insert there, or enclose first insert into CTE and then make second insert selecting
81.
by ptrwis 7y ago
pgAdmin4 is not that bad, I'm using it every day
82.
by ptrwis 7y ago
I dislike both. Most readable template syntax for me is PHP's "alternative syntax for control structures" (the one with colons instead of braces and closing keywords).
83.
by ptrwis 7y ago
For wrapping behaviour you need to add % symbol, like a+%b is wrapping addition.
84.
by ptrwis 7y ago
You can use syntax of the form vec1.add(vec2), which is still better than add(vec1, vec2)
85.
by ptrwis 7y ago
I would love to see now PostgreSQL going more into improving developer's expierience. Job queues, job scheduler, packages.