====== NocoDB ======

===== What is it =====
NocoDB turns any PostgreSQL, MySQL, SQL Server, SQLite & MariaDB database into a smart spreadsheet (like Airtable).
It provides a no-code UI on top of an existing relational database, with record editing, views, and API access.

===== Deployment =====
<code docker>
 service: mere-nocodb
 image: nocodb/nocodb:0.250.0
 container port: 8080/tcp (internal only)
 volume: fatal_nocodb-data → /usr/app/data
 nginx upstream: 172.20.0.4:8080 (static IP for the nocodb container)
 server_name: revodb.mere-mortal.net
 </code>

**Why a static IP in nginx?** The NocoDB container gets a stable IP on the mere-net bridge.
Using the IP directly in the nginx upstream avoids DNS resolution issues inside the nginx container.

===== Issues Encountered =====
 * **Upstream IP**: nginx upstream points to the container's bridge IP (172.20.0.4) instead of the service name.
   This is a pragmatic choice — the IP is stable across restarts on this small stack.

===== Current Status =====
 * Running and accessible at https://revodb.mere-mortal.net
 * Persistent volume: fatal_nocodb-data
 * NocoDB v0.250.0

===== Planned / To Do =====
 * **Initial setup**: Complete admin account creation.
 * **Database connection**: Connect NocoDB to an actual database (SQLite by default, or external PostgreSQL/MySQL).
 * **Backup**: The data volume contains all NocoDB configuration.