Skip to content
프로젝트

cmu-db/dbdb.io has 594 GitHub stars and 49 forks. GitHot measured 0 stars in 24 hours, +1 in 7 days, and +4 in 15 days. Last checked 2026-11-22 11:53 UTC. Last push 2026-11-15.

이 수치를 측정하는 방법

측정된 스타 증가

in 24h
0
in 7 days
+1
in 15 days
+4
in 1 month
기록 수집 중

서로 겹치는 기간의 순증가량이며 일별 합계가 아닙니다. 측정값이 없으면 비워 둡니다. 스타는 관심도를 나타내며 품질을 보장하지 않습니다.

소개

The On-line Database of Databases

데이터

README.md

Original

Tests

Database of Databases

Installation

sudo apt-get install build-essential libffi-dev libpq-dev python3-dev postgresql-common-dev libcairo2
uv sync

Running the development server

uv run python manage.py runserver

Deployment

Run deploy/update_dbdb_app.sh on the production machine to fetch new changes, run migrations, and restart the wsgi server.


Test fixtures

Test fixtures live in data/fixtures/. Django loads them by name; the search path is configured in settings.py via FIXTURE_DIRS.

Fixture Contents Source
adminuser.json Superuser account for tests Static
testuser.json Non-superuser account for tests Static
core_features.json Feature + FeatureOption rows Dumped from production (see below)
core_attributes.json Attribute + AttributeOption rows Dumped from production (see below)
core_system.json Two synthetic test systems (SQLite, XXX) Static
core_savedsearch.json One saved search for testing Static

Regenerating fixtures from production

Requires Tailscale to be connected so db-web.tail5fc291.ts.net is reachable.

# Features and feature options
uv run python manage.py dumpdata core.feature core.featureoption \
    --indent 2 -o data/fixtures/core_features.json

# Attributes and attribute options
uv run python manage.py dumpdata core.attribute core.attributeoption \
    --indent 2 -o data/fixtures/core_attributes.json

These commands use the DATABASE_URL in .env, which points to the production database.

Loading fixtures into a local database

uv run python manage.py loaddata adminuser testuser \
    core_features core_attributes core_system core_savedsearch

Running the tests

Tests require a local PostgreSQL instance. The test runner creates and destroys a dedicated database (test_dbdb_io) on every run.

PGUSER=<your-local-pg-user> uv run python manage.py test dbdb.core \
    --settings=dbdb.test_settings --verbosity=2

The dbdb.test_settings module overrides the production DATABASE_URL with local PostgreSQL connection parameters. It reads the following environment variables (all optional, with defaults shown):

Variable Default Notes
PGUSER dbdb_user Must have CREATEDB privilege
PGPASSWORD (empty) Omit if using peer auth (Unix socket)
PGHOST (empty) Empty = Unix socket (peer auth); localhost = TCP
PGPORT 5432
PGDATABASE postgres Connection database — must differ from test_dbdb_io

The test database is always named test_dbdb_io and is dropped and recreated fresh on every run.

관련 프로젝트 살펴보기

불러오는 중…