HNHacker News
TopNewBestAskShowJobs

realPubkey

610 karma · joined January 27, 2017

submissionscomments
realPubkey··on The SQLite Index Suggester
I did something similar for a NoSQL database [1]. The biggest surprise was how much the query performance can change for an index when the data distribution changes slightly. For example using a real distribution for an 'age' field instead of just using a random number like in the test data.

[1] https://rxdb.info/query-optimizer.html

realPubkey··on Ask HN: Why doesn't every home have an acceptable volume level for speech?
You should go to youtube and watch how planet fitness ensures people do not train to loud. Then you understand why noone wants that at home.
realPubkey··on Germany is offering a summer of cheap trains
https://www.youtube.com/watch?v=mKmSLO6QNwg&ab_channel=Wobin...
realPubkey··on Ask HN: How do you sync your computer’s development configurations/environment?
I have put vscode into a docker container. This allows you to commit the settings via git.

https://github.com/pubkey/vscode-in-docker

realPubkey··on Actions rooted in open source culture can make a big impact
Afterwards, fly somewhere for recreation.
realPubkey··on Ask HN: Long time programmers of HN, what are you surprised does not exist yet?
Decentralized search engines.
realPubkey··on The realtime web: evolution of the user experience
You should check out RxDB. It applies realtime replication to an offline first storage. This means you even have less backend load compared to regular CRUD apps. Also you get multi-tab support for free where only one browser tabs runs the client-server connection.

https://rxdb.info/

realPubkey··on TodoMVC App Written in Vanilla JavaScript
Also it does not work properly when it is used in more then one browser tab.
realPubkey··on GraphQL Is a Trap?
Watch this Honeypot documentation about GraphQL. Listen to what the developers tell which problems they had to solve when they invented GraphQL. You likely do not have any of these problems.

https://www.youtube.com/watch?v=783ccP__No8&t=875s&ab_channe...

realPubkey··on Razer X Lambda Tensorbook – The Deep Learning Laptop
Does anyone really use local hardware for deep learning?
realPubkey··on Google says AI generated content is against guidelines
I am translating german content to swedish and back again. Google never noticed. My backtranslated content even corrects all typos and gramatical errors. It ranks better then the original content and I see no way they could ever detect.
realPubkey··on Dall-E 2 illustrations of Twitter bios
As always, these results are cherry picked by OpenAI. Same as GPT-2/3, the "average" output of the model is barely useable.
realPubkey··on Proposed EU rules would require clothes to last longer and be easier to repair
My whole generation is brainwashed with a shopping addiction.
realPubkey··on Automerge CRDT – Build local-first software
I tried to apply CRDTs many times, what I learned: CRDTs sound great in theory but for most use cases they cannot be applied to the buisness logic. Most of the time you either need to read out other information in from different collections to resolve a conflict. In other cases you have to ask the user to resolve the conflict. The cases where CRDTs work great are also the cases where you do not really care about conflicts and a last-write-wins is ok.

https://rxdb.info/downsides-of-offline-first.html

realPubkey··on Show HN: React-Table-Library
Yes, totally broken on android chrome, also when opening the plain table without storybook [1]

[1] https://react-table-library.com/iframe.html?args=&id=getting...

realPubkey··on GitHub issues disabled in "broadcast-channel" project
1) If that is your mindset, you will likely not contribute anyway.

2) Noone cares if you use my open source project.

realPubkey··on GraphQL is now available on Supabase
From the example generated schema in the docs, it does not look like they have subscriptions.
realPubkey··on GitHub issues disabled in "broadcast-channel" project
Maintainer of the repo here.

I disabled the issues of most of my projects. Over the years I have observed that people who actually contribute value, do not need the issue section. They will directly open a PR with a change or at least some code that explains their problem.

People started arguing with me about this topic. But these where never the people that actually contributed to any open source project that was not their own, so I do not care at all.

I opened the discussion section so people can actually discuss there, without wasting the time of the maintainer.

realPubkey··on Vast.ai – marketplace for renting out your GPU, or renting someone else's GPU
Used this several times, works great. But for smaller training tasks (max 1 GPU), colab pro plus is much cheaper
realPubkey··on Podman can transfer container images without a registry
Also with docker-compose there is a remote option to deploy local containers via ssh.
realPubkey··on CD sales grow for first time since 2004
For me, collection things that you do not really need, is just a waste of scarce resources.
realPubkey··on Ask HN: Should I give up and get a job?
Instead of invalidating query caches, you can sometime re-calculate the new result instead https://github.com/pubkey/event-reduce
realPubkey··on Offline First
RxDB maintainer here.

I am aware of that problem. Pouchdb got some good love in the last weeks where some people made good PRs with fixes for the indexeddb adapter. But still it is mostly unmaintained and issues are just closed by the state bot instead of being fixed.

So in the last major RxDB release [1] I abstracted the underlaying pouchdb in a way that it can be swapped out for a different storage engine. This means you could in theory use RxDB directly on SQLite or indexeddb. In practice of course someone has to first create a working implementation of the RxStorage interface.

[1] https://github.com/pubkey/rxdb/blob/master/orga/releases/10....

realPubkey··on FBI says seized fortune was criminals’ loot—owners say: Where’s the proof?
Well there are way more and easier ways to get illegal money without directly stealing it.
realPubkey··on Developer, you may need a co-founder in marketing
Can relate so much to this. Noone will come once you have finished coding your product, you need a marketing strategy that is proven to work before you start coding a single line.
realPubkey··on SHC URI Scheme
I do not understand this
realPubkey··on The most cited neural networks all build on work done in my labs
As you see he always focuses one one thing. Here it is his biceps.
realPubkey··on El Salvador will adopt Bitcoin as legal tender from today
Thank you, that makes sense of course.
realPubkey··on El Salvador will adopt Bitcoin as legal tender from today
It can do the same without having bitcoin as legal tender.
realPubkey··on React and D3.js
This. I also used it, works great.
← PreviousPage 3 of 8Next →