JoelJacobson

12 ms·

91.
by JoelJacobson 5y ago
Maybe by also changing the voting method to secret ballot? A poor country would then have no incentive to actually vote for the crazy idea, as they would not be able to present proof of their vote in favor of the crazy idea, and could there
92.
Let's democratize the United Nations and make it relevant again
12 points by JoelJacobson 5y ago|21 comments
93.
by JoelJacobson 5y ago
Back in 2021-10-06 when I bought mines, they were crazy expensive! I paid 89239 SEK (~9349 USD) +25% VAT = 111549 SEK (~11685 USD) per unit. Not sure about the VAT rate if buying from US. Hopefully they have reduced the prices since then, n
94.
by JoelJacobson 5y ago
I live in Sweden (country with severe darkness) and just bought two Virtual Sun united from https://innerscene.com/ NOTE: Be extremely careful when transporting/moving these units, they easily break. The supplier who
95.
by JoelJacobson 5y ago
It would be interesting to read the thread if you could please share a link to it?
96.
by JoelJacobson 5y ago
I think this old proposal contains some interesting ideas, such as: “2.5 Mapping of version 4 numbers Initially, all existing Internet numbers are defined as belonging to the NSF/Internet AD, number 192.0.0.” This means you could keep
97.
IPv7 (1993)(rfc-editor.org)
2 points by JoelJacobson 5y ago|1 comments
98.
by JoelJacobson 5y ago
I would prioritize fixing the support for WebAuthn resident keys: https://bugzilla.mozilla.org/show_bug.cgi?id=1530370
99.
1000+ PostgreSQL EXTENSIONs(gist.github.com)
5 points by JoelJacobson 5y ago|0 comments
100.
List of PostgreSQL Extension Repos(github.com)
2 points by JoelJacobson 5y ago|0 comments
101.
by JoelJacobson 5y ago
https://github.com/immunant/c2rust : > We rely on Emscripten's Relooper algorithm to translate arbitrary C control flows. Article on why Relooper isn't good enough and the superior Stackifier algorithm, whi
102.
by JoelJacobson 5y ago
cube222, does the schema above look more or less correct to you? Below are the query plans I got when running the query against empty tables in PostgreSQL 15dev (not Aurora Serverless), for comparison. Would be nice to populate the tables a
103.
by JoelJacobson 5y ago
Deduced schema based on the naming of tables/columns: CREATE TABLE accounts ( id bigint NOT NULL GENERATED ALWAYS AS IDENTITY, max_public_parallelism integer NOT NULL, PRIMARY KEY (id) ); CREA
104.
by JoelJacobson 5y ago
Hi Jacob, I would like to try rewriting your query using different JOIN FOREIGN [1] syntax alternatives, to study how readability is affected. It would help if you could share the table definitions and foreign keys for the tables involved i
105.
by JoelJacobson 5y ago
There are multiple alternative syntaxes suggested in the proposal, one of them doesn’t use foreign key names, but instead the foreign key column names, similar to USING (), but without the ambiguity: https://gist.github.com/
106.
by JoelJacobson 5y ago
> 2) adding new functionality requires addition of new keywords There are reserved keywords and unreserved keywords. The latter can be used as table/column/function/etc names, and don’t cause any trouble. New syntax can be
107.
by JoelJacobson 5y ago
> and annoying to do the correct thing (joining on the defined foreign keys). Maybe you’ve seen this thread already; a proposal with some alternatives on how to improve the situation for joining in foreign key columns, but in case not he
108.
by JoelJacobson 5y ago
For reference, here is my PostgreSQL extension implementation of CBOR and WebAuthn: https://github.com/truthly/pg-cbor https://github.com/truthly/pg-webauthn
109.
by JoelJacobson 5y ago
I think CBOR could be one of the reasons why WebAuthn unfortunately hasn’t gained more popularity. Would have been much easier for all parties if they would have simply used JSON and base64 or hex to encode/decode binary data. I implem
110.
by JoelJacobson 5y ago
I have no idea. I was thinking about the Tesla Roadster and Tesla Semi, two products delayed with years and counting. I pre-paid the Tesla Roadster in full 2018-06-14 and was expecting it to be delivered in 2020, so every new Tesla project
111.
by JoelJacobson 5y ago
Not so sure about the "faster" part in that sentence. I think Tesla could possibly have too many parallel projects in the pipe already.
112.
by JoelJacobson 5y ago
Great idea! The data model and code describe in "4.2 Scheduling Studies" is very similar to a PostgreSQL stored procedure scheduler system we've written to parallelize large UPDATE/INSERT ... SELECT jobs, parallelizable
113.
Poll: JOIN FOREIGN
2 points by JoelJacobson 5y ago|1 comments
114.
by JoelJacobson 5y ago
1) JOIN FOREIGN fk_alias.fk_name (original proposal)
115.
by JoelJacobson 5y ago
2) JOIN table FOREIGN fk_alias.fk_name REF pk_alias
116.
by JoelJacobson 5y ago
3) JOIN table FOREIGN fk_name [ FROM | TO ] alias
117.
by JoelJacobson 5y ago
4) JOIN table FOREIGN (fk_col, ...) [ FROM | TO ] alias
118.
by JoelJacobson 5y ago
5) Some other syntax
119.
by JoelJacobson 5y ago
6) Status quo
120.
by JoelJacobson 5y ago
1) JOIN FOREIGN fk_alias.fk_name (original proposal)

More ›