Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
koeng
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
32 ms
·
331.
▲
by
koeng
6y ago
For anyone interested in biology's slow advance, I'd highly recommend checking out the 2003 study that coined the term "Synthetic Biology"[0]. TL;DR is that we've known that dropping costs and scaling collaboration
332.
▲
by
koeng
6y ago
How would you compare Caprover to Dokku? I use dokku a lot, and really love some of the plugins (like postgres with the automatic backups and such). Is there any reason why you wouldn't use Caprover in production? (other than you haven
333.
▲
by
koeng
6y ago
Halophiles are a thing on earth and they live in extremely high salt content areas
334.
▲
by
koeng
6y ago
This is awesome! I will be using.
335.
▲
by
koeng
6y ago
These are actually some really good numbers for a certain application I'm looking at ( https://news.ycombinator.com/item?id=24191307 ), especially with bulk inserts being so high. A few questions: - Why 255 bytes to 255
336.
▲
by
koeng
6y ago
This is definitely one of the best books I've ever read related to computers. Highly recommend.
337.
▲
by
koeng
6y ago
The “vast majority” were proteobacteria. I’m not exactly sure what 99% means - there is a pretty darn good likelihood that they found some new strains, but not completely new phyla or anything special. Though, honestly, if you just go aroun
338.
▲
by
koeng
6y ago
As a biologist, the Biology and genetics section was really disappointing. > What’s the minimum viable human population? Depends on your technology. If you have frozen sperm and an effective means of genetic engineering (to fix mutations
339.
▲
by
koeng
6y ago
> Identical files will always have the same hash and can more easily be moved from one torrent to another (when creating torrents) without having to re-hash anything. Files that are identical can also more easily be identified across dif
340.
▲
by
koeng
6y ago
How so? Do you have some examples?
341.
▲
by
koeng
6y ago
I really like git push workflows (Heroku / Dokku). I would use https://github.com/dokku/dokku-scheduler-kubernetes , but it doesn't support Dockerfiles, and I need Dockerfiles for a few of the applications th
342.
▲
by
koeng
6y ago
The entire pharma system is extremely complicated and there are a ton of weird incentives in its structure. Those incentive structures are really powerful, and since it is about human health, much harder to change. Good paper on the topic -
343.
▲
by
koeng
6y ago
They have culture A and culture B, but they don't have culture C and culture D, acting as negative controls. Since they don't have negative controls, their experiments don't really show anything...
344.
▲
by
koeng
6y ago
Any reason the fork is better than the main project?
345.
▲
by
koeng
6y ago
I’ve found Sia to be quite good. Their “skynet” system is really cool.
346.
▲
by
koeng
6y ago
I've disabled all constraints, but I haven't removed indexing during loading. I'll look into doing that, with adding the indexing later
347.
▲
by
koeng
6y ago
How has dropping and recreating indexes been hit or miss? I've been thinking about doing exactly that
348.
▲
by
koeng
6y ago
I have a single physical server for running all my virtual machines. ZFS is nice for everything else, and it just so happens that my database virtual machine takes up most of the SSD space on that computer. I guess I should have a dedicated
349.
▲
by
koeng
6y ago
How fast did it go for your last use-case? Disabling all the consistency and durability storage features is dreadful, to say the least, but I'd definitely be open to trying it if it means I can get it done quicker. The algorithm I'
350.
▲
by
koeng
6y ago
I do batch the inserts into a large transaction, and usually optimize for the transaction to commit in approximately ~10s. Not sure if it is optimal, but I like to monitor it like that. BRIN indexes actually work for some of the data types
351.
▲
by
koeng
6y ago
The query that I have working is an abomination (it works though, https://github.com/Koeng101/poly/blob/polyStore_v0.1/store/c... ) The basic idea is that I am using SQL to back a suffix array ( http
352.
▲
by
koeng
6y ago
I use recursive queries in SQL to search persistent suffix arrays (mainly when there is a LOT OF DATA). You can do string search hundreds of gigabytes of data within ~0.004s with SQLite on cheap SSD and pretty much no RAM - my goal is to be
353.
▲
by
koeng
6y ago
Yep! The data is for the most part append-only, with massive writes once a month (that's how often the genetic repositories update their data dumps) with a few updates scattered in when annotations change. What exactly do you mean by s
354.
▲
by
koeng
6y ago
I have a ~1TB SQLite database (genetic data). All my queries run really fast, and overall I'm very impressed with the performance.
355.
▲
by
koeng
6y ago
yep, and you can even make synthetic endosymbionts! (pretty new science too!)
356.
▲
by
koeng
6y ago
I guess that was a bit of a hyperbole. You can learn more about the mitochondria genetically engineering the nucleus, but the main problem is that there still is science to be done on the mitochondrial genome that is "locked" down
357.
▲
by
koeng
6y ago
You can make a base pair edit, but you can’t, for example, add in GFP
358.
▲
by
koeng
6y ago
Unfortunately we don’t have anything beyond editing yet :( We’ve known TALENs can edit for a while, but that breakthrough made it a lot more efficient.
359.
▲
by
koeng
6y ago
Add new DNA into the human mitochondria. If you could do that, you unlock a massive amount of science around how mitochondria function, kinda similar to “what I cannot create I do not understand. From an engineer’s perspective, mitochondria
360.
▲
by
koeng
6y ago
Fun fact: we still can’t genetically transform human mitochondria, and we’ve tried for decades
More ›