ROW_NUMBER Updated Created
sqlite3 ':memory:'  'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over () FROM t'
Possible output:
-1|1
-1|2
-2|3
Gives them unique IDs.
With a partition by:
sqlite3 ':memory:'  'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over ( partition by i ) FROM t'
possible output:
-2|1
-1|1
-1|2
Ruby on Rails React integration Updated Created
Integrations React integration:
Sample code Updated Created
Like everything else in programming, the only way to really understand this is to play with minimal examples.
What makes this a "hard" subject is that the minimal example is large because you need to make your own small OS.
C. elegans nervous system Updated Created
Celestron NexStar Updated Created
Video 1.
Celestron NexStar SE Tutorial by Astronomia UK (2022)
Source. Meh! ;-)
Center Updated Created
Child of physics 2 Updated Created
Chinese company Updated Created
Chinese culture Updated Created
Bibliography:
Chinese currency Updated Created
Chinese Updated Created
Chinese policy Updated Created
Chordate Updated Created
Chordate is a sad clade.
You read the name and think: hmm, neural cords!
But then you see that his is one of its members:
Yup. That's your cousin. And it's a much closer cousin than something like arthropods, which at least have heads eyes and legs like you.
Xah Lee Updated Created
Figure 1.
Xah Lee with some weird statuettes of himself
. Source. 2019.
Let's see:
X-10 Graphite Reactor Updated Created
This was an intermediate step between the nuclear chain reaction prototype Chicago Pile-1 and the full blown plutonium mass production at Hanford site. Located in the Oak Ridge National Laboratory.
Figure 1.
Exterior of the X-10 Graphite Reactor in 1950
. Source.
Figure 2.
Workers loading Uranium into the X-10 Graphite Reactor with a rod
. Source.
XP School Updated Created
Amazing self-directed learning direction:
The pupils have a parents' evening coming up but instead of their teachers giving an account of their progress, it is a "student-led conference" at which they must present a portfolio of their work, explain what they are most proud of and discuss where they need to put in more effort.
world.hey.com/gwyn/no-excuses-bc4152fb mentions that the founder was inspired by other schools: High Tech High and Expeditionary Learning.
Lots of focus on showcase student work.
The founder Gwyn ap Harri is quite dirty mouthed, which is also cool.
Ciro Santilli tried to contact them in 2021 at: twitter.com/cirosantilli/status/1448924419016036353 and on website contact form to see if we could do some project together, but no reply.
X-ray crystallography Updated Created
One of its main applications is to determine the 3D structure of proteins.
Sometimes you are not able to crystallize the proteins however, and the method cannot be used.
Crystallizing is not simple because:
  • you need a considerable amount of the protein
  • sometimes it only crystallizes if you add some extra small chemical that stabilizes it
Cryogenic electron microscopy can sometimes determine the structures of proteins that failed crystallization.
Chromosome Updated Created

Unlisted articles are being shown, click here to show only listed articles.