Many of the games are disabled by default on Ubuntu. But we can enable some games and build from source with:
apt-get source bsdgames
cd bsdgames-*
sed -ri '/^bsd_games_cfg_no_build_dirs=/s/ number / /' config.params
./configure
make -jHere we enabled the game number, so now we can:which gives:
number/number 123one hundred twenty-three.We can also "install" it locally with:which puts the games locally under:which you can add to your
make installdebian/bsdgames/usr/games/numberPATH environment variable.There are infinitely many conjectures asking if such types of primes also form infinite families.
Usually the answer is yes, but no one was able to prove it yet.
National Institute of Advanced Industrial Science and Technology Updated 2025-06-12 +Created 2024-12-13
Homepage: www.mysteryofmatter.net
Particularly tasteful is their choice of native speaker actors who speak their native language for less important narration, and English with an accent for more important moments, in particular when talking solo to the camera.
This one is good: stackoverflow.com/questions/36533429/generate-random-string-in-postgresql/44200391#44200391 as it also describes how to generate multiple values.
with symbols(characters) as (VALUES ('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'))
select string_agg(substr(characters, (random() * (length(characters) - 1) + 1)::INTEGER, 1), '')
from symbols
join generate_series(1,8) as word(chr_idx) on 1 = 1 -- word length
join generate_series(1,10000) as words(idx) on 1 = 1 -- # of words
group by idx;Then you can insert it into a row with:
create table tmp(s text);
insert into tmp(s)
select s from
(
with symbols(characters) as (VALUES ('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'))
select string_agg(substr(characters, (random() * (length(characters) - 1) + 1)::INTEGER, 1), '') as asdf
from symbols
join generate_series(1,8) as word(chr_idx) on 1 = 1 -- word length
join generate_series(1,10000) as words(idx) on 1 = 1 -- # of words
group by idx
) as sub(s);A more convenient approach is likely to define the function:
CREATE OR REPLACE FUNCTION random_string(int) RETURNS TEXT as $$
select
string_agg(substr(characters, (random() * length(characters) + 1)::integer, 1), '') as random_word
from (values('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789 --')) as symbols(characters)
join generate_series(1, $1) on 1 = 1
$$ language sql;And then:
create table tmp(s text, t text);
insert into tmp(s) select random_string(10) from generate_series(10);- output one column per line: stackoverflow.com/questions/9604723/alternate-output-format-for-psql-showing-one-column-per-line-with-column-name
- PostgreSQL does not automatically index foreign keys! stackoverflow.com/questions/970562/postgres-and-indexes-on-foreign-keys-and-primary-keys
Convert project Gutenberg King James Bible to verse number to text dataset Updated 2025-06-12 +Created 2024-12-05
This section is about converting: www.gutenberg.org/ebooks/10, and most likely the plaintext version: stackoverflow.com/a/43060761/895245 to the same data format as www.kaggle.com/datasets/oswinrh/bible mapping book/chapter/verse to the text:
1 1 1 In the beginning God created the heaven and the earth.
1 1 2 And the earth was without form, and void; and darkness was upon the face of the deep.On particular annoyance is that the txt version has multiple verses per line at times.
Verse number to text:
- www.kaggle.com/datasets/oswinrh/bible verse to text. TODO how was it generated
- gist.github.com/sebastiancarlos/2fdb072e46ee80038d6da196cc0bb8bc
- sebastiancarlos.com/religions-please-migrate-your-holy-texts-to-json-76bce058291d
- www.reddit.com/r/programming/comments/wv6q6r/religions_please_migrate_your_holy_texts_to_json/
- github.com/acrawford73/postgresql-bible-kjv pre-extracted CSV with undocumented method
Actual NLP into text:
- github.com/BradyStephenson/bible-data actually digs a bit into the text
Unlisted articles are being shown, click here to show only listed articles.