HNHacker News
TopNewBestAskShowJobs

adontz

1,085 karma · joined December 9, 2014

adontz.at.hn

Software Architect, Python/Django enthusiast.

submissionscomments
adontz··on The racist AI deepfake that fooled and divided a community
It's in the interest of general public to fund AI detection technologies, including AI based AI detection technologies.
adontz··on Ask HN: Who wants to be hired? (October 2024)
Location: Georgia (+04:00)

Remote: Yes

Willing to relocate: Depends

Technologies: Python, Django, Tailwind, C#/WPF, C++/Qt, PostgreSQL, AWS (EC2, DynamoDB, ElasiCache, RDS, Lambda), Terraform (AWS, Azure), Ansible, Linux, Windows, Git, TailwindCSS, reverse engineering formats and protocols, cryptocurrencies.

Résumé/CV: https://linkedin.com/in/adontz

Email: adontz@gmail.com

I am an Engineer with experience in backend software development, desktop software development, embedded development and electronics, infrastructure management. In recent years I was head of devops department in a bank and CTO is a startup. Seeking for something less stressful. Love open source. I like to know things.

adontz··on Ask HN: Freelancer? Seeking freelancer? (October 2024)
Location: Georgia (+04:00)

Remote: Yes

Willing to relocate: Depends

Technologies: Python, Django, Tailwind, C#/WPF, C++/Qt, PostgreSQL, AWS (EC2, DynamoDB, ElasiCache, RDS, Lambda), Terraform (AWS, Azure), Ansible, Linux, Windows, Git, TailwindCSS, reverse engineering formats and protocols, cryptocurrencies.

Résumé/CV: https://linkedin.com/in/adontz

Email: adontz@gmail.com

I am an Engineer with experience in backend software development, desktop software development, embedded development and electronics, infrastructure management. In recent years I was head of devops department in a bank and CTO is a startup. Seeking for something less stressful. Love open source. I like to know things.

adontz··on WALDO: Whereabouts Ascertainment for Low-Lying Detectable Objects
I wonder if these achievements are related to war in Ukraine. Do scientists suddenly receive more funding or something? Or it just happens?

Is there a non public version with very reliable arm/mil? Is there a version which can reliably distinguish T-80 with and without Z?

adontz··on We created a new account in Telegram and started looking for a job in Estonia
I have no doubt about Durov's morals. 12 years ago he was throwing paper airplanes folded from bills to make fun of "little people". https://www.youtube.com/watch?v=VTRem0YRjqY https://www.youtube.com/watch?v=tJFZMyFzlR8

Telegram is used by drug dealers in my country too. All types of illegal content. Honestly Telegram is new darknet, but not even that dark. Streets are full of QR codes linking to Telegram channels,

OTOH Telegram is a really good technology. Very lightweight client. Whatsapp sucks compared to Telegram. Very hard to block protocol, Russian authorities basically failed to block Telegram. Very easy to write bots. Telegram bots are very powerful, way beyond simple chat replies. One can build UI with buttons and dropdowns inside Telegram.

Also, in not so free countries Telegram is the Internet basically.

adontz··on MiniJinja: Learnings from Building a Template Engine in Rust
Do I understand JinjaX correctly, that it's specifically for HTML templates, not text templates in general?
adontz··on Soft Deletes with Ecto and PostgreSQL
Help me here please. I really do not see how

WHERE CURRENT_TIMESTAMP BETWEEN start AND end is much better than WHERE deleted_at IS NOT NULL

Also, if we are talking about real use case of audit, not a simplified artificial one, my real tables were more like

changeset(id INT, timestamp DATETIME, user ^USER, host TEXT, ip_address TEXT, <other security data>)

datatable1(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)

datatable2(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)

datatable3(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)

adontz··on Soft Deletes with Ecto and PostgreSQL
This thing? https://learn.microsoft.com/en-us/sql/relational-databases/t...

Are not we talking about PostgreSQL?

adontz··on MIFARE Classic: exposing the static encrypted nonce variant [pdf]
RFIDs are rarely certified as possession factors, you need an EMV card for that. TPM chips may protect readers. Depends on reader/card ratio, if it's feasible.

Clones/double use/double spend must be caught on reader/server anyway. One can pass a card to another person, and you do not want two people to enter building with the same card.

I implemented double spend protection by introducing a simple operation counter. If the sequence of operation IDs is not continuous, card is blocked. Clones were added to block list within minutes. It was good enough for the use case. Again, MiFARE is very cheap, so tradeoffs are expected.

adontz··on Toothpaste Null-Terminator
For a neurodivergent person remembering to buy a toothpaste or just anything maybe quite challenging. https://www.additudemag.com/adhd-dad-lost-in-the-supermarket...
adontz··on Toothpaste Null-Terminator
I believe neurotypical and neurodivergent people have very different understanding of this article.
adontz··on MIFARE Classic: exposing the static encrypted nonce variant [pdf]
MIFARE Classic are cheap and reliable, only their encryption is broken. One can use them as simple storage and encrypt/authenticate data by different means. Nothing wrong with that. I did that, ECC signatures are small enough to fit in 2K/4K cards.
adontz··on Soft Deletes with Ecto and PostgreSQL
While I appreciate all criticism of this approach in the comments, it's not that simple.

1. There may be audit policies, compliance policies, retention policies in place. You may HAVE to keep data which is deleted from user's perspective.

2. People make mistakes. While I agree that restoring a long ago soft-deleted object may be very tricky because of referential integrity. It's easy to restore a recently (hours, days) soft-deleted object. Not only easy, it's much faster than restoring a point-in-time backup of an entire database. Also restored version is guaranteed to be the latest one, unlike in backup.

3. PostgreSQL supports partial indexes and partial unique constraints. https://www.postgresql.org/docs/current/indexes-partial.html

Other databases support similar features too. That allows excluding soft-deleted records from indexes, makes indexes smaller. A good query does not scan a table anyway. If one needs to read less pages from a table, PostgreSQL has CLUSTER command. If there are too many soft-deleted tuples, maybe it's time to think about an archive table anyway.

Unique constraints may ignore soft-deleted objects, so only active objects need to be unique. That is very useful if you need to support idempotent calls. Additionally that may actually be a security feature too. If I create a new user with the same username as an old deleted user, I know that username is unique, but also, that I will not accidentally get permissions of the old user assigned.

4. The worst is tooling. Forgetting "WHERE deleted_at IS NOT NULL" or "WHERE NOT is_deleted" is a very real problem. I would rather advise against soft deleted objects because of that problem alone.

On the other hand, if you use a decent ORM, (and why would not you?) like SQLAlchemy, Django ORM or EntityFramework/Linq (sorry for guys who are not Python/.Net, I do not have a good example for you), then it's quite easy to create a default model query which is not empty. But honestly, if your system is complex enough and has any custom row level security, if it is multi-tenant, if not all users see everything, you already have quite similar problem, you already have to start with non-empty query which already has WHERE and possibly even JOIN clauses. Without a good ORM it will suck anyway.

adontz··on Features I'd like to see in future IDEs
I believe Commit Masks are actually a bad practice.

I am huge fan of having a EC2 machine in AWS and using VSCode remote SSH or anything similar for development. There are so many differences between cloud and local, that you either embrace it (develop in EC2) or try to wrap it into one more layer or abstraction (hello Docker) and still fail.

adontz··on Writing GUI applications on the Raspberry Pi without a desktop environment (2019)
I've successfully utilized Qt5 (probably would work with 6 too) for framebuffer/OpenGL.

QML is nice, animations were much smoother than I expected.

adontz··on Show HN: Abusing a GitHub repo as a private certificate authority
For the exactly the same reason (local development closely resemble production when at all possible) I develop inside VPS via VSCode RemoteSSH and manage certificates (and everything else) exactly as in production
adontz··on The “3.5% rule”: How a small minority can change the world
Thanks for sharing this. Any bit of such research is really inspiring for people peacefully protesting currently.
adontz··on Show HN: Peerdb Streams – Simple, native Postgres change data capture
SQS and EventBridge targets not even on the roadmap? Why? Any specific reason?
adontz··on Show HN: I built a free in-browser Llama 3 chatbot powered by WebGPU
If anyone knows, is this about the best model one can run locally on an old consumer grade GPU (GXT 1080 in my case)?
adontz··on Why SQLite Uses Bytecode
There is no implied requirement to support JIT everywhere.
adontz··on Run0, a systemd based alternative to sudo, announced
here's a new tool in systemd, called "run0". Or actually, it's not a new tool, it's actually the long existing tool "systemd-run", but when invoked under the "run0" name (via a symlink) it behaves a lot like a sudo clone.
adontz··on Why SQLite Uses Bytecode
Looks like SQLite could benefit from copy-and-patch JIT compiler.
adontz··on The UX of UUIDs
It's a mess. In Georgian we say "lower dash". No short name in any language I know.
adontz··on Intel One Mono
Georgian and Russian. Georgian is hopeless, I'm really just whining into the void. DejaVu is my only option to make text editor not look like a movie style ransom letter.
adontz··on Intel One Mono
I really do not consider Intel a US or US-focused company.

https://www.statista.com/statistics/263560/net-revenue-of-in...

adontz··on Intel One Mono
It's really sad this is just another [Extended] Latin only font. One more of all these beautiful fonts I cannot use because I have to edit files in three languages. Maybe 1 in 100 developers is visually impaired, but 75 in 100 developers are not native English speakers.
adontz··on SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
I was looking for such comment, thank you for making my day.
adontz··on Why choose async/await over threads?
There are a lot of moments not covered. For example:

- async/await runs in context of one thread, so there is no need for locks or synchronization. Unless one runs async/await in multiple threads to actually utilize CPU cores, then locks and synchronization are necessary again. This complexity may be hidden in some external code. For example instead of synchronizing access to a single database connection it is much easier to open one database connection per async task. However such approach may affect performance, especially with sqlite and postgres.

- error propagation in async/await is not obvious. Especially when one tries to group up async tasks. Happy eyeballs are a classic example.

- since network I/O was mentioned, backpressure should also be mentioned. CPython implementation of async/await notoriously lacks network backpressure causing some problems.

adontz··on SpaceX is building spy satellite network for US intelligence agency, sources say
Musk has a long history of having opinions on policies. Why would DoD/CIA/NSA trust him with anything?
adontz··on Things unexpectedly named after people (2020)
Also https://wiki.debian.org/WhyTheName
← PreviousPage 2 of 13Next →