Platformatic v0.5.0 has been tagged and released on npm. It includes new features and a lot of bug fixes!
Thanks to all of you that welcomed Platformatic into the Open Source community with all your contributions. This release would not be possible without your help.
You can find the complete list to all pull requests included at: https://github.com/platformatic/platformatic/releases/tag/v0.5.0
Notable Changes Video
Added GraphQL Subscriptions to Platformatic DB!
GraphQL Subscriptions are hard to implement and scale. Mercurius offers excellent support for them, however, we had to fix a couple of bugs to implement this feature (#895 and #896) to be able to have complete support for GraphiQL and authorization. Enjoy a simple demo:
As part of my Ph.D. in the Internet of Things, I worked a lot in implementing publish/subscribe systems at scale and MQEmitter was born. In Platformatic DB we also support mqemitter-redis for cross-process communication.
As in all Platformatic's modules, the support for subscriptions is easily layered so that you can customize them as you please. Publishing events when saving or deleting entities is done by @platformatic/sql-events, while @platformatic/sql-graphql leverage that module to create a GraphQL adapter.
Platformatic Service - new command with Video!
platformatic service start is a new command to start a Fastify plugin with all the Platformatic developer experience but without all the automated data mapping of Platformatic DB. It's the barebone Platformatic experience.
See a video of platformatic service start in action:
You can start your platformatic service start journey with the following config file:
Docs and integration in the dashboard will follow soon. Would you like to contribute?
A special mention goes to Riccardo Fiorenza that is working hard to integrate React Admin as part of our dashboard: https://github.com/platformatic/platformatic/pull/255.
Fly.io deployment guide
At Platformatic, we are huge fans of fly.io and we love deploying things there. We have created a fantastic guide to deploy Platformatic DB to Fly.io: https://oss.platformatic.dev/docs/guides/deployment/deploy-to-fly-io-with-sqlite.
Transaction support in sql-mapper
Lastly, we have added support for transactions to @platformatic/sql-mapper, enabling you to do multiple database calls in isolation. Check it out:
const { connect } = require('@platformatic/sql-mapper')
const logger = pino(pretty())
asyncfunctionmain() {
const pgConnectionString = 'postgres://postgres:postgres@127.0.0.1/postgres'const { db, entities} = await connect({
connectionString: pgConnectionString,
log: logger,
})
const result = await db.tx(async tx => {
// these two operations will be executed in the same transactionconst authorResult = await entities.author.save({
fields: ['id', 'name'],
input: { name: 'test'},
tx
})
const res = await entities.page.save({
fields: ['title', 'authorId'],
input: { title: 'page title', authorId: authorResult.id },
tx
})
return res
})
}
Acknowledgements
Contributors to this release were: Abdullah Osama, Alex Ruheni, Dmitry Zakharov, Eckhardt (Kaizen) Dreyer, Giacomo Cerquone, Giacomo Lombardi, Ismajl Ramadani, Ivan Tymoshenko, Jacopo Riciputi, Leonardo Rossi, Manny, Matija Gašpar, Matteo Collina, Mikhail Cheremuhin-Rerberg, Mohamed Sohail, MzUgM, Riccardo Fiorenza, Salvatore Delpiano, Saptarshi Sarkar, Simon Plenderleith, Yagiz Nizipli, Zlatin Stanimirov, bacebu4, Marco Piraccini.
