deathclassic

Everyone says germline editing would reduce diversity in the gene pool, and I can see validity to that argument. But, could it not do the opposite when people start altering their children to align with their own values? I could see the loss of some universally "bad" genes, but a lot of the judgement on this sort of things gonna come down to who does the gene editing and how they exactly implement it. When multiple groups start doing this in practice, I could see it fracturing the species more than homogenizing it. Especially when combined with something like iterated embryonic stem cell selection when you can jump several generations at a time. That would result in multiple post-human species derived from baseline humanity with their own specializations, talents, etc. Which would be more diverse.

Same. Specifically I would want to be a pharmacologist. There are two major barriers that prevented me from considering this route:

I'm a fairly terrible student and 8 years of school wasn't gonna happen. I can't stand blood/body parts. Even if I got through school I don't think I could stomach a clinical position.

hmmm. Wonder what would happen if you configured a zfs pool with this as the l2arc vdev.

Yeah docker is great and I've done the exact same as you for a few years. But, I don't think I even knew what a docker container was until 2018, and again, as an intern or college kid with a school/work windows workstation telling them to run it in a container is a non starter.

Ever try to install postgres on windows? On a school or work computer you may or may not have admin access on? That's the kind of enviroment a lot of people (including myself) started in. In that sort of enviroment, it's easier to run sqlite3.exe database.db. And that's the kind of enviroment a lot of people (myself included) got started in databases.

Ignore this, I was wrong. Django supports sqlite just fine. Last time I did anything with django I was an intern and just copied the setup from the readme which happened to include a mysql setup. I have not touched django since.

It's been at least 3 years since I did anything with django and that was with mysql.

SQLite has other advantages over larger db systems. - By far easiest db to install. - Really go to learn database fundamentals with.

If you have no experience with databases and are just starting out programming, PG is going to steepen the learning curve substantially.

It would probably be harder to bend Django to use SQLite as a backend then it would be to just setup MySQL or PostGRES and use the existing Django tooling for it.

This project comes to mind https://github.com/rqlite/rqlite but I've never used it, and I'm not sure if it would count as "pure sqlite" like the op advocated anymore.

There is https://github.com/rqlite/rqlite but i've never used it.

Also valid. I just use ISO8601 and bite the bullet because storage is cheap.

It's ok until you have to deal with loading a bunch of point cloud or geometry data based on associations and sort it out in memory. Then PostGRES becomes your friend.

Ok JSON maybe wasn't the best example. I wasn't aware that SQLite had those json features though, thanks for the advice.

Blocking can become an issue pretty quickly with SQLite unless you do what this guy does and make a different database for essentially every process writing to the db. This can crop up in all sorts of situations.

For example today I was writing tests for a python application I'm working on that uses SQLite. SQLite is the only option I have for this program as I have literally no way to setup a client server db in it's environment.

I had the tests all configured to write to the same test db file. The program I wrote the tests for had no issues with locking because it doesn't run anything concurrently.

However, when I did the same in my test suite, they ran in parallel, which caused my tests to hang. Of course, I figured this out quickly and made the tests write to their own individual DB. This is a really small program, so cleaning up afterwards is no big deal. (I could also just use an in memory db instance instead of even dealing with files). But, for a program with a LOT of tests, I could see this being an issue.

I like sqlite as much as the next guy but it's built-in datatypes are limited. Things like arrays, UUIDs, geometry stuff, JSON, etc. Sure you can store more advanced stuff as blobs or text but then you have to mess around with deserializing it in the host language and you lose the ability to query it directly in the db engine.

Not directly. But it is directly correlated with disregard for others feelings, and general lack of social awareness. Which in the case of male EA nerds certainly seems to lead to a lot of situations in which women were disrespected to say the least.

asprin + codiene sounds like a based painkiller combo. Who needs a liver tbh?

Of course these dipshits needed to be polyamorous their little community was like 70% dudes, their clearly wasn't enough pussy to go around. Of course, this would cause more problems than it solved - having been in a poly relationship before I can tell you firsthand that the number of issues in the relationship scale n! for n people involved in the relationship.

Based. Utilitarianism is cringe, these guys need to read Kant or something.

What? A bunch of autistic male nerds obsessed with how smart they are don't respect women? I'm so suprised.

Anyway, I dismissed EA because I dismiss basically all forms of utilitarian ethics. When you try to use math and statistics to form your entire moral basis, you can kinda justify anything you want, and get to some weird contradictory judgements as well.

Exactly. And large scale pension systems and the financial vehicles are essentially the family unit scaled up to the size of a country. I do think there are advantages to doing it the social security way, as it puts less pressure on the individual to take care of their elderly parents. Many people aren't equipped with the time and know-how to run an assisted living facility in their living room, so specialized facilities for that purpose and social programs can help fill in the gaps.

Everyone's children is their retirement plan - just some societies have socialized/obfuscated this to varying degrees. All retirement financial mechanisms and social programs are funded by younger people paying taxes, and putting money (buying) into things like 401ks, IRAs, Stocks, housing, etc. Retirement is when you "withdraw" (sell) these things for cash to live on without having to work.

OP did create a tool that could easily be used for abuse and blackmail. Of course, it could also be used to solve the problem if the government just grew a pair and banned porn outright and punished anyone caught hosting or producing it harshly.

Could something like epitalon reverse this effect?

Are you fucking stupid? You literally just built a porn reverse image search tool. Think about it, all you need is a screen shot of a single frame of porn and you can find links to other vids with that person. This is a godsend for coomers. Not to mention, the abuse potential of something like this is insane. Now anyone can just use a girls facebook profile or linkedin pic to find nudes - perfect for fapping or for blackmail. Copyright isn't gonna stop offiline copies from being taken, and the fact that most NCII out there exists of a subject that is unaware of said content being published, hence the people that need your tool the most proabably won't know it exists - until its too late. It's so funny how you're trying to pass of this tool as "socially beneficial" when all it's gonna do is make the problem worse.

The internet and digital cameras being available to everyone was a mistake, when I come to power I'm just outright banning any transmission or storage of any photos of naked human bodies with the exception of medical reference pics. Or I'll just ban cellphones and home computers from civillian use entirely.

EDIT: I probably wouldn't ban the internet or home computers, but I'd at least completely ban porn, and use a tool like OPs to enforce such a ban with extreme prejudice. Anyone hosting or running a site with such content would face years of hard labor

Even as a person that drinks sometimes, I find it annoying when people try to pressure me to drink if I don't want to. It's polite to offer but if someone says no than just ignore it.

You're really not missing anything skipping the booze. If the stuff was invented today it would be seen in the same light as huffing paint for fun. I definitely don't like when people sober-shame others for not partaking in the stuff, even as someone who drinks from time to time.

However, not all drugs are poisonous in the same way alchohol is. Caffeine is a drug and in moderate quantities is probably pretty good for you. Weed is probably far less toxic than booze if used in small amounts by adults that don't have certain genetic markers for schizophrenia. Mushrooms aren't toxic at all. There are tons of psychoactive drugs used for medicine and fun that arguably cause more harm than good.

Anyway, people have a natural impulse to alter their consciousness, be it through extremely harmful ways like booze and coke, or through less harmful ways like mushrooms or meditation. I don't see it ending anytime soon.

Wow I love these pop sci articles, lists 4 genes: - ESR1 - DRD2 - DCC - TRAF3 that everyone has, and no details on what variants of said genese are actually relevant. This is about as useful as saying "having a brain increases risks of suicidal thoughts". I need r-numbers and alleles to actually plug into promethase/23andme to see if any of this is relevant to me.

The fact that vivitrol is both rare and stupidly expensive is a tradgedy. Like, if the goverment just forced pharma companies to supply the stuff for free or extremely cheap it would help addicts immensely. Also why not hit people with the vivitrol shot the second they get caught with opioids or show up in the emergency room because of an OD? Don't bother with criminal charges or forced rehab, just mandate the person comes in and gets the shot for a few months, free of charge. I know vivitrol isn't perfect but it's the closest thing we have to a vaccine for opiod addiction, we should be giving it out like a flu shot.