I loved coding ToH, I want to write more database-less websites/services
How Does a Database Work? | Let’s Build a Simple Database https://cstack.github.io/db_tutorial/
Database as Filesystem - YouTube https://www.youtube.com/watch?v=wN6IwNriwHc
Notion “ The all-in-one workspace for your notes, tasks, wikis, and databases. https://www.notion.so/tools-and-craft/03-ted-nelson
Interesting idea: create a search-by-meaning for functions using the memoization database http://www.vpri.org/pdf/rn2017002_memoization.pdf
GitHub - orbitdb/orbit-db: Peer-to-Peer Databases for the Decentralized Web https://github.com/orbitdb/orbit-db
Is there a term for absurd euphemisms constructed for censoring dialogue for television – like ‘melon farmer’ and ‘this is what happens when you meet a stranger in the alps’? Is there a database of them?
Are there enough shared answers in the jeopardy questions & answers database to make a ‘Ladies, if he X, then he’s not your man, he’s Y’ bot from that corpus? Assume 4 questions per answer.
Bad idea of the day: a database of maps of conceptual spaces that are drawn like maps of physical spaces (ex., xkcd’s map of the internet & Knuppe’s map of the fields of mathematics)
I love it. I have a program that needs to processing about half a million records, which will take 3 days. The database that all those records are suppose to go to is acting up after I’ve just done 140K records.
The design and implementation of modern column-oriented database systems | the morning paper https://blog.acolyer.org/2018/09/26/the-design-and-implementation-of-modern-column-oriented-database-systems/
While certainly not a solution to everything, I find I’m using temporary SQLITE database a bunch to solve problems with a few lines of sql and less then 50 lines of code (to insert data into the SQLITE DB) instead of several hundred of lines of code and a bunch of arrays.
@sdk@codevoid.de I have to admit that’s true. While I don’t call myself an expert, I almost always wore several hats at places I’ve worked. Programmer, Server Admin, Network Admin, Cable Puller, Telephone Admin, PBX installer, Database Admin, etc
Notion “ The all-in-one workspace for your notes, tasks, wikis, and databases. https://www.notion.so/tools-and-craft/01-andy-hertzfeld
GitHub - geophile/osh: Osh (Object SHell) is a command-line and API toolkit combining cluster access, database access, and data slicing and dicing. Sort of like awk and cssh morsels wrapped up in a Python crust. https://github.com/geophile/osh
#nanogenmo idea: a database of loosely-related epigrams or paragraphs, tagged by topic; going to a topic displays the associated epigrams in arbitrary order. the tags are generated from analysis of the text.
Fun with data! The complete roster twtxt database can be downloaded at https://roster.twtxt.org/twtxt_20160405.sql.gz
MySQL Database Insert & Get Last Insert ID ⌘ Read more…
@kdy I kinda hope people don’t mess with the timestamp, I use it as part of a UNIQUE constraint in the database for my site: https://git.xeserv.us/xena/twtxtlist/src/master/src/twtxtlist.nim#L14-L20
a nice side effect of all this is that you can reconstruct the data instantly, so my sqlite database can actually be quite volatile