Star Trek: Voyager 星艦上的資料庫 ⌘ Read more

Think of it like buying a signed print of a photo, instead of the photo itself, but the “signature” is an entry in a database and that’s all you get. Still dumb.

An unlikely database migration at tailscale ⌘ Read more…

bitcaskfs - A FUSE filesystem for the Bitcask database ⌘ https://github.com/prologic/bitcaskfs

The lospec palette list is a database of palettes for pixel art: [[https://lospec.com/palette-list]] #links #pixelart #color

huh. it seems that dumping + gzipping a SQLite database can sometimes have better compression than gzipping the SQLite database directly. cool. #sqlite

It works better if you start up its database first.

Baserow: Open source online database tool https://gitlab.com/bramw/baserow #airtable alternative ⌘ https://baserow.io/

4 practical principles of high-quality database integration tests in Go ⌘ https://threedots.tech/post/database-integration-testing

here is the script I use to convert my twtxt feed into a SQLite database: !twtxt_sqlite

a unique thing I do with my twtxt feed is convert it to a SQLite database. This, combined with the Janet + SQLite scripting abilities available in SQLite, could provide interesting metrics and insights over time.

in particular, twtxt provides timestamps. weewiki doesn’t really track the passage of time. it only wants to be a key/value database with org markup.

Posted to Entropy Arbitrage: Database Basics https://john.colagioia.net/blog/2020/04/05/database.html #database #intro #education #preparation

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

Setup Syncthing to mirror buku bookmark database

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

Backing up and restoring GPG keys
If you use GPG to occasionally encrypt and/or sign your email, or to encrypt your files before placing them on the cloud, you will understand how important it is to have a backup of your GPG keys. Similarly important will be to know how to restore them as well.

To back your private, and public keys, as well as your trust database, you will do1:

gpg --armor --export-secret-keys > ~/Des ... ⌘ [Read more](https://collantes.us/2015/10/13/backing-up-and-restoring-gpg-keys/)

Nice Idea but I don’t believe this belongs to the database. https://t.co/Uy1wiVBNNz

Hello world, again!
I am starting over. I might “port” back some entries from the old weblog, but that’s pretty much it. Right now everything is in state of flux, running on a vanilla WordPress installation with a couple of plugins on. Work will progress as time permits.

There isn’t one single reason why I am starting over, but a few. Basically, the old weblog database was “dirty” with entries and rows, and tables from plugins… and god knows what other things (I ran quite a few experiments on that one) … ⌘ Read more

Small catching up
Last week was a busy week. The Exchange server went into ¾ full production and, yes, it crashed. For the first time I had to recover the PRIV and PUB databases and the server wasn’t been on production not even a week! Oh boy…

I got the Lingo gateway (VoIP gateway, that is) and the quality is excellent, while reaching their technical support is close to impossible. When I finall … ⌘ Read more