PostgreSQL
PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Windows, Linux, macOS, FreeBSD, OpenBSD and NetBSD, and handles a range of workloads from single machines to data warehouses, data lakes, or web services with many concurrent users.
Related work
- chaipat.cc, the ask-me-anything site Key work Nov 2026This site: a portfolio for finding entities and their live sites, about pages and source code, as well as asking questions about his work. A Turtle knowledge graph supplies facts to a browser SPARQL engine and a shared resource catalog, next to a wiki with full-text search, a timeline and a graph view of the graph and its ontology.
- Knowledge-graph explorer Key work Apr 2026
Next.js and React in TypeScript, with PostgreSQL and Redis behind it.
- Word games engine Key work Jun 2026
Data: a dictionary engine on PostgreSQL, with Redis as a cache.
- research-os Key work Mar 2026
PostgreSQL through SQLAlchemy, with Alembic migrations. Large files stored on local disk or any S3-compatible object store, through boto3.
- Homie Kitchen Jul 2025Restaurant management system in Next.js: authentication, menus, orders and inventory.
- PostgreSQL 16 Docker image Sep 2024
PostgreSQL 16 Docker image is the source of ghcr.io/appleboiy/pg16, a PostgreSQL 16.3 image for development and testing, published on the GitHub Container Registry.
- Question log (chaipat.cc)
The data goes to PostgreSQL on Neon, over its HTTP interface, with no database driver.
- Dockerfiles Oct 2024
Dockerfiles is his collection of reusable Docker images, currently for MongoDB and PostgreSQL.
- 3Stack NFP Jul 2024
3Stack NFP is a starter template for a three-tier web application: a Next.js front end in TypeScript, a Flask API, and a PostgreSQL database.
- 3Stack RFP May 2024
3Stack RFP is a full-stack template with three services, each in its own Docker container: a React front end in TypeScript; a Flask API; a PostgreSQL database.
- FlaskPG May 2024
FlaskPG is a development setup for Flask applications backed by PostgreSQL, run with Docker Compose.