- Clone this repository
- Install pnpm
npm i pnpm --location=global
- Install dependencies for root project:
pnpm i
- Install docker with Docker Desktop or Colima
The CLI package is now available at ./node_modules/.bin/platformatic. Use
pnpm link
to use platformatic
everywhere.
(cd packages/cli && pnpm link --global)
We use Docker to start all the databases we develop against.
On Linux, execute: docker compose up
On Intel Macs: docker compose -f docker-compose-mac.yml up
On Apple Silicon Macs: docker compose -f docker-compose-apple-silicon.yml up
Read thorough documentation on the quick start guide, or follow these steps to quickly create and start a platformatic db:
- Create directories to work from
mkdir -p my-demo
thencd my-demo
- Then create a package.json file with the default configs:
npm init --yes
- Create a migrations directory to store your database migration files:
mkdir migrations
Then create a new migration file named 001.do.sql in the migrations directory:touch migrations/001.do.sql
Copy and paste this SQL query into the migration file:CREATE TABLE pages ( id INTEGER PRIMARY KEY, title VARCHAR(255) NOT NULL )
- In your project directory, create a new Platformatic configuration file named platformatic.db.json:
touch platformatic.db.json
Copy and paste this configuration:{ "server": { "hostname": "127.0.0.1", "port": "3042" }, "core": { "connectionString": "sqlite://./pages.db" }, "migrations": { "dir": "./migrations", "autoApply": true } }
- In your project directory, use the Platformatic CLI to start your API server:
platformatic db start
- Start interacting with the API by opening the following link on your browser http://127.0.0.1:3042/documentation/static/index.html or you can use curl to do it. Read the quick start guide to see examples.
Create a ./packages/db-dashboard/.env
file with the following content
VITE_SERVER_URL=http://localhost:3042
Or whatever port you are running platformatic DB server on.
Use the command
pnpm run dashboard:start
This will start a webpack server on port 3000
by default, with watcher and hot-reload (as a standard create-react-app
application).
Note that GraphiQL will not work because platformatic-db has not been started yet.
First build the dashboard for production with the command
pnpm run dashboard:build
This will create compressed files and assets under packages/dashboard/build directory. To run the service:
platformatic db
This will load config from local directory (i.e using config file platformatic.db.json).
If you want to use another config file use the option --config=/path/to/some.json
.
- Run docker
- Run
pnpm run dashboard:build
- Run tests:
pnpm test
If you encounter issues running tests (f.e. failing tests without making a change to the codebase), try to:
- Run
pnpm cleanall
- Run
pnpm store path
and remove the folder shown as an output - Run
pnpm install
again
All platformatic modules share the same release number and are released
in a single process. In order to avoid internal breakages, dependencies as
part of this repository are using the workspace:*
which will be replaced
by precise versions during publish by pnpm.
The procedure to release is simple:
- Update the version of the root
package.json
- run
./scripts/sync-version.sh
- run
pnpm -r publish --access=public
On the top of the PR description, if this is a fix of a github issue, add:
fixes #issuenum
When all checks are passed and the changes are approved, merge the PR with squash and merge
option
Developer Certificate of Origin
Version 1.1
Copyright (C) 2004, 2006 The Linux Foundation and its contributors.
1 Letterman Drive
Suite D4700
San Francisco, CA, 94129
Everyone is permitted to copy and distribute verbatim copies of this
license document, but changing it is not allowed.
Developer's Certificate of Origin 1.1
By making a contribution to this project, I certify that:
(a) The contribution was created in whole or in part by me and I
have the right to submit it under the open source license
indicated in the file; or
(b) The contribution is based upon previous work that, to the best
of my knowledge, is covered under an appropriate open source
license and I have the right under that license to submit that
work with modifications, whether created in whole or in part
by me, under the same open source license (unless I am
permitted to submit under a different license), as indicated
in the file; or
(c) The contribution was provided directly to me by some other
person who certified (a), (b) or (c) and I have not modified
it.
(d) I understand and agree that this project and the contribution
are public and that a record of the contribution (including all
personal information I submit with it, including my sign-off) is
maintained indefinitely and may be redistributed consistent with
this project or the open source license(s) involved.
If you want to know how to retroactively add the DCO to your commits, check out this guide.