Forem: Michael Willian Santos

Prisma Backup

Michael Willian Santos — Sat, 30 Aug 2025 12:24:23 +0000

Github: https://github.com/DaxSoft/prisma-backup

Simple PostgreSQL Backups for Your Prisma Project

You're building an awesome project with Prisma and a free PostgreSQL database from a cloud provider. It's fast, it's modern, it's great... until you realize the free tier doesn't offer a way to export or back up your data, neither it allows to connect to pgAdmin. How do you migrate to another service? What if you need to recover from a mistake?

🚀 Ideal Use Cases

This tool is perfect for:

Migrating off a free-tier service: This is the primary use case. You can easily dump your entire database and move to a different provider without getting locked in.
Seeding development environments: Quickly populate your local or staging database with a snapshot of production data.
Manual recovery: Provides a safety net before performing major, destructive schema changes.

⚠️ A Quick Word of Caution

This tool is designed for convenience and is best suited for small-sized projects. It is not a substitute for enterprise-grade, point-in-time recovery solutions.

Step 1: Installation

First, add the package to your project.

# Using npm
npm install @vorlefan/prisma-backup

# Using yarn
yarn add @vorlefan/prisma-backup

Step 2: Creating a Backup

The backup process is straightforward. You create an instance of the PrismaBackup class, passing it your Prisma Client and some configuration.

Let's create a script called backup.ts:

// backup.ts
import { PrismaClient } from 'output/generated/prisma/client';
import { PrismaBackup } from '@vorlefan/prisma-backup';

const prisma = new PrismaClient();

async function main() {
  console.log('Starting backup...');

  const backup = new PrismaBackup(prisma, {
    // The root folder where all backup folders will be created
    folderName: '.db_backups',
    database: 'postgres',

    // Optional: Handle large tables by fetching data in batches
    offset: {
      Posts: { limit: 200 }, // Backup the 'Posts' table in batches of 200
    },
  });

  await backup.run();

  console.log('✅ Backup completed!');
}

main();

When you run this (ts-node backup.ts), it will:

Query all your PostgreSQL tables.
Create a new folder inside .db_backups.
Save the data for each table as a separate JSON file.

Step 3: Restoring From a Backup

Restoring is just as simple, but with one critical requirement: you must provide Prisma's schema metadata. This allows the tool to understand your table relationships and insert data in the correct order to avoid foreign key constraint errors.

Let's create restore.ts:

// restore.ts
import { PrismaClient, Prisma } from 'output/generated/prisma/client';
import { PrismaRestore } from '@vorlefan/prisma-backup';

// Important: Import the 'Prisma' namespace to access the DMMF
const prisma = new PrismaClient();

async function main() {
  console.log('Starting restore...');

  const restore = new PrismaRestore(prisma, {
    // The specific backup folder you want to restore from
    folderName: '.db_backups', 
    database: 'postgres',

    // THIS IS THE MOST IMPORTANT PART!
    // It allows the tool to understand your schema and relations.
    baseModels: Prisma.dmmf.datamodel.models as any,
  });

  await restore.run();

  console.log('✅ Restore completed!');
}

main();

When you run this script, it will automatically:

Analyze your baseModels to determine the correct insertion order (e.g., User before Posts).
Insert the backup data table-by-table.

Conclusion

And that's it! You now have a simple and effective strategy for backing up and migrating your Prisma project's database.

Check out the repository on GitHub for more details. Happy coding

How to promote my product?

Michael Willian Santos — Sat, 03 May 2025 16:09:41 +0000

Newbie as an owner by building a writing platform for writers and storytellers.

How do I start to promote my product? Any advice? I'm in full "Macbeth" mode for my product to change my family's life for the better.

Any doubt on the technical side, I'm in for answering. 👻

Context of the platform: The ultimate platform designed to empower you, fellow wordsmith, to showcase your novel in the most captivating manner.
Let your words shine for everyone to discover.

Built with: Prisma, NextJS, Typescript, Redis, Shadcn (Tailwind), AWS, Trigger Dev, Cloudflare, Vercel.

Link: https://www.travelerspentales.com/

Prisma - Backup System

Michael Willian Santos — Sat, 05 Feb 2022 18:30:28 +0000

// start

Hi everyone!
GitHub of the Project

Use this module to create a backup measure for your project that uses Prisma. You can either backup the information, or use them to migrate to another database, or just to reset the database.
Example: Let's say that you need to change a unique key (email) to another like (code). You can backup first,
then change the schema.prisma, and use this module to inject the old information.

// How To Use

Basic example using the Prisma, let's imagine that we have two models, User & Post. And the Post model is related to the User model.

import { PrismaClient } from '@prisma/client';
import { backup } from '@vorlefan/prisma-backup';

const prisma = new PrismaClient();

void (async function () {
    const [user, post] = await prisma.$transaction([prisma.user.findMany({}), prisma.post.findMany({})]);

    // w/out encrypt

    await backup({
        models: {
            user,
        },
    });

    // encrypting the models

    await backup({
        models: {
            user,
        },
        encrypt: true,
        password: 'pwd123',
        backupFolderName: 'encrypted'
    });
})();

// End

There a lot of feature that I'm planning for this module, then if you want to, please contribute or follow up the news xD

Google News | Crawler

Michael Willian Santos — Sat, 31 Oct 2020 19:01:27 +0000

// start

Hi everyone!
GitHub of the Project

While I was coding a paid-project from my freelancer career. There was the need to get news from certain topics. I have searched and discovered that there are few solutions for this particular problem. So, this is the reason that I have created this package.

// How To Use

It's pretty simple to use, in which you need to only define the class and call for the method run (async/await)

Example taken from the folder 'example/basic' at the github page.

const { GoogleNews } = require('@vorlefan/google-news')

const news = new GoogleNews(['One Piece', 'Kingkiller Chronicles'], {
    routeName: 'download',
    language: 'en-US',
    localization: 'US',
    route: (route) => {
        route.set('src', __dirname)
        route.inject('download', 'src')
        console.log(route.get('root').filepath)
    },
})

void (async function () {
    await news.run()
})()

// Use Case

If you are creating a web-app, SaaS or whatever that needs to crawler the most recent news from certain topic, this is for you :)

// End

There a lot of feature that I'm planning for this module, then if you want to, please contribute or follow up the news xD

Brand : crawler to get up-to-date brand assets

Michael Willian Santos — Wed, 01 Jul 2020 21:35:01 +0000

// start

Hi everyone!
GitHub of the Project

One of the projects I am working has a page where you can search for stock market enterprises (company). One of my struggles of the project was the requirement to get the brand logo of the company. So I was searching around the web several tools to make it more easy... I have found some, however, either the price was not affordable or the tool itself not attend all my needs. So I have decided to create one using the concept of 'scraping into the web'.

// How To Use

Warn: It is not ready for production.
To use it you need to install on your Node project the package 'puppeteer' and this one '@vorlefan/brand'.
The function itself is really easy to use. Few options, you can read the doc on the github page.

Example:

const { BrandCrawler } = require('@vorlefan/brand').default
const puppeteer = require('puppeteer')

let URL = 'https://www.lojasrenner.com.br/'

void (async function () {
    const test = await BrandCrawler({
        website: URL,
        puppeteer,
        timeout: 1e9,
        instagram: true,
        pageTimeout: 0,
        twitter: true,
        facebook: true,
    })

    console.log(test)
})()

The return you can find on the github page (I don't want to polute this post here xD)

// Use Case

If you are building a 'brand search' or the app that you are creating requires the logo and banner from the enterprise in question, I guess that this will suit you pretty well :)

// End

There a lot of feature that I'm planning for this module, then if you want to, please contribute or follow up the news xD

Convert XLSX file into JSON

Michael Willian Santos — Thu, 25 Jun 2020 14:11:45 +0000

// start

Hi everyone!
GitHub of the Project

I was working into a PaaS that requires to read a .xls|xlsx file and extract the data into a readable .json, in which will be sent for the database. Seeking around the web, I found the amazing 'mongo-xlsx', however, the data generated was a messy. So, I had the idea to create a package around the 'mongo-xlsx', in which I would use the other package 'string-similarity', to construct a better parse. In the end, it worked as I wanted and needed for the project. Then, I had decide to construct a 'better one' from the one I have built to share with everyone. Please, if you can contribute with pull-requests, do it. I guess that this package can be pretty useful for everyone to use :)

// How To Use

The package is really simple to use. By justing taking a look at the main README.md and the examples, I guess that you guys can see how to use. However, whatever doubt about it, just ask here :)

// Use Case

As given by the example intermediate, the main motive that leads me to create this package, it is an application that I'm making. I had the problem and the needs to convert a lot of .xlsx file into .json one for the Database. The big problem of this, is that the .xlsx was pretty complex (from stock market).

With this package, I could transform that .xlsx file from the cover page, into a .json data. Example:

Sure thing, after it, there is the need to sanitize and so on.

// End

I hope that this package — that will be improved by time, helps someone in their needs. Please, if you can, contribute to the project. I guess that it will help a lot of people xD

How I Built My Portfolio

Michael Willian Santos — Sun, 19 Apr 2020 21:16:01 +0000

Hello, everyone :)
Link: Github
Site: Website

I have been using Next.js for a while. And my portfolio on Github was very outdated. For this motive, I have creating a new other using Next.JS. By far the most annoying thing to resolve was the problem of exporting the application to work with the Github Pages. There are not that many of tutorial or example, that explains in a clear way.

Then, if you guys want to, check out the source code of the website :)

Features

Things that I was seeking on have in my portfolio:

Clear and simple
Shows up my project that I have on Behance
Shows up the projects on my Github
Be the host of some project's documentation

Behance

I don't want to have any time that I publish a new project on Behance, go on my portfolio then edit some sort of file or anything like this to display the info of this project.

Then, I have use the Puppeteer to scrape my projects on Behance, grab the pictures and some statics, and generate a json file.

With the Github Actions, I will automate this process using some sort of CRON time.

Github

Using the Github's API, I could get my project list that it's mine (not forked).
I have created some sort of 'To-Do' for this website, in which is getting the list of open issues from the Github repo. and displaying on Website.

Github Project's Documentation

Every project of mine that have on his description from the Github repository, the keyword '#docs'. It will be available on Website to see the documentation.
With the Github's API, I can went into this repositories, look at if it haves a folder named 'docs', then it will render on the website, using React Markdown.

Well, for while is it :)

React Hooks | My Package

Michael Willian Santos — Sat, 04 Apr 2020 16:59:28 +0000

#start

Hi everyone!
GitHub of the Project

I have been using React for about 7 months already. And by this, I have created a lot of Hooks and other stuff to made my life easy. So by this, I have created a suit of react hooks to help me. In which, I have been using in whatever 'react-project' I made.

useAsync : Handle with Async Functions
useBoolean : Better way with a good semantic to handle with Boolean states
useClient : Useful for server-side apps, in which you can check up it is under Server-Side or Client-Side
useDebounce : For functions that the user can call any time
useFetch : A complete tool to handle with requests from API.
useIndex : With this you can handle with 'Pagination' or whatever use the concept of 'Page Index', 'Per Page'
useKeyboard : Identify the key pressed
useLocalStorage : Save values it and get the values on LocalStorage
useMiddleMouse : Identify if the user is using the MiddleMouse (scrolling)
useMouseOut : Identify if the mouse cursor is out of the range of the element
useMouseIn : Identify if the mosue cursor is inside of the range of the element
useObject : Better way to handle with Object values
useScreenSize : Identify the size of the Window and the orientation of the screen.
useScroll : Identify the state of the scroll of the page
useToggle : Useful to handle with Toggle elements like 'Tabs' and so on.

I'm currently building up the Docs for this package and editing to give you guys a better example. So, I'll be really happy if you guys give me a feedback xD

Example: (Next.js + React + Fastify)

It's a simple example of search repository on Github.
To check up, clone the folder 'example' on the repository of this Project. And run up:

npm install && npm run build && npm run start

JavaScript - Abbreviate Numbers

Michael Willian Santos — Thu, 12 Mar 2020 03:55:36 +0000

Case

I am working into a website in which I handle with a lot of data and by this, the end user (client) shall see the results and values. So, I was caught into a problem... The overall display of the values.
While in some cases for the user, it will be interesting to see the raw value (like, 13.640.333.000)... in another, just the abbreviation of the value will be acceptable (13.64 B).
So I went to look forward a way to solve this problem of mine — looking around the community. But, the scripts that I have found either is "heavy" for this purpose or it is very fancy for this.
Then... I end up creating my own, tiny solution...

Warning

As I'm pretty busy with my works recently, I'll not be able to share my codes with the community (I'll share some 'react hooks' and snippets that I use often).
However, since I feel that this can be very useful... I'll share here xD

Code

/**
 * Abrreviete the number by unit
 * @param {Number|String} number
 * @param {Object} config
 * @param {Boolean} config.absolute if it will replace the 'x.yyy', '.yyy', for
 * empty space. Like, '13.4' to '13'
 * @param {Number} config.factor the factor on 'toFixed'
 * @param {Array} config.unit
 * @param {Boolean} config.numeric if the final value will be the type 'number'
 * or 'string'
 */

function abbreviate (number, config = {}) {
    if (typeof config !== 'object') config = {}
    if (!config.hasOwnProperty('factor')) config.factor = 2
    if (!config.hasOwnProperty('absolute')) config.absolute = true
    if (!config.hasOwnProperty('unit'))
        config.unit = ['', 'K', 'M', 'B', 'T', 'Q']
    if (!config.hasOwnProperty('numeric')) config.numeric = false
    let value = String(number).replace(/(\.|\)|\(|\,)/g, '')
    let length = value.length - 1
    const unit_index = ~~(length / 3)
    value = eval(
        `parseFloat(${value} / 1e${unit_index * 3}).toFixed(${config.factor})`
    )
    //console.log(config)

    if (!!config.absolute) value = value.replace(/\.(\d+)$/, '')
    return !!config.numeric ? +value : `${value} ${config.unit[unit_index]}`
}

How to Use

Copy the code on the DevTools of your Browser and let's test it xD

Default

You can use the standard way...
Like:

abbreviate("123458886")
// "123 M"

or to control decimal places

abbreviate("123458886", {absolute: false, factor: 3})
// "123.459 M"

Bye

Well, that is it... If it helps you or if you have some feedback/suggestion, let me know :)... Any doubt, please, comment as well

My first month with React

Michael Willian Santos — Tue, 24 Dec 2019 23:39:37 +0000

What is this about?

One month ago, at 24/11/2019, I was talking with my client in which road his web application should go. Giving him pointers and asking what he thinks about it. Then I have talked with him about the React and NextJS, telling that for his application it would be the ideal — it's a website about analise of stocks & assets with a community to interact. Then we decided to choose this two frameworks.

However, I never have used this two frameworks before on my life — of course, I have told him about it, that it would be the first time of me using it, he agreed and told me that trust me. Then, I went to battle.

My background with Javascript was pure Javascript + NodeJS (and his several possibilites). Never ever used a framework before xD. But I was not afraid of trying it out, my last two years was pure javascript, so I decided to "take on ship".

First week

It was everything so confuse, I mean, the whole concept of using both 'html' with javascript and so on. I was very lost, then I have did what every developer should do: be friend of the docs of both frameworks and taking a look at several codes on projects over GitHub, trying to understand the concepts and so on.

Second week

I was stuck trying to understand the React Hooks and how to make the 'ui-library' of the Material-UI, works fine with NextJS. Then I went to understand about the 'initialProps' and how works the lifecycle of React and NextJS

Third week

After create some pretty small projects to practice what I have learned, I had the feel that was about time to start the big project with this two frameworks.
Over this week I have created 4 pages, but I will only show up one because the project isn't complete and I cannot show up everything yet.

Last Week

Well, I think I have enought confidence to go on with the project on both frameworks. Of course, I could have choose to work on my comfort zone, with pure Javascript, however... I know that I'm not coding to myself, it will have a lot of coders on future and I want to make easy for them xD. Then, let's go on...

What I've learned

It's fun to get out of your comfort zone
Take it as law, at least that your project is just for fun and for yourself, always code thinking that others will look at your code and develop over your lines.
At first everything is confuse and it's normal to be. Then, don't take it at your heart, if you are feeling stuck with something, go out for some hang out, running, sport or make stuffs that you enjoy. Then, after it, go back at your project. You will feel that what previous you thought of being a big mountain, hard to fight out, was a little stone on your shoes worths of a good laugh. So go, go laugh of yourself, it will make you more healthly.

My first NPM module

Michael Willian Santos — Wed, 27 Nov 2019 17:58:44 +0000

#start

Hi everyone!
GitHub of the Project

For my first post here I have think about sharing my first NPM module.

First of all I'm not an newbie into coding neither on JavaScript language, however I never thought to share some application that I write, that in overall helps me in production time and so on.

But, getting so much from open source and community, I have decided that it's time for me to start sharing some application, libraries and snippets that I usually write and use on my projects.

#vorlefan.path_route

What is it about? The main functions is to given the power of easily manage the access to the folders and files of your project. With the ability to handle files (example: read json file)

Why I have created this? I was tired of typing '../../../../someName/file.json' everytime on my projects. Or being almost all time using 'path.resolve' to not get some errors.

#example

In my current project that I'm working at the back-end with NodeJS and at the front-end with React (NextJS). I have a folder named 'server', inside of this folder I have my structure of folders and two javascript file. 'index.js', that executes the server and 'path_route.js', that handles with the structure of my path routes. Take a look:

The main reason that my 'path_route.js' is at the main folder, is just to have the __dirname directed to the main folder. This make easy my life.

Now the code (I'll not show up the complete code to not make this post big)

With this piece of code, I can access my folders easily, example:

To access my 'assets' folder:

Route.Main.get('assets')

// it returns

{ 
  "name": "assets",
  "path": "__dirname/assets"
}

And my module.exports to make it more general for my overall application is:

With this I'll only need to require this file, to access the overall structure of folders and files of my project.

// Access the folder structure of my folder 'assets'.

const Assets = require('../../../path_route').load('Assets')

#end

Sure things there are a lot of room to improvement and features to add, however I'm pretty enjoyed this module of mine and to be first in both publishing and experience in using 'npm publish', I feel that it's okay xD.

It would be nice to receive some feedback and suggestions :)