Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
scottrogowski
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
31.
▲
by
scottrogowski
5y ago
I upvoted your first comment because I felt that you were making a valid if controversial point. But the concept of "handing over" Ukraine really underlines why the rest of the world views Russia as such a threat to world peace. U
32.
▲
by
scottrogowski
5y ago
Disagree that the statistics I cited have water availability as a prerequisite to improvement. California can simultaneously have water problems and graduate more seniors. They are not mutually exclusive. Agree in the need to ramp up water
33.
▲
by
scottrogowski
5y ago
That's very interesting. Today I learned.
34.
▲
by
scottrogowski
5y ago
I agree so strongly with this sentiment. There is always such a defeatist attitude on these threads that assumes California is somehow full and unchangeable. Outside of the three metro areas, it's basically empty! Separately, in the me
35.
▲
by
scottrogowski
5y ago
I have a pet theory for this phenomenon. If you look at recently contacted peoples or those who have little contact with the outside world, endemic warfare is common. In these societies, well over 20% of men are killed in the ongoing confli
36.
▲
by
scottrogowski
5y ago
Could you expand on that? I'm not familiar with the world of rooting android. Does something exist that would allow you to specify exactly which apps are installed (and remove the web browser and play store)?
37.
▲
by
scottrogowski
5y ago
I'm with OP in their diagnosis of the problem. Other commenters seem to focus on "tricks". The problem with these tricks is that they can all be bypassed and you always go back to normal. Would you suggest someone who wants t
38.
▲
by
scottrogowski
5y ago
This is almost certainly wrong but is worth a mention given that the author can't figure it out. In Southern India, there is a language known as Kannada. It has 43 million speakers, which, fun trivia, is more than the population of Can
39.
▲
by
scottrogowski
5y ago
The only reason why Bitcoin energy usage is so high is because the difficulty is automatically adjusted so that the average time between blocks is approximately 10 minutes. Any attempts to improve the energy efficiency, rather than reduce t
40.
▲
by
scottrogowski
5y ago
Yup. Considered it. I initially settled on no because it might compromise the design goal of 1:1 MongoDB/PyMongo compatibility. Now the idea is being revived as an option alongside the two existing backends. I am concerned there might
41.
▲
by
scottrogowski
5y ago
O(n) cache size is fine (and IMHO, preferable) for small datasets. For large datasets, you're correct. Cache eviction is important when memory usage gets too high. I didn't have it explicitly on the README as something that needs
42.
▲
by
scottrogowski
5y ago
You're right. Fixed. SQLite is more-so the winner but Mongita appears to squeak ahead in id lookups https://github.com/scottrogowski/mongita/blob/master/assets/... (to be fair, it might be the
43.
▲
by
scottrogowski
5y ago
Thanks for the kind words :) I like your idea. As I understand it, since SQLite performs better on most benchmarks anyway, why not have an engine subclass that utilizes SQLite itself? This would be a little trickier than your envisioning. T
44.
▲
by
scottrogowski
5y ago
I think as I understand it, your question is whether we can't just put a distributed layer on top of basic embedded databases. This is really interesting and is something I came across while writing this. It turns out that concurrency
45.
▲
by
scottrogowski
5y ago
Hey, your first statement is true but your second is not. The disk engine does store data in memory which is part of the design. You wouldn't want to use a database that doesn't utilize caching. The last benchmark panel, https:&#
46.
▲
by
scottrogowski
5y ago
This is good and helpful feedback. Thank you. I'm humbled by how well this has done so far but definitely feeling the criticism. A title like, "Mongita is embedded MongoDB for Python", while being a statement without ambiguit
47.
▲
by
scottrogowski
5y ago
It's a good question and to be accurate, depending on the benchmark, Mongita is about the same speed at SQLite to several-times slower. There is less happening algorithmically than you would think. Where the tricky slow bits do exist,
48.
▲
by
scottrogowski
5y ago
Author here. My goal with that one-liner was to convey immediately what it is - an embedded database that implements the PyMongo/MongoDB API. Is it semantically perfect? Probably not. Will Mongita be useful to Python developers who are
49.
▲
by
scottrogowski
5y ago
Thank you! I actually did consider doing exactly what you said. Early on, I decided one my goals for the project would be to make it easy to swap back and forth between Mongita and PyMongo/MongoDB. For me, that meant getting as close a
50.
▲
by
scottrogowski
5y ago
Author here. That's exactly it. I think it would be very difficult to completely beat SQLite with a Python library. My goal wasn't to beat it but to have performance that's within an order of magnitude which I think I've
51.
▲
by
scottrogowski
5y ago
That's a good question. I'll try adding it to the benchmarks.
52.
▲
Show HN: Mongita is to MongoDB as SQLite is to SQL
(github.com)
126 points
by
scottrogowski
5y ago
|
93 comments
53.
▲
by
scottrogowski
5y ago
I have a genuine curiousity (because I can't seem to find it in the news reports). The contract is going to the starship design. What exactly are they planning to take that requires such a large ship? The lunar landers were tiny becaus
54.
▲
by
scottrogowski
5y ago
Very cool. Reminds me of an excellent radiolab I listened to about Wubi: https://www.wnycstudios.org/podcasts/radiolab/articles/wubi-... If you can effectively type 70,000 characters with 26 keys, certainly y
55.
▲
by
scottrogowski
5y ago
I try to use Firefox (I do) but there are still issues every now and then and I find that I have to use Chrome for something at least once a day. Most developers develop for Chrome and don't even consider Firefox. I'm not particul
56.
▲
by
scottrogowski
5y ago
The difference between what mainstream agile is and what the original authors of the agile manifesto were trying to achieve is vast. This talk from one of the authors is an amazing rebuttal of what agile has become and clarification of what
57.
▲
by
scottrogowski
5y ago
While I agree that it was an offhand comment, if you look closely at the chart you posted, the weakest correlation is on the bottom right under "mood, anxiety, and psychotic disorders" which is what I believe OP was implying. Unde
58.
▲
by
scottrogowski
5y ago
You are failing to take into account the hygiene hypothesis: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2841828/ . There is evidence that a lack of exposure to germs is a cause of autoimmune and allergic dis
59.
▲
by
scottrogowski
6y ago
I agree with most of the other replies to your comment. The world is full of counter-intuitives and I'm genuinely curious about whether this is one. As I said, my guess is that the risk of surface-transmission of COVID is probably stil
60.
▲
by
scottrogowski
6y ago
I'd be curious to see whether we actually see an uptick in cancers in the coming months/years. If so, I wonder whether it will turn out that using hand sanitizer resulted in a net increase or decrease in overall mortality. Evidenc
More ›