Virtuoso Universal Server Updated +Created
SQL COUNT function Updated +Created
Have a look at some interesting examples under nodejs/sequelize/raw/many_to_many.js.
Being proud of low level programming is stupid Updated +Created
Ciro's word of caution for 2019 aspiring system programmers: Should you waste your life with systems programming?
This is basically a direct consequence of backward design.
The higher the level you can operate at, the better.
C is better than assembly, userland better than kernelland.
The ideal level to operate at, and one of humankind's greatest ambitions is "AGI, make me money", the highest possible level.
Only go down a level when it seems necessary.
Type-II superconductor Updated +Created
Particle decay Updated +Created
Can produce two entangled particles.
Relativistic particle in a box thought experiment Updated +Created
Described for example in lecture 1.
SQL genenerate_series Updated +Created
SQL transaction isolation level Updated +Created
Each transaction isolation level specifies what can or cannot happen when two queries are being run in parallel, i.e.: the memory semantics of the system.
Remember that queries can affects thousands of rows, and database systems like PostgreSQL can run multiple such queries at the same time.
Implementation specifics:
Free university Updated +Created
Related projects:
  • freeuniversitybrighton.org/
    Free University Brighton has been working since 2012 to provide an alternative and for the last five years we’ve been running ‘freegrees’. These are University level courses, open to all regardless of qualification. Our courses range from 4 week long introductory courses aimed at First Years (people who have never been to University before) to 12-week long Humanities, Social Sciences and Philosophy courses that rival anything in a ‘traditional’ University. We do this all with no money exchanged anywhere - no fees, no debt.
Agilent Technologies oscilloscope Updated +Created
Closure table Updated +Created
Nested set model in SQL Updated +Created
How to implement Nested set model in SQL:
How to cite a book on Wikipedia Updated +Created
A good big sample definition:
<ref name="googleStory">{{cite book |last1=Vise |first1=David |author-link1=David A. Vise |last2=Malseed |first2=Mark |author-link2=Mark Malseed |title=The Google Story |date=2008 |publisher=Delacorte Press |url=https://archive.org/details/isbn_9780385342728}}</ref>
There is also title-link to link to a wiki page. But it is incompatible with url= for Internet Archive Open Library links which is a shame.
Wikipedia edit request Updated +Created
So, it turns out that Wikipedia does have a (ultra obscure as usual) mechanism for pull requests. You learn a new one every day.
Steven Pruitt Updated +Created
Video 1.
Meet the man behind a third of what's on Wikipedia
. Source.
Chemiosmosis Updated +Created
SQLite import CSV Updated +Created

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