Programmatic API

Platformatic DB allows starting and managing database instances programmatically using JavaScript, offering a flexible way to integrate database operations into your applications or scripts.

import { buildServer } from '@platformatic/db'

const app = await buildServer('/path/to/platformatic.db.json')

await app.start() // This starts the server.
console.log('Server URL:', app.url)

const res = await fetch(app.url)
console.log('Server response:', await res.json())

// Additional operations can be performed here.

await app.close() // This stops the server.

Customizing Configuration

You can customize the server configuration to meet specific requirements, such as setting a custom hostname or database connection string:

import { buildServer } from '@platformatic/db'

const app = await buildServer({
  server: {
    hostname: '127.0.0.1',
    port: 0
  },
  db: {
    connectionString: 'sqlite://test.sqlite'
  },
})

await app.start() // this will start our server

console.log('URL', app.url)

const res = await fetch(app.url)
console.log(await res.json())

// do something

await app.close()

For more details on how this is implemented, read Platformatic Service Programmatic API.

API

buildServer(config)

• parameters: config (Object) - configuration settings for the server and database.
• Returns: An instance of restartable application

RestartableApp

• .start(): Initializes and listens to the hostname/port defined in the config.
• .restart(): Restarts the Fastify application, useful for applying configuration changes or recovering from state issues.
• .close(): Stops the application.

Issues

If you run into a bug or have a suggestion for improvement, please raise an issue on GitHub or join our Discord feedback channel.