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
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
Nice Idea but I don’t believe this belongs to the database. https://t.co/Uy1wiVBNNz
rtdb.py: Extension for dtuple.py
This is specific to sqlite but could easily be adopted to work with other databases. # # rtdb.py: Extension for dtuple.py # # Written by Dennis T Kaplan . Public Domain. # No Copyright, no Rights Reserved, and no Warranties. class rtdb: def __init__(self, dbname, sql, one = True): self.one = one connection = sqlite3.connect(dbname) […] ⌘ Read more