Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins by user chungy
|
2025-04-02
| ||
| 08:17 | Stardate for “Veritas” (Lower Decks) Leaf check-in: ad8cb74fc0 user: chungy tags: trunk | |
|
2025-03-31
| ||
| 22:56 | Use proper Markdown-format verbatim tags in the command sequence. Closed-Leaf check-in: 365c89b236 user: chungy tags: postgresql | |
| 22:53 | Convert README to Markdown, for display in Fossil. This is <strong>not</strong> meant to convey a continuance of the PostgreSQL version, it is done. I just want this version of the repository to have a nice display. check-in: 5e8beed101 user: chungy tags: postgresql | |
| 11:26 | Use heading-3 in the README's future plans sections check-in: 4464b52492 user: chungy tags: trunk | |
| 11:26 | Add Strange New Worlds seasons 1 and 2, catching the database up to all current official Star Trek productions. check-in: 8fa8a4f8ed user: chungy tags: trunk | |
| 11:05 | Add very Short Treks. In my normal commit cadence, I've been doing shows starting from their first airing, but I'm making an exception here between very Short and Strange New Worlds, since the latter is still being produced (possibly the last Kurtzman-era show), I can keep the episode_id a little saner by including it last. check-in: e75b5fa1fd user: chungy tags: trunk | |
| 10:56 | Add Prodigy. The stardate for episode 8, <em>Time Amok</em>, looks suspicious, being set at 607125.6. Memory Alpha claims the episode takes place on this stardate in the year 2383, whereas episode 10's stardate is listed as 61103.1 in the year 2384. The latter is consistent with the stardate system established first in <em>The Next Generation</em>. The episode would have to be watched to confirm whether the six-figured stardate is actually what it is. check-in: 6bf60fab85 user: chungy tags: trunk | |
| 09:21 | Update README file for status on modern Star Trek progress. check-in: 417538a221 user: chungy tags: trunk | |
| 09:19 | Update README file for status on modern Star Trek progress. Closed-Leaf check-in: 124ba74e0d user: chungy tags: mistake | |
| 09:13 | Add Lower Decks. Season 2 episode 9, “wej Duj” is playing double-duty as a special case in the database. It is so far the only instance where artistic license is overriding my normal sense to use standard title case on episode titles, though being a Klingon phrase might just mean the English rules do not apply anyway. The episode's title is rendered in Klingon script on-screen, but Unicode has thus far refused to admit Klingon script into the text standard. If you have the conscript fonts installed, the name could be rendered also as “ ”. With this check-in, the repository has also now not just reached a status of matching the old PostgreSQL version in entries, but surpassing it entirely. check-in: d66cd430dd user: chungy tags: trunk | |
| 08:31 | Add Star Trek Picard check-in: e47a8eddf5 user: chungy tags: trunk | |
| 08:07 | Add Short Treks check-in: ab78a64678 user: chungy tags: trunk | |
| 07:57 | Ignore Emacs backup files check-in: 17a8b0ae9c user: chungy tags: trunk | |
| 05:20 | Add Star Trek: Discovery metadata, the first part of Kurtzman-era Trek. check-in: d1c8341194 user: chungy tags: trunk | |
| 04:01 | Put the README file back into the source tree, for it provides a better GitHub display. check-in: 850375aee2 user: chungy tags: trunk | |
|
2025-03-30
| ||
| 00:36 | Re-add (short) README, for GitHub purposes :-) check-in: c31deebfff user: chungy tags: trunk | |
|
2025-03-29
| ||
| 23:19 | Complete fossilization of the repository. Move .gitignore to .fossil-settings/ignore-glob, delete REAMDE.md from the source tree (use the wiki instead). The license text is also changed from WTFPL to CC0. check-in: aa5761459e user: chungy tags: trunk | |
| 22:30 | Add Windows batch file to make the database. Requires sqlite3.exe, obtained from the sqlite-tools-win-*.zip file from the SQLite download page. Probably works on DOS too, if you built a DOS version of SQLite. ;) check-in: 502711a730 user: chungy tags: trunk | |
| 22:16 | Re-order drop table commands in schema.sql. This order will allow the schema.sql script to work even when running with `PRAGMA foreign_keys=on;` (as you'd get with an active sqlite3 shell). check-in: fde322b1e5 user: chungy tags: trunk | |
| 22:06 | SQLite conversion: part two. This brings in a complete (in reference to the PostgreSQL data set) listing of Star Trek series DVDs/Blu-ray. It turns out I hadn't even done Voyager DVDs in the previous version, that oversight is now corrected. This makes the SQLite conversion effectively fully-functional compared to the Postgres version, not counting the incomplete older listings of Discovery, Picard, and Lower Decks. check-in: c1aaa5787f user: chungy tags: trunk | |
| 10:18 | SQLite conversion: part one. SQLite's main advantage over PostgreSQL is that it doesn't require any server set up. It's a bit more limited in features, but still plenty for this data set. Movie and episode data are here, and the TOS Blu-ray set. More to come soon. check-in: 6082a04056 user: chungy tags: trunk | |
|
2020-08-08
| ||
| 11:48 | Populate with the first four episodes of Lower Decks check-in: 94ee3efb4d user: chungy tags: trunk, postgresql | |
|
2020-08-04
| ||
| 21:12 | Add TAS Blu-ray to the media sets. check-in: e6c68e8e7a user: chungy tags: trunk | |
|
2020-06-19
| ||
| 20:37 | Update film titles for 7 and 10 to lack the colon Various films official titles have conflicting representation in text, though the studio and Memory Alpha both seem to prefer a colon-less version for Generations and Nemesis. The titles even seem to read out like a complete phrase without them, so this is pretty good. check-in: 706077c62f user: chungy tags: trunk | |
|
2020-03-27
| ||
| 09:56 | Re-add accidentally removed picard insertion trigger check-in: f451d2bfe2 user: chungy tags: trunk | |
| 09:53 | Add remaining Picard episodes check-in: f7c938c008 user: chungy tags: trunk | |
|
2020-01-31
| ||
| 19:52 | Picard: Fix production codes, add next two episodes known check-in: 4a072f4746 user: chungy tags: trunk | |
|
2020-01-22
| ||
| 08:33 | First three episodes of Picard check-in: a872492bbc user: chungy tags: trunk | |
|
2020-01-12
| ||
| 22:23 | Change Operation ‐‐ Annihilate!’s name to have two hyphens Much better in-line with the visual intent of the episode’s title card. check-in: 1751b4a8f4 user: chungy tags: trunk | |
|
2020-01-09
| ||
| 09:55 | Correct airdates for TNG check-in: 8198f0a143 user: chungy tags: trunk | |
| 09:39 | Correct airdates for TOS Same as before, but only one episode wrong in this one. check-in: 9bc742ab07 user: chungy tags: trunk | |
| 09:29 | Correct airdates for DS9 Most of the episode data was copied by scrapping Memory Alpha listings, without strong scrutiny for accuracy. Turns out many of the airdates on the series listing are incorrect (despite being correct on the episode articles themselves). check-in: f6dabe89f8 user: chungy tags: trunk | |
|
2020-01-03
| ||
| 01:12 | Add DS9 DVD set check-in: e397106959 user: chungy tags: trunk | |
|
2019-12-28
| ||
| 20:41 | Preliminary information about ST: Picard check-in: 194890b2dc user: chungy tags: trunk | |
| 20:37 | Add Short Treks season 2 check-in: 07c6e78050 user: chungy tags: trunk | |
|
2019-04-23
| ||
| 17:49 | Add Discovery Season 2 check-in: 9d85b6b7d4 user: chungy tags: trunk | |
|
2019-01-21
| ||
| 19:39 | Document first two DIS S2 episodes check-in: bcabcfd431 user: chungy tags: trunk | |
|
2018-12-08
| ||
| 07:26 | Add Short Treks check-in: f1e1d5d6b7 user: chungy tags: trunk | |
|
2018-05-07
| ||
| 08:55 | Add the Enterprise Blu-ray release check-in: 9faef32e4a user: chungy tags: trunk | |
| 08:19 | Functions to make it easier to add video releases. check-in: 65fd65863e user: chungy tags: trunk | |
| 07:42 | Update for new psql search path stuff check-in: fd610418a3 user: chungy tags: trunk | |
|
2018-01-29
| ||
| 10:10 | stardate for What’s Past Is Prologue check-in: 5e41a8b6d1 user: chungy tags: trunk | |
|
2017-12-16
| ||
| 11:40 | Discovery episodes 11-15 check-in: 9c1401fa94 user: chungy tags: trunk | |
|
2017-11-16
| ||
| 12:21 | DIS Episode 10 title known check-in: e207e18676 user: chungy tags: trunk | |
|
2017-11-14
| ||
| 11:23 | Stardate for “To Boldly Go, Part II” check-in: bc95ea273c user: chungy tags: trunk | |
|
2017-11-07
| ||
| 22:16 | Stardate for “Si Vis Pacem, Para Bellum” check-in: d5241a2b0b user: chungy tags: trunk | |
|
2017-10-31
| ||
| 10:20 | Discovery finally has a new stardate! check-in: 4bed7fa742 user: chungy tags: trunk | |
|
2017-10-23
| ||
| 21:23 | Lethe takes place December 2256 check-in: 74623863c9 user: chungy tags: trunk | |
|
2017-10-20
| ||
| 00:10 | Add dump script check-in: 98e492e465 user: chungy tags: trunk | |
| 00:09 | schema: clean database schema before creating objects check-in: 676c953428 user: chungy tags: trunk | |