HNHacker News
TopNewBestAskShowJobs

samanator

404 karma · joined November 5, 2018

My name is Shmuel Kamensky. My email is my first name and then my last name at gmail.
submissionscomments
samanator··on What the First Amendment says – 4 basic principles of free speech in the U.S.
"First they came for the Communists... Then they came for me And there was no one left To speak out for me"

- Martin Niemöller

One man's hate speech is another man's freedom of expression. Who will arbitrate the definition of hate speech?

What if you don't agree with their definition? What if saying you don't agree with their definition also gets labeled as hate speech by the arbitrator?

It's a slippery slope...

samanator··on 2009scape
Source code for the server:

https://gitlab.com/2009scape/2009scape

samanator··on SQLedge: Replicate Postgres to SQLite on the Edge
How does this work with custom postgres types?
samanator··on Google Maps has become an eyesore
> Yet no matter how far in I zoom in, Google Maps doesn’t always apply a label to the street I’m standing on. It just remains blank.

The same thing happens to me. The most useful piece of information is hidden. I've never understood that decision.

samanator··on Transparent field level encryption for Django with pgcrypto PostgreSQL extension
What are the performance implications of an application that uses this? I'd imagine constantly encrypting and decrypting would increase latency...
samanator··on PLJS – JavaScript Language Plugin for PostreSQL
I just tried building plv8 today. After 2 hours, I gave up and just copied the ready made artifact from a docker image.

Here is more context for the QuickJS engine experiment as the runtime for a pl language.

https://github.com/plv8/plv8/issues/364

samanator··on Launch HN: Twenty.com (YC S23) – Open-source CRM
One of my requirements is that I must be able to host the database myself :-) (with a preference for Postgres)
samanator··on Launch HN: Twenty.com (YC S23) – Open-source CRM
> The actual CRM part (basically tables of data with a UI) is trivial

Although I agree with the general sentiment, I disagree with this. I've tried out over 100 low-code ui builder over the past year (including creatio,Corteza,ERPNext,Baserow,tadabase,appsmith,nocodb,mathesar,bubble, etc.) and so far none of them have perfected "excel like ease with the power of a database".

If anyone has any suggestions, (that's not on my list https://docs.google.com/spreadsheets/d/15Pg6y11JscBMK-PK06f7... ), please let me know!

samanator··on Thousands of subreddits pledge to go dark after the Reddit CEO’s recent remarks
I meant to say that leadership still likes to avoid bad press for the sake of self preservation. Bad press focused on individualals has consequences even when consumers aren't the primary audience. Think stockholders, potential business partners, boards, etc.

Large subreddit protests are bad press.

samanator··on Thousands of subreddits pledge to go dark after the Reddit CEO’s recent remarks
Probably so, but the theverge article and others like it will not go anywhere. This is ammo for future journalists to character assassinate the current Reddit leadership. Bad press is always available for later reuse.
samanator··on Kenneth Anger has died
Archive link: https://archive.is/20230524171127/https://dangerousminds.net...
samanator··on PyPI Was Subpoenaed
Yep, I was thinking the same thing. What a beautiful way of communicating that.
samanator··on Writing summaries is more important than reading more books
> I took a course at UChicago on how to read a book based on Mortimer Adler’s book of the same name

That's the same book mentioned in the footnotes of the article.

"How to Read a Book: The Classic Guide to Intelligent Reading Mortimer J. Adler, Charles van Doren"

https://www.goodreads.com/book/show/567610.How_to_Read_a_Boo...

samanator··on Use of antibiotics in farming ‘endangering human immune system’
> ...the prevalence of these strains of E coli have dropped steeply since China banned the use of colistin as a growth promoter, suggesting that these genes carry other “fitness disadvantages” for the pathogens.

That sentence seems pretty important but is hardly given any attention. It seems like if we simply stop using the antibiotics then the dangerous strains will die out on their own?

samanator··on Shell admits 1.5C climate goal means immediate end to fossil fuel growth
https://web.archive.org/web/20230425155432/https://www.resil...
samanator··on Show HN: Gsubpy, an interpreter for subset of Python, written in Go
Another python implementation in golang:

https://github.com/go-python/gpython

samanator··on PL/Rust 1.0: now a trusted language for Postgres
I understand, and I've used the old and new table aliases. But I meant that I don't see a way to use those in the PL/Rust docs.
samanator··on Semaphore: A Full-Body Keyboard
I rewatched that part of the video and don't see where he made fun of him. Are you referring to when he mentions that Claude Chappe was "big-brained" and zooms in on his head? If so, that sounds like a compliment to me.
samanator··on PL/Rust 1.0: now a trusted language for Postgres
You're right! My mistake. I was thinking of statement triggers.

https://www.postgresql.org/docs/current/sql-createtrigger.ht...

> The REFERENCING option enables collection of transition relations

I don't see any examples of statement triggers...

samanator··on PL/Rust 1.0: now a trusted language for Postgres
A crucial facet of optimization for computational triggers in PostgreSQL pertains to the implementation of event triggers, which enable operations to be executed in bulk (per DML statement) rather than on a per-row basis. It appears that, at present, PL/Rust has not incorporated support for event triggers. According to the documentation:

> Event Triggers and DO blocks are not (yet) supported by PL/Rust.

samanator··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
I'm running postgres on docker on an ec2 instance and outerbase lets me save the connection but doesn't show any schemas or let me query any tables.

I've checked and double checked firewalls to make sure the IP is whitelisted. I'm able to connect with the same setup from my personal computer via psql (with the only difference being the ip whitelisted)by whitelisting it.

Hope you get this working or add some improved connection diagnosist mechanism.

Edit:

If it helps, a POST request to

https://app.outerbase.com/api/v1/workspace/39b72940-083d-4aa...

Fails with a 503 response of > The server does not support SSL connections

... But it's not an SSL connection. I provided a plain ip address.

samanator··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Sure! I'll file it this weekend.
samanator··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Will this be the interface that I need?

Mathesar ( https://news.ycombinator.com/item?id=34999774 ) was the last one I tried out but it couldn't support more than 250k rows without crashing and required foreign keys in order to infer relationships. Otherwise it's exactly what I want. An Excel/Airtable interface around a raw database connection.

How does Outerbase compare?

Edit:

Mistypes

samanator··on Show HN: Mathesar – open-source collaborative UI for Postgres databases
Wow I wish this had been published a year ago!

This is exactly what I've been looking for (but now I'm heavily invested in a full fledged CRM)!

Thank you for this

samanator··on Show HN: MrScraper – A visual web-scraping tool
How do you approach pages that sometimes, non deterministically, present captcha challenges?

Are you using a service like 2captcha to auto-solve captchas?

samanator··on Google exec fired after female boss groped him at drunken bash, suit says
It's sad to me that the most upvoted comment in response to a sexual harassment is about false harassment claims.

Imagine the roles were reversed and it were a woman being harassed. What would the response to this comment be?

samanator··on Features I'd Like in PostgreSQL
Nope, you must run

  REFRESH MATERIALIZED VIEW mymatview;
Which does a full view update.

See https://www.postgresql.org/docs/current/rules-materializedvi...

samanator··on Whisper.cpp example running fully in the browser
This is incredible! Thank you for sharing! Did OpenAI release these pretrained models, or was the training done separately alone with this project?

Of OpenAI releases the pretrained models, why would we use their service?

samanator··on YouTube Transcript – read YouTube videos
Likely cached. Try with a long video with few views.

Edit: after reading other comments it seems this may be using an undocumented api to retrieve the data.

samanator··on Who invented the thumb drive?
The myth lives on. According to Wikipedia:

> Multiple individuals have staked a claim to being the inventor of the USB flash drive. On April 5, 1999, Amir Ban, Dov Moran, and Oron Ogdan of M-Systems, an Israeli company, filed a patent application entitled "Architecture for a Universal Serial Bus-Based PC Flash Disk".

← PreviousPage 2 of 5Next →