TekMol

13 ms·

181.
Ask HN: Should I switch away from SQLite if I only use JSON fields?
5 points by TekMol 2y ago|7 comments
182.
by TekMol 2y ago
I wouldn't even know how to go about using Windows. On Debian, there is a universe of software in the repos. I can install anything I need with just a apt install <something> and use all these programs in concert with pi
183.
by TekMol 2y ago
This also looks interesting. My question is similar to the wormhole one. Does it really need to be 168 files of code to do this? I don't know WebRTC, but wouldn't a single PHP file be enough to create the connection between the tw
184.
by TekMol 2y ago
That looks like an interesting approach. Does it really need to be a giant application made from "Go, JavaScript, TypeScript and Python"? What does all that code do? Wouldn't a single PHP file that acts as the connection betw
185.
by TekMol 2y ago
Is that a "Sign up and install our binaries on your devices" service? I prefer to not install additional software from 3rd parties on my devices.
186.
by TekMol 2y ago
That wants me to install a binary. I don't want to run any external code on my hardware.
187.
by TekMol 2y ago
I like Git Submodules very much. Are there any downsides to completely skip dependency managers of specific languages and just use submodules to handle dependencies? I don't mean code by 3rd parties. I mean the projects and libraries I
188.
by TekMol 2y ago
Does Hetzner provide a way to limit how much traffic a cloud server can use? I'm always afraid to use paid services to host my hobby projects, because what happens when some malicious or stupid actor with huge bandwith hotlinks an imag
189.
by TekMol 2y ago
Do you guys know who the most popular artists of our time are? Reading this article and its mention of celebrities I was like "Who are today's celebrities anyhow?"? And typed most popular artists 2024 into Google. It
190.
by TekMol 2y ago
You are implying that the web based exploits in the history of iOS were not publicly known but only available to very few. If that holds true, that would be an importent addition to the discussion. The comment I replied to was about a publi
191.
by TekMol 2y ago
What is the motivation of Foursquare to open source their places data?
192.
by TekMol 2y ago
Shouldn't that lead to a massive amount of iPhones being broken into? If not, why? If so, what happened to all those phones? I never hear stories like "My iPhone was broken into and this happened: ..."
193.
by TekMol 2y ago
The article sounds like it also applies to iOS The company urged users across the Apple ecosystem to apply the urgent iOS 18.1.1, macOS Sequoia 15.1.1 and the older iOS 17.7.2. And that it is web based maliciously cra
194.
by TekMol 2y ago
> When do you consider the write/transaction to be completed? Sending a UPDATE/INSERT/DELETE statement to SQLite is not blocking? I would think it is, because in my code I can read the number of affected rows right after I
195.
by TekMol 2y ago
What makes it hard? Having a single DB that takes write queries via a proxy which spreads them out to multiple read-only-DBs sounds easy at first.
196.
by TekMol 2y ago
My feeling is that I would have something better. Because I can use SQLite and its "a file is all you need" approach as long as I don't need multiple machines. And only bring in the other software (the proxy) when I need it.
197.
by TekMol 2y ago
Should replication really be a concern of the DB layer? Replication means writing queries which alter the data to multiple machines, right? Shouldn't that be done by a software one level up? Which takes in the queries via some network
198.
by TekMol 2y ago
Should the concept of "machines" really be a concern of the DB layer? SQLite already allows multiple connections, so putting it on a server and adding a program that talks a network protocol and proxies the queries to the DB sound
199.
by TekMol 2y ago
Are there still reasons to use PostgreSQL? I like the simplicity of SQLite's "a file is all you need" approach so much, that I started to converge all my projects to SQLite. So far, I have not come across any roadblocks. Can
200.
by TekMol 2y ago
All people I know in the EU who build something use Lemonsqueezy, Gumroad or Paddle to invoice their customers. 3 companies not in the EU which are charging an arm and a leg to do the complicated invoicing for EU makers. It's kind of s
201.
by TekMol 2y ago
Putting it on Arweave is the best I can think of. And then link to the content on arweave.net: https://www.google.com/search?q=site:arweave.net+book As Arweave is designed for this exact use case. Even if arweave.net disapp
202.
by TekMol 2y ago
How can software run on different CPUs when they support different operations? When you download "debian-live-12.7.0-amd64-kde.iso", all the programs in the repos support all current Intel and AMD CPUs, right? Do they just target
203.
by TekMol 2y ago
the following snippet is correct HTML [...] will still be reported as an error by SuperHTML [...] it's most probably a typo Bad. A tool should do one thing and do it will. A tool to verify HTML should verify HTML. No
204.
by TekMol 2y ago
Why is it that some people can accept - even like - music behind a voice that tells something? I strongly dislike it. It makes it harder to listen to the voice. Am I the only one?
205.
by TekMol 2y ago
The way Hacker News does it.
206.
by TekMol 2y ago
possibility to compile to WASM or machine code How is this better than "possibility to compile to JS or machine code"?
207.
by TekMol 2y ago
Awesome. I will notice when you reply here, no matter when. I routinely check for new replies even to old comments.
208.
by TekMol 2y ago
Compiling your C to WASM might make it run twice as fast as compiling it to JS. That's all. All other aspects of the workflow are the same.
209.
by TekMol 2y ago
No. I say we could build the same dev experience to non-js coders by offering them compile-2-js tools instead of compile-2-wasm tools.
210.
by TekMol 2y ago
Theoretically or because of the tooling landscape?

More ›