HNHacker News
TopNewBestAskShowJobs

stilisstuk

150 karma · joined November 20, 2019

submissionscomments
stilisstuk··on Migrating to SQLAlchemy 2.0
Why is nobody ever writing raw SQL? I've never understood why ORMs are sine qua min.
stilisstuk··on R Markdown: The Definitive Guide
Hmmm... I've always found tideverse syntax inelegant. Data.table syntax does more with fewer different words. But it can get a bit convoluted. Any ways: there are different ways to solveing problems and writing code. Should we not encourage this? Otherwise it's just cargo cult again and again.
stilisstuk··on Protonmail was down
I never understood why people love proton so much. I pay less for more features (e.g. catch all and calendar) with mailfence. And mailfence just seams more honest and less theater like (no cryptocurrency, no vpn, no 1000 meters if granite. Just pgp and metadata removal.)
stilisstuk··on The Economics of Christmas Trees
I am going to buy a replantable pottgrown tree this year. I've read plastic trees needs to be used 14 years in order to be more eco friendly than cutting a new tree every year.
stilisstuk··on Librem 5 Mass Production Phone Has Begun Shipping
Why don't you think it'll be your daily driver, if I may ask?
stilisstuk··on Zero-Days in Desktop Web Browsers
Why is that interesting? It reflects number if users, not breeder security?
stilisstuk··on Deprecating scp
Correct
stilisstuk··on The High Privacy Cost of a “Free” Website
A alternative to disquss, good for static websites https://posativ.org/isso/
stilisstuk··on Tell HN: Never search for domains on Godaddy.com
Agreed. Plus whoisprivacy is free if the tld supports it. Autorenewal is nice also. Only gripe is that they use authy for 2fa. This is a big gripe though.
stilisstuk··on I Denmark you cant trust the intelligence service, whistle blower reveals
It's the first line, the heading, of the press release (1).

> PRESS RELEASE The Danish Intelligence Service completes special investigation of the Defense Intelligence Service (FE) on the basis of material submitted by one or more whistleblowers In November 2019, the Danish Intelligence Service came across one or more whistleblowers in possession of a significant amount of material concerning FE, which the Authority has not had so far. knowledge of or opportunity to provide. The material is of such a nature that the Authority decided to focus its control of the FE in order to carry out an in-depth investigation of the present circumstances. With this announcement, the Authority publishes the unclassified results of the investigation. On the basis of the Authority's investigation of the submitted material, the Authority submitted an analysis in four volumes to the Minister of Defense on 21 August 2020, containing the Authority's conclusions and recommendations. Throughout the process of the special investigation of FE, the Authority has kept the Minister of Defense informed. The Minister of Defense has regularly expressed support for the Authority's in-depth examination of the material. The Authority's assessments and recommendations deal with matters which are wholly or partly assessed to be within the Authority's legality control in accordance with the FE Act and rules issued pursuant thereto, as well as matters which the Minister in the Authority's opinion should be aware of, cf. section 16 of the FE Act. , PCS. 2. Based on a source-critical approach to the study

Conclusions

> That FE has on several occasions since the Authority's establishment in 2014 and until the summer of 2020 - in connection with, among other things, the Authority's specific inspections and meetings with the head of FE - withheld key and crucial information for the Authority and provided the Authority with incorrect information regarding the service's collection and disclosure. of information. It is the opinion of the supervisory authority that the statutory duty to provide information is absolutely necessary for a functional supervision, and that it rests on the trust of the legislator that the FE complies with the obligation in all respects. The result of these repeated breaches of the statutory duty to provide information is that the legality check which the supervision under the FE Act is required to carry out and which contributes to the legitimation of FE's business, does not work as intended.  That at central parts of FE's collection capacities there are risks that collection can be made unjustifiably against Danish citizens.  That the submitted material indicates that FE's management has failed to follow up on or further investigate indications of espionage within the area of the Ministry of Defense.  That there is an inappropriate culture of legality in FE's management and parts of the service, where the service's any unjustified activities or inappropriate conditions are sought to be shelved, including by failing to inform the supervisor of matters relevant to its control.  That the submitted material indicates that FE before the supervision was established in 2014 has initiated operational activities in violation of Danish law, including by obtaining and passing on a significant amount of information about Danish citizens.  That the FE has unjustifiably processed information about an employee in the supervision.

(1): https://www.tet.dk/wp-content/uploads/2020/08/PRESSEMEDDELEL...

stilisstuk··on Telegram messaging app proves crucial to Belarus protests
> If you won't use Signal, I'm going to force a downgrade to SMS or email, and then you get even worse security and privacy.

Or we will set up e2e encrypted telegram. Or not talk.

> What if I have a very good memory, and follow conversations by writing up their details

You saying that you remember I said something, even took a screenshot vs you can prove I said something, is a big difference.

If I am doing a snowden, I might go to a sauna. If I am planning to overthrow my boss, I think e2e telegram is okay. Because I can delete the conversation it might even be preferable to signal.

Use cases and threat models...

stilisstuk··on Telegram messaging app proves crucial to Belarus protests
What if only the other partys messages where deleted?

In telegram it is understood that 'secret chats' constitutes confidentiality. As such, both parties, I believe, ought to be able to delete everything.

I kind of see you point about non-secret chats.

But then we are back with a opt-in model for privacy.

Personally: what I tell you at the coffee machine, in confidence or not, is ephemeral. I would probably not talk to you at all if you where taperecording all conversations, as you want to do with messages... so I think both.parties.should be able to delete text conversations. And privacy should be on by default.

stilisstuk··on Degoogle: Cutting Google out of your life
Not an alternative, bit insidious is aborter frontend to YouTube... and om Android there is newpipe.

However, for me, the problems are: Maps. Google Maps are great. Calendar: my calender provider online has ICS calendar sharing, not e.g. itip.and imip.

stilisstuk··on Telegram messaging app proves crucial to Belarus protests
There are two parties in a conversation. Both 'own' the conversation. Both have a 'veto' right.
stilisstuk··on Apache Arrow 1.0
Say I have a 50GB (bigger than RAM) CSV file I want to analyse locally with R. Can I somehow use Apache arrow for that?
stilisstuk··on Hackers take over prominent Twitter accounts in simultaneous attack
Inkl bite: lets say I hack capable of doing this. How do I sell my hack?
stilisstuk··on Mozilla VPN
I feel a bit different: Email is a standard. You are talking about an app. Send later is the job of the application,not the standard. Same with reply all. Intelligent priority inbox is _hard_ but i. Principle the same.

When you use gmail you conflate the standard with the app.

stilisstuk··on Massive spying on users of Google's Chrome shows new security weakness
I love that my it departement has turned off password saving, citing security concerns. But there is no problem in downloading any and all extensions.
stilisstuk··on Create diagrams with code using Graphviz
Dokuwiki has a very usefull graphviz plugin. https://www.dokuwiki.org/plugin:graphviz
stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
In a private chat... thats a feature. Imo
stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
But I can't go back and delete a message. I can prepare to delete the next message. Not, a message.
stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
Disappearing messages are per thread. In telegram i can choose to 'disapear' single messages.
stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
My threat model with nudes are different from my whistle blowing.

Signal also makes trade offs in order to het crypto to the masses.

stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
Definately not the same. For a better snapchat—like feature, where you want reasonable protection against your coms partner telegram is way better. Also protects you from screenshots etc (again: reasonable privacy relative to threat model)
stilisstuk··on Show HN: TrashEmail – Telegram-based disposable mail service
But e.g. signal don't have the feature where either party of a conversation can delete messages on both phones. This is possible with telegrams secret chat. And its great.
stilisstuk··on DuckDB: SQLite for Analytics
Yes off course. It humbles me. I thought i've dealt with pretty big data, but with no need to be speedy, clearly. Thx
stilisstuk··on DuckDB: SQLite for Analytics
Thanks..reading the link.

Edit: really interesting. That makes sense. But also a very strict set of requirements.

Thanks.

stilisstuk··on DuckDB: SQLite for Analytics
Okay. So its a matter of optimising for speed. Since my work requires flexibilty we just try to approximate normalization (I'm not strong on 1St, 2nd etc) - I guess what you describe a t2. Even with milions of rows its normally pretty fast to aggregate rows for e.g. one customer. Depending on the complexity. It might.take a few seconds.to.filter by delivery.method, group by payment etc...

But any ways... it seems to me, one would allways design for flexibilty (t2). And then just create views for the special cases you describe?

stilisstuk··on DuckDB: SQLite for Analytics
Can someone point me to what OLAP is? I've read the wiki page, but don't get. All the databases I have worked with are multidimenaional.(i.e. complex erp systems with 100's of tabled joined together in various ways). Granted most of my analytical work is done in R, after performing queries.

But I've never had the need for 'special sql'.

Is this 'cubes' all over? I understand cubes as basically views precalculated to perform faster on mostly to charge more?

But OK... If need to work on datasets bigger than e.g. 5 GB you begin to eat RAM fast. Is this the use case? Then why not simply say that?

stilisstuk··on Firefox extensions to make remote work and school a little better
I stil think profiles (personas in chrome) are better and more flexible. I can completely have different browsers, extensions, themes, for different contexts. This beats containers for me.

Firefox --no-remote

← PreviousPage 2 of 4Next →