The author of PB is really excellent, and PB is a great work.
But we really need to run PB online in high pressure and complex environments. Sqlite cannot handle this scenario, so I am working hard to make it support cockroachdb and postgreSQL for cluster and standalone environments.(Preferably compatible with cockroachdb , but not yet dealing with pg dialects。 And due to time constraints, only the regular curd was tested, and the operation of the JSON function was not tested.)
Current modification progress, running cockroachdb by default as a single node by default
Then run PB to install and perform curd operations normally.
run cockroachdb
cockroach start-single-node --insecure
cockroach sql --insecure
CREATE DATABASE logs;
CREATE DATABASE data;
build pb
go build .\examples\base\
run pb --help
PocketBase CLI
Usage:
base.exe [command]
Available Commands:
admin Manages admin accounts
migrate Executes app DB migration scripts
serve Starts the web server (default to 127.0.0.1:8090)
update Automatically updates the current PocketBase executable with the latest available version
Flags:
--automigrate enable/disable auto migrations (default true)
--dataDsn string store data postgresql dsn(default postgresql://[email protected]:26257/data?sslmode=disable) (default "postgresql://[email protected]:26257/data?sslmode=disable")
--debug enable debug mode, aka. showing more detailed logs
--dir string the PocketBase data directory (default "D:\\src\\postgresqlbaseapi\\pb_data")
--encryptionEnv string the env variable whose value of 32 characters will be used
as encryption key for the app settings (default none)
-h, --help help for base.exe
--hooksDir string the directory with the JS app hooks
--hooksPool int the total prewarm goja.Runtime instances for the JS app hooks execution (default 50)
--hooksWatch auto restart the app on pb_hooks file change (default true)
--indexFallback fallback the request to index.html on missing static path (eg. when pretty urls are used with SPA) (default true)
--logDsn string store logs postgresql dsn(default postgresql://[email protected]:26257/logs?sslmode=disable) (default "postgresql://[email protected]:26257/logs?sslmode=disable")
--migrationsDir string the directory with the user defined migrations
--publicDir string the directory to serve static files (default "D:\\src\\postgresqlbaseapi\\pb_public")
--queryTimeout int the default SELECT queries timeout in seconds (default 30)
-v, --version version for base.exe
Use "base.exe [command] --help" for more information about a command.