Feed aggregator

Show HN: Star Trek database, using SQLite

Hacker News - Sat, 03/29/2025 - 11:45pm

This isn't exactly a new project, it dates back to 2015 and started in PostgreSQL (the "postgresql" tag represents the last state of that database). As a weekend project, I overhauled it to port over to SQLite, partly as an exercise, but also to increase its usability. Since SQLite requires no server to install or administer, and the database is a single file, it's now real easy to pass around and play with.

While it is biased to Star Trek media that I own and enjoy, it can still be fun to query and get answers to questions you never thought to ask.

Example queries:

Listing episodes of The Next Generation season 1 by star date: SELECT title, airdate, episode_number, stardate FROM tng WHERE season = 1 ORDER BY stardate;

If your birthday is March 15, find the episodes that aired on that day: SELECT series.title AS series, episode.title AS episode, airdate FROM episode JOIN series USING (series_id) WHERE airdate like '%-03-15';

Pick a random episode of Enterprise to watch, and display the Blu-ray disc to find it on: SELECT * FROM ent_bluray ORDER BY random() LIMIT 1;

Comments URL: https://news.ycombinator.com/item?id=43521130

Points: 3

# Comments: 0

Categories: Hacker News

Ask HN: whence New Window

Hacker News - Sat, 03/29/2025 - 11:15pm

UI question for the oldest of the old-timers here:

Why is the New Window function found in the File menu, and not in the Window menu? does this go back to PARC days?

EMACS keybindings are are pretty consistent about buffers, windows, files, and frames, but the menus... eh.

Comments URL: https://news.ycombinator.com/item?id=43520957

Points: 1

# Comments: 0

Categories: Hacker News

Show HN: Cloud-Ready Postgres MCP Server

Hacker News - Sat, 03/29/2025 - 11:14pm

Hey HN,

I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio)

Features - Supports multiple database connections from multiple agents

- Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases)

- Read-Only Queries: Controlled execution of queries via MCP.

- EXPLAIN Tool: Helps smart agents optimize queries before execution.

- Extension Plugins: YAML-based plugin system for Postgres extensions (supports pgvector and postgis out of the box).

- Server Mode: Spin up the container and it's ready to accept connections at http://localhost:8000/sse

Comments URL: https://news.ycombinator.com/item?id=43520953

Points: 5

# Comments: 1

Categories: Hacker News

Ask HN: Do you study for your job?

Hacker News - Sat, 03/29/2025 - 11:06pm

I do root cause analysis for a complex piece of software. For a couple of years I've been doing fine at my job, but last week I decided to read a rather dense book on the software and related topics, and I'm doing flash cards. I feel that my ability to diagnose and troubleshoot issues is limited by having to look things up all the time.

Does anyone else study for their job? If so, has it had an impact? I limit myself to 30-60 minutes a day, because I want to maintain some work-life balance.

Comments URL: https://news.ycombinator.com/item?id=43520910

Points: 1

# Comments: 3

Categories: Hacker News

Pages