|
Warning: this is an htmlized version!
The original is here, and the conversion rules are here. |
#######
#
# E-scripts on LLMs.
#
# Note 1: use the eev command (defined in eev.el) and the
# ee alias (in my .zshrc) to execute parts of this file.
# Executing this file as a whole makes no sense.
# An introduction to eev can be found here:
#
# (find-eev-quick-intro)
# http://anggtwu.net/eev-intros/find-eev-quick-intro.html
#
# Note 2: be VERY careful and make sure you understand what
# you're doing.
#
# Note 3: If you use a shell other than zsh things like |&
# and the for loops may not work.
#
# Note 4: I always run as root.
#
# Note 5: some parts are too old and don't work anymore. Some
# never worked.
#
# Note 6: the definitions for the find-xxxfile commands are on my
# .emacs.
#
# Note 7: if you see a strange command check my .zshrc -- it may
# be defined there as a function or an alias.
#
# Note 8: the sections without dates are always older than the
# sections with dates.
#
# This file is at <http://anggtwu.net/e/llms.e>
# or at <http://anggtwu.net/e/llms.e.html>.
# See also <http://anggtwu.net/emacs.html>,
# <http://anggtwu.net/.emacs[.html]>,
# <http://anggtwu.net/.zshrc[.html]>,
# <http://anggtwu.net/escripts.html>,
# and <http://anggtwu.net/>.
#
#######
# «.emacs-packages» (to "emacs-packages")
# «.chatgpt-free» (to "chatgpt-free")
# «.gptel» (to "gptel")
# «.sqlite-to-python» (to "sqlite-to-python")
# «.sqlite-to-elisp» (to "sqlite-to-elisp")
# «.video-smaller» (to "video-smaller")
# «.strawberry-question» (to "strawberry-question")
# «.i-used-to-love-curl» (to "i-used-to-love-curl")
# «.o-cisne» (to "o-cisne")
# «.fracoes-parciais» (to "fracoes-parciais")
#####
#
# emacs-packages
# 2024sep05
#
#####
# «emacs-packages» (to ".emacs-packages")
# (find-telegachat "6264384040#236523" "que eu te mando links pros mais óbvios")
# (find-telegachatm "6264384040#236524")
# (find-epackage-links 'chatgpt-shell)
# (find-epackage-links 'gpt)
# (find-epackage-links 'gpt-commit)
# (find-epackage-links 'gptai)
# (find-epackage-links 'gptel)
# (find-epackage-links 'magit-gptcommit)
# (find-epackage-links 'ob-chatgpt-shell)
# (find-epackage-links 'org-ai)
# (find-epackage-links 'sumibi)
#####
#
# chatgpt-free
# 2024sep05
#
#####
# «chatgpt-free» (to ".chatgpt-free")
# (find-telegachat "6264384040#237141" "Tipo algum esquema de N perguntas gratis por mes?")
# https://chatgpt.com/
#####
#
# gptel
# 2024sep05
#
#####
# «gptel» (to ".gptel")
# https://www.blogbyben.com/2024/08/gptel-mindblowing-integration-between.html?m=1
# https://www.blogbyben.com/2024/08/gptel-mindblowing-integration-between.html
# (find-youtubedl-links "/sda5/videos/Emacs/" "Every_LLM_in_Emacs_with_gptel" "bsRnh_brggM" ".mp4" "everyllm")
# (code-video "everyllmvideo" "/sda5/videos/Emacs/Every_LLM_in_Emacs_with_gptel-bsRnh_brggM.mp4")
# (find-everyllmvideo "0:00")
# (find-everyllmvideo "1:28")
# (find-epackage-links 'gptel "gptel" "~/.emacs.d/elpa/gptel-20240905.1946/")
# (code-c-d "gptel" "~/.emacs.d/elpa/gptel-20240905.1946/")
# (find-gptelfile "")
# (find-gptelgrep "grep --color=auto -niH --null -e chatgpt *.el")
# (find-efunctiondescr 'gptel-send)
# (find-efunction 'gptel-send)
# (find-evardescr 'gptel-api-key)
# (find-evariable 'gptel-api-key)
# (find-efunctiondescr 'gptel-api-key-from-auth-source)
# (find-efunction 'gptel-api-key-from-auth-source)
# (find-node "(auth)Overview")
#####
#
# sqlite-to-python
# 2024sep05
#
#####
# «sqlite-to-python» (to ".sqlite-to-python")
# https://chatgpt.com/share/928d014f-c32e-4dd3-a6c7-1f3f6615d7a8
# (find-es "sqlite" "python")
# (find-man "1 sqlite3")
---
How do I translate these SQLite commands to the Python SQLite API?
create table tbl1 (one varchar(10), two smallint);
insert into tbl1 values ('hello!', 10);
insert into tbl1 values ('goodbye', 20);
.mode columns
.headers on
select * from tbl1;
.help
.databases
.dump tbl1
.exit
---
* (eepitch-shell)
* (eepitch-kill)
* (eepitch-shell)
rm -fv /tmp/example.db
sqlite3 /tmp/example.db
create table tbl1 (one varchar(10), two smallint);
insert into tbl1 values ('hello!', 10);
insert into tbl1 values ('goodbye', 20);
.mode columns
.headers on
select * from tbl1;
.help
.databases
.dump tbl1
.exit
* (find-sh0 "rm -fv /tmp/example.db")
* (eepitch-python)
* (eepitch-kill)
* (eepitch-python)
import sqlite3
conn = sqlite3.connect('/tmp/example.db')
cursor = conn.cursor()
cursor.execute("CREATE TABLE tbl1 (one VARCHAR(10), two SMALLINT)")
cursor.execute("INSERT INTO tbl1 VALUES ('hello!', 10)")
cursor.execute("INSERT INTO tbl1 VALUES ('goodbye', 20)")
conn.commit()
cursor.execute("SELECT * FROM tbl1")
rows = cursor.fetchall()
print("one".ljust(10), "two")
print("-" * 15)
for row in rows:
print(str(row[0]).ljust(10), row[1])
for line in conn.iterdump():
print(line)
conn.close()
* (sqlite-mode-open-file "/tmp/example.db")
#####
#
# sqlite-to-elisp
# 2024sep07
#
#####
# «sqlite-to-elisp» (to ".sqlite-to-elisp")
# https://chatgpt.com/c/66dcfce6-57dc-800a-8302-4cf71445523d
# (find-es "sqlite" "elisp")
(require 'sqlite)
(delete-file "/tmp/foo.db")
(setq db (sqlite-open "/tmp/foo.db"))
(sqlite-execute db "CREATE TABLE tbl1 (one VARCHAR(10), two SMALLINT);")
(sqlite-execute db "INSERT INTO tbl1 VALUES ('hello!', 10);")
(sqlite-execute db "INSERT INTO tbl1 VALUES ('goodbye', 20);")
(sqlite-select db "SELECT * FROM tbl1;")
(setq dbcreates
(mapconcat
(lambda (row) (format "%s\n" row))
(sqlite-execute db "SELECT sql FROM sqlite_master WHERE type='table' AND name='tbl1';")
))
(setq dbcreates
(mapconcat
(lambda (row) (format "%s\n" row))
(sqlite-execute db "SELECT sql FROM sqlite_master WHERE type='table';")
))
(setq dbselects
(mapconcat
(lambda (row) (format "%S\n" row))
(sqlite-select db "SELECT * FROM tbl1;")
""))
(with-temp-buffer
(insert dbcreates)
(insert (mapconcat (lambda (row) (format "%S" row))
(sqlite-select db "SELECT * FROM tbl1;")
"\n"))
(write-file "/tmp/foo_dump.sql"))
(message "Data: %S" result))
;; Open the database (in-memory for example)
(let ((db (sqlite-open ":memory:")))
;; Create table
;; Insert values
;; Select data
(let ((result (sqlite-select db "SELECT * FROM tbl1;")))
(message "Data: %S" result))
;; Dump table
;; Close the connection
(sqlite-close db))
#####
#
# video-smaller
# 2024sep06
#
#####
# «video-smaller» (to ".video-smaller")
# https://chatgpt.com/c/66daee4c-7acc-800a-95fd-d8036ba76f9c
# How do I convert a video to a smaller format with ffmpeg?
#####
#
# strawberry-question
# 2024sep22
#
#####
# «strawberry-question» (to ".strawberry-question")
anthropic strawberry hacker news
https://news.ycombinator.com/item?id=40116488 Anthropic: Prompt Library (anthropic.com)
https://news.ycombinator.com/item?id=41395921 Anthropic's Prompt Engineering Interactive Tutorial (github.com/anthropics)
https://news.ycombinator.com/item?id=40116488 Anthropic: Prompt Library (anthropic.com)
https://news.ycombinator.com/item?id=41540902 Terence Tao on O1 (mathstodon.xyz)
https://www.reddit.com/r/singularity/comments/1dl3pgq/the_strawberry_question_should_now_be_a_prize_lol/
#####
#
# i-used-to-love-curl
# 2024dec24
#
#####
# «i-used-to-love-curl» (to ".i-used-to-love-curl")
# https://news.ycombinator.com/item?id=42501922 Open source maintainers are drowning in junk bug reports written by AI (theregister.com) - However, after engaging with its creator, I felt disrespected
#####
#
# "O cisne" do Cruz e Souza
# 2025aug16
#
#####
# «o-cisne» (to ".o-cisne")
# https://www.threads.com/@karolaferraz/post/DNVzi6-tdEn
Passei uma atividade para recuperação e minha maior decepção foi a
maioria ter entregado. Eu explico:
Na aula de Literatura estudávamos o autor Cruz e Sousa, alguns alunos
não atingiram a média bimestral e eu decidi passar uma atividade para
recuperar a nota. Pois bem, pedi que os alunos lessem o poema “O
Cisne” do dito autor e respondessem algumas questões de interpretação
sobre o texto.
A maioria fez, para a minha tristeza, dei o visto conforme os cadernos
foram chegando e não falei nada...
Quando todos já haviam finalizado a atividade eu perguntei como haviam
conseguido responder às questões. Em uníssono disseram “porque lemos o
texto professora!”. Pedi que lessem o texto em voz alta, cada aluno
uma estrofe. Quando o primeiro aluno começou, os outros se
entreolharam, confusos... o outro já não quis ler, e a partir daí
entenderam tudo:
O poema “O cisne” não existe! Eles pesquisaram no chat GPT, que criou
um texto diferente para cada aluno e inventou respostas para as
perguntas.
E a habilidade aprendida no dia foi: Reconhecer fontes de informação
confiáveis em notícias, veículos de divulgação e outros meios,
avaliando sua credibilidade.
#####
#
# fracoes-parciais
# 2025nov21
#
#####
# «fracoes-parciais» (to ".fracoes-parciais")
# Como eu integro (2x+3)/((x-4)(x+5)) por frações parciais?
# https://chatgpt.com/c/69209240-1f34-8328-9ff0-c8599714ff3b
# (find-telegachat "@rcdrun#241420" "The Power of Eev: Enhancing Emacs for Beginners and Experts Alike")
https://ben.page/jumbocode-ai AI is an impediment to learning web development
https://news.ycombinator.com/item?id=41757711 AI is an impediment to learning web development (ben.page)
https://old.reddit.com/r/ChatGPT/comments/1fye6tb/the_human_internet_is_dying_ai_images_taking_over/
https://news.ycombinator.com/item?id=41767648 Nearly all of the Google images results for "baby peacock" are AI generated (twitter.com/notengoprisa)
https://old.reddit.com/r/MaliciousCompliance/comments/1gmkwg3/i_cant_give_students_a_zero_for_using_ai_unless_i/ Elara
https://news.ycombinator.com/item?id=42093394 When you ask ChatGPT "Tell me a story" it's always is about a girl named Elara (reddit.com)
How do I create an array with all the file names in a directory in Python?
https://chatgpt.com/c/66dc8826-921c-800a-94db-63069883d5d3
https://gist.github.com/PHAredes/b3f986648fa31120fa2997e27dde4475 sexp hyperlinks and eepitch blocks
# (find-google-links "how do I obtain my chatgpt key")
https://github.com/pv-pterab-s/emacs-pinky-saver/tree/main
# (find-telegachat "-1002188044240#4239" "igualdade é antissimetrica")
# (find-fline "~/tmp/equality_is_anisymmetric.jpg")
https://openai.com/chatgpt/use-cases/student-writing-guide/
https://news.ycombinator.com/item?id=42129064 A Student's Guide to Writing with ChatGPT (openai.com)
https://www.geoffreylitt.com/2024/12/22/making-programming-more-fun-with-an-ai-generated-debugger
https://blog.startifact.com/posts/the-curious-case-of-quentell/ ***
https://stratechery.com/2025/deepseek-faq/
https://news.ycombinator.com/item?id=42841524 DeepSeek FAQ (stratechery.com)
https://locusmag.com/2023/12/commentary-cory-doctorow-what-kind-of-bubble-is-ai/ ***
https://biblioracle.substack.com/p/chatgpt-cant-kill-anything-worth
https://news.ycombinator.com/item?id=43451166 ChatGPT can't kill anything worth preserving (biblioracle.substack.com)
https://news.ycombinator.com/item?id=43542131 The case against conversational interfaces (julian.digital) - driving their car by only talking to it
https://gist.github.com/izabera/3fb2f510f9e29811b57d3702002fc2a2 a rubik's cube looks like this
https://www.oneusefulthing.org/p/no-elephants-breakthroughs-in-image
https://socket.dev/blog/slopsquatting-how-ai-hallucinations-are-fueling-a-new-class-of-supply-chain-attacks
https://arstechnica.com/tech-policy/2025/01/ai-haters-build-tarpits-to-trap-and-trick-ai-scrapers-that-ignore-robots-txt/
https://nmn.gl/blog/ai-scam AI Can't Even Fix a Simple Bug — But Sure, Let's Fire Engineers
https://news.ycombinator.com/item?id=44082293 AI can't even fix a simple bug – but sure, let's fire engineers (nmn.gl)
https://chomsky.info/20230503-2/ Noam Chomsky Speaks on What ChatGPT Is Really Good For
https://news.ycombinator.com/item?id=44089156 Chomsky on what ChatGPT is good for (2023) (chomsky.info)
https://addyo.substack.com/p/the-prompt-engineering-playbook-for
https://news.ycombinator.com/item?id=44182188 Prompt engineering playbook for programmers (addyo.substack.com)
https://blog.glyph.im/2025/06/i-think-im-done-thinking-about-genai-for-now.html
https://mail.google.com/mail/u/0/#inbox/FMfcgzQbgJMGwfJwCNHHPjJfMwzlTQKn Daniel Durante - calculadora logica
https://www.afterbabel.com/p/ai-emotional-offloading First We Gave AI Our Tasks. Now We’re Giving It Our Hearts.
https://www.acpjournals.org/doi/10.7326/aimcc.2024.1260 A Case of Bromism Influenced by Use of Artificial Intelligence
https://news.ycombinator.com/item?id=45004846 Comet AI browser can get prompt injected from any site, drain your bank account (twitter.com/zack_overflow)
https://www.alephic.com/writing/the-magic-of-claude-code
https://news.ycombinator.com/item?id=45437893 Unix philosophy and filesystem access makes Claude Code amazing (alephic.com)
https://www.lesswrong.com/posts/AcKRB8wDpdaN6v6ru/interpreting-gpt-the-logit-lens
https://vgel.me/posts/seahorse/
http://archive.md/https://www.newyorker.com/magazine/2025/07/07/the-end-of-the-english-paper there was no social friction, no aura of illicit activity. Nor did it feel like sharing notes
https://www.reddit.com/r/Longreads/comments/1lpaohm/what_happens_after_ai_destroys_college_writing/
;; (find-pdf-page "~/tmp/What Happens After A.I. Destroys College Writing_ _ The New Yorker.pdf")
;; (find-pdf-text "~/tmp/What Happens After A.I. Destroys College Writing_ _ The New Yorker.pdf")
(code-pdf-page "whathappens" "~/tmp/What Happens After A.I. Destroys College Writing_ _ The New Yorker.pdf")
(code-pdf-text "whathappens" "~/tmp/What Happens After A.I. Destroys College Writing_ _ The New Yorker.pdf")
;; (find-whathappenspage)
;; (find-whathappenstext)
# (find-whathappenspage 8 "Apologies for the earlier confusion")
# (find-whathappenstext 8 "Apologies for the earlier confusion")
# (find-whathappenspage 10 "As the craft of writing is degraded by A.I.")
# (find-whathappenstext 10 "As the craft of writing is degraded by A.I.")
# (find-whathappenspage 11 "Respect me enough to give me your authentic voice, even if you don't think it's that great")
# (find-whathappenstext 11 "Respect me enough to give me your authentic voice, even if you don't think it's that great")
# (find-whathappenspage 11 "Students these days view college as consumers")
# (find-whathappenstext 11 "Students these days view college as consumers")
# (find-whathappenspage 12 "I didn't\n retain anything")
# (find-whathappenstext 12 "I didn't\n retain anything")
https://www.newyorker.com/culture/open-questions/whats-happening-to-reading
http://archive.md/https://www.newyorker.com/culture/open-questions/whats-happening-to-reading
https://eli.thegreenplace.net/2025/latex-llms-and-boring-technology/
https://www.planetearthandbeyond.co/p/ai-pullback-has-officially-started They found that AI only increases productivity in “low-skill” tasks / For higher-skilled jobs where accuracy is essential / and authors hiding AI prompts in their papers to get the peer review AI to give them a false good grade ***
https://news.ycombinator.com/item?id=45709486 AI Pullback Has Officially Started (planetearthandbeyond.co)
https://www.anildash.com//2025/10/22/atlas-anti-web-browser/
https://www.tbray.org/ongoing/When/202x/2025/10/28/Grokipedia
https://www.seangoedecke.com/em-dashes/
https://news.ycombinator.com/item?id=45788327 Why do AI models use so many em-dashes? (seangoedecke.com)
https://news.ycombinator.com/item?id=45744209 Ask HN: How to deal with long vibe-coded PRs?
https://www.anildash.com//2025/11/14/wanting-not-to-want-ai/
https://thehumanityarchive.substack.com/p/the-well-where-truth-hides
A college student in Boston submitted his essay. One minute later, researchers asked him to quote a single sentence.
He couldn’t.
Not one line, not even close. The AI had done the work, he got the grade, but 83% of students using AI couldn’t remember anything they’d written minutes earlier while students who used their brains could recite their essays almost verbatim.
The connection was severed. Thought from word. Effort from understanding.
https://mathstodon.xyz/@tao/115591487350860999 Over at the Erdos problem website, AI assistance is now becoming routine
https://x.com/karpathy/status/1993010584175141038 Therefore, the majority of grading has to shift to in-class work (instead of at-home assignments), in settings where teachers can physically monitor students *
https://news.ycombinator.com/item?id=46036878 Implications of AI to schools (twitter.com/karpathy) - There is a fractal pattern between authentic and inauthentic writing. ***
https://oxide-and-friends.transistor.fm/episodes/ai-in-higher-education-with-michael-littman/transcript
https://kelvinpaschal.com/blog/educators-hackers/
La2018
# Local Variables:
# coding: utf-8-unix
# End: