CC-BY-NC Science Surf
accessed 30.11.2025
Es geht darum, Handlungsräume zu beschreiben
Ausriss von https://www.wissenschaft-im-dialog.de/blog/blogartikel/beitrag/ich-bin-ein-misfit/
Es geht darum, Handlungsräume zu beschreiben und loszulaufen. Ob und wie viele Menschen mitkommen, liegt außerhalb unserer Macht. Aber Dankbarkeit für das Leben und Verantwortung für seinen gesunden Erhalt zu übernehmen, auch wenn wir nicht wissen, wie das Morgen wird, ist eine schöne Energie und bereichert das Jetzt.
(Maja Göpel)
CC-BY-NC Science Surf
accessed 30.11.2025
The Bluest Blues
https://www.zeit.de/kultur/musik/2013-03/alvin-lee-ten-years-after-tod?page=1#comments
CC-BY-NC Science Surf
accessed 30.11.2025
Convert MS SQL Server database to SQLITE
It took me basically 2 days to figure that out as most hits at Google were misleading.
My recommendation now is to install Docker and use a 2019 version of MS SQL Server.
docker pull mcr.microsoft.com/mssql/server:2019-latest docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=you_should_know_it" -e "MSSQL_PID=Express" -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2019-latest sudo docker ps -a # gives you the id like bea83... below that is needed to copy the mdf file to the container docker cp /Users/you_should_know/database.mdf bea8369066ed:/var/opt/mssql/data docker cp /Users/you_should_know/database_log.ldf bea8369066ed:/var/opt/mssql/data
Login as su and change permission of the uploaded file. Afterwards attach the database
sudo docker exec -u 0 -it sql1 "bash" chmod 777 /var/opt/mssql/data/data*.* /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P "you_should_know_it" -Q "CREATE DATABASE [new_data_base] ON (FILENAME = N'/var/opt/mssql/data/database.mdf'),(FILENAME = N'/var/opt/mssql/data/database_log.ldf') FOR ATTACH"
Cool, on localhost:1443 we can now see MS SQL Server working..
Connecting with Azure was a dead end, also with SQL Pro Studio as the export could not be read by SQLITE.
Razor SQL worked (do not use DB Tools -> Export but DB Tools -> Database Conversion).
This generates a sql file that SQLITE will understand.
cat run.sql | sqlite3 database.db
CC-BY-NC Science Surf
accessed 30.11.2025
Fortunately Galactica is down
I just started a review of Galactica.
but today the search bar is already gone. So what happened here? cnet knows more
Galactica is an artificial intelligence developed by Meta AI (formerly known as Facebook Artificial Intelligence Research) with the intention of using machine learning to “organize science.” It’s caused a bit of a stir since a demo version was released online last week, with critics suggesting it produced pseudoscience, was overhyped and not ready for public use.
There is no need to make any further comment.
CC-BY-NC Science Surf
accessed 30.11.2025
On code review
A R function creating 96 well plate sample assignment
Most recently I had to add forgotten data to a SQL server database that was in use only until 2010. Script language was Cold Fusion at that time creating a visual interface to 96 well plates where proband IDs are assigned to plate positions by drop down fields.
R doesn’t have any good way for formatted data entry. Some shiny apps would be helpful but a bit overkill here. Data export into a javascript framework would be also a more professional solution while I just needed only a quick way to modify my database.
So I came up with some R code producing html code embedding javascript functions that can export the result as SQL code, so a 4 language mixup.
dataentry <- function(plate_id,city) {
# get orig IDs from database first
# position identifier A01, A02...
pos = NULL
for (i in 1:8) {
pos = c(pos, paste0( rep( LETTERS[i], 12), str_pad( 1:12 ,2,pad="0" ) ) )
}
HTML <- paste('<html>
<script>
function download(filename, text) {
var element = document.createElement("a");
element.setAttribute("href", "data:text/plain;charset=utf-8," + encodeURIComponent(text));
element.setAttribute("download", filename);
element.style.display = "none";
document.body.appendChild(element);
element.click();
document.body.removeChild(element);
}
function saveValues() {
var frm = document.getElementById("f");
var params = "";
var sample_id = ',sample_id,';
for( var i=0; i<frm.length; i++ ) {
sample_id++;
var fieldId = frm.elements[i].id;
var fieldValue = frm.elements[i].value;
if (fieldValue) params += "INSERT INTO samples (plate_id,plate_position,patient_id) VALUES (',plate_id,'," + fieldId + "," + fieldValue + ")\\n";
}
download("',plate_id,'.SQL",params);
}
</script>
<body>
<form id="f">')
# dropdowns
sel ='<option value=""></option>'
for (i in 1:dim(patients)[1]) {
sel <- paste0(sel,'<option value=',patients[i,"patient_id"],'>',patients[i,"Orig_ID"],'</option>\n')
}
for (i in pos) {
if (substr(i,2,3) == "01") HTML <- paste0(HTML,'<BR>')
HTML <- paste(HTML,'<select id=',i,'>',sel,'</select>')
}
HTML <- paste(HTML,'</form>
<br><input name="save" type="button" value="SQL" onclick="saveValues(); return false"/>
</body></html>')
sink( paste('plate.html') )
cat(HTML)
sink()
}
dataentry(725,'city')
CC-BY-NC Science Surf
accessed 30.11.2025
Une grenouille vit un Bœuf
Ein Frosch sah einen Ochsen gehen.
Une grenouille vit un Bœuf
Wie stattlich war der anzusehen!
Qui lui sembla de belle taille.
Er, der nicht größer als ein Ei, war neidisch drauf,
Elle qui n’était pas grosse en tout comme un œuf,
Er spreizt sich, bläht mit Macht sich auf,
Envieuse s’étend, et s’enfle, et se travaille
Um gleich zu sein dem großen Tier,
Pour égaler l’animal en grosseur,
Und rief: »Ihr Brüder achtet und vergleicht!
Disant : « Regardez bien, ma sœur,
Wie, bin ich nun so weit? Ach, sagt es mir!« –
Est-ce assez ? dites-moi : n’y suis-je point encore ?
»Nein!« – »Aber jetzt?« – »Was denkst du dir!« –
— Nenni. — M’y voici donc ? — Point du tout. — M’y voilà ?
»Und jetzt?« – »Noch lange nicht erreicht!« –
— Vous n’en approchez point. » La chétive pécore »
Das Fröschlein hat sich furchtbar aufgeblasen,
Es platzte und verschied im grünen Rasen.
S’enfla si bien qu’elle creva.
Le monde est plein de gens qui ne sont pas plus sages :
Tout Bourgeois veut bâtir comme les grands Seigneurs,
Tout petit Prince a des Ambassadeurs,
Tout Marquis veut avoir des Pages.
CC-BY-NC Science Surf
accessed 30.11.2025
IPFS
CC-BY-NC Science Surf
accessed 30.11.2025
Why lines of code is a bad metric for a programmer
There is a long explanation over at medium
committing code is a small part of what software engineers do. There are many ways in which you can contribute technically without writing much code. In fact, the best senior engineers I know are great at prioritization, delegation, and simplifying. Their pull requests are tiny because they’ve made the code modular and straightforward. … Writing negative code is a point of pride! If you refactored a complex piece of logic, picked a good library to solve a problem, or eliminated unnecessary features, then you’ll have a negative commit history. .. fine-tune configs, research arcane issues, and dive deep into underlying architecture. Working on these jobs can mean days of research just to make a few-line change.
The same applies to amount of funding received by a scientist (although frequently used for calculation of salariy). If I can achieve the same impact at a fraction of the costs, isn’t that much better than producing more costs?
CC-BY-NC Science Surf
accessed 30.11.2025
At least one positive advice?
Is there at least one positive advice of all that Musk utterance?
- Avoid large meetings
Large meetings waste valuable time and energy – They discourage debate – People are more guarded than open – There’s not enough time for everyone to contribute. Don’t schedule large meetings unless you’re certain they provide value to everyone. - Leave a meeting if you’re not contributing
If a meeting doesn’t require your: – Input – Value – Decisions Your presence is useless. It’s not rude to leave a meeting. But it’s rude to waste people’s time. - Forget the chain of command
Communicate with colleagues directly. Not through supervisors or managers. Fast communicators make fast decisions. Fast decisions = competitive advantage. - Be clear, not clever
Avoid nonsense words and technical jargon. It slows down communication. Choose words that are: – Concise – To the point – Easy to understand Don’t sound smart. Be efficient. - Ditch frequent meetings
There’s no better way to waste everyone’s time. Use meetings to: – Collaborate – Attack issues head-on – Solve urgent problems But once you resolve the issue, frequent meetings are no longer necessary. You can resolve most issues without a meeting. Instead of meetings: – Send a text – Send an email – Communicate on a discord or slack channel Don’t interrupt your team’s workflow if it’s unnecessary. - Use common sense if a company rule doesn’t make sense
Contribute to progress – Apply to your specific situation Avoid following the rule with your eyes closed. Don’t follow rules. Follow principles.
Warning : 2) and even other x) only suitable for slightly autistic, self obsessed and excellent scientists.
CC-BY-NC Science Surf
accessed 30.11.2025
Brave new AI science world
AI works well in some areas while results are very mixed or even dangerous in others [1, 2].
But what about AI in generic scientific areas?
I have recently looked at scite.ai, a service that claims to analyze a paper if the references have been supported or contrasted the findings — any references that have been retracted in the meantime or received an expression of concern? While the latter isn’t really a big question, I was not very much impressed by the results as most references could not be classified.
But there are now more companies off the ground. Let’s have a look at some.
One is SciScore
SciScore claims
SciScore generates three reports and a score for every submission. These materials assist researchers, editors, and funders in improving the quality and reliability of scientific research by automatically reporting detected criteria of interest for future review. Researchers signing up with their ORCID get ten free reports. Reports can take as little as 1 minute!
The next one is Prophy, another reference finder.
and there is Galactica.
and well also copy.ai
I have no idea if we really need this kind of stuff – any AI to write my blog even faster?
Also others commented earlier this month that it is “not obviously wrong but wrong in subtle ways”.
Fortunately Copyleaks released now even an AI detector just to fight back…
CC-BY-NC Science Surf
accessed 30.11.2025
No irony allowed
Ronagh & Souder in “The ethics of ironic science”
We adopt the concept of irony from the fields of literary and rhetorical criticism to detect, characterize, and analyze the interpretations in the more than 60 published research papers that cite an instance of ironic science. We find a variety of interpretations: some citing authors interpret the research as valid and accept it, some contradict or reject it, and some acknowledge its ironic nature.
bonus example 61 “Effect on human longevity of added dietary chocolate“
CC-BY-NC Science Surf
accessed 30.11.2025
Es gelingt so selten jemand an die richtige Stelle zu bringen
Does identification of misconduct in studies affect medical guidelines?
This question has been answered by an earlier study of Avenell et al.
By 2016 the affected trial reports were cited in 1158 publications, including 68 systematic reviews, meta-analyses, narrative reviews, guidelines and clinical trials. We judged that 13 guidelines, systematic or other reviews would likely change their findings if the affected trial reports were removed, and in another eight it was unclear if findings would change. By 2018, only one of the 68 citing publications, a systematic review, appeared to have undertaken a reassessment, which led to a correction.
We found evidence that this group of affected trial reports distorted the evidence base. Correction of these distortions is slow, uncoordinated and inconsistent. Unless there is a rapid, systematic, coordinated approach by bibliographic databases, authors, journals and publishers to mitigate the impact of known cases of research misconduct, patients, other researchers and their funders may continue to be adversely affected.
CC-BY-NC Science Surf
accessed 30.11.2025