Ciro Santilli @cirosantilli 37

She's truly passionate about health research and keeping healthy, almost obsessed by it. Also she's strong willed, and energetic. Good traits for founding 23andMe.

www.vanityfair.com/style/2014/04/sergey-brin-amanda-rosenberg-affair Fantastic painting of the people.

As www.nytimes.com/2017/11/18/style/anne-wojcicki-23andme-genetics.html puts it well:

The Wojcickis grew into Silicon Valley royalty. It’s the sort of family, Anne jokes, where “you’re only a viable fetus once you have your Ph.D.

Video 1.

Anne Wojcicki interview by Talks at Google (2018)

Source. She's athletic! As mentioned at: www.vanityfair.com/style/2014/04/sergey-brin-amanda-rosenberg-affair. And despite the name, and unlike Sergey, she's completely american as seen from her perfect accent!

youtu.be/pDoALM0q1LA?t=173 coding on garage while they do dishes and burritos
youtu.be/pDoALM0q1LA?t=331 why she's obsessed with healthcare. Also mentioned at: www.vanityfair.com/style/2014/04/sergey-brin-amanda-rosenberg-affair how she was trying to save Sergei from some of his genetic predispositions
youtu.be/pDoALM0q1LA?t=571 she really cared about 23andMe, but the public didn't as much as her. She's truly passionate about mining genetic data. Maybe she came a bit early.
youtu.be/pDoALM0q1LA?t=1038 doc in a box workaround

 Read the full article

The horrors of Sequelize by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

foreign keys are capitalized:
- stackoverflow.com/questions/55273091/why-use-the-uppercase-key-when-creating-association-model-in-sequelize
- github.com/sequelize/sequelize/issues/5828
you must give foreignKey when using aliases, otherwise it fails subtely. That would be derived automatically.
stackoverflow.com/questions/41502699/return-flat-object-from-sequelize-with-association can't auto-flatten to reuse the database's ORDER
limit and offset don't work without subQuery: false when doing includes! It is just too buggy. Examples of this can be found e.g. under nodejs/sequelize/many_to_many_same_model.js.
stackoverflow.com/questions/34059081/how-do-i-reference-an-association-when-creating-a-row-in-sequelize-without-assum hard to not duplicate foreign keys values everywhere
stack traces permanently broken or requiring non-obvious configs:
does not automatically update fields on hooks: github.com/sequelize/sequelize/issues/8586#issuecomment-422877555
cannot change columns when other columns have constraints due to the backup table?
- stackoverflow.com/questions/64533732/process-of-changing-a-table-with-sequelize-migration-if-foreign-key-constraint-i
you have to use .get() for attribute aliased fields, why? stackoverflow.com/questions/32649218/how-do-i-select-a-column-using-an-alias/69890944#69890944
.id gets added to SELECT no matter what, breaking GROUP BY unless you do horrible workarounds:
- github.com/sequelize/sequelize/issues/3256
- github.com/sequelize/sequelize/issues/5481
no simple built-in mechanism for transaction retries: Sequelize transaction retries
impossible to do subqueries in general. Docs just tell you to use literals. This in particular prevents single query deletes with join as done at nodejs/sequelize/raw/many_to_many.js:
- sequelize.org/master/manual/sub-queries.html: the docs actually just tell you to use literals, lol
- stackoverflow.com/questions/45354001/nodejs-sequelize-delete-with-nested-select-query
Also, you can't get query strings either: github.com/sequelize/sequelize/issues/2325
migrations. Generally speaking, anything but the simplest migrations are exceedingly hard to get right, as you have to go very low level when doing migrations. Syntax can be very different from regular DB operations.
- no way to do (non-raw) queries during migrations, e.g. to update fields based on other fields in a complex way?
  github.com/sequelize/cli/issues/862
  stackoverflow.com/questions/18742962/add-data-in-sequelize-migration-script
  stackoverflow.com/questions/38671483/sequelize-migration-update-model-after-updating-column-attributes
  stackoverflow.com/questions/38998397/can-i-use-sequelize-models-in-migration-scripts
  stackoverflow.com/questions/45286429/custom-query-on-sequelize-seeder
  queryInterface.sequelize.models contains only SequelizeMeta. Not sure why they have this limitation.
  Edit: actually things will likely just work if immediately after making table changes you just instantiate a new sequelize and do any data changes.
- stackoverflow.com/questions/56043246/node-js-sequelize-no-primary-keys-when-migrating/56046101#56046101
- SQLite changeColumn migrations do on delete cascades of other tables. SQLite does not have change column statements, so they have to drop and recreate tables, but they don't temporarily remove cascades, so you lose data: stackoverflow.com/questions/62667269/sequelize-js-how-do-we-change-column-type-in-migration/70486686#70486686
- associations require full explicit index construction: stackoverflow.com/questions/39651853/how-to-create-join-table-with-foreign-keys-with-sequelize-or-sequelize-cli
ability to iterate over a large result without blowing up memory and without using limit + offset (which is inneficient e.g. when looping over recursive queries). This is also known as cursor or streaming interfaces:
- stack overflow
- issue tracker
E.g. the Python SQLite interface supports this just fine: stackoverflow.com/questions/29582736/python3-is-there-a-way-to-iterate-row-by-row-over-a-very-large-sqlite-table-wi
empty attributes: [] breaks some nested queries: github.com/sequelize/sequelize/issues/16436
does not expose a iteration API that supports large arrays?
- github.com/sequelize/sequelize/issues/8550
- stackoverflow.com/questions/57164242/perform-sequelize-findall-in-a-huge-array
E.g. Python SQLite does: stackoverflow.com/questions/29582736/python3-is-there-a-way-to-iterate-row-by-row-over-a-very-large-sqlite-table-wi

 Read the full article

Varun-Hegde/Conduit_NodeJS by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

Very raw. Easy to understand. Relatively well organiezd. But also very buggy at 3ab8d9f849a1cdf2985a8d123b1893f0fd4e79ab: github.com/Varun-Hegde/Conduit_NodeJS/issues/3, I just can't trust it. There must be several helper libraries that would greatly DRY up the repetitive CRUD. Ciro hates the style :-) 4 space indents, no space after commas, no semicolon. Not based on github.com/gothinkster/node-express-realworld-example-app which is essentially one of the reference implementations, so from scratch apparently, which is a bad sign.

 Read the full article

Quantinuum H1-2 by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

E.g.: www.quantinuum.com/pressrelease/demonstrating-benefits-of-quantum-upgradable-design-strategy-system-model-h1-2-first-to-prove-2-048-quantum-volume from 2021.

 Read the full article

Three polarizers 45 degrees apart by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

physics.stackexchange.com/questions/61918/three-polarizers-45-apart/261188#261188

 Read the full article

How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it / Sequencing by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

Once we had the amplified 16S DNA, we were almost ready to start sequencing!

 Read the full article

How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it / External links to this page by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

2021-03-25: Oxford Nanopore Technologies retweeted this article, that's awesome!
2021: hackaday.com/author/wd5gnr1/ "SEQUENCING DNA FOR METAGENOMICS" by Al Williams (2021). This came after Ciro Santilli self promoted at: stackoverflow.blog/2021/02/03/sequencing-your-dna-with-a-usb-dongle-and-open-source-code/#comment-1411921

 Read the full article

Oxford Master Course in Mathematical and Theoretical Physics by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

mmathphys.physics.ox.ac.uk/

At least they have a fucking clear course schedule unlike the undergrad.

 Read the full article

Microwave source by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

Microwave only found applications into the 1940s and 1950s, much later than radio, because good enough sources were harder to develop.

One notable development was the cavity magnetron in 1940, which was the basis for the original radar systems of World War II.

 Read the full article

Human mission to Mars by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 Read the full article

Mach-Zehnder interferometer by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

 Read the full article

Codaisseur/feathersjs-react-redux-ssr by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

github.com/Codaisseur/feathersjs-react-redux-ssr

Also webpack and Babel, looks promising!

As of 2021, last commit from 2017.

Running:

git clone https://github.com/Codaisseur/feathersjs-react-redux-ssr
cd feathersjs-react-redux-ssr
npm install

failed on Ubuntu 20.10 Node.js v14.15.3 with:

../src/create_string.cpp:17:37: error: no matching function for call to ‘v8::String::Utf8Value::Utf8Value(v8::Local<v8::Value>&)’
   17 |   v8::String::Utf8Value string(value);
      |                                     ^

Likely similar bullshit from: stackoverflow.com/questions/50111688/node-sqlite-node-gyp-build-error-no-member-named-forceset-in-v8object because the Node.js version is too new.

If I try nvm install v10

I Google error messages until reaching:

diff --git a/gulpfile.js b/gulpfile.js
index b931e06..24d2cc8 100644
--- a/gulpfile.js
+++ b/gulpfile.js
@@ -14,34 +14,34 @@ gulp.task('css', function() {
            .pipe(gulp.dest('./dist'))
 })
 
-gulp.task('css:watch', ['css'], function() {
+gulp.task('css:watch', gulp.series('css', function() {
   gulp.watch('app/styles/**/*.sass', ['css'])
-})
+}))
 
 gulp.task('moveAssets', function() {
   return gulp.src('./app/assets/**/*')
              .pipe(gulp.dest('./dist/assets'))
 })
 
-gulp.task('build:revAssets', ['css', 'moveAssets'], function() {
+gulp.task('build:revAssets', gulp.series('css', 'moveAssets', function() {
   var rev = new $.revAll()
   return gulp.src('./dist/**/*')
              .pipe(rev.revision())
              .pipe(gulp.dest('./dist/public'))
              .pipe(rev.manifestFile())
              .pipe(gulp.dest('./dist'))
-})
+}))
 
 gulp.task('build:cpServer', function() {
   return gulp.src('./app/**/*.{js,ejs}')
              .pipe(gulp.dest('./dist/server-build'))
 })
-gulp.task('build:revServer', ['build:cpServer'], function() {
+gulp.task('build:revServer', gulp.series('build:cpServer', function() {
   var manifest = gulp.src('./dist/rev-manifest.json')
   return gulp.src('./dist/server-build/{components,containers}/**/*')
              .pipe($.revReplace({ manifest: manifest }))
              .pipe(gulp.dest('./dist/server-build'))
-})
+}))
 
 gulp.task('build', function() {
   runSequence('build:revAssets', 'build:revServer')
diff --git a/package.json b/package.json
index bcb29c3..86bd593 100644
--- a/package.json
+++ b/package.json
@@ -67,7 +67,7 @@
     "redux-thunk": "^0.1.0",
     "request": "^2.79.0",
     "rewire": "^2.3.4",
-    "run-sequence": "^1.2.2",
+    "run-sequence": "^2.2.1",
     "serve-favicon": "^2.3.2",
     "socket.io-client": "^1.7.2",
     "superagent": "^1.4.0",
@@ -86,16 +86,16 @@
     "concurrently": "^2.0.0",
     "cross-env": "^1.0.7",
     "enzyme": "^2.3.0",
-    "gulp": "^3.9.0",
+    "gulp": "^4.0.2",
     "gulp-autoprefixer": "^3.1.0",
     "gulp-load-plugins": "^1.2.0",
     "gulp-rev": "^6.0.1",
-    "gulp-sass": "^2.1.1",
+    "gulp-sass": "4.1.0",
     "gulp-sourcemaps": "^1.6.0",
     "jsdom": "^7.0.1",
     "mocha": "^2.4.5",
     "nock": "^2.17.0",
-    "node-sass": "^3.4.2",
+    "node-sass": "^5.0.0",
     "nodemon": "^1.6.0",
     "react-addons-test-utils": "^15.3.2",
     "react-transform-catch-errors": "^1.0.0",

and the next problem is: stackoverflow.com/questions/48513573/gulp-error-gulp-hastask-is-not-a-function

 Read the full article

Atmospheric science by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 Read the full article

E. Coli K-12 MG1655 gene thrL by

Ciro Santilli 37  Updated 2025-07-01  +Created 1970-01-01

 View more

UniProt entry: www.uniprot.org/uniprot/P0AD86.

NCBI gene entry: www.ncbi.nlm.nih.gov/gene/944742.

The first gene in the E. Coli K-12 MG1655 genome. Remember however that bacterial chromosome is circular, so being the first doesn't mean much, how the choice was made: Section "E. Coli genome starting point".

Part of E. Coli K-12 MG1655 operon thrLABC.

At only 65 bp, this gene is quite small and boring. For a more interesting gene, have a look at the next gene, e. Coli K-12 MG1655 gene thrA.

Does something to do with threonine.

This is the first in the sequence thrL, thrA, thrB, thrC. This type of naming convention is quite common on related adjacent proteins, all of which must be getting transcribed into a single RNA by the same promoter. As mentioned in the analysis of the KEGG entry for e. Coli K-12 MG1655 gene thrA, those A, B and C are actually directly functionally linked in a direct metabolic pathway.

We can see that thrL, A, B, and C are in the same transcription unit by browsing the list of promoter at: biocyc.org/group?id=:ALL-PROMOTERS&orgid=ECOLI. By finding the first one by position we reach; biocyc.org/ECOLI/NEW-IMAGE?object=TU0-42486.

 Read the full article

E. Coli K-12 MG1655 gene dksA by